VIEW: APPS.PO_REQS_IN_POOL_V

Source

View Text - Preformatted

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 trunc(PAPF.EFFECTIVE_START_DATE) AND (trunc(PAPF.EFFECTIVE_END_DATE)+1)

View Text - HTML Formatted

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 TRUNC(PAPF.EFFECTIVE_START_DATE)
AND (TRUNC(PAPF.EFFECTIVE_END_DATE)+1)