VIEW: APPS.PO_REQUISITION_HEADERS_ALL_V

Source

View Text - Preformatted

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 , PRH.REVISION_NUM , 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 = PSP.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 TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE 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') AND PRH.REVISION_NUM IS NULL

View Text - HTML Formatted

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
, PRH.REVISION_NUM
, 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 = PSP.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 TRUNC(SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE
AND EFFECTIVE_END_DATE
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')
AND PRH.REVISION_NUM IS NULL