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')