Product: | OE - Order Entry |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.WSHBV_PACKED_CONTAINER |
SELECT PC.CONTAINER_ID
, PC.DELIVERY_ID
, PC.CONTAINER_INVENTORY_ITEM_ID
, PC.QUANTITY PACKED_QUANTITY
, PC.SEQUENCE_NUMBER
, PC.PARENT_SEQUENCE_NUMBER
, PC.GROSS_WEIGHT
, PC.WEIGHT_UOM_CODE
, PC.ORGANIZATION_ID
, MSI.DESCRIPTION CONTAINER_DESCRIPTION
, PC.INVENTORY_LOCATION_ID
, PC.SUBINVENTORY
, PC.REVISION
, PC.LOT_NUMBER
, PC.SERIAL_NUMBER
, PC.MASTER_SERIAL_NUMBER
, PC.INVENTORY_STATUS INVENTORY_INTERFACED_STATUS
, PC.RA_INTERFACE_STATUS RECEIVABLE_INTERFACED_STATUS
, PC.CREATION_DATE
, PC.CREATED_BY
, PC.LAST_UPDATE_DATE
, PC.LAST_UPDATED_BY
, PC.LAST_UPDATE_LOGIN
, PC.PROGRAM_APPLICATION_ID
, PC.PROGRAM_ID
, PC.PROGRAM_UPDATE_DATE
, PC.REQUEST_ID
FROM WSH_PACKED_CONTAINERS PC
, MTL_SYSTEM_ITEMS MSI
WHERE PC.CONTAINER_INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID
AND PC.ORGANIZATION_ID = MSI.ORGANIZATION_ID