VIEW: APPS.CST_COST_HISTORY_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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