VIEW: APPS.WSH_PACK_SLIP_V

Source

View Text - Preformatted

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') AND del.delivery_type = 'STANDARD'

View Text - HTML Formatted

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')
AND DEL.DELIVERY_TYPE = 'STANDARD'