View: PO_REQS_IN_POOL_V

Product:	PO - Purchasing
Description:	10SC ONLY - Retrofitted
Implementation/DBA Data:	APPS.PO_REQS_IN_POOL_V

View Text

SELECT /*+ NO_MERGE(PRH) */ PRH.SEGMENT1
, PRH.REQUISITION_HEADER_ID
, PAPF.FULL_NAME
, PRH.DESCRIPTION
, PRH.AUTHORIZATION_STATUS
, PRH.CLOSED_CODE
, PRH.EMERGENCY_PO_NUM
, PRH.PCARD_ID
, PRH.APPS_SOURCE_CODE
, PRH.EMERGENCY_PO_ORG_ID
, PRH.ORG_ID
FROM (SELECT PRQH.SEGMENT1
, PRQH.REQUISITION_HEADER_ID
, PRQH.PREPARER_ID
, PRQH.DESCRIPTION
, PRQH.AUTHORIZATION_STATUS
, PRQH.CLOSED_CODE
, PRQH.EMERGENCY_PO_NUM
, PRQH.PCARD_ID
, PRQH.APPS_SOURCE_CODE
, PRQH.EMERGENCY_PO_ORG_ID
, PRQH.ORG_ID
FROM PO_REQUISITION_HEADERS PRQH
WHERE NVL(PRQH.CANCEL_FLAG
, 'N') = 'N'
AND NVL(PRQH.CLOSED_CODE
, 'OPEN') != 'FINALLY CLOSED'
AND EXISTS (SELECT 'LINES CAN BE PUT ON A PO'
FROM PO_REQUISITION_LINES_ALL PRL
WHERE PRL.REQUISITION_HEADER_ID = PRQH.REQUISITION_HEADER_ID
AND PRL.LINE_LOCATION_ID IS NULL
AND NVL(PRL.AT_SOURCING_FLAG
, 'N') = 'N'
AND NVL(PRL.CANCEL_FLAG
, 'N') = 'N'
AND NVL(PRL.CLOSED_CODE
, 'OPEN') != 'FINALLY CLOSED'
AND NVL(PRL.MODIFIED_BY_AGENT_FLAG
, 'N') = 'N'
AND PRL.SOURCE_TYPE_CODE = 'VENDOR' ) ) PRH
, PER_ALL_PEOPLE_F PAPF
WHERE PRH.PREPARER_ID = PAPF.PERSON_ID
AND SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE
AND PAPF.EFFECTIVE_END_DATE

Columns