View: CST_CG_ITEM_COSTS_VIEW

Product:	BOM - Bills of Material
Description:	This level, previous level and total elemental costs in an average costing organization.
Implementation/DBA Data:	APPS.CST_CG_ITEM_COSTS_VIEW

View Text

SELECT NVL(CQL.LAYER_ID
, 1) LAYER_ID
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, DECODE(MP.PRIMARY_COST_METHOD
, 1
, 1
, NVL(MP.DEFAULT_COST_GROUP_ID
, 1))
, CQL.COST_GROUP_ID) COST_GROUP_ID
, NVL(CQL.LAYER_QUANTITY
, 1) LAYER_QUANTITY
, CIC.INVENTORY_ITEM_ID
, MP.ORGANIZATION_ID
, CIC.INVENTORY_ASSET_FLAG
, CIC.LOT_SIZE
, CIC.BASED_ON_ROLLUP_FLAG
, CIC.SHRINKAGE_RATE
, CIC.DEFAULTED_FLAG
, CIC.COST_UPDATE_ID
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.PL_MATERIAL
, CQL.PL_MATERIAL) PL_MATERIAL
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.PL_MATERIAL_OVERHEAD
, CQL.PL_MATERIAL_OVERHEAD) PL_MATERIAL_OVERHEAD
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.PL_RESOURCE
, CQL.PL_RESOURCE) PL_RESOURCE
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.PL_OUTSIDE_PROCESSING
, CQL.PL_OUTSIDE_PROCESSING) PL_OUTSIDE_PROCESSING
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.PL_OVERHEAD
, CQL.PL_OVERHEAD) PL_OVERHEAD
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.TL_MATERIAL
, CQL.TL_MATERIAL) TL_MATERIAL
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.TL_MATERIAL_OVERHEAD
, CQL.TL_MATERIAL_OVERHEAD) TL_MATERIAL_OVERHEAD
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.TL_RESOURCE
, CQL.TL_RESOURCE) TL_RESOURCE
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.TL_OUTSIDE_PROCESSING
, CQL.TL_OUTSIDE_PROCESSING) TL_OUTSIDE_PROCESSING
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.TL_OVERHEAD
, CQL.TL_OVERHEAD) TL_OVERHEAD
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.MATERIAL_COST
, CQL.MATERIAL_COST) MATERIAL_COST
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.MATERIAL_OVERHEAD_COST
, CQL.MATERIAL_OVERHEAD_COST) MATERIAL_OVERHEAD_COST
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.RESOURCE_COST
, CQL.RESOURCE_COST) RESOURCE_COST
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.OUTSIDE_PROCESSING_COST
, CQL.OUTSIDE_PROCESSING_COST) OUTSIDE_PROCESSING_COST
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.OVERHEAD_COST
, CQL.OVERHEAD_COST) OVERHEAD_COST
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.PL_ITEM_COST
, CQL.PL_ITEM_COST) PL_ITEM_COST
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.TL_ITEM_COST
, CQL.TL_ITEM_COST) TL_ITEM_COST
, NVL( DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.ITEM_COST
, CQL.ITEM_COST)
, 0) ITEM_COST
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.UNBURDENED_COST
, CQL.UNBURDENED_COST) UNBURDENED_COST
, DECODE(CQL.INVENTORY_ITEM_ID
, NULL
, CIC.BURDEN_COST
, CQL.BURDEN_COST) BURDEN_COST
, CIC.ATTRIBUTE1
, CIC.ATTRIBUTE2
, CIC.ATTRIBUTE3
, CIC.ATTRIBUTE4
, CIC.ATTRIBUTE5
, CIC.ATTRIBUTE6
, CIC.ATTRIBUTE7
, CIC.ATTRIBUTE8
, CIC.ATTRIBUTE9
, CIC.ATTRIBUTE10
, CIC.ATTRIBUTE11
, CIC.ATTRIBUTE12
, CIC.ATTRIBUTE13
, CIC.ATTRIBUTE14
, CIC.ATTRIBUTE15
FROM CST_QUANTITY_LAYERS CQL
, MTL_PARAMETERS MP
, CST_ITEM_COSTS CIC
WHERE CQL.INVENTORY_ITEM_ID(+) = CIC.INVENTORY_ITEM_ID AND CQL.ORGANIZATION_ID(+) = CIC.ORGANIZATION_ID
AND MP.COST_ORGANIZATION_ID = CIC.ORGANIZATION_ID AND MP.PRIMARY_COST_METHOD = CIC.COST_TYPE_ID

Columns