[Home] [Help]
View: PO_REQUISITION_HEADERS_ALL_V
View Text
SELECT DISTINCT PRH.SEGMENT1
, PRH.REQUISITION_HEADER_ID
, PRH.TYPE_LOOKUP_CODE
, PRH.PREPARER_ID
, PAPF.FULL_NAME
, POLC.DISPLAYED_FIELD
, PRH.DESCRIPTION
, PDT.SECURITY_LEVEL_CODE
, HOUTL.NAME
, PRH.ORG_ID
FROM PO_DOCUMENT_TYPES_ALL PDT
, PO_LOOKUP_CODES POLC
, PO_REQUISITION_HEADERS_ALL PRH
, PER_ALL_PEOPLE_F PAPF
, HR_ALL_ORGANIZATION_UNITS_TL HOUTL
, PO_SYSTEM_PARAMETERS PSP
WHERE PDT.DOCUMENT_TYPE_CODE = 'REQUISITION'
AND PDT.DOCUMENT_SUBTYPE = PRH.TYPE_LOOKUP_CODE
AND PDT.ORG_ID = PRH.ORG_ID
AND POLC.LOOKUP_TYPE = 'AUTHORIZATION STATUS'
AND POLC.LOOKUP_CODE = NVL(PRH.AUTHORIZATION_STATUS
, 'INCOMPLETE')
AND PRH.PREPARER_ID = PAPF.PERSON_ID
AND PAPF.EFFECTIVE_START_DATE = (SELECT MAX(PAPF2.EFFECTIVE_START_DATE)
FROM PER_ALL_PEOPLE_F PAPF2
WHERE PAPF2.PERSON_ID = PAPF.PERSON_ID)
AND ( PSP.ORG_ID = PRH.ORG_ID OR PSP.ORG_ID IN (SELECT PLL.ORG_ID
FROM PO_LINE_LOCATIONS_ALL PLL
, PO_REQUISITION_LINES_ALL PRL
WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
AND PRL.LINE_LOCATION_ID IS NOT NULL
AND PLL.LINE_LOCATION_ID = PRL.LINE_LOCATION_ID))
AND HOUTL.ORGANIZATION_ID(+) = PRH.ORG_ID
AND HOUTL.LANGUAGE(+) = USERENV('LANG')
Columns
Name |
SEGMENT1 |
REQUISITION_HEADER_ID |
TYPE_LOOKUP_CODE |
PREPARER_ID |
FULL_NAME |
DISPLAYED_FIELD |
DESCRIPTION |
SECURITY_LEVEL_CODE |
REQUESTING_ORG |
ORG_ID |