View: CST_XLA_TRF_PLA_CAT_REF_V

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

View Text

SELECT MC.CATEGORY_ID TRF_PLA_CATEGORY_ID
, MIC.INVENTORY_ITEM_ID TRF_PLA_CAT_ITEM_ID
, MIC.ORGANIZATION_ID TRF_PLA_CAT_ORGANIZATION_ID
, MC.ATTRIBUTE_CATEGORY TRF_PLA_ITEM_CAT_ATTR_CATEGORY
, MC.ATTRIBUTE1 TRF_PLA_ITEM_CAT_ATTRIBUTE1
, MC.ATTRIBUTE2 TRF_PLA_ITEM_CAT_ATTRIBUTE2
, MC.ATTRIBUTE3 TRF_PLA_ITEM_CAT_ATTRIBUTE3
, MC.ATTRIBUTE4 TRF_PLA_ITEM_CAT_ATTRIBUTE4
, MC.ATTRIBUTE5 TRF_PLA_ITEM_CAT_ATTRIBUTE5
, MC.ATTRIBUTE6 TRF_PLA_ITEM_CAT_ATTRIBUTE6
, MC.ATTRIBUTE7 TRF_PLA_ITEM_CAT_ATTRIBUTE7
, MC.ATTRIBUTE8 TRF_PLA_ITEM_CAT_ATTRIBUTE8
, MC.ATTRIBUTE9 TRF_PLA_ITEM_CAT_ATTRIBUTE9
, MC.ATTRIBUTE10 TRF_PLA_ITEM_CAT_ATTRIBUTE10
, MC.ATTRIBUTE11 TRF_PLA_ITEM_CAT_ATTRIBUTE11
, MC.ATTRIBUTE12 TRF_PLA_ITEM_CAT_ATTRIBUTE12
, MC.ATTRIBUTE13 TRF_PLA_ITEM_CAT_ATTRIBUTE13
, MC.ATTRIBUTE14 TRF_PLA_ITEM_CAT_ATTRIBUTE14
, MC.ATTRIBUTE15 TRF_PLA_ITEM_CAT_ATTRIBUTE15
, MC.SEGMENT1 TRF_PLA_ITEM_CAT_SEGMENT1
, MC.SEGMENT2 TRF_PLA_ITEM_CAT_SEGMENT2
, MC.SEGMENT3 TRF_PLA_ITEM_CAT_SEGMENT3
, MC.SEGMENT4 TRF_PLA_ITEM_CAT_SEGMENT4
, MC.SEGMENT5 TRF_PLA_ITEM_CAT_SEGMENT5
, MC.SEGMENT6 TRF_PLA_ITEM_CAT_SEGMENT6
, MC.SEGMENT7 TRF_PLA_ITEM_CAT_SEGMENT7
, MC.SEGMENT8 TRF_PLA_ITEM_CAT_SEGMENT8
, MC.SEGMENT9 TRF_PLA_ITEM_CAT_SEGMENT9
, MC.SEGMENT10 TRF_PLA_ITEM_CAT_SEGMENT10
, MC.SEGMENT11 TRF_PLA_ITEM_CAT_SEGMENT11
, MC.SEGMENT12 TRF_PLA_ITEM_CAT_SEGMENT12
, MC.SEGMENT13 TRF_PLA_ITEM_CAT_SEGMENT13
, MC.SEGMENT14 TRF_PLA_ITEM_CAT_SEGMENT14
, MC.SEGMENT15 TRF_PLA_ITEM_CAT_SEGMENT15
, MC.SEGMENT16 TRF_PLA_ITEM_CAT_SEGMENT16
, MC.SEGMENT17 TRF_PLA_ITEM_CAT_SEGMENT17
, MC.SEGMENT18 TRF_PLA_ITEM_CAT_SEGMENT18
, MC.SEGMENT19 TRF_PLA_ITEM_CAT_SEGMENT19
, MC.SEGMENT20 TRF_PLA_ITEM_CAT_SEGMENT20
, MCA.BRIDGING_ACCOUNT TRF_PLA_BRIDGING_ACCT
, MCA.EXPENSE_ACCOUNT TRF_PLA_EXPENSE_ACCT
, MCA.MATERIAL_ACCOUNT TRF_PLA_MATERIAL_ACCT
, MCA.MATERIAL_OVERHEAD_ACCOUNT TRF_PLA_MATERIAL_OVERHEAD_ACCT
, MCA.OUTSIDE_PROCESSING_ACCOUNT TRF_PLA_OUTSIDE_PROCESS_ACCT
, MCA.OVERHEAD_ACCOUNT TRF_PLA_OVERHEAD_ACCT
, MCA.RESOURCE_ACCOUNT TRF_PLA_RESOURCE_ACCT
, DECODE(MCA.SUBINVENTORY_CODE
, NULL
, DECODE(MCA.COST_GROUP_ID
, NULL
, '-99'
, TO_CHAR(MCA.COST_GROUP_ID))
, MCA.SUBINVENTORY_CODE) TRF_PLA_SUBINV_CG
, MCA.AVERAGE_COST_VAR_ACCOUNT TRF_PLA_ACV_ACCT
, MCA.ENCUMBRANCE_ACCOUNT TRF_PLA_ENCUMBRANCE_ACCT
, MCA.ANALYTICAL_IPV TRF_PLA_ANALYTICAL_IPV_ACCT
, MCA.ANALYTICAL_PO_MIRROR TRF_PLA_ANALYTICAL_PO_MI_ACCT
, MCA.NON_INVOICED_SO TRF_PLA_NON_INVOICED_SO_ACCT
, MCA.NON_INVOICED_REVENUE TRF_PLA_NON_INVOICED_REV_ACCT
, MCA.ANALYTICAL_REVENUE_MIRROR TRF_PLA_ANALYTICAL_REV_MI_ACCT
, MCA.ANALYTICAL_MOGS TRF_PLA_ANALYTICAL_MOGS_ACCT
FROM MTL_CATEGORIES MC
, MTL_DEFAULT_CATEGORY_SETS MDCS
, MTL_ITEM_CATEGORIES MIC
, MTL_CATEGORY_ACCOUNTS MCA
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

Columns