VIEW: APPS.PO_TRANSACTION_V

Source

View Text - Preformatted

SELECT PH.PO_HEADER_ID,PH.SEGMENT1,PH.TYPE_LOOKUP_CODE,PH.VENDOR_ID,PV.VENDOR_NAME,PH.VENDOR_SITE_ID,POS.VENDOR_SITE_CODE,PH.AGENT_ID,HE.FULL_NAME,PH.CREATION_DATE FROM PO_HEADERS_ALL PH,HR_EMPLOYEES HE,PO_VENDORS PV,PO_VENDOR_SITES_ALL POS WHERE PH.AGENT_ID = HE.EMPLOYEE_ID AND PH.VENDOR_ID = PV.VENDOR_ID AND PH.VENDOR_SITE_ID = POS.VENDOR_SITE_ID(+) AND PH.ORG_ID = POS.ORG_ID(+)

View Text - HTML Formatted

SELECT PH.PO_HEADER_ID
, PH.SEGMENT1
, PH.TYPE_LOOKUP_CODE
, PH.VENDOR_ID
, PV.VENDOR_NAME
, PH.VENDOR_SITE_ID
, POS.VENDOR_SITE_CODE
, PH.AGENT_ID
, HE.FULL_NAME
, PH.CREATION_DATE
FROM PO_HEADERS_ALL PH
, HR_EMPLOYEES HE
, PO_VENDORS PV
, PO_VENDOR_SITES_ALL POS
WHERE PH.AGENT_ID = HE.EMPLOYEE_ID
AND PH.VENDOR_ID = PV.VENDOR_ID
AND PH.VENDOR_SITE_ID = POS.VENDOR_SITE_ID(+)
AND PH.ORG_ID = POS.ORG_ID(+)