View: IBY_XML_FD_PEBA_1_0_V

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

View Text

SELECT XMLCONCAT( XMLELEMENT("BANKACCOUNTINTERNALID"
, EXT_BA.EXT_BANK_ACCOUNT_ID)
, XMLELEMENT("BANKNAME"
, EXT_BA.BANK_NAME)
, XMLELEMENT("BANKNUMBER"
, EXT_BA.BANK_NUMBER)
, XMLELEMENT("BRANCHINTERNALID"
, EXT_BA.BRANCH_PARTY_ID)
, XMLELEMENT("BRANCHNAME"
, EXT_BA.BANK_BRANCH_NAME)
, XMLELEMENT("BRANCHNUMBER"
, EXT_BA.BRANCH_NUMBER)
, XMLELEMENT("BRANCHTYPE"
, XMLELEMENT("CODE"
, EXT_BA.BRANCH_TYPE)
, XMLELEMENT("MEANING"
, BANK_BRANCH_TYPE_LOOKUP.MEANING) )
, XMLELEMENT("ACCOUNTHOLDERNAME"
, NULL)
, XMLELEMENT("BANKACCOUNTNAME"
, EXT_BA.BANK_ACCOUNT_NAME)
, XMLELEMENT("BANKACCOUNTNUMBER"
, EXT_BA.BANK_ACCOUNT_NUMBER)
, XMLELEMENT("SWIFTCODE"
, EXT_BA.EFT_SWIFT_CODE)
, XMLELEMENT("IBANNUMBER"
, EXT_BA.IBAN_NUMBER)
, XMLELEMENT("CHECKDIGITS"
, EXT_BA.CHECK_DIGITS)
, XMLELEMENT("BANKACCOUNTTYPE"
, XMLELEMENT("CODE"
, EXT_BA.BANK_ACCOUNT_TYPE)
, XMLELEMENT("MEANING"
, BANK_ACCOUNT_TYPE_LOOKUP.MEANING) )
, XMLELEMENT("BANKACCOUNTCURRENCY"
, XMLELEMENT("CODE"
, EXT_BA.CURRENCY_CODE) )
, XMLELEMENT("BANKADDRESS"
, XML_HZ_ADDR.ADDRESS)
, CASE WHEN EXT_BA_TABLE.ATTRIBUTE_CATEGORY IS NULL THEN NULL ELSE XMLELEMENT("DESCRIPTIVEFLEXFIELD"
, IBY_EXTRACTGEN_PVT.GET_DFFS( 'IBY_EXT_BANK_ACCOUNTS'
, EXT_BA.EXT_BANK_ACCOUNT_ID
, NULL)) END )
, EXT_BA.EXT_BANK_ACCOUNT_ID
FROM IBY_EXT_BANK_ACCOUNTS_V EXT_BA
, IBY_EXT_BANK_ACCOUNTS EXT_BA_TABLE
, AR_LOOKUPS BANK_BRANCH_TYPE_LOOKUP
, FND_LOOKUPS BANK_ACCOUNT_TYPE_LOOKUP
, IBY_XML_HZ_ADDR_1_0_V XML_HZ_ADDR
WHERE EXT_BA.BANK_BRANCH_ADDRESS_ID = XML_HZ_ADDR.LOCATION_ID(+)
AND EXT_BA.EXT_BANK_ACCOUNT_ID = EXT_BA_TABLE.EXT_BANK_ACCOUNT_ID
AND EXT_BA.BRANCH_TYPE = BANK_BRANCH_TYPE_LOOKUP.LOOKUP_CODE(+)
AND BANK_BRANCH_TYPE_LOOKUP.LOOKUP_TYPE(+) = 'BANK_BRANCH_TYPE'
AND EXT_BA.BANK_ACCOUNT_TYPE = BANK_ACCOUNT_TYPE_LOOKUP.LOOKUP_CODE(+)
AND BANK_ACCOUNT_TYPE_LOOKUP.LOOKUP_TYPE(+) = 'BANK_ACCOUNT_TYPE'

Columns