View: IBY_EXT_FD_PRBA_1_0_V

Product:	IBY - Payments
Description:
Implementation/DBA Data:	APPS.IBY_EXT_FD_PRBA_1_0_V

View Text

SELECT BANK_ACCT.BANK_ACCOUNT_ID
, BANK_AND_BRANCH.BANK_NAME
, BANK_AND_BRANCH.BANK_NUMBER
, BANK_AND_BRANCH.BRANCH_PARTY_ID
, BANK_AND_BRANCH.BANK_BRANCH_NAME
, BANK_AND_BRANCH.BRANCH_NUMBER
, BANK_AND_BRANCH.BANK_BRANCH_TYPE
, BANK_BRANCH_TYPE_LOOKUP.MEANING
, BANK_ACCT.BANK_ACCOUNT_NAME
, BANK_ACCT.BANK_ACCOUNT_NUM
, BANK_AND_BRANCH.EFT_SWIFT_CODE
, BANK_ACCT.IBAN_NUMBER
, BANK_ACCT.CHECK_DIGITS
, BANK_ACCT.BANK_ACCOUNT_TYPE
, BANK_ACCOUNT_TYPE_LOOKUP.MEANING
, BANK_ACCT.CURRENCY_CODE
, PARTY_SITE.LOCATION_ID
, BANK_ACCT.ATTRIBUTE_CATEGORY
, RFC_ID_CA.CLASS_CODE
, BANK_ACCT.AGENCY_LOCATION_CODE
, IBY_FD_EXTRACT_GEN_PVT.GET_ABBREVIATED_AGENCY_CODE(IBY_UTILITY_PVT.GET_VIEW_PARAM('PMT_INSTR_ID'))
, IBY_FD_EXTRACT_GEN_PVT.GET_FEIN(IBY_UTILITY_PVT.GET_VIEW_PARAM('PMT_INSTR_ID'))
, BANK_AND_BRANCH.EFT_USER_NUMBER
, BANK_ACCT.EFT_USER_NUM
FROM CE_BANK_BRANCHES_V BANK_AND_BRANCH
, HZ_CODE_ASSIGNMENTS RFC_ID_CA
, CE_BANK_ACCOUNTS BANK_ACCT
, HZ_PARTY_SITES PARTY_SITE
, AR_LOOKUPS BANK_BRANCH_TYPE_LOOKUP
, FND_LOOKUPS BANK_ACCOUNT_TYPE_LOOKUP
WHERE BANK_ACCT.BANK_ID = BANK_AND_BRANCH.BANK_PARTY_ID
AND BANK_ACCT.BANK_BRANCH_ID = BANK_AND_BRANCH.BRANCH_PARTY_ID
AND BANK_AND_BRANCH.BRANCH_PARTY_ID = PARTY_SITE.PARTY_ID(+)
AND PARTY_SITE.IDENTIFYING_ADDRESS_FLAG = 'Y'
AND BANK_AND_BRANCH.BANK_BRANCH_TYPE = BANK_BRANCH_TYPE_LOOKUP.LOOKUP_CODE(+)
AND BANK_BRANCH_TYPE_LOOKUP.LOOKUP_TYPE(+) = 'BANK_BRANCH_TYPE'
AND BANK_ACCT.BANK_ACCOUNT_TYPE = BANK_ACCOUNT_TYPE_LOOKUP.LOOKUP_CODE(+)
AND BANK_ACCOUNT_TYPE_LOOKUP.LOOKUP_TYPE(+) = 'BANK_ACCOUNT_TYPE'
AND RFC_ID_CA.CLASS_CATEGORY(+) = 'RFC_IDENTIFIER'
AND RFC_ID_CA.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND RFC_ID_CA.OWNER_TABLE_ID(+) = BANK_AND_BRANCH.BRANCH_PARTY_ID

Columns