VIEW: APPS.WSH_POD_CARGO_V

Source

View Text - Preformatted

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 = -9999999 AND 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

View Text - HTML Formatted

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 = -9999999
AND 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