VIEW: APPS.CST_XLA_INV_CATEGORY_REF_V

Source

View Text - Preformatted

SELECT mc.CATEGORY_ID CATEGORY_ID, mic.INVENTORY_ITEM_ID CATEGORY_ITEM_ID, mic.ORGANIZATION_ID CATEGORY_ORGANIZATION_ID, mc.ATTRIBUTE_CATEGORY ITEM_CATEGORY_ATTR_CATEGORY, mc.ATTRIBUTE1 ITEM_CATEGORY_ATTRIBUTE1, mc.ATTRIBUTE2 ITEM_CATEGORY_ATTRIBUTE2, mc.ATTRIBUTE3 ITEM_CATEGORY_ATTRIBUTE3, mc.ATTRIBUTE4 ITEM_CATEGORY_ATTRIBUTE4, mc.ATTRIBUTE5 ITEM_CATEGORY_ATTRIBUTE5, mc.ATTRIBUTE6 ITEM_CATEGORY_ATTRIBUTE6, mc.ATTRIBUTE7 ITEM_CATEGORY_ATTRIBUTE7, mc.ATTRIBUTE8 ITEM_CATEGORY_ATTRIBUTE8, mc.ATTRIBUTE9 ITEM_CATEGORY_ATTRIBUTE9, mc.ATTRIBUTE10 ITEM_CATEGORY_ATTRIBUTE10, mc.ATTRIBUTE11 ITEM_CATEGORY_ATTRIBUTE11, mc.ATTRIBUTE12 ITEM_CATEGORY_ATTRIBUTE12, mc.ATTRIBUTE13 ITEM_CATEGORY_ATTRIBUTE13, mc.ATTRIBUTE14 ITEM_CATEGORY_ATTRIBUTE14, mc.ATTRIBUTE15 ITEM_CATEGORY_ATTRIBUTE15, mc.SEGMENT1 ITEM_CATEGORY_SEGMENT1, mc.SEGMENT2 ITEM_CATEGORY_SEGMENT2, mc.SEGMENT3 ITEM_CATEGORY_SEGMENT3, mc.SEGMENT4 ITEM_CATEGORY_SEGMENT4, mc.SEGMENT5 ITEM_CATEGORY_SEGMENT5, mc.SEGMENT6 ITEM_CATEGORY_SEGMENT6, mc.SEGMENT7 ITEM_CATEGORY_SEGMENT7, mc.SEGMENT8 ITEM_CATEGORY_SEGMENT8, mc.SEGMENT9 ITEM_CATEGORY_SEGMENT9, mc.SEGMENT10 ITEM_CATEGORY_SEGMENT10, mc.SEGMENT11 ITEM_CATEGORY_SEGMENT11, mc.SEGMENT12 ITEM_CATEGORY_SEGMENT12, mc.SEGMENT13 ITEM_CATEGORY_SEGMENT13, mc.SEGMENT14 ITEM_CATEGORY_SEGMENT14, mc.SEGMENT15 ITEM_CATEGORY_SEGMENT15, mc.SEGMENT16 ITEM_CATEGORY_SEGMENT16, mc.SEGMENT17 ITEM_CATEGORY_SEGMENT17, mc.SEGMENT18 ITEM_CATEGORY_SEGMENT18, mc.SEGMENT19 ITEM_CATEGORY_SEGMENT19, mc.SEGMENT20 ITEM_CATEGORY_SEGMENT20 from MTL_CATEGORIES mc, MTL_DEFAULT_CATEGORY_SETS mdcs, MTL_ITEM_CATEGORIES mic WHERE mc.category_id = mic.category_id AND mdcs.functional_area_id = 5 AND mic.category_set_id = mdcs.category_set_id

View Text - HTML Formatted

SELECT MC.CATEGORY_ID CATEGORY_ID
, MIC.INVENTORY_ITEM_ID CATEGORY_ITEM_ID
, MIC.ORGANIZATION_ID CATEGORY_ORGANIZATION_ID
, MC.ATTRIBUTE_CATEGORY ITEM_CATEGORY_ATTR_CATEGORY
, MC.ATTRIBUTE1 ITEM_CATEGORY_ATTRIBUTE1
, MC.ATTRIBUTE2 ITEM_CATEGORY_ATTRIBUTE2
, MC.ATTRIBUTE3 ITEM_CATEGORY_ATTRIBUTE3
, MC.ATTRIBUTE4 ITEM_CATEGORY_ATTRIBUTE4
, MC.ATTRIBUTE5 ITEM_CATEGORY_ATTRIBUTE5
, MC.ATTRIBUTE6 ITEM_CATEGORY_ATTRIBUTE6
, MC.ATTRIBUTE7 ITEM_CATEGORY_ATTRIBUTE7
, MC.ATTRIBUTE8 ITEM_CATEGORY_ATTRIBUTE8
, MC.ATTRIBUTE9 ITEM_CATEGORY_ATTRIBUTE9
, MC.ATTRIBUTE10 ITEM_CATEGORY_ATTRIBUTE10
, MC.ATTRIBUTE11 ITEM_CATEGORY_ATTRIBUTE11
, MC.ATTRIBUTE12 ITEM_CATEGORY_ATTRIBUTE12
, MC.ATTRIBUTE13 ITEM_CATEGORY_ATTRIBUTE13
, MC.ATTRIBUTE14 ITEM_CATEGORY_ATTRIBUTE14
, MC.ATTRIBUTE15 ITEM_CATEGORY_ATTRIBUTE15
, MC.SEGMENT1 ITEM_CATEGORY_SEGMENT1
, MC.SEGMENT2 ITEM_CATEGORY_SEGMENT2
, MC.SEGMENT3 ITEM_CATEGORY_SEGMENT3
, MC.SEGMENT4 ITEM_CATEGORY_SEGMENT4
, MC.SEGMENT5 ITEM_CATEGORY_SEGMENT5
, MC.SEGMENT6 ITEM_CATEGORY_SEGMENT6
, MC.SEGMENT7 ITEM_CATEGORY_SEGMENT7
, MC.SEGMENT8 ITEM_CATEGORY_SEGMENT8
, MC.SEGMENT9 ITEM_CATEGORY_SEGMENT9
, MC.SEGMENT10 ITEM_CATEGORY_SEGMENT10
, MC.SEGMENT11 ITEM_CATEGORY_SEGMENT11
, MC.SEGMENT12 ITEM_CATEGORY_SEGMENT12
, MC.SEGMENT13 ITEM_CATEGORY_SEGMENT13
, MC.SEGMENT14 ITEM_CATEGORY_SEGMENT14
, MC.SEGMENT15 ITEM_CATEGORY_SEGMENT15
, MC.SEGMENT16 ITEM_CATEGORY_SEGMENT16
, MC.SEGMENT17 ITEM_CATEGORY_SEGMENT17
, MC.SEGMENT18 ITEM_CATEGORY_SEGMENT18
, MC.SEGMENT19 ITEM_CATEGORY_SEGMENT19
, MC.SEGMENT20 ITEM_CATEGORY_SEGMENT20
FROM MTL_CATEGORIES MC
, MTL_DEFAULT_CATEGORY_SETS MDCS
, MTL_ITEM_CATEGORIES MIC
WHERE MC.CATEGORY_ID = MIC.CATEGORY_ID
AND MDCS.FUNCTIONAL_AREA_ID = 5
AND MIC.CATEGORY_SET_ID = MDCS.CATEGORY_SET_ID