View: AR_CBA_EFT_USER_NUMBER_V

Product:	AR - Receivables
Description:	(Release 11.6 Only)
Implementation/DBA Data:	APPS.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