IBY_EXT_FD_PRBA_1_0

Details

Schema: FUSION
Object owner: IBY
Object type: VIEW

Columns

Name
BANK_ACCOUNT_ID BANK_NAME BANK_NUMBER BRANCH_PARTY_ID BANK_BRANCH_NAME BRANCH_NUMBER BANK_BRANCH_TYPE BANK_BRANCH_TYPE_MEANING BANK_ACCOUNT_NAME BANK_ACCOUNT_NUMBER EFT_SWIFT_CODE IBAN_NUMBER CHECK_DIGITS BANK_ACCOUNT_TYPE BANK_ACCOUNT_TYPE_MEANING CURRENCY_CODE BANK_BRANCH_ADDRESS_ID BANK_ACCOUNT_ATTR_CAT REGIONAL_FINANCE_CENTER_ID AGENCY_LOCATION_CODE ABBREVIATED_AGENCY_CODE FEDERAL_EMPLOYER_ID_NUMBER BRANCH_LEVEL_EFT_USER_NUMBER ACCOUNT_LEVEL_EFT_USER_NUMBER BANK_ACCOUNT_NUM_ELECTRONIC BANK_ACCOUNT_NAME_ALT INT_BANK_ALT_NAME INT_BANK_BRANCH_ALT_NAME ACCOUNT_SUFFIX EFT_REQUESTER_IDENTIFIER BANK_HOME_COUNTRY

Name

BANK_ACCOUNT_ID

BANK_NAME

BANK_NUMBER

BRANCH_PARTY_ID

BANK_BRANCH_NAME

BRANCH_NUMBER

BANK_BRANCH_TYPE

BANK_BRANCH_TYPE_MEANING

BANK_ACCOUNT_NAME

BANK_ACCOUNT_NUMBER

EFT_SWIFT_CODE

IBAN_NUMBER

CHECK_DIGITS

BANK_ACCOUNT_TYPE

BANK_ACCOUNT_TYPE_MEANING

CURRENCY_CODE

BANK_BRANCH_ADDRESS_ID

BANK_ACCOUNT_ATTR_CAT

REGIONAL_FINANCE_CENTER_ID

AGENCY_LOCATION_CODE

ABBREVIATED_AGENCY_CODE

FEDERAL_EMPLOYER_ID_NUMBER

BRANCH_LEVEL_EFT_USER_NUMBER

ACCOUNT_LEVEL_EFT_USER_NUMBER

BANK_ACCOUNT_NUM_ELECTRONIC

BANK_ACCOUNT_NAME_ALT

INT_BANK_ALT_NAME

INT_BANK_BRANCH_ALT_NAME

ACCOUNT_SUFFIX

EFT_REQUESTER_IDENTIFIER

BANK_HOME_COUNTRY

Query

SQL_Statement
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, bank_acct.BANK_ACCOUNT_NUM_ELECTRONIC, bank_acct.bank_account_name_alt, bank_and_branch.bank_name_alt, bank_and_branch.bank_branch_name_alt, bank_acct.account_suffix, bank_acct.EFT_REQUESTER_IDENTIFIER, bank_and_branch.BANK_HOME_COUNTRY FROM ce_all_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, ce_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

SQL_Statement

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, bank_acct.BANK_ACCOUNT_NUM_ELECTRONIC, bank_acct.bank_account_name_alt, bank_and_branch.bank_name_alt, bank_and_branch.bank_branch_name_alt, bank_acct.account_suffix, bank_acct.EFT_REQUESTER_IDENTIFIER, bank_and_branch.BANK_HOME_COUNTRY FROM ce_all_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, ce_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