View: CST_COST_HISTORY_V

Product:	BOM - Bills of Material
Description:	Elemental item cost and adjustment quantity in a standard cost update : SINGLE-ORG view
Implementation/DBA Data:	APPS.CST_COST_HISTORY_V

View Text

SELECT CSC.ROWID
, CSC.COST_UPDATE_ID
, CSC.COST_UPDATE_ID
, COUNT(*)
, CSC.INVENTORY_ITEM_ID
, MSI.DESCRIPTION
, MSI.PADDED_ITEM_NUMBER
, MSI.PRIMARY_UOM_CODE
, CCU.DESCRIPTION
, CSC.ORGANIZATION_ID
, TRUNC(FND_DATE.ADJUST_DATETIME(CSC.STANDARD_COST_REVISION_DATE
, FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE
, FND_TIMEZONES.GET_CLIENT_TIMEZONE_CODE))
, MAX(CSC.STANDARD_COST)
, CSC.INVENTORY_ADJUSTMENT_VALUE
, CSC.INTRANSIT_ADJUSTMENT_VALUE
, CSC.WIP_ADJUSTMENT_VALUE
, CSC.INVENTORY_ADJUSTMENT_QUANTITY
, CSC.INTRANSIT_ADJUSTMENT_QUANTITY
, CSC.WIP_ADJUSTMENT_QUANTITY
, SUM(DECODE(E.COST_ELEMENT_ID
, 1
, NVL(E.STANDARD_COST
, 0)
, 0)) MTL
, SUM(DECODE(E.COST_ELEMENT_ID
, 2
, NVL(E.STANDARD_COST
, 0)
, 0)) MTL_OVH
, SUM(DECODE(E.COST_ELEMENT_ID
, 3
, NVL(E.STANDARD_COST
, 0)
, 0)) RESC
, SUM(DECODE(E.COST_ELEMENT_ID
, 4
, NVL(E.STANDARD_COST
, 0)
, 0)) OP
, SUM(DECODE(E.COST_ELEMENT_ID
, 5
, NVL(E.STANDARD_COST
, 0)
, 0)) OVHD
, CSC.LAST_UPDATE_DATE
, CSC.LAST_UPDATED_BY
, CSC.CREATION_DATE
, CSC.CREATED_BY
, CSC.LAST_UPDATE_LOGIN
, CSC.REQUEST_ID
, CSC.PROGRAM_APPLICATION_ID
, CSC.PROGRAM_ID
, CSC.PROGRAM_UPDATE_DATE
FROM CST_STANDARD_COSTS CSC
, CST_STANDARD_COSTS CSC2
, CST_ELEMENTAL_COSTS E
, CST_COST_UPDATES CCU
, MTL_ITEM_FLEXFIELDS MSI
, MTL_PARAMETERS MP
WHERE MP.ORGANIZATION_ID = CSC.ORGANIZATION_ID
AND CSC2.ORGANIZATION_ID = MP.COST_ORGANIZATION_ID
AND CSC2.INVENTORY_ITEM_ID = CSC.INVENTORY_ITEM_ID
AND CSC2.COST_UPDATE_ID = CSC.COST_UPDATE_ID
AND E.COST_UPDATE_ID(+) = CSC2.COST_UPDATE_ID
AND E.INVENTORY_ITEM_ID (+) = CSC2.INVENTORY_ITEM_ID
AND E.ORGANIZATION_ID (+) = CSC2.ORGANIZATION_ID
AND CCU.COST_UPDATE_ID(+) = CSC.COST_UPDATE_ID
AND CCU.ORGANIZATION_ID(+) = CSC.ORGANIZATION_ID
AND MSI.ORGANIZATION_ID = CSC.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = CSC.INVENTORY_ITEM_ID GROUP BY CSC.STANDARD_COST_REVISION_DATE
, CSC.INVENTORY_ITEM_ID
, MSI.DESCRIPTION
, MSI.PADDED_ITEM_NUMBER
, CSC.COST_UPDATE_ID
, MSI.PRIMARY_UOM_CODE
, CCU.DESCRIPTION
, CSC.ORGANIZATION_ID
, CSC.LAST_UPDATE_DATE
, CSC.INVENTORY_ADJUSTMENT_VALUE
, CSC.INTRANSIT_ADJUSTMENT_VALUE
, CSC.WIP_ADJUSTMENT_VALUE
, CSC.INVENTORY_ADJUSTMENT_QUANTITY
, CSC.INTRANSIT_ADJUSTMENT_QUANTITY
, CSC.WIP_ADJUSTMENT_QUANTITY
, CSC.REQUEST_ID
, CSC.LAST_UPDATED_BY
, CSC.CREATION_DATE
, CSC.CREATED_BY
, CSC.LAST_UPDATE_LOGIN
, CSC.PROGRAM_APPLICATION_ID
, CSC.PROGRAM_ID
, CSC.PROGRAM_UPDATE_DATE
, CSC.ROWID

Columns