View: CSTBV_ITM_STD_CST_UPD_ELM_HST

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

View Text

SELECT /* UNIQUE ATTRIBUTES */ CEC.COST_UPDATE_ID
, CEC.ORGANIZATION_ID
, CEC.INVENTORY_ITEM_ID
, CEC.COST_ELEMENT_ID
, /* REGULAR ATTRIBUTES */ CEC.STANDARD_COST
, /* RESOLVE FOREIGN KEY RESOLUTIONS */ CCU.DESCRIPTION
, MP.ORGANIZATION_CODE
, HAOU.NAME
, '_KF:INV:MSTK:MSI'
, CCE.COST_ELEMENT
, /* ID */ /* WHO */ CEC.CREATION_DATE
, CEC.CREATED_BY
, CEC.LAST_UPDATE_DATE
, CEC.LAST_UPDATED_BY
FROM CST_COST_ELEMENTS CCE
, MTL_SYSTEM_ITEMS MSI
, CST_COST_UPDATES CCU
, HR_ALL_ORGANIZATION_UNITS HAOU
, MTL_PARAMETERS MP
, CST_ELEMENTAL_COSTS CEC
WHERE CEC.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND CEC.ORGANIZATION_ID = HAOU.ORGANIZATION_ID
AND CEC.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND CEC.ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND CEC.COST_UPDATE_ID = CCU.COST_UPDATE_ID (+)
AND CEC.ORGANIZATION_ID = CCU.ORGANIZATION_ID (+)
AND CEC.COST_ELEMENT_ID = CCE.COST_ELEMENT_ID
AND '_SEC:CEC.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns