[Home] [Help]
View: AR_CBA_EFT_USER_NUMBER_V
View Text
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'
Columns
Name |
BANK_PARTY_ID |
EFT_USER_NUMBER |
EFT_SWIFT_CODE |