View: CSTFV_ITEM_STD_CST_UPDATE_ADJ

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

View Text

SELECT /* UNIQUE ATTRIBUTES */ CSCAV.COST_UPDATE_ID
, CSCAV.COST_ELEMENT_ID
, CSCAV.ORGANIZATION_ID
, CSCAV.INVENTORY_ITEM_ID
, CSCAV.WIP_ENTITY_ID
, CSCAV.SUBINVENTORY
, CSCAV.OPERATION_SEQ_NUM
, CSCAV.FROM_ORGANIZATION_ID
, CSCAV.TO_ORGANIZATION_ID
, CSCAV.DEPARTMENT_ID
, CSCAV.RESOURCE_ID
, /* REGULAR ATTRIBUTES */ '_LA:CSCAV.TRANSACTION_TYPE:MFG_LOOKUPS:CST_UPDATE_TXN_TYPE:MEANING'
, CSCAV.ADJUSTMENT_QUANTITY
, CSCAV.OLD_UNIT_COST
, CSCAV.NEW_UNIT_COST
, '_LA:CSCAV.LEVEL_TYPE:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, CSCAV.IN_OUT_FLAG
, CSCAV.RESOURCE_SEQ_ID
, CSCAV.RESOURCE_SEQ_NUM
, '_LA:CSCAV.STANDARD_RATE_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, CSCAV.TRANSACTION_ID
, '_LA:CSCAV.BASIS_TYPE:MFG_LOOKUPS:CST_BASIS:MEANING'
, /* RESOLVE FOREIGN KEY RESOLUTIONS */ MP.ORGANIZATION_CODE
, HAOU.NAME
, CCU.DESCRIPTION
, CCE.COST_ELEMENT
, '_KF:INV:MSTK:MSI'
, WE.WIP_ENTITY_NAME
, MP1.ORGANIZATION_CODE
, HAOU1.NAME
, MP2.ORGANIZATION_CODE
, HAOU2.NAME
, BD.DEPARTMENT_CODE
, BR.RESOURCE_CODE
, /* ID */ /* WHO */ CSCAV.CREATION_DATE
, CSCAV.CREATED_BY
, CSCAV.LAST_UPDATE_DATE
, CSCAV.LAST_UPDATED_BY
FROM WIP_ENTITIES WE
, MTL_SYSTEM_ITEMS MSI
, CST_COST_UPDATES CCU
, CST_COST_ELEMENTS CCE
, BOM_RESOURCES BR
, BOM_DEPARTMENTS BD
, HR_ALL_ORGANIZATION_UNITS HAOU
, MTL_PARAMETERS MP
, HR_ALL_ORGANIZATION_UNITS HAOU1
, MTL_PARAMETERS MP1
, HR_ALL_ORGANIZATION_UNITS HAOU2
, MTL_PARAMETERS MP2
, CST_STD_COST_ADJ_VALUES CSCAV
WHERE /* ORGANIZATION_ID IS A PRIMARY KEY
AND NOT NULL */ CSCAV.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND CSCAV.ORGANIZATION_ID = HAOU.ORGANIZATION_ID /* FROM_ORGANIZATION_ID IS A PRIMARY KEY
AND NULL ???
, HENCE THE OUTER JOIN */
AND CSCAV.FROM_ORGANIZATION_ID = MP1.ORGANIZATION_ID(+)
AND CSCAV.FROM_ORGANIZATION_ID = HAOU1.ORGANIZATION_ID(+) /* TO_ORGANIZATION_ID IS A PRIMARY KEY
AND NULL ???
, HENCE THE OUTER JOIN */
AND CSCAV.TO_ORGANIZATION_ID = MP2.ORGANIZATION_ID(+)
AND CSCAV.TO_ORGANIZATION_ID = HAOU2.ORGANIZATION_ID(+) /* COST_ELEMENT IS A PRIMARY
AND NOT NULL */
AND CSCAV.COST_ELEMENT_ID = CCE.COST_ELEMENT_ID /* INVENTORY_ITEM_ID
AND PRIMARY KEY
AND NULL
, HENCE THE OUTER JOIN. ALSO THE INVENTORY_ITEM_ID IS BASED ON ORGANIZATION_ID
, HENCE WE HAVE ANOTHER JOIN TO ORGANIZATION_ID (ALSO AN OUTER JOIN) */
AND CSCAV.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID(+)
AND CSCAV.ORGANIZATION_ID = MSI.ORGANIZATION_ID(+) /* WIP_ENTITY_ID IS A PRIMARY KEY
AND NULL.ALSO DEPENDS ON ORGANIZATION_ID
, HENCE THE TWO JOINS
, BOTH OF WHICH ARE OUTER */
AND CSCAV.WIP_ENTITY_ID = WE.WIP_ENTITY_ID(+)
AND CSCAV.ORGANIZATION_ID = WE.ORGANIZATION_ID(+) /* SUBINVENTORY IS A PRIMARY KEY
AND NULL.ALSO DEPENDS ON ORGANIZATION_ID
, HENCE THE TWO JOINS
, BOTH OF WHICH ARE OUTER */ /* COST_UPDATE_ID IS A PRIMARY KEY
AND NOT NULL.ALSO DEPENDS ON ORGANIZATION_ID
, HENCE THE TWO JOINS */
AND CSCAV.COST_UPDATE_ID = CCU.COST_UPDATE_ID
AND CSCAV.ORGANIZATION_ID = CCU.ORGANIZATION_ID
AND CSCAV.DEPARTMENT_ID = BD.DEPARTMENT_ID(+)
AND CSCAV.RESOURCE_ID = BR.RESOURCE_ID(+)
AND '_SEC:CSCAV.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns