View: CSTFV_ITEM_STD_COST_UPDT_HIST

Product:	BOM - Bills of Material
Description:	- Retrofitted
Implementation/DBA Data:	APPS.CSTFV_ITEM_STD_COST_UPDT_HIST

View Text

SELECT /* UNIQUE ATTRIBUTES */ CSC.COST_UPDATE_ID
, CSC.INVENTORY_ITEM_ID
, CSC.ORGANIZATION_ID
, CSC.LAST_COST_UPDATE_ID
, /* REGULAR ATTRIBUTES */ CSC.STANDARD_COST_REVISION_DATE
, CSC.STANDARD_COST
, CSC.INVENTORY_ADJUSTMENT_QUANTITY
, CSC.INVENTORY_ADJUSTMENT_VALUE
, CSC.INTRANSIT_ADJUSTMENT_QUANTITY
, CSC.INTRANSIT_ADJUSTMENT_VALUE
, CSC.WIP_ADJUSTMENT_QUANTITY
, CSC.WIP_ADJUSTMENT_VALUE
, /* RESOLVE FOREIGN KEY RESOLUTIONS */ MP.ORGANIZATION_CODE
, HAOU.NAME
, '_KF:INV:MSTK:MSI'
, /* ID */ /* WHO */ CSC.CREATION_DATE
, CSC.CREATED_BY
, CSC.LAST_UPDATE_DATE
, CSC.LAST_UPDATED_BY
FROM MTL_SYSTEM_ITEMS MSI
, HR_ALL_ORGANIZATION_UNITS HAOU
, MTL_PARAMETERS MP
, CST_STANDARD_COSTS CSC
WHERE CSC.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND CSC.ORGANIZATION_ID = HAOU.ORGANIZATION_ID
AND CSC.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND CSC.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND '_SEC:CSC.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns