VIEW: APPS.AP_SRS_PAYEE_V

Source

View Text - Preformatted

SELECT hp.party_name payee_name, asup.segment1 vendor_number, asup.party_id payee_party_id from ap_suppliers asup, iby_external_payees_all iep, hz_parties hp WHERE asup.party_id = iep.payee_party_id and asup.party_id = hp.party_id group by hp.party_name, segment1, asup.party_id UNION select hp.party_name payee_name, null vendor_number, hp.party_id payee_party_id from hz_parties hp, iby_external_payees_all iep where hp.party_id = iep.payee_party_id and not exists (select 'x' from ap_suppliers asup where asup.party_id = iep.payee_party_id) group by hp.party_name, hp.party_id order by 1

View Text - HTML Formatted

SELECT HP.PARTY_NAME PAYEE_NAME
, ASUP.SEGMENT1 VENDOR_NUMBER
, ASUP.PARTY_ID PAYEE_PARTY_ID
FROM AP_SUPPLIERS ASUP
, IBY_EXTERNAL_PAYEES_ALL IEP
, HZ_PARTIES HP
WHERE ASUP.PARTY_ID = IEP.PAYEE_PARTY_ID
AND ASUP.PARTY_ID = HP.PARTY_ID GROUP BY HP.PARTY_NAME
, SEGMENT1
, ASUP.PARTY_ID UNION SELECT HP.PARTY_NAME PAYEE_NAME
, NULL VENDOR_NUMBER
, HP.PARTY_ID PAYEE_PARTY_ID
FROM HZ_PARTIES HP
, IBY_EXTERNAL_PAYEES_ALL IEP
WHERE HP.PARTY_ID = IEP.PAYEE_PARTY_ID
AND NOT EXISTS (SELECT 'X'
FROM AP_SUPPLIERS ASUP
WHERE ASUP.PARTY_ID = IEP.PAYEE_PARTY_ID) GROUP BY HP.PARTY_NAME
, HP.PARTY_ID ORDER BY 1