IBY_XML_FD_PRBA_1_0

Details

Schema: FUSION
Object owner: IBY
Object type: VIEW

Columns

Name
INT_BANK_ACCOUNT BANK_ACCOUNT_ID PAYMENT_ID

Name

INT_BANK_ACCOUNT

BANK_ACCOUNT_ID

PAYMENT_ID

Query

SQL_Statement
SELECT XMLConcat( XMLElement("BankAccountInternalID", int_ba.bank_account_id), XMLElement("BankName", int_ba.bank_name), XMLElement("AlternateBankName", int_ba.INT_BANK_ALT_NAME), XMLElement("BankNumber", int_ba.bank_number), XMLElement("BranchInternalID", int_ba.branch_party_id), XMLElement("BranchName", int_ba.bank_branch_name), XMLElement("AlternateBranchName", int_ba.INT_BANK_BRANCH_ALT_NAME), XMLElement("BranchNumber", int_ba.branch_number), XMLElement("BankAccountName", int_ba.bank_account_name), XMLElement("AlternateBankAccountName", int_ba.bank_account_name_alt), XMLElement("BankAccountNumber", int_ba.BANK_ACCOUNT_NUM_ELECTRONIC), XMLElement("MaskedBankAccountNumber", iby_ext_bankacct_pub.mask_bank_number(int_ba.bank_account_num_electronic,syssec.ext_ba_mask_setting, syssec.ext_ba_unmask_len)), XMLElement("UserEnteredBankAccountNumber", int_ba.bank_account_number), XMLElement("BankAccountSuffix",int_ba.account_suffix), XMLElement("SwiftCode", int_ba.eft_swift_code), XMLElement("IBANNumber", int_ba.iban_number), XMLElement("CheckDigits", int_ba.check_digits), XMLElement("SecondaryBankAccountReference", int_ba.secondary_account_reference),XMLElement("BankAccountType", XMLElement("Code", int_ba.bank_account_type), XMLElement("Meaning", int_ba.bank_account_type_meaning) ), XMLElement("BankAccountCurrency", XMLElement("Code", int_ba.currency_code) ), XMLElement("BankAddress", IBY_FD_EXTRACT_GEN_PVT.Get_account_Address(bank_branch_address_id, bank_branch_home_country)), XMLElement("DescriptiveFlexField", IBY_EXTRACTGEN_PVT.Get_Dffs( 'CE_BANK_ACCOUNTS', int_ba.bank_account_id, NULL)), XMLElement("BranchDescriptiveFlexField", IBY_EXTRACTGEN_PVT.Get_Dffs( 'HZ_PARTIES', int_ba.branch_party_id, NULL)), XMLElement("FederalBankAccountInfo", XMLElement("FederalRFCIdentifier", int_ba.regional_finance_center_id), XMLElement("FederalAgencyLocationCode", int_ba.agency_location_code), XMLElement("FederalAbbreviatedAgencyCode", int_ba.abbreviated_agency_code), XMLElement("FederalEmployerIdentificationNumber", int_ba.federal_employer_id_number) ), XMLElement("EFTUserNumber", XMLElement("AccountLevelEFTNumber", int_ba.account_level_eft_user_number), XMLElement("BranchLevelEFTNumber", int_ba.branch_level_eft_user_number), XMLElement("EFTRequesterId", int_ba.eft_requester_identifier) ) ), int_ba.bank_account_id, int_ba.payment_id FROM iby_ext_fd_prba_1_0_vd int_ba, iby_sys_security_options syssec

SQL_Statement

SELECT XMLConcat( XMLElement("BankAccountInternalID", int_ba.bank_account_id), XMLElement("BankName", int_ba.bank_name), XMLElement("AlternateBankName", int_ba.INT_BANK_ALT_NAME), XMLElement("BankNumber", int_ba.bank_number), XMLElement("BranchInternalID", int_ba.branch_party_id), XMLElement("BranchName", int_ba.bank_branch_name), XMLElement("AlternateBranchName", int_ba.INT_BANK_BRANCH_ALT_NAME), XMLElement("BranchNumber", int_ba.branch_number), XMLElement("BankAccountName", int_ba.bank_account_name), XMLElement("AlternateBankAccountName", int_ba.bank_account_name_alt), XMLElement("BankAccountNumber", int_ba.BANK_ACCOUNT_NUM_ELECTRONIC), XMLElement("MaskedBankAccountNumber", iby_ext_bankacct_pub.mask_bank_number(int_ba.bank_account_num_electronic,syssec.ext_ba_mask_setting, syssec.ext_ba_unmask_len)), XMLElement("UserEnteredBankAccountNumber", int_ba.bank_account_number), XMLElement("BankAccountSuffix",int_ba.account_suffix), XMLElement("SwiftCode", int_ba.eft_swift_code), XMLElement("IBANNumber", int_ba.iban_number), XMLElement("CheckDigits", int_ba.check_digits), XMLElement("SecondaryBankAccountReference", int_ba.secondary_account_reference),XMLElement("BankAccountType", XMLElement("Code", int_ba.bank_account_type), XMLElement("Meaning", int_ba.bank_account_type_meaning) ), XMLElement("BankAccountCurrency", XMLElement("Code", int_ba.currency_code) ), XMLElement("BankAddress", IBY_FD_EXTRACT_GEN_PVT.Get_account_Address(bank_branch_address_id, bank_branch_home_country)), XMLElement("DescriptiveFlexField", IBY_EXTRACTGEN_PVT.Get_Dffs( 'CE_BANK_ACCOUNTS', int_ba.bank_account_id, NULL)), XMLElement("BranchDescriptiveFlexField", IBY_EXTRACTGEN_PVT.Get_Dffs( 'HZ_PARTIES', int_ba.branch_party_id, NULL)), XMLElement("FederalBankAccountInfo", XMLElement("FederalRFCIdentifier", int_ba.regional_finance_center_id), XMLElement("FederalAgencyLocationCode", int_ba.agency_location_code), XMLElement("FederalAbbreviatedAgencyCode", int_ba.abbreviated_agency_code), XMLElement("FederalEmployerIdentificationNumber", int_ba.federal_employer_id_number) ), XMLElement("EFTUserNumber", XMLElement("AccountLevelEFTNumber", int_ba.account_level_eft_user_number), XMLElement("BranchLevelEFTNumber", int_ba.branch_level_eft_user_number), XMLElement("EFTRequesterId", int_ba.eft_requester_identifier) ) ), int_ba.bank_account_id, int_ba.payment_id FROM iby_ext_fd_prba_1_0_vd int_ba, iby_sys_security_options syssec