VIEW: APPS.PO_HEADERS_REF_V

Source

View Text - Preformatted

SELECT PH.PO_HEADER_ID, PH.SEGMENT1, PH.TYPE_LOOKUP_CODE, PH.COMMENTS, PH.AGENT_ID, HR.FULL_NAME, PH.REVISION_NUM, AC.CARD_NUMBER, PH.ENCUMBRANCE_REQUIRED_FLAG, PH.VENDOR_ID, PV.VENDOR_NAME, PH.VENDOR_SITE_ID, POS.VENDOR_SITE_CODE, PH.ORG_ID, HOU.NAME, GLT.ENCUMBRANCE_TYPE_ID, FSP.PURCH_ENCUMBRANCE_FLAG, FSP.REQ_ENCUMBRANCE_FLAG, PH.GLOBAL_AGREEMENT_FLAG, PH.ATTRIBUTE_CATEGORY, PH.ATTRIBUTE1, PH.ATTRIBUTE2, PH.ATTRIBUTE3, PH.ATTRIBUTE4, PH.ATTRIBUTE5, PH.ATTRIBUTE6, PH.ATTRIBUTE7, PH.ATTRIBUTE8, PH.ATTRIBUTE9, PH.ATTRIBUTE10, PH.ATTRIBUTE11, PH.ATTRIBUTE12, PH.ATTRIBUTE13, PH.ATTRIBUTE14, PH.ATTRIBUTE15, PH.GLOBAL_ATTRIBUTE_CATEGORY, PH.GLOBAL_ATTRIBUTE1 , PH.GLOBAL_ATTRIBUTE2 , PH.GLOBAL_ATTRIBUTE3 , PH.GLOBAL_ATTRIBUTE4 , PH.GLOBAL_ATTRIBUTE5 , PH.GLOBAL_ATTRIBUTE6 , PH.GLOBAL_ATTRIBUTE7 , PH.GLOBAL_ATTRIBUTE8 , PH.GLOBAL_ATTRIBUTE9 , PH.GLOBAL_ATTRIBUTE10 , PH.GLOBAL_ATTRIBUTE11 , PH.GLOBAL_ATTRIBUTE12 , PH.GLOBAL_ATTRIBUTE13 , PH.GLOBAL_ATTRIBUTE14 , PH.GLOBAL_ATTRIBUTE15 , PH.GLOBAL_ATTRIBUTE16 , PH.GLOBAL_ATTRIBUTE17 , PH.GLOBAL_ATTRIBUTE18 , PH.GLOBAL_ATTRIBUTE19 , PH.GLOBAL_ATTRIBUTE20 FROM PO_HEADERS_ALL PH, per_all_people_f HR, AP_CARDS_ALL AC, PO_VENDORS PV, PO_VENDOR_SITES_ALL POS, HR_ALL_ORGANIZATION_UNITS_TL HOU, FINANCIALS_SYSTEM_PARAMS_ALL FSP, GL_ENCUMBRANCE_TYPES GLT WHERE PH.AGENT_ID = HR.PERSON_ID AND Trunc(SYSDATE) BETWEEN hr.effective_start_date AND hr.effective_end_date AND PH.PCARD_ID = AC.CARD_ID(+) AND PH.VENDOR_ID = PV.VENDOR_ID AND PH.VENDOR_SITE_ID = POS.VENDOR_SITE_ID(+) AND PH.ORG_ID = POS.ORG_ID(+) AND PH.ORG_ID = HOU.ORGANIZATION_ID AND HOU.LANGUAGE = USERENV('LANG') AND PH.ORG_ID = FSP.ORG_ID AND GLT.ENCUMBRANCE_TYPE_KEY = 'Obligation'

View Text - HTML Formatted

SELECT PH.PO_HEADER_ID
, PH.SEGMENT1
, PH.TYPE_LOOKUP_CODE
, PH.COMMENTS
, PH.AGENT_ID
, HR.FULL_NAME
, PH.REVISION_NUM
, AC.CARD_NUMBER
, PH.ENCUMBRANCE_REQUIRED_FLAG
, PH.VENDOR_ID
, PV.VENDOR_NAME
, PH.VENDOR_SITE_ID
, POS.VENDOR_SITE_CODE
, PH.ORG_ID
, HOU.NAME
, GLT.ENCUMBRANCE_TYPE_ID
, FSP.PURCH_ENCUMBRANCE_FLAG
, FSP.REQ_ENCUMBRANCE_FLAG
, PH.GLOBAL_AGREEMENT_FLAG
, PH.ATTRIBUTE_CATEGORY
, PH.ATTRIBUTE1
, PH.ATTRIBUTE2
, PH.ATTRIBUTE3
, PH.ATTRIBUTE4
, PH.ATTRIBUTE5
, PH.ATTRIBUTE6
, PH.ATTRIBUTE7
, PH.ATTRIBUTE8
, PH.ATTRIBUTE9
, PH.ATTRIBUTE10
, PH.ATTRIBUTE11
, PH.ATTRIBUTE12
, PH.ATTRIBUTE13
, PH.ATTRIBUTE14
, PH.ATTRIBUTE15
, PH.GLOBAL_ATTRIBUTE_CATEGORY
, PH.GLOBAL_ATTRIBUTE1
, PH.GLOBAL_ATTRIBUTE2
, PH.GLOBAL_ATTRIBUTE3
, PH.GLOBAL_ATTRIBUTE4
, PH.GLOBAL_ATTRIBUTE5
, PH.GLOBAL_ATTRIBUTE6
, PH.GLOBAL_ATTRIBUTE7
, PH.GLOBAL_ATTRIBUTE8
, PH.GLOBAL_ATTRIBUTE9
, PH.GLOBAL_ATTRIBUTE10
, PH.GLOBAL_ATTRIBUTE11
, PH.GLOBAL_ATTRIBUTE12
, PH.GLOBAL_ATTRIBUTE13
, PH.GLOBAL_ATTRIBUTE14
, PH.GLOBAL_ATTRIBUTE15
, PH.GLOBAL_ATTRIBUTE16
, PH.GLOBAL_ATTRIBUTE17
, PH.GLOBAL_ATTRIBUTE18
, PH.GLOBAL_ATTRIBUTE19
, PH.GLOBAL_ATTRIBUTE20
FROM PO_HEADERS_ALL PH
, PER_ALL_PEOPLE_F HR
, AP_CARDS_ALL AC
, PO_VENDORS PV
, PO_VENDOR_SITES_ALL POS
, HR_ALL_ORGANIZATION_UNITS_TL HOU
, FINANCIALS_SYSTEM_PARAMS_ALL FSP
, GL_ENCUMBRANCE_TYPES GLT
WHERE PH.AGENT_ID = HR.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN HR.EFFECTIVE_START_DATE
AND HR.EFFECTIVE_END_DATE
AND PH.PCARD_ID = AC.CARD_ID(+)
AND PH.VENDOR_ID = PV.VENDOR_ID
AND PH.VENDOR_SITE_ID = POS.VENDOR_SITE_ID(+)
AND PH.ORG_ID = POS.ORG_ID(+)
AND PH.ORG_ID = HOU.ORGANIZATION_ID
AND HOU.LANGUAGE = USERENV('LANG')
AND PH.ORG_ID = FSP.ORG_ID
AND GLT.ENCUMBRANCE_TYPE_KEY = 'OBLIGATION'