VIEW: APPS.OKE_DELIVERABLE_PURCHASING_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 , H.PO_HEADER_ID , L.PO_LINE_ID , LL.LINE_LOCATION_ID , H.SEGMENT1 , L.LINE_NUM , LL.SHIPMENT_NUM , D.QUANTITY_ORDERED , D.QUANTITY_DELIVERED , D.QUANTITY_CANCELLED , L.UNIT_MEAS_LOOKUP_CODE , EMP.FULL_NAME , LL.NEED_BY_DATE , H.VENDOR_ID , V.VENDOR_NAME , V.SEGMENT1 , H.VENDOR_SITE_ID , VS.VENDOR_SITE_CODE , S.MEANING , LOC.LOCATION_CODE FROM PO_HEADERS_ALL H , PO_LINES_ALL L , PO_LINE_LOCATIONS_ALL LL , PO_DISTRIBUTIONS_ALL D , FND_LOOKUP_VALUES_VL S , HR_LOCATIONS_ALL LOC , PER_ALL_PEOPLE_F EMP , PO_VENDORS V , PO_VENDOR_SITES_ALL VS WHERE L.PO_HEADER_ID = H.PO_HEADER_ID AND LL.PO_LINE_ID = L.PO_LINE_ID AND D.LINE_LOCATION_ID = LL.LINE_LOCATION_ID AND S.VIEW_APPLICATION_ID = 201 AND S.LOOKUP_TYPE = 'AUTHORIZATION STATUS' AND S.LOOKUP_CODE = NVL(H.AUTHORIZATION_STATUS , 'INCOMPLETE') AND LOC.LOCATION_ID (+) = LL.SHIP_TO_LOCATION_ID AND EMP.PERSON_ID = H.AGENT_ID AND TRUNC(SYSDATE) BETWEEN NVL( EMP.EFFECTIVE_START_DATE , SYSDATE - 1 ) AND NVL( EMP.EFFECTIVE_END_DATE , SYSDATE + 1 ) AND V.VENDOR_ID = H.VENDOR_ID AND VS.VENDOR_SITE_ID = H.VENDOR_SITE_ID 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
, H.PO_HEADER_ID
, L.PO_LINE_ID
, LL.LINE_LOCATION_ID
, H.SEGMENT1
, L.LINE_NUM
, LL.SHIPMENT_NUM
, D.QUANTITY_ORDERED
, D.QUANTITY_DELIVERED
, D.QUANTITY_CANCELLED
, L.UNIT_MEAS_LOOKUP_CODE
, EMP.FULL_NAME
, LL.NEED_BY_DATE
, H.VENDOR_ID
, V.VENDOR_NAME
, V.SEGMENT1
, H.VENDOR_SITE_ID
, VS.VENDOR_SITE_CODE
, S.MEANING
, LOC.LOCATION_CODE
FROM PO_HEADERS_ALL H
, PO_LINES_ALL L
, PO_LINE_LOCATIONS_ALL LL
, PO_DISTRIBUTIONS_ALL D
, FND_LOOKUP_VALUES_VL S
, HR_LOCATIONS_ALL LOC
, PER_ALL_PEOPLE_F EMP
, PO_VENDORS V
, PO_VENDOR_SITES_ALL VS
WHERE L.PO_HEADER_ID = H.PO_HEADER_ID
AND LL.PO_LINE_ID = L.PO_LINE_ID
AND D.LINE_LOCATION_ID = LL.LINE_LOCATION_ID
AND S.VIEW_APPLICATION_ID = 201
AND S.LOOKUP_TYPE = 'AUTHORIZATION STATUS'
AND S.LOOKUP_CODE = NVL(H.AUTHORIZATION_STATUS
, 'INCOMPLETE')
AND LOC.LOCATION_ID (+) = LL.SHIP_TO_LOCATION_ID
AND EMP.PERSON_ID = H.AGENT_ID
AND TRUNC(SYSDATE) BETWEEN NVL( EMP.EFFECTIVE_START_DATE
, SYSDATE - 1 )
AND NVL( EMP.EFFECTIVE_END_DATE
, SYSDATE + 1 )
AND V.VENDOR_ID = H.VENDOR_ID
AND VS.VENDOR_SITE_ID = H.VENDOR_SITE_ID
AND LL.SHIPMENT_TYPE <> 'PREPAYMENT'
AND D.DISTRIBUTION_TYPE <> 'PREPAYMENT'