View: PO_REQS_IN_POOL_SEC_V

Product:	PO - Purchasing
Description:	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
Implementation/DBA Data:	APPS.PO_REQS_IN_POOL_SEC_V

View Text

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 )

Columns