View: CST_XLA_INV_CATEGORY_REF_V

Product:	BOM - Bills of Material
Description:
Implementation/DBA Data:	APPS.CST_XLA_INV_CATEGORY_REF_V

View Text

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

Columns