View: CST_DEFAULT_COST_VIEW

Product:	BOM - Bills of Material
Description:	Default item cost : SINGLE-ORG view
Implementation/DBA Data:	APPS.CST_DEFAULT_COST_VIEW

View Text

SELECT CCT.COST_TYPE_ID
, CIC.COST_TYPE_ID
, CIC.INVENTORY_ITEM_ID
, CIC.ORGANIZATION_ID
, CIC.INVENTORY_ASSET_FLAG
, CIC.LOT_SIZE
, CIC.BASED_ON_ROLLUP_FLAG
, CIC.SHRINKAGE_RATE
, CIC.DEFAULTED_FLAG
, CIC.COST_UPDATE_ID
, CIC.PL_MATERIAL
, CIC.PL_MATERIAL_OVERHEAD
, CIC.PL_RESOURCE
, CIC.PL_OUTSIDE_PROCESSING
, CIC.PL_OVERHEAD
, CIC.TL_MATERIAL
, CIC.TL_MATERIAL_OVERHEAD
, CIC.TL_RESOURCE
, CIC.TL_OVERHEAD
, CIC.MATERIAL_COST
, CIC.MATERIAL_OVERHEAD_COST
, CIC.RESOURCE_COST
, CIC.OUTSIDE_PROCESSING_COST
, CIC.OVERHEAD_COST
, CIC.PL_ITEM_COST
, CIC.TL_ITEM_COST
, CIC.ITEM_COST
, CIC.UNBURDENED_COST
, CIC.BURDEN_COST
FROM CST_ITEM_COSTS CIC
, CST_COST_TYPES CCT
WHERE CIC.ORGANIZATION_ID=NVL(CCT.ORGANIZATION_ID
, CIC.ORGANIZATION_ID)
AND ( ( (CIC.COST_TYPE_ID = CCT.DEFAULT_COST_TYPE_ID)
AND (NOT EXISTS (SELECT 'X'
FROM CST_ITEM_COSTS CIC2
WHERE CIC2.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
AND CIC2.ORGANIZATION_ID = CIC.ORGANIZATION_ID
AND CIC2.COST_TYPE_ID = CCT.COST_TYPE_ID)) ) OR (CIC.COST_TYPE_ID = CCT.COST_TYPE_ID) )

Columns