View: CST_ITEM_COSTS_FOR_GL_VIEW

Product:	BOM - Bills of Material
Description:	Item costs depending on costing method : SINGLE-ORG view
Implementation/DBA Data:	APPS.CST_ITEM_COSTS_FOR_GL_VIEW

View Text

SELECT 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
, NVL(CIC.PL_MATERIAL
, 0)
, NVL(CIC.PL_MATERIAL_OVERHEAD
, 0)
, NVL(CIC.PL_RESOURCE
, 0)
, NVL(CIC.PL_OUTSIDE_PROCESSING
, 0)
, NVL(CIC.PL_OVERHEAD
, 0)
, NVL(CIC.TL_MATERIAL
, 0)
, NVL(CIC.TL_MATERIAL_OVERHEAD
, 0)
, NVL(CIC.TL_RESOURCE
, 0)
, NVL(CIC.TL_OUTSIDE_PROCESSING
, 0)
, NVL(CIC.TL_OVERHEAD
, 0)
, NVL(CIC.MATERIAL_COST
, 0)
, NVL(CIC.MATERIAL_OVERHEAD_COST
, 0)
, NVL(CIC.RESOURCE_COST
, 0)
, NVL(CIC.OUTSIDE_PROCESSING_COST
, 0)
, NVL(CIC.OVERHEAD_COST
, 0)
, NVL(CIC.PL_ITEM_COST
, 0)
, NVL(CIC.TL_ITEM_COST
, 0)
, NVL(CIC.ITEM_COST
, 0)
, NVL(CIC.UNBURDENED_COST
, 0)
, NVL(CIC.BURDEN_COST
, 0)
, 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 MTL_PARAMETERS MP
, CST_ITEM_COSTS CIC
WHERE CIC.ORGANIZATION_ID = MP.COST_ORGANIZATION_ID
AND CIC.COST_TYPE_ID = MP.PRIMARY_COST_METHOD

Columns