IBY_XML_FC_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("UserEnteredBankAccountNumber", int_ba.bank_account_number), XMLElement("SwiftCode", int_ba.eft_swift_code), XMLElement("IBANNumber", int_ba.iban_number), XMLElement("CheckDigits", int_ba.check_digits), 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("BankAccountSuffix",int_ba.account_suffix), XMLElement("BankAddress", IBY_FD_EXTRACT_GEN_PVT.Get_Hz_Address(bank_branch_address_id)), XMLElement("DescriptiveFlexField", IBY_EXTRACTGEN_PVT.Get_Dffs( 'CE_BANK_ACCOUNTS', int_ba.bank_account_id, NULL)), XMLElement("EftRequesterIdentifier",int_ba.EFT_REQUESTER_IDENTIFIER), XMLElement("BankHomeCountry",int_ba.BANK_HOME_COUNTRY), XMLElement("BranchDescriptiveFlexField", IBY_EXTRACTGEN_PVT.Get_Dffs( 'HZ_PARTIES', int_ba.branch_party_id, NULL)), XMLElement("EFTUserNumber", XMLElement("AccountLevelEFTNumber", int_ba.account_level_eft_user_number), XMLElement("BranchLevelEFTNumber", int_ba.branch_level_eft_user_number) ) ), int_ba.bank_account_id, null /int_ba.payment_id/ FROM iby_ext_fd_prba_1_0_v int_ba

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("UserEnteredBankAccountNumber", int_ba.bank_account_number), XMLElement("SwiftCode", int_ba.eft_swift_code), XMLElement("IBANNumber", int_ba.iban_number), XMLElement("CheckDigits", int_ba.check_digits), 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("BankAccountSuffix",int_ba.account_suffix), XMLElement("BankAddress", IBY_FD_EXTRACT_GEN_PVT.Get_Hz_Address(bank_branch_address_id)), XMLElement("DescriptiveFlexField", IBY_EXTRACTGEN_PVT.Get_Dffs( 'CE_BANK_ACCOUNTS', int_ba.bank_account_id, NULL)), XMLElement("EftRequesterIdentifier",int_ba.EFT_REQUESTER_IDENTIFIER), XMLElement("BankHomeCountry",int_ba.BANK_HOME_COUNTRY), XMLElement("BranchDescriptiveFlexField", IBY_EXTRACTGEN_PVT.Get_Dffs( 'HZ_PARTIES', int_ba.branch_party_id, NULL)), XMLElement("EFTUserNumber", XMLElement("AccountLevelEFTNumber", int_ba.account_level_eft_user_number), XMLElement("BranchLevelEFTNumber", int_ba.branch_level_eft_user_number) ) ), int_ba.bank_account_id, null /*int_ba.payment_id*/ FROM iby_ext_fd_prba_1_0_v int_ba