VIEW: APPS.OKE_DELIVERABLE_RECEIVING_V

Source

View Text - Preformatted

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 , LL.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.CREATION_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') AND LL.shipment_type <> 'PREPAYMENT' AND D.distribution_type <> 'PREPAYMENT'

View Text - HTML Formatted

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
, LL.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.CREATION_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')
AND LL.SHIPMENT_TYPE <> 'PREPAYMENT'
AND D.DISTRIBUTION_TYPE <> 'PREPAYMENT'