View: OKE_DTS_REQUISITIONS_V

Product:	OKE - Project Contracts
Description:	View for requisition data related to contract deliverables
Implementation/DBA Data:	APPS.OKE_DTS_REQUISITIONS_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.REQUISITION_HEADER_ID
, L.REQUISITION_LINE_ID
, H.SEGMENT1
, L.LINE_NUM
, L.QUANTITY
, L.UNIT_MEAS_LOOKUP_CODE
, EMP.FULL_NAME
, L.NEED_BY_DATE
, S.MEANING
, LOC.LOCATION_CODE
FROM PO_REQUISITION_HEADERS_ALL H
, PO_REQUISITION_LINES_ALL L
, PO_REQ_DISTRIBUTIONS_ALL D
, FND_LOOKUP_VALUES_VL S
, HR_LOCATIONS LOC
, PER_ALL_PEOPLE_F EMP
WHERE L.REQUISITION_HEADER_ID = H.REQUISITION_HEADER_ID
AND D.REQUISITION_LINE_ID = L.REQUISITION_LINE_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 (+) = L.DELIVER_TO_LOCATION_ID
AND EMP.PERSON_ID (+) = L.PURCHASING_AGENT_ID
AND TRUNC(SYSDATE) BETWEEN NVL( EMP.EFFECTIVE_START_DATE
, SYSDATE - 1 )
AND NVL( EMP.EFFECTIVE_END_DATE
, SYSDATE + 1 )

Columns