View: OKE_DTS_RECEIVING_V

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

View Text

SELECT L.OKE_CONTRACT_HEADER_ID
, D.OKE_CONTRACT_LINE_ID
, D.OKE_CONTRACT_DELIVERABLE_ID
, D.PROJECT_ID
, D.TASK_ID
, L.PO_HEADER_ID
, L.PO_LINE_ID
, LL.LINE_LOCATION_ID
, SH.SHIPMENT_HEADER_ID
, SL.SHIPMENT_LINE_ID
, SH.RECEIPT_NUM
, L.QUANTITY
, LL.NEED_BY_DATE
, SL.LINE_NUM
, SLS.MEANING
, T.QUANTITY
, T.UNIT_OF_MEASURE
, T.TRANSACTION_TYPE
, T.TRANSACTION_DATE
, T.DESTINATION_TYPE_CODE
, LL.PROMISED_DATE
, SH.SHIPPED_DATE
, DT.MEANING
FROM PO_LINES_ALL L
, PO_LINE_LOCATIONS_ALL LL
, PO_DISTRIBUTIONS_ALL D
, RCV_SHIPMENT_HEADERS SH
, RCV_SHIPMENT_LINES SL
, RCV_TRANSACTIONS T
, FND_LOOKUP_VALUES SLS
, FND_LOOKUP_VALUES DT
WHERE SL.SHIPMENT_LINE_ID = T.SHIPMENT_LINE_ID
AND SH.SHIPMENT_HEADER_ID = SL.SHIPMENT_HEADER_ID
AND T.PO_DISTRIBUTION_ID = D.PO_DISTRIBUTION_ID
AND L.PO_LINE_ID = SL.PO_LINE_ID
AND LL.LINE_LOCATION_ID = SL.PO_LINE_LOCATION_ID
AND LL.PO_LINE_ID = L.PO_LINE_ID
AND D.LINE_LOCATION_ID = LL.LINE_LOCATION_ID
AND SLS.VIEW_APPLICATION_ID (+) = 201
AND SLS.LOOKUP_TYPE (+) = 'SHIPMENT LINE STATUS'
AND SLS.LOOKUP_CODE (+) = SL.SHIPMENT_LINE_STATUS_CODE
AND SLS.LANGUAGE (+) = USERENV('LANG')
AND D.OKE_CONTRACT_DELIVERABLE_ID IS NOT NULL
AND DT.VIEW_APPLICATION_ID = 201
AND DT.LOOKUP_TYPE = 'RCV TRANSACTION TYPE'
AND DT.LOOKUP_CODE = T.TRANSACTION_TYPE
AND DT.LANGUAGE = USERENV('LANG')

Columns