Product: | INV - Inventory |
---|---|
Description: | 10SC ONLY |
Implementation/DBA Data: | APPS.MTL_ITEM_CATALOG_GROUPS_V |
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')