VIEW: APPS.PO_REQ_HEADERS_REF_V

Source

View Text - Preformatted

SELECT PRH.REQUISITION_HEADER_ID, PRH.SEGMENT1 , PODT.TYPE_NAME , PRH.DESCRIPTION, PRH.PREPARER_ID, HR.FULL_NAME, PRH.ORG_ID, HOU.NAME, PRH.CBC_ACCOUNTING_DATE, FSP.REQ_ENCUMBRANCE_TYPE_ID, GLET.ENCUMBRANCE_TYPE , FSP.REQ_ENCUMBRANCE_FLAG, FSP.PURCH_ENCUMBRANCE_FLAG, PRH.ATTRIBUTE_CATEGORY , PRH.ATTRIBUTE1, PRH.ATTRIBUTE2, PRH.ATTRIBUTE3, PRH.ATTRIBUTE4, PRH.ATTRIBUTE5, PRH.ATTRIBUTE6, PRH.ATTRIBUTE7, PRH.ATTRIBUTE8, PRH.ATTRIBUTE9, PRH.ATTRIBUTE10, PRH.ATTRIBUTE11, PRH.ATTRIBUTE12, PRH.ATTRIBUTE13, PRH.ATTRIBUTE14, PRH.ATTRIBUTE15 FROM PO_REQUISITION_HEADERS_ALL PRH, HR_ALL_ORGANIZATION_UNITS_TL HOU, FINANCIALS_SYSTEM_PARAMS_ALL FSP, PO_DOCUMENT_TYPES_ALL_B PODB, PO_DOCUMENT_TYPES_ALL_TL PODT, GL_ENCUMBRANCE_TYPES GLET, HR_EMPLOYEES HR WHERE PRH.ORG_ID = FSP.ORG_ID AND PODB.DOCUMENT_TYPE_CODE = 'REQUISITION' AND PODB.ORG_ID = PRH.ORG_ID AND PODB.DOCUMENT_SUBTYPE = PRH.TYPE_LOOKUP_CODE AND PODB.DOCUMENT_TYPE_CODE = PODT.DOCUMENT_TYPE_CODE AND PODB.DOCUMENT_SUBTYPE = PODT.DOCUMENT_SUBTYPE AND PODT.LANGUAGE = USERENV('LANG') AND PODT.ORG_ID = PODB.ORG_ID AND FSP.REQ_ENCUMBRANCE_TYPE_ID = GLET.ENCUMBRANCE_TYPE_ID(+) AND PRH.PREPARER_ID = HR.EMPLOYEE_ID AND PRH.ORG_ID = HOU.ORGANIZATION_ID AND HOU.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT PRH.REQUISITION_HEADER_ID
, PRH.SEGMENT1
, PODT.TYPE_NAME
, PRH.DESCRIPTION
, PRH.PREPARER_ID
, HR.FULL_NAME
, PRH.ORG_ID
, HOU.NAME
, PRH.CBC_ACCOUNTING_DATE
, FSP.REQ_ENCUMBRANCE_TYPE_ID
, GLET.ENCUMBRANCE_TYPE
, FSP.REQ_ENCUMBRANCE_FLAG
, FSP.PURCH_ENCUMBRANCE_FLAG
, PRH.ATTRIBUTE_CATEGORY
, PRH.ATTRIBUTE1
, PRH.ATTRIBUTE2
, PRH.ATTRIBUTE3
, PRH.ATTRIBUTE4
, PRH.ATTRIBUTE5
, PRH.ATTRIBUTE6
, PRH.ATTRIBUTE7
, PRH.ATTRIBUTE8
, PRH.ATTRIBUTE9
, PRH.ATTRIBUTE10
, PRH.ATTRIBUTE11
, PRH.ATTRIBUTE12
, PRH.ATTRIBUTE13
, PRH.ATTRIBUTE14
, PRH.ATTRIBUTE15
FROM PO_REQUISITION_HEADERS_ALL PRH
, HR_ALL_ORGANIZATION_UNITS_TL HOU
, FINANCIALS_SYSTEM_PARAMS_ALL FSP
, PO_DOCUMENT_TYPES_ALL_B PODB
, PO_DOCUMENT_TYPES_ALL_TL PODT
, GL_ENCUMBRANCE_TYPES GLET
, HR_EMPLOYEES HR
WHERE PRH.ORG_ID = FSP.ORG_ID
AND PODB.DOCUMENT_TYPE_CODE = 'REQUISITION'
AND PODB.ORG_ID = PRH.ORG_ID
AND PODB.DOCUMENT_SUBTYPE = PRH.TYPE_LOOKUP_CODE
AND PODB.DOCUMENT_TYPE_CODE = PODT.DOCUMENT_TYPE_CODE
AND PODB.DOCUMENT_SUBTYPE = PODT.DOCUMENT_SUBTYPE
AND PODT.LANGUAGE = USERENV('LANG')
AND PODT.ORG_ID = PODB.ORG_ID
AND FSP.REQ_ENCUMBRANCE_TYPE_ID = GLET.ENCUMBRANCE_TYPE_ID(+)
AND PRH.PREPARER_ID = HR.EMPLOYEE_ID
AND PRH.ORG_ID = HOU.ORGANIZATION_ID
AND HOU.LANGUAGE = USERENV('LANG')