VIEW: APPS.WSH_PACKING_SLIPS_DB_V

Source

View Text - Preformatted

SELECT wdi.rowid, wdi.document_instance_id, wdi.document_type, wdi.sequence_number, wdi.status, wdi.final_print_date, wdi.entity_name, wdi.entity_id, wdi.doc_sequence_category_id, wdl.pod_flag, wdl.pod_by, wdl.pod_date, wnd.reason_of_transport, wnd.description, wnd.delivery_id, wnd.name FROM WSH_DOCUMENT_INSTANCES wdi, WSH_NEW_DELIVERIES wnd, WSH_DELIVERY_LEGS wdl WHERE wdi.entity_id = wnd.delivery_id AND wnd.delivery_id = wdl.delivery_id(+) AND wdi.entity_name = 'WSH_NEW_DELIVERIES' AND wdi.document_type = 'PACK_TYPE' AND wdi.status(+) <> 'CANCELLED' AND nvl(wnd.shipment_direction, 'O') IN ('O', 'IO') AND wnd.delivery_type = 'STANDARD'

View Text - HTML Formatted

SELECT WDI.ROWID
, WDI.DOCUMENT_INSTANCE_ID
, WDI.DOCUMENT_TYPE
, WDI.SEQUENCE_NUMBER
, WDI.STATUS
, WDI.FINAL_PRINT_DATE
, WDI.ENTITY_NAME
, WDI.ENTITY_ID
, WDI.DOC_SEQUENCE_CATEGORY_ID
, WDL.POD_FLAG
, WDL.POD_BY
, WDL.POD_DATE
, WND.REASON_OF_TRANSPORT
, WND.DESCRIPTION
, WND.DELIVERY_ID
, WND.NAME
FROM WSH_DOCUMENT_INSTANCES WDI
, WSH_NEW_DELIVERIES WND
, WSH_DELIVERY_LEGS WDL
WHERE WDI.ENTITY_ID = WND.DELIVERY_ID
AND WND.DELIVERY_ID = WDL.DELIVERY_ID(+)
AND WDI.ENTITY_NAME = 'WSH_NEW_DELIVERIES'
AND WDI.DOCUMENT_TYPE = 'PACK_TYPE'
AND WDI.STATUS(+) <> 'CANCELLED'
AND NVL(WND.SHIPMENT_DIRECTION
, 'O') IN ('O'
, 'IO')
AND WND.DELIVERY_TYPE = 'STANDARD'