VIEW: APPS.AR_CBA_EFT_USER_NUMBER_V

Source

View Text - Preformatted

SELECT BranchParty.party_id bank_party_id, eft.eft_user_number, eft.eft_swift_code FROM hz_parties BranchParty, hz_contact_points Eft WHERE Eft.owner_table_name = 'HZ_PARTIES' AND Eft.owner_table_id = BranchParty.party_id AND Eft.contact_point_type = 'EFT' AND Eft.status(+) = 'A'

View Text - HTML Formatted

SELECT BRANCHPARTY.PARTY_ID BANK_PARTY_ID
, EFT.EFT_USER_NUMBER
, EFT.EFT_SWIFT_CODE
FROM HZ_PARTIES BRANCHPARTY
, HZ_CONTACT_POINTS EFT
WHERE EFT.OWNER_TABLE_NAME = 'HZ_PARTIES'
AND EFT.OWNER_TABLE_ID = BRANCHPARTY.PARTY_ID
AND EFT.CONTACT_POINT_TYPE = 'EFT'
AND EFT.STATUS(+) = 'A'