VIEW: APPS.CSTBV_ITEM_STD_CST_UPDATE_ADJ

Source

View Text - Preformatted

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' , WIP_ENTITY_NAME , MP1.ORGANIZATION_CODE , HAOU1.NAME , MP2.ORGANIZATION_CODE , HAOU2.NAME , /* 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, 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 '_SEC:cscav.organization_id' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

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'
, WIP_ENTITY_NAME
, MP1.ORGANIZATION_CODE
, HAOU1.NAME
, MP2.ORGANIZATION_CODE
, HAOU2.NAME
, /* 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
, 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 '_SEC:CSCAV.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY