Table Name: MTL_ITEM_CATALOG_GROUPS
select * from MTL_ITEM_CATALOG_GROUPS order by creation_date desc
Single Record View
As of: dd/mm/yyyy hh:mm:ss
ROW_ID:
ITEM_CATALOG_GROUP_ID:
INACTIVE_DATE:
PARENT_CATALOG_GROUP_ID:
ITEM_CREATION_ALLOWED_FLAG:
ITEM_NUM_GEN_METHOD:
PREFIX:
STARTING_NUMBER:
INCREMENT_BY:
SUFFIX:
CURRENT_NUMBER:
ITEM_NUM_ACTION_ID:
ITEM_DESC_GEN_METHOD:
ITEM_DESC_ACTION_ID:
NEW_ITEM_REQUEST_REQD:
NEW_ITEM_REQ_CHANGE_TYPE_ID:
ITEM_NUM_SEQ_NAME:
SEGMENT1:
SEGMENT2:
SEGMENT3:
SEGMENT4:
SEGMENT5:
SEGMENT6:
SEGMENT7:
SEGMENT8:
SEGMENT9:
SEGMENT10:
SEGMENT11:
SEGMENT12:
SEGMENT13:
SEGMENT14:
SEGMENT15:
SEGMENT16:
SEGMENT17:
SEGMENT18:
SEGMENT19:
SEGMENT20:
SUMMARY_FLAG:
ENABLED_FLAG:
START_DATE_ACTIVE:
END_DATE_ACTIVE:
ATTRIBUTE_CATEGORY:
ATTRIBUTE1:
ATTRIBUTE2:
ATTRIBUTE3:
ATTRIBUTE4:
ATTRIBUTE5:
ATTRIBUTE6:
ATTRIBUTE7:
ATTRIBUTE8:
ATTRIBUTE9:
ATTRIBUTE10:
ATTRIBUTE11:
ATTRIBUTE12:
ATTRIBUTE13:
ATTRIBUTE14:
ATTRIBUTE15:
CREATION_DATE:
CREATED_BY:
LAST_UPDATE_DATE:
LAST_UPDATED_BY:
LAST_UPDATE_LOGIN:
REQUEST_ID:
PROGRAM_APPLICATION_ID:
PROGRAM_ID:
PROGRAM_UPDATE_DATE:
DESCRIPTION:
select * from MTL_ITEM_CATALOG_GROUPS order by creation_date desc
Single Record View
As of: dd/mm/yyyy hh:mm:ss
ROW_ID:
ITEM_CATALOG_GROUP_ID:
INACTIVE_DATE:
PARENT_CATALOG_GROUP_ID:
ITEM_CREATION_ALLOWED_FLAG:
ITEM_NUM_GEN_METHOD:
PREFIX:
STARTING_NUMBER:
INCREMENT_BY:
SUFFIX:
CURRENT_NUMBER:
ITEM_NUM_ACTION_ID:
ITEM_DESC_GEN_METHOD:
ITEM_DESC_ACTION_ID:
NEW_ITEM_REQUEST_REQD:
NEW_ITEM_REQ_CHANGE_TYPE_ID:
ITEM_NUM_SEQ_NAME:
SEGMENT1:
SEGMENT2:
SEGMENT3:
SEGMENT4:
SEGMENT5:
SEGMENT6:
SEGMENT7:
SEGMENT8:
SEGMENT9:
SEGMENT10:
SEGMENT11:
SEGMENT12:
SEGMENT13:
SEGMENT14:
SEGMENT15:
SEGMENT16:
SEGMENT17:
SEGMENT18:
SEGMENT19:
SEGMENT20:
SUMMARY_FLAG:
ENABLED_FLAG:
START_DATE_ACTIVE:
END_DATE_ACTIVE:
ATTRIBUTE_CATEGORY:
ATTRIBUTE1:
ATTRIBUTE2:
ATTRIBUTE3:
ATTRIBUTE4:
ATTRIBUTE5:
ATTRIBUTE6:
ATTRIBUTE7:
ATTRIBUTE8:
ATTRIBUTE9:
ATTRIBUTE10:
ATTRIBUTE11:
ATTRIBUTE12:
ATTRIBUTE13:
ATTRIBUTE14:
ATTRIBUTE15:
CREATION_DATE:
CREATED_BY:
LAST_UPDATE_DATE:
LAST_UPDATED_BY:
LAST_UPDATE_LOGIN:
REQUEST_ID:
PROGRAM_APPLICATION_ID:
PROGRAM_ID:
PROGRAM_UPDATE_DATE:
DESCRIPTION:
No comments:
Post a Comment