VIEW: APPS.WSHBV_DOCUMENT_PACKSLIP

Source

View Text - Preformatted

SELECT WDI.DOCUMENT_INSTANCE_ID, WDI.ENTITY_NAME, WDI.ENTITY_ID, '_LA:DOCUMENT_TYPE:WSH_LOOKUPS:DOCUMENT_TYPE:MEANING', WDI.SEQUENCE_NUMBER, WDI.STATUS, WDI.FINAL_PRINT_DATE, WDI.DOC_SEQUENCE_CATEGORY_ID, WDI.CREATION_DATE, WDI.CREATED_BY, WDI.LAST_UPDATE_DATE, WDI.LAST_UPDATED_BY, WDI.LAST_UPDATE_LOGIN, WDL.POD_FLAG, WDL.POD_BY, WDL.POD_DATE, WND.REASON_OF_TRANSPORT, WND.DESCRIPTION, WND.COD_AMOUNT, WND.COD_CURRENCY_CODE, WND.COD_REMIT_TO, WND.COD_CHARGE_PAID_BY, WND.PROBLEM_CONTACT_REFERENCE, WDL.BILL_FREIGHT_TO, WND.CARRIED_BY, WDL.PORT_OF_LOADING, WDL.PORT_OF_DISCHARGE, WDL.BOOKING_OFFICE, WDL.BOOKING_NUMBER, WDL.SERVICE_CONTRACT, WDL.SHIPPER_EXPORT_REF, WDL.CARRIER_EXPORT_REF, WDL.DOC_NOTIFY_PARTY, WDL.AETC_NUMBER, WDL.SHIPPER_SIGNED_BY, WDL.SHIPPER_DATE, WDL.CARRIER_SIGNED_BY, WDL.CARRIER_DATE, WDL.DOC_ISSUE_OFFICE, WDL.DOC_ISSUED_BY, WDL.DOC_DATE_ISSUED, WDL.SHIPPER_HM_BY, WDL.SHIPPER_HM_DATE, WDL.CARRIER_HM_BY, WDL.CARRIER_HM_DATE, WDL.EXPECTED_POD_DATE FROM WSH_DOCUMENT_INSTANCES WDI, WSH_NEW_DELIVERIES WND, WSH_DELIVERY_LEGS WDL WHERE WND.DELIVERY_ID = WDI.ENTITY_ID AND WND.DELIVERY_ID = WDL.DELIVERY_ID AND WDI.DOCUMENT_TYPE = 'PACK_TYPE' AND NVL(WND.SHIPMENT_DIRECTION, 'O') IN ('O', 'IO') WITH READ ONLY

View Text - HTML Formatted

SELECT WDI.DOCUMENT_INSTANCE_ID
, WDI.ENTITY_NAME
, WDI.ENTITY_ID
, '_LA:DOCUMENT_TYPE:WSH_LOOKUPS:DOCUMENT_TYPE:MEANING'
, WDI.SEQUENCE_NUMBER
, WDI.STATUS
, WDI.FINAL_PRINT_DATE
, WDI.DOC_SEQUENCE_CATEGORY_ID
, WDI.CREATION_DATE
, WDI.CREATED_BY
, WDI.LAST_UPDATE_DATE
, WDI.LAST_UPDATED_BY
, WDI.LAST_UPDATE_LOGIN
, WDL.POD_FLAG
, WDL.POD_BY
, WDL.POD_DATE
, WND.REASON_OF_TRANSPORT
, WND.DESCRIPTION
, WND.COD_AMOUNT
, WND.COD_CURRENCY_CODE
, WND.COD_REMIT_TO
, WND.COD_CHARGE_PAID_BY
, WND.PROBLEM_CONTACT_REFERENCE
, WDL.BILL_FREIGHT_TO
, WND.CARRIED_BY
, WDL.PORT_OF_LOADING
, WDL.PORT_OF_DISCHARGE
, WDL.BOOKING_OFFICE
, WDL.BOOKING_NUMBER
, WDL.SERVICE_CONTRACT
, WDL.SHIPPER_EXPORT_REF
, WDL.CARRIER_EXPORT_REF
, WDL.DOC_NOTIFY_PARTY
, WDL.AETC_NUMBER
, WDL.SHIPPER_SIGNED_BY
, WDL.SHIPPER_DATE
, WDL.CARRIER_SIGNED_BY
, WDL.CARRIER_DATE
, WDL.DOC_ISSUE_OFFICE
, WDL.DOC_ISSUED_BY
, WDL.DOC_DATE_ISSUED
, WDL.SHIPPER_HM_BY
, WDL.SHIPPER_HM_DATE
, WDL.CARRIER_HM_BY
, WDL.CARRIER_HM_DATE
, WDL.EXPECTED_POD_DATE
FROM WSH_DOCUMENT_INSTANCES WDI
, WSH_NEW_DELIVERIES WND
, WSH_DELIVERY_LEGS WDL
WHERE WND.DELIVERY_ID = WDI.ENTITY_ID
AND WND.DELIVERY_ID = WDL.DELIVERY_ID
AND WDI.DOCUMENT_TYPE = 'PACK_TYPE'
AND NVL(WND.SHIPMENT_DIRECTION
, 'O') IN ('O'
, 'IO') WITH READ ONLY