View: OKE_DTS_SHIPPING_V

Product:	OKE - Project Contracts
Description:	View for shipping data related to contract deliverables
Implementation/DBA Data:	APPS.OKE_DTS_SHIPPING_V

View Text

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_UTILS.GET_LOCATION_DESCRIPTION(DLVDTL.SHIP_FROM_LOCATION_ID)
, DLVDTL.SHIP_TO_LOCATION_ID
, OKE_UTILS.GET_LOCATION_DESCRIPTION(DLVDTL.SHIP_TO_LOCATION_ID)
, DLV.PLANNED_FLAG
, DLVSTAT.MEANING
, DLVDTL.TRACKING_NUMBER
, DLV.WAYBILL
, PACK.PACKING_SLIP_NUMBER
, INS.SEQUENCE_NUMBER
FROM WSH_NEW_DELIVERIES DLV
, WSH_DELIVERY_ASSIGNMENTS DLVASGN
, WSH_DELIVERY_DETAILS DLVDTL
, FND_LOOKUP_VALUES_VL DLVSTAT
, WSH_DOCUMENT_INSTANCES INS
, WSH_DELIVERY_LEGS LEG
, 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
AND INS.ENTITY_ID(+) = LEG.DELIVERY_LEG_ID
AND INS.ENTITY_NAME(+) = 'WSH_DELIVERY_LEGS'
AND INS.STATUS(+) <> 'CANCELLED'
AND LEG.DELIVERY_ID(+) = DLV.DELIVERY_ID

Columns