VIEW: APPS.CST_XLA_TRF_PLA_CAT_REF_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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