This view was created for HTML Autocreate. This view retrieves the requisition headers that have one or more lines that are currently in the pool (i.e. eligible for Autocreate), in the operating units specified by the MO: Security Profile p
SELECT PRH.ORG_ID , PRH.REQUISITION_HEADER_ID , PRH.SEGMENT1 REQUISITION_NUM , PRH.DESCRIPTION , PRH.AUTHORIZATION_STATUS , PRH.CLOSED_CODE , PRH.EMERGENCY_PO_NUM , PRH.EMERGENCY_PO_ORG_ID , PRH.PCARD_ID , PRH.APPS_SOURCE_CODE , PRH.PREPARER_ID FROM PO_REQUISITION_HEADERS_ALL PRH WHERE EXISTS(SELECT 'LINES IN THE POOL FROM THE ALLOWED OPERATING UNITS' FROM PO_REQ_LINES_IN_POOL_SEC_V PRLIP WHERE PRLIP.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID )