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