VIEW: APPS.OKE_DELIVERABLE_SHIPPING_V

Source

View Text - Preformatted

SELECT DLVDTL.SOURCE_HEADER_ID , DLVDTL.SOURCE_LINE_ID , DLV.NAME , DLVDTL.REQUESTED_QUANTITY , DLVDTL.REQUESTED_QUANTITY_UOM , DLVDTL.SHIPPED_QUANTITY , DLVDTL.DELIVERED_QUANTITY , DLVDTL.CANCELLED_QUANTITY , DLVDTL.DATE_REQUESTED , DLVDTL.DATE_SCHEDULED , DLV.INITIAL_PICKUP_DATE , DLVDTL.SHIP_FROM_LOCATION_ID , OKE_ACTION_VALIDATIONS_PKG.get_location_description(DLVDTL.SHIP_FROM_LOCATION_ID) , DLVDTL.SHIP_TO_LOCATION_ID , OKE_ACTION_VALIDATIONS_PKG.get_location_description(DLVDTL.SHIP_TO_LOCATION_ID) , DLV.PLANNED_FLAG , DLVSTAT.MEANING , DLVDTL.TRACKING_NUMBER , DLV.WAYBILL , PACK.PACKING_SLIP_NUMBER , ( SELECT MAX(INS.SEQUENCE_NUMBER) FROM WSH_DOCUMENT_INSTANCES INS , WSH_DELIVERY_LEGS LEG WHERE LEG.DELIVERY_ID = DLV.DELIVERY_ID AND INS.ENTITY_ID = LEG.DELIVERY_LEG_ID AND INS.ENTITY_NAME = 'WSH_DELIVERY_LEGS' AND INS.DOCUMENT_TYPE = 'BOL' AND INS.STATUS <> 'CANCELLED' ) BILL_OF_LADING_NUMBER FROM WSH_NEW_DELIVERIES DLV , WSH_DELIVERY_ASSIGNMENTS DLVASGN , WSH_DELIVERY_DETAILS DLVDTL , FND_LOOKUP_VALUES_VL DLVSTAT , WSH_PACKING_SLIPS_DB_V PACK WHERE DLVDTL.SOURCE_CODE = 'OKE' AND DLV.DELIVERY_ID (+) = DLVASGN.DELIVERY_ID AND DLVDTL.DELIVERY_DETAIL_ID = DLVASGN.DELIVERY_DETAIL_ID AND DLVSTAT.LOOKUP_TYPE = 'DELIVERY_STATUS' AND DLVSTAT.LOOKUP_CODE = NVL(DLV.STATUS_CODE , 'OP') AND PACK.DELIVERY_ID (+) = DLV.DELIVERY_ID

View Text - HTML Formatted

SELECT DLVDTL.SOURCE_HEADER_ID
, DLVDTL.SOURCE_LINE_ID
, DLV.NAME
, DLVDTL.REQUESTED_QUANTITY
, DLVDTL.REQUESTED_QUANTITY_UOM
, DLVDTL.SHIPPED_QUANTITY
, DLVDTL.DELIVERED_QUANTITY
, DLVDTL.CANCELLED_QUANTITY
, DLVDTL.DATE_REQUESTED
, DLVDTL.DATE_SCHEDULED
, DLV.INITIAL_PICKUP_DATE
, DLVDTL.SHIP_FROM_LOCATION_ID
, OKE_ACTION_VALIDATIONS_PKG.GET_LOCATION_DESCRIPTION(DLVDTL.SHIP_FROM_LOCATION_ID)
, DLVDTL.SHIP_TO_LOCATION_ID
, OKE_ACTION_VALIDATIONS_PKG.GET_LOCATION_DESCRIPTION(DLVDTL.SHIP_TO_LOCATION_ID)
, DLV.PLANNED_FLAG
, DLVSTAT.MEANING
, DLVDTL.TRACKING_NUMBER
, DLV.WAYBILL
, PACK.PACKING_SLIP_NUMBER
, ( SELECT MAX(INS.SEQUENCE_NUMBER)
FROM WSH_DOCUMENT_INSTANCES INS
, WSH_DELIVERY_LEGS LEG
WHERE LEG.DELIVERY_ID = DLV.DELIVERY_ID
AND INS.ENTITY_ID = LEG.DELIVERY_LEG_ID
AND INS.ENTITY_NAME = 'WSH_DELIVERY_LEGS'
AND INS.DOCUMENT_TYPE = 'BOL'
AND INS.STATUS <> 'CANCELLED' ) BILL_OF_LADING_NUMBER
FROM WSH_NEW_DELIVERIES DLV
, WSH_DELIVERY_ASSIGNMENTS DLVASGN
, WSH_DELIVERY_DETAILS DLVDTL
, FND_LOOKUP_VALUES_VL DLVSTAT
, WSH_PACKING_SLIPS_DB_V PACK
WHERE DLVDTL.SOURCE_CODE = 'OKE'
AND DLV.DELIVERY_ID (+) = DLVASGN.DELIVERY_ID
AND DLVDTL.DELIVERY_DETAIL_ID = DLVASGN.DELIVERY_DETAIL_ID
AND DLVSTAT.LOOKUP_TYPE = 'DELIVERY_STATUS'
AND DLVSTAT.LOOKUP_CODE = NVL(DLV.STATUS_CODE
, 'OP')
AND PACK.DELIVERY_ID (+) = DLV.DELIVERY_ID