Product: | OE - Order Entry |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.WSHFV_CONTAINER_LOAD |
SELECT WCL.MASTER_ORGANIZATION_ID
, ORG.ORGANIZATION_CODE
, WCL.CONTAINER_ITEM_ID
, MSI1.DESCRIPTION CONTAINER_DESCRIPTION
, WCL.LOAD_ITEM_ID
, MSI2.DESCRIPTION ITEM_DESCRIPTION
, WCL.MAX_LOAD_QUANTITY
, WCL.CREATION_DATE
, WCL.CREATED_BY
, WCL.LAST_UPDATE_DATE
, WCL.LAST_UPDATED_BY
, WCL.LAST_UPDATE_LOGIN
, WCL.PROGRAM_APPLICATION_ID
, WCL.PROGRAM_ID
, WCL.PROGRAM_UPDATE_DATE
, WCL.REQUEST_ID
FROM WSH_CONTAINER_LOAD WCL
, MTL_SYSTEM_ITEMS MSI1
, MTL_SYSTEM_ITEMS MSI2
, MTL_PARAMETERS ORG
WHERE WCL.CONTAINER_ITEM_ID = MSI1.INVENTORY_ITEM_ID (+)
AND WCL.MASTER_ORGANIZATION_ID = MSI1.ORGANIZATION_ID (+)
AND WCL.LOAD_ITEM_ID = MSI2.INVENTORY_ITEM_ID (+)
AND WCL.MASTER_ORGANIZATION_ID = MSI2.ORGANIZATION_ID (+)
AND ORG.ORGANIZATION_ID (+) = WCL.MASTER_ORGANIZATION_ID