View: CST_MGD_LIFO_ITEM_COSTS_V

Product:	BOM - Bills of Material
Description:	View on which the Periodic Costing Item Inquiry form is based
Implementation/DBA Data:	APPS.CST_MGD_LIFO_ITEM_COSTS_V

View Text

SELECT PIC.ROWID ROW_ID
, PIC.COST_LAYER_ID
, PIC.CREATION_DATE
, PIC.CREATED_BY
, PIC.LAST_UPDATE_DATE
, PIC.LAST_UPDATED_BY
, PIC.LAST_UPDATE_LOGIN
, PP.LEGAL_ENTITY LEGAL_ENTITY_ID
, PIC.PAC_PERIOD_ID
, PIC.COST_GROUP_ID
, PP.COST_TYPE_ID
, PIC.INVENTORY_ITEM_ID
, MSI.DESCRIPTION INVENTORY_ITEM_DESCRIPTION
, MSI.PRIMARY_UOM_CODE UOM_CODE
, PIC.ITEM_COST
, PIC.MARKET_VALUE
, PIC.JUSTIFICATION
, PIC.REQUEST_ID
, PIC.PROGRAM_APPLICATION_ID
, PIC.PROGRAM_ID
, PIC.PROGRAM_UPDATE_DATE
, PIC.ATTRIBUTE_CATEGORY
, PIC.ATTRIBUTE1
, PIC.ATTRIBUTE2
, PIC.ATTRIBUTE3
, PIC.ATTRIBUTE4
, PIC.ATTRIBUTE5
, PIC.ATTRIBUTE6
, PIC.ATTRIBUTE7
, PIC.ATTRIBUTE8
, PIC.ATTRIBUTE9
, PIC.ATTRIBUTE10
, PIC.ATTRIBUTE11
, PIC.ATTRIBUTE12
, PIC.ATTRIBUTE13
, PIC.ATTRIBUTE14
, PIC.ATTRIBUTE15
FROM CST_PAC_ITEM_COSTS PIC
, CST_COST_GROUPS CG
, CST_PAC_PERIODS PP
, CST_COST_TYPES CT
, XLE_FIRSTPARTY_INFORMATION_V XFI
, MTL_SYSTEM_ITEMS_VL MSI
WHERE CG.COST_GROUP_ID = PIC.COST_GROUP_ID
AND PP.PAC_PERIOD_ID = PIC.PAC_PERIOD_ID
AND PP.COST_TYPE_ID = CT.COST_TYPE_ID
AND XFI.LEGAL_ENTITY_ID = PP.LEGAL_ENTITY
AND MSI.ORGANIZATION_ID = CG.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = PIC.INVENTORY_ITEM_ID

Columns