VIEW: APPS.CSTFV_ITEM_STD_COST_UPDT_HIST

Source

View Text - Preformatted

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

View Text - HTML Formatted

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