VIEW: APPS.CST_XLA_PLA_CATEGORY_REF_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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