View: CST_XLA_PLA_CATEGORY_REF_V

Product:	BOM - Bills of Material
Description:	Product Line Category accounts
Implementation/DBA Data:	APPS.CST_XLA_PLA_CATEGORY_REF_V

View Text

SELECT MC.CATEGORY_ID PLA_CATEGORY_ID
, MIC.INVENTORY_ITEM_ID PLA_CAT_ITEM_ID
, MIC.ORGANIZATION_ID PLA_CAT_ORGANIZATION_ID
, MC.ATTRIBUTE_CATEGORY PLA_ITEM_CAT_ATTR_CATEGORY
, MC.ATTRIBUTE1 PLA_ITEM_CAT_ATTRIBUTE1
, MC.ATTRIBUTE2 PLA_ITEM_CAT_ATTRIBUTE2
, MC.ATTRIBUTE3 PLA_ITEM_CAT_ATTRIBUTE3
, MC.ATTRIBUTE4 PLA_ITEM_CAT_ATTRIBUTE4
, MC.ATTRIBUTE5 PLA_ITEM_CAT_ATTRIBUTE5
, MC.ATTRIBUTE6 PLA_ITEM_CAT_ATTRIBUTE6
, MC.ATTRIBUTE7 PLA_ITEM_CAT_ATTRIBUTE7
, MC.ATTRIBUTE8 PLA_ITEM_CAT_ATTRIBUTE8
, MC.ATTRIBUTE9 PLA_ITEM_CAT_ATTRIBUTE9
, MC.ATTRIBUTE10 PLA_ITEM_CAT_ATTRIBUTE10
, MC.ATTRIBUTE11 PLA_ITEM_CAT_ATTRIBUTE11
, MC.ATTRIBUTE12 PLA_ITEM_CAT_ATTRIBUTE12
, MC.ATTRIBUTE13 PLA_ITEM_CAT_ATTRIBUTE13
, MC.ATTRIBUTE14 PLA_ITEM_CAT_ATTRIBUTE14
, MC.ATTRIBUTE15 PLA_ITEM_CAT_ATTRIBUTE15
, MC.SEGMENT1 PLA_ITEM_CAT_SEGMENT1
, MC.SEGMENT2 PLA_ITEM_CAT_SEGMENT2
, MC.SEGMENT3 PLA_ITEM_CAT_SEGMENT3
, MC.SEGMENT4 PLA_ITEM_CAT_SEGMENT4
, MC.SEGMENT5 PLA_ITEM_CAT_SEGMENT5
, MC.SEGMENT6 PLA_ITEM_CAT_SEGMENT6
, MC.SEGMENT7 PLA_ITEM_CAT_SEGMENT7
, MC.SEGMENT8 PLA_ITEM_CAT_SEGMENT8
, MC.SEGMENT9 PLA_ITEM_CAT_SEGMENT9
, MC.SEGMENT10 PLA_ITEM_CAT_SEGMENT10
, MC.SEGMENT11 PLA_ITEM_CAT_SEGMENT11
, MC.SEGMENT12 PLA_ITEM_CAT_SEGMENT12
, MC.SEGMENT13 PLA_ITEM_CAT_SEGMENT13
, MC.SEGMENT14 PLA_ITEM_CAT_SEGMENT14
, MC.SEGMENT15 PLA_ITEM_CAT_SEGMENT15
, MC.SEGMENT16 PLA_ITEM_CAT_SEGMENT16
, MC.SEGMENT17 PLA_ITEM_CAT_SEGMENT17
, MC.SEGMENT18 PLA_ITEM_CAT_SEGMENT18
, MC.SEGMENT19 PLA_ITEM_CAT_SEGMENT19
, MC.SEGMENT20 PLA_ITEM_CAT_SEGMENT20
, MCA.BRIDGING_ACCOUNT PLA_BRIDGING_ACCOUNT
, MCA.EXPENSE_ACCOUNT PLA_EXPENSE_ACCOUNT
, MCA.MATERIAL_ACCOUNT PLA_MATERIAL_ACCOUNT
, MCA.MATERIAL_OVERHEAD_ACCOUNT PLA_MATERIAL_OVERHEAD_ACCOUNT
, MCA.OUTSIDE_PROCESSING_ACCOUNT PLA_OUTSIDE_PROCESSING_ACCOUNT
, MCA.OVERHEAD_ACCOUNT PLA_OVERHEAD_ACCOUNT
, MCA.RESOURCE_ACCOUNT PLA_RESOURCE_ACCOUNT
, DECODE(MP.PRIMARY_COST_METHOD
, 1
, MCA.SUBINVENTORY_CODE
, MCA.COST_GROUP_ID) PLA_SUBINV_CG
, MCA.AVERAGE_COST_VAR_ACCOUNT PLA_ACV_ACCOUNT
, MCA.ENCUMBRANCE_ACCOUNT PLA_ENCUMBRANCE_ACCOUNT
, MCA.ANALYTICAL_IPV PLA_ANALYTICAL_IPV_ACCT
, MCA.ANALYTICAL_PO_MIRROR PLA_ANALYTICAL_PO_MIRROR_ACCT
, MCA.NON_INVOICED_SO PLA_NON_INVOICED_SO_ACCT
, MCA.NON_INVOICED_REVENUE PLA_NON_INVOICED_REV_ACCT
, MCA.ANALYTICAL_REVENUE_MIRROR PLA_ANALYTICAL_REV_MIRROR_ACCT
, MCA.ANALYTICAL_MOGS PLA_ANALYTICAL_MOGS_ACCT
FROM MTL_CATEGORIES MC
, MTL_DEFAULT_CATEGORY_SETS MDCS
, MTL_ITEM_CATEGORIES MIC
, MTL_CATEGORY_ACCOUNTS MCA
, MTL_PARAMETERS MP
WHERE MC.CATEGORY_ID = MIC.CATEGORY_ID
AND MDCS.FUNCTIONAL_AREA_ID = 8
AND MIC.CATEGORY_SET_ID = MDCS.CATEGORY_SET_ID
AND MCA.CATEGORY_ID = MC.CATEGORY_ID
AND MCA.CATEGORY_SET_ID = MDCS.CATEGORY_SET_ID
AND MCA.ORGANIZATION_ID = MIC.ORGANIZATION_ID
AND MIC.ORGANIZATION_ID = MP.ORGANIZATION_ID

Columns