View: OKE_DTS_PURCHASING_V

Product:	OKE - Project Contracts
Description:	View for purchasing data related to contract deliverables
Implementation/DBA Data:	APPS.OKE_DTS_PURCHASING_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
, 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
, 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
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 )

Columns