VIEW: APPS.WSHBV_PACKED_CONTAINER

Source

View Text - Preformatted

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

View Text - HTML Formatted

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