VIEW: APPS.IBY_XML_FD_PRBA_1_0_V0

Source

View Text - Preformatted

SELECT XMLConcat( XMLElement("BankAccountInternalID", int_ba.bank_account_id), XMLElement("BankName", int_ba.bank_name), XMLElement("BankNumber", int_ba.bank_number), XMLElement("BranchInternalID", int_ba.branch_party_id), XMLElement("BranchName", int_ba.bank_branch_name), XMLElement("BranchNumber", int_ba.branch_number), XMLElement("BranchType", XMLElement("Code", int_ba.bank_branch_type), XMLElement("Meaning", int_ba.bank_branch_type_meaning) ), 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("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("BankAddress", xml_hz_addr.address), 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, 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 FROM iby_ext_fd_prba_1_0_v int_ba, iby_xml_hz_addr_1_0_v xml_hz_addr, iby_sys_security_options syssec WHERE int_ba.bank_branch_address_id = xml_hz_addr.location_id(+)

View Text - HTML Formatted

SELECT XMLCONCAT( XMLELEMENT("BANKACCOUNTINTERNALID"
, INT_BA.BANK_ACCOUNT_ID)
, XMLELEMENT("BANKNAME"
, INT_BA.BANK_NAME)
, XMLELEMENT("BANKNUMBER"
, INT_BA.BANK_NUMBER)
, XMLELEMENT("BRANCHINTERNALID"
, INT_BA.BRANCH_PARTY_ID)
, XMLELEMENT("BRANCHNAME"
, INT_BA.BANK_BRANCH_NAME)
, XMLELEMENT("BRANCHNUMBER"
, INT_BA.BRANCH_NUMBER)
, XMLELEMENT("BRANCHTYPE"
, XMLELEMENT("CODE"
, INT_BA.BANK_BRANCH_TYPE)
, XMLELEMENT("MEANING"
, INT_BA.BANK_BRANCH_TYPE_MEANING) )
, 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("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("BANKADDRESS"
, XML_HZ_ADDR.ADDRESS)
, 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
, 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
FROM IBY_EXT_FD_PRBA_1_0_V INT_BA
, IBY_XML_HZ_ADDR_1_0_V XML_HZ_ADDR
, IBY_SYS_SECURITY_OPTIONS SYSSEC
WHERE INT_BA.BANK_BRANCH_ADDRESS_ID = XML_HZ_ADDR.LOCATION_ID(+)