VIEW: APPS.MTL_ITEM_CATALOG_GROUPS_V

Source

View Text - Preformatted

SELECT MICG.ROW_ID , MICG.ITEM_CATALOG_GROUP_ID , MICG.LAST_UPDATE_DATE , MICG.LAST_UPDATED_BY , MICG.CREATION_DATE , MICG.CREATED_BY , MICG.LAST_UPDATE_LOGIN , MICG.INACTIVE_DATE , MICG.PARENT_CATALOG_GROUP_ID , MICG.ITEM_CREATION_ALLOWED_FLAG , MICG.ITEM_NUM_GEN_METHOD , MICG.PREFIX , MICG.STARTING_NUMBER , MICG.INCREMENT_BY , MICG.SUFFIX , MICG.CURRENT_NUMBER , MICG.ITEM_NUM_ACTION_ID , MICG.ITEM_DESC_GEN_METHOD , MICG.ITEM_DESC_ACTION_ID , MICG.NEW_ITEM_REQUEST_REQD , MICG.NEW_ITEM_REQ_CHANGE_TYPE_ID , MICG.ITEM_NUM_SEQ_NAME , MICG.SUMMARY_FLAG , MICG.ENABLED_FLAG , MICG.START_DATE_ACTIVE , MICG.END_DATE_ACTIVE , MICG.SEGMENT1 , MICG.SEGMENT2 , MICG.SEGMENT3 , MICG.SEGMENT4 , MICG.SEGMENT5 , MICG.SEGMENT6 , MICG.SEGMENT7 , MICG.SEGMENT8 , MICG.SEGMENT9 , MICG.SEGMENT10 , MICG.SEGMENT11 , MICG.SEGMENT12 , MICG.SEGMENT13 , MICG.SEGMENT14 , MICG.SEGMENT15 , MICG.ATTRIBUTE_CATEGORY , MICG.ATTRIBUTE1 , MICG.ATTRIBUTE2 , MICG.ATTRIBUTE3 , MICG.ATTRIBUTE4 , MICG.ATTRIBUTE5 , MICG.ATTRIBUTE6 , MICG.ATTRIBUTE7 , MICG.ATTRIBUTE8 , MICG.ATTRIBUTE9 , MICG.ATTRIBUTE10 , MICG.ATTRIBUTE11 , MICG.ATTRIBUTE12 , MICG.ATTRIBUTE13 , MICG.ATTRIBUTE14 , MICG.ATTRIBUTE15 , MICG.REQUEST_ID , MICG.PROGRAM_APPLICATION_ID , MICG.PROGRAM_ID , MICG.PROGRAM_UPDATE_DATE , MICG.SEGMENT16 , MICG.SEGMENT17 , MICG.SEGMENT18 , MICG.SEGMENT19 , MICG.SEGMENT20 , T.DESCRIPTION , MICG.CONCATENATED_SEGMENTS CATALOG_CONCAT_SEGS , MICG.PADDED_CONCATENATED_SEGMENTS CATALOG_PADDED_CONCAT_SEGS FROM MTL_ITEM_CATALOG_GROUPS_TL T , MTL_ITEM_CATALOG_GROUPS_B_KFV MICG WHERE MICG.ITEM_CATALOG_GROUP_ID = T.ITEM_CATALOG_GROUP_ID AND T.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT MICG.ROW_ID
, MICG.ITEM_CATALOG_GROUP_ID
, MICG.LAST_UPDATE_DATE
, MICG.LAST_UPDATED_BY
, MICG.CREATION_DATE
, MICG.CREATED_BY
, MICG.LAST_UPDATE_LOGIN
, MICG.INACTIVE_DATE
, MICG.PARENT_CATALOG_GROUP_ID
, MICG.ITEM_CREATION_ALLOWED_FLAG
, MICG.ITEM_NUM_GEN_METHOD
, MICG.PREFIX
, MICG.STARTING_NUMBER
, MICG.INCREMENT_BY
, MICG.SUFFIX
, MICG.CURRENT_NUMBER
, MICG.ITEM_NUM_ACTION_ID
, MICG.ITEM_DESC_GEN_METHOD
, MICG.ITEM_DESC_ACTION_ID
, MICG.NEW_ITEM_REQUEST_REQD
, MICG.NEW_ITEM_REQ_CHANGE_TYPE_ID
, MICG.ITEM_NUM_SEQ_NAME
, MICG.SUMMARY_FLAG
, MICG.ENABLED_FLAG
, MICG.START_DATE_ACTIVE
, MICG.END_DATE_ACTIVE
, MICG.SEGMENT1
, MICG.SEGMENT2
, MICG.SEGMENT3
, MICG.SEGMENT4
, MICG.SEGMENT5
, MICG.SEGMENT6
, MICG.SEGMENT7
, MICG.SEGMENT8
, MICG.SEGMENT9
, MICG.SEGMENT10
, MICG.SEGMENT11
, MICG.SEGMENT12
, MICG.SEGMENT13
, MICG.SEGMENT14
, MICG.SEGMENT15
, MICG.ATTRIBUTE_CATEGORY
, MICG.ATTRIBUTE1
, MICG.ATTRIBUTE2
, MICG.ATTRIBUTE3
, MICG.ATTRIBUTE4
, MICG.ATTRIBUTE5
, MICG.ATTRIBUTE6
, MICG.ATTRIBUTE7
, MICG.ATTRIBUTE8
, MICG.ATTRIBUTE9
, MICG.ATTRIBUTE10
, MICG.ATTRIBUTE11
, MICG.ATTRIBUTE12
, MICG.ATTRIBUTE13
, MICG.ATTRIBUTE14
, MICG.ATTRIBUTE15
, MICG.REQUEST_ID
, MICG.PROGRAM_APPLICATION_ID
, MICG.PROGRAM_ID
, MICG.PROGRAM_UPDATE_DATE
, MICG.SEGMENT16
, MICG.SEGMENT17
, MICG.SEGMENT18
, MICG.SEGMENT19
, MICG.SEGMENT20
, T.DESCRIPTION
, MICG.CONCATENATED_SEGMENTS CATALOG_CONCAT_SEGS
, MICG.PADDED_CONCATENATED_SEGMENTS CATALOG_PADDED_CONCAT_SEGS
FROM MTL_ITEM_CATALOG_GROUPS_TL T
, MTL_ITEM_CATALOG_GROUPS_B_KFV MICG
WHERE MICG.ITEM_CATALOG_GROUP_ID = T.ITEM_CATALOG_GROUP_ID
AND T.LANGUAGE = USERENV('LANG')