View: CST_CQL_CIC_ITEM_COSTS_V

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

View Text

SELECT CQL.ORGANIZATION_ID
, CQL.INVENTORY_ITEM_ID
, CQL.COST_GROUP_ID
, -1
, CQL.ITEM_COST
, CQL.PL_MATERIAL
, CQL.PL_MATERIAL_OVERHEAD
, CQL.PL_RESOURCE
, CQL.PL_OUTSIDE_PROCESSING
, CQL.PL_OVERHEAD
, CQL.TL_MATERIAL
, CQL.TL_MATERIAL_OVERHEAD
, CQL.TL_RESOURCE
, CQL.TL_OUTSIDE_PROCESSING
, CQL.TL_OVERHEAD
, CQL.MATERIAL_COST
, CQL.MATERIAL_OVERHEAD_COST
, CQL.RESOURCE_COST
, CQL.OUTSIDE_PROCESSING_COST
, CQL.OVERHEAD_COST
, CQL.PL_ITEM_COST
, CQL.TL_ITEM_COST
, CQL.UNBURDENED_COST
, CQL.BURDEN_COST
, DECODE(MSI.INVENTORY_ASSET_FLAG
, 'Y'
, 1
, 0)
FROM CST_QUANTITY_LAYERS CQL
, MTL_SYSTEM_ITEMS MSI
WHERE CQL.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND CQL.ORGANIZATION_ID = MSI.ORGANIZATION_ID UNION ALL SELECT ORGANIZATION_ID
, INVENTORY_ITEM_ID
, -1
, COST_TYPE_ID
, ITEM_COST
, PL_MATERIAL
, PL_MATERIAL_OVERHEAD
, PL_RESOURCE
, PL_OUTSIDE_PROCESSING
, PL_OVERHEAD
, TL_MATERIAL
, TL_MATERIAL_OVERHEAD
, TL_RESOURCE
, TL_OUTSIDE_PROCESSING
, TL_OVERHEAD
, MATERIAL_COST
, MATERIAL_OVERHEAD_COST
, RESOURCE_COST
, OUTSIDE_PROCESSING_COST
, OVERHEAD_COST
, PL_ITEM_COST
, TL_ITEM_COST
, UNBURDENED_COST
, BURDEN_COST
, INVENTORY_ASSET_FLAG
FROM CST_ITEM_COSTS

Columns