VIEW: APPS.WSHFV_DOCUMENT_BOL

Source

View Text - Preformatted

SELECT WDI.DOCUMENT_INSTANCE_ID, WDI.ENTITY_NAME, WDI.ENTITY_ID, '_LA:WDI.DOCUMENT_TYPE:WSH_LOOKUPS:DOCUMENT_TYPE:MEANING', WDI.SEQUENCE_NUMBER, WDI.STATUS, WDI.FINAL_PRINT_DATE, WDI.DOC_SEQUENCE_CATEGORY_ID, WDS.DOCUMENT_CODE, '_LA:WDS.ENABLED_FLAG:FND_LOOKUPS:YES_NO:MEANING', '_DF:WSH:WSH_DOCUMENT_INSTANCES:WDI', 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_DOC_SEQUENCE_CATEGORIES WDS, WSH_NEW_DELIVERIES WND, WSH_DELIVERY_LEGS WDL WHERE WDI.DOC_SEQUENCE_CATEGORY_ID = WDS.DOC_SEQUENCE_CATEGORY_ID(+) AND WDL.DELIVERY_LEG_ID = WDI.ENTITY_ID AND WDL.DELIVERY_ID = WND.DELIVERY_ID AND WDI.DOCUMENT_TYPE = 'BOL' 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:WDI.DOCUMENT_TYPE:WSH_LOOKUPS:DOCUMENT_TYPE:MEANING'
, WDI.SEQUENCE_NUMBER
, WDI.STATUS
, WDI.FINAL_PRINT_DATE
, WDI.DOC_SEQUENCE_CATEGORY_ID
, WDS.DOCUMENT_CODE
, '_LA:WDS.ENABLED_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, '_DF:WSH:WSH_DOCUMENT_INSTANCES:WDI'
, 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_DOC_SEQUENCE_CATEGORIES WDS
, WSH_NEW_DELIVERIES WND
, WSH_DELIVERY_LEGS WDL
WHERE WDI.DOC_SEQUENCE_CATEGORY_ID = WDS.DOC_SEQUENCE_CATEGORY_ID(+)
AND WDL.DELIVERY_LEG_ID = WDI.ENTITY_ID
AND WDL.DELIVERY_ID = WND.DELIVERY_ID
AND WDI.DOCUMENT_TYPE = 'BOL'
AND NVL(WND.SHIPMENT_DIRECTION
, 'O') IN ('O'
, 'IO') WITH READ ONLY