VIEW: APPS.IBY_XML_FD_PRBA_1_0_V

Source

View Text - Preformatted

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("MaskedIBANNumber", iby_ext_bankacct_pub.mask_bank_number (int_ba.iban_number, syssec.ext_ba_mask_setting, syssec.ext_ba_unmask_len)), 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("BankAddress", IBY_FD_EXTRACT_GEN_PVT.Get_account_Address(bank_branch_address_id, bank_branch_home_country)), CASE WHEN int_ba.bank_account_attr_cat IS NULL THEN NULL ELSE XMLElement("DescriptiveFlexField", IBY_EXTRACTGEN_PVT.Get_Dffs( 'CE_BANK_ACCOUNTS', int_ba.bank_account_id, NULL)) END, CASE WHEN IBY_EXTRACTGEN_PVT.Get_Dffs('HZ_PARTIES', int_ba.branch_party_id, NULL) IS NULL THEN NULL ELSE XMLElement("BranchDescriptiveFlexField", IBY_EXTRACTGEN_PVT.Get_Dffs( 'HZ_PARTIES', int_ba.branch_party_id, NULL)) END, 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) ) ), int_ba.bank_account_id, int_ba.payment_id FROM iby_ext_fd_prba_1_0_vd int_ba, iby_sys_security_options syssec

View Text - HTML Formatted

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("MASKEDIBANNUMBER"
, IBY_EXT_BANKACCT_PUB.MASK_BANK_NUMBER (INT_BA.IBAN_NUMBER
, SYSSEC.EXT_BA_MASK_SETTING
, SYSSEC.EXT_BA_UNMASK_LEN))
, 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("BANKADDRESS"
, IBY_FD_EXTRACT_GEN_PVT.GET_ACCOUNT_ADDRESS(BANK_BRANCH_ADDRESS_ID
, BANK_BRANCH_HOME_COUNTRY))
, CASE WHEN INT_BA.BANK_ACCOUNT_ATTR_CAT IS NULL THEN NULL ELSE XMLELEMENT("DESCRIPTIVEFLEXFIELD"
, IBY_EXTRACTGEN_PVT.GET_DFFS( 'CE_BANK_ACCOUNTS'
, INT_BA.BANK_ACCOUNT_ID
, NULL)) END
, CASE WHEN IBY_EXTRACTGEN_PVT.GET_DFFS('HZ_PARTIES'
, INT_BA.BRANCH_PARTY_ID
, NULL) IS NULL THEN NULL ELSE XMLELEMENT("BRANCHDESCRIPTIVEFLEXFIELD"
, IBY_EXTRACTGEN_PVT.GET_DFFS( 'HZ_PARTIES'
, INT_BA.BRANCH_PARTY_ID
, NULL)) END
, 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) ) )
, INT_BA.BANK_ACCOUNT_ID
, INT_BA.PAYMENT_ID
FROM IBY_EXT_FD_PRBA_1_0_VD INT_BA
, IBY_SYS_SECURITY_OPTIONS SYSSEC