View: IBY_XML_FD_PRBA_1_0_V

Product:	IBY - Payments
Description:
Implementation/DBA Data:	APPS.IBY_XML_FD_PRBA_1_0_V

View Text

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("ACCOUNTHOLDERNAME"
, NULL)
, XMLELEMENT("BANKACCOUNTNAME"
, INT_BA.BANK_ACCOUNT_NAME)
, XMLELEMENT("BANKACCOUNTNUMBER"
, 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
WHERE INT_BA.BANK_BRANCH_ADDRESS_ID = XML_HZ_ADDR.LOCATION_ID(+)

Columns