FND Design Data [Home] [Help]

View: PO_REQ_LINES_IN_POOL_SEC_V

Product: PO - Purchasing
Description:
Implementation/DBA Data: ViewAPPS.PO_REQ_LINES_IN_POOL_SEC_V
View Text

SELECT PRH.ORG_ID
, PRH.REQUISITION_HEADER_ID
, PRH.SEGMENT1 REQUISITION_NUM
, PRL.REQUISITION_LINE_ID
, PRL.LINE_NUM
, PRL.SUGGESTED_VENDOR_NAME
, PRL.SUGGESTED_VENDOR_LOCATION
, PRL.VENDOR_ID
, PRL.VENDOR_SITE_ID
, PRL.AUCTION_DISPLAY_NUMBER
, PRL.AUCTION_HEADER_ID
, PRL.BLANKET_PO_HEADER_ID
FROM PO_REQUISITION_HEADERS_ALL PRH
, PO_REQUISITION_LINES_ALL PRL
WHERE PRH.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID
AND NVL(PRH.CANCEL_FLAG
, 'N') = 'N'
AND NVL(PRH.CLOSED_CODE
, 'OPEN') != 'FINALLY CLOSED'
AND PRH.AUTHORIZATION_STATUS = 'APPROVED'
AND NVL(PRL.LINE_LOCATION_ID
, -999) = -999
AND NVL(PRL.REQS_IN_POOL_FLAG
, 'Y') = 'Y'
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'
AND (PRH.ORG_ID IS NULL /** SINGLE-ORG INSTANCE **/ OR PRH.ORG_ID IN (SELECT ORGANIZATION_ID
FROM PER_ORGANIZATION_LIST
WHERE SECURITY_PROFILE_ID = FND_PROFILE.VALUE('XLA_MO_SECURITY_PROFILE_LEVEL')))

Columns

Name
ORG_ID
REQUISITION_HEADER_ID
REQUISITION_NUM
REQUISITION_LINE_ID
LINE_NUM
SUGGESTED_VENDOR_NAME
SUGGESTED_VENDOR_LOCATION
VENDOR_ID
VENDOR_SITE_ID
AUCTION_DISPLAY_NUMBER
AUCTION_HEADER_ID
BLANKET_PO_HEADER_ID