FND Design Data [Home] [Help]

View: WSH_PACKING_SLIPS_DB_V

Product: WSH - Shipping Execution
Description:
Implementation/DBA Data: ViewAPPS.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')

Columns

Name
ROWI_ID
DOCUMENT_INSTANCE_ID
DOCUMENT_TYPE
PACKING_SLIP_NUMBER
STATUS
FINAL_PRINT_DATE
ENTITY_NAME
ENTITY_ID
DOC_SEQUENCE_CATEGORY_ID
POD_FLAG
POD_BY
POD_DATE
REASON_OF_TRANSPORT
DESCRIPTION
DELIVERY_ID
DELIVERY_NAME