View: WSH_POD_CARGO_V

Product:	WSH - Shipping Execution
Description:
Implementation/DBA Data:	APPS.WSH_POD_CARGO_V

View Text

SELECT WDI.SEQUENCE_NUMBER||TO_CHAR(WDD1.CONTAINER_NAME)||TO_CHAR(WDA.DELIVERY_DETAIL_ID) CARGO_PK
, WDD1.DELIVERY_DETAIL_ID CONTAINER_INSTANCE_ID
, WDI.SEQUENCE_NUMBER BILL_OF_LADING_NUMBER
, WND.DELIVERY_ID DELIVERY_ID
, WDD1.CONTAINER_NAME CONTAINER_NUMBER
, WDD1.SEAL_CODE SEAL_NUMBER
, WDD1.SERIAL_NUMBER SERIAL_NUMBER
, WDD1.CONTAINER_TYPE_CODE CONTAINER_TYPE
, WDD1.ITEM_DESCRIPTION CONTAINER_DESCRIPTION
, WDD1.SHIPPED_QUANTITY CONTAINER_QUANTITY
, WDD1.REQUESTED_QUANTITY_UOM CONTAINER_QUANTITY_UOM
, WDD1.GROSS_WEIGHT CONTAINER_GROSS_WEIGHT
, WDD1.NET_WEIGHT CONTAINER_NET_WEIGHT
, WDD1.WEIGHT_UOM_CODE CONTAINER_UOM_WEIGHT_CODE
, WDD1.VOLUME CONTAINER_VOLUME
, WDD1.VOLUME_UOM_CODE CONTAINER_UOM_VOLUME_CODE
, WDD2.DELIVERY_DETAIL_ID ITEM_DETAIL_ID
, WDD2.ITEM_DESCRIPTION ITEM_DESCRIPTION
, WDD2.HAZARD_CLASS_ID ITEM_HAZARD_CODE
, WDD2.COUNTRY_OF_ORIGIN ITEM_COUNTRY_OF_ORIGIN
, WDD2.CLASSIFICATION ITEM_CLASSIFICATION
, WDD2.SHIP_TOLERANCE_ABOVE ITEM_SHIP_TOLERANCE_ABOVE
, WDD2.SHIP_TOLERANCE_BELOW ITEM_SHIP_TOLERANCE_BELOW
, WDD2.SHIPPED_QUANTITY ITEM_SHIPPED_QUANTITY
, WDD2.REQUESTED_QUANTITY_UOM ITEM_SHIP_QUANTITY_UOM
, WDD2.DELIVERED_QUANTITY ITEM_DELIVERED_QUANTITY
, WDD2.SERIAL_NUMBER ITEM_SERIAL_NUMBER
, WDD2.DETAIL_CONTAINER_ITEM_ID ITEM_CONTAINER_ID
, WDD2.NET_WEIGHT ITEM_NET_WEIGHT
, WDD2.WEIGHT_UOM_CODE ITEM_WEIGHT_UOM_CODE
, WDD2.VOLUME ITEM_VOLUME
, WDD2.VOLUME_UOM_CODE ITEM_VOLUME_UOM
, WDD2.CUST_PO_NUMBER ITEM_CUST_PO_NUMBER
FROM WSH_DOCUMENT_INSTANCES WDI
, WSH_NEW_DELIVERIES WND
, WSH_DELIVERY_ASSIGNMENTS WDA
, WSH_DELIVERY_DETAILS WDD1
, WSH_DELIVERY_DETAILS WDD2
, WSH_DELIVERY_LEGS WDL
WHERE WDL.DELIVERY_LEG_ID = WDI.ENTITY_ID
AND WDI.ENTITY_NAME = 'WSH_DELIVERY_LEGS'
AND WDL.DELIVERY_ID = WND.DELIVERY_ID
AND WND.DELIVERY_ID = WDA.DELIVERY_ID
AND WDA.DELIVERY_DETAIL_ID = WDD1.DELIVERY_DETAIL_ID(+)
AND WDA.DELIVERY_DETAIL_ID = WDD2.DELIVERY_DETAIL_ID(+)

Columns