View: WSH_PACKING_SLIPS_DB_V

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

View Text

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'

Columns