DBA Data[Home] [Help]

VIEW: APPS.CSTBV_ITM_STD_CST_UPD_ELM_HST

Source

View Text - Preformatted

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
View Text - HTML Formatted

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