View: AP_SRS_PAYEE_V

Product:	AP - Payables
Description:
Implementation/DBA Data:	APPS.AP_SRS_PAYEE_V

View Text

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

Columns