VIEW: APPS.PO_RELEASE_TRANSACTION_V

Source

View Text - Preformatted

SELECT PR.PO_RELEASE_ID , PH.SEGMENT1 || '-' || PR.RELEASE_NUM, PR.RELEASE_TYPE || ' RELEASE' , PH.VENDOR_ID , PV.VENDOR_NAME , PH.VENDOR_SITE_ID , POS.VENDOR_SITE_CODE, PR.AGENT_ID , HE.FULL_NAME , PR.RELEASE_DATE FROM PO_RELEASES_ALL PR, PO_HEADERS_ALL PH, HR_EMPLOYEES HE, PO_VENDORS PV, PO_VENDOR_SITES_ALL POS WHERE PR.PO_HEADER_ID = PH.PO_HEADER_ID AND PR.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 PR.PO_RELEASE_ID
, PH.SEGMENT1 || '-' || PR.RELEASE_NUM
, PR.RELEASE_TYPE || ' RELEASE'
, PH.VENDOR_ID
, PV.VENDOR_NAME
, PH.VENDOR_SITE_ID
, POS.VENDOR_SITE_CODE
, PR.AGENT_ID
, HE.FULL_NAME
, PR.RELEASE_DATE
FROM PO_RELEASES_ALL PR
, PO_HEADERS_ALL PH
, HR_EMPLOYEES HE
, PO_VENDORS PV
, PO_VENDOR_SITES_ALL POS
WHERE PR.PO_HEADER_ID = PH.PO_HEADER_ID
AND PR.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(+)