FND Design Data [Home] [Help]

View: WSH_PACK_SLIP_V

Product: WSH - Shipping Execution
Description:
Implementation/DBA Data: ViewAPPS.WSH_PACK_SLIP_V
View Text

SELECT DEL.DELIVERY_ID DELIVERY_ID
, DEL.NAME DELIVERY_NAME
, DEL.ORGANIZATION_ID
FROM WSH_NEW_DELIVERIES DEL
, WSH_DOCUMENT_INSTANCES DOC
WHERE DEL.STATUS_CODE!='CA'
AND DEL.DELIVERY_ID=DOC.ENTITY_ID
AND DOC.FINAL_PRINT_DATE IS NULL
AND DOC.DOCUMENT_TYPE='PACK_TYPE'
AND DOC.ENTITY_NAME='WSH_NEW_DELIVERIES'
AND NVL(DEL.SHIPMENT_DIRECTION
, 'O') IN ('O'
, 'IO')

Columns

Name
DELIVERY_ID
DELIVERY_NAME
ORGANIZATION_ID