VIEW: APPS.IBY_XML_FD_PEBAM_1_0_VD

Source

View Text - Preformatted

SELECT XMLConcat( XMLElement("BankAccountInternalID", 'XXXX'), XMLElement("BankName", 'XXXX'), XMLElement("AlternateBankName", 'XXXX'), XMLElement("BankNumber", 'XXXX'), XMLElement("BranchInternalID", 'XXXX'), XMLElement("BranchName", 'XXXX'), XMLElement("AlternateBranchName", 'XXXX'), XMLElement("BranchNumber", 'XXXX'), XMLElement("BankCode", 'XXXX'), XMLElement("BankAccountName", 'XXXX'), XMLElement("AlternateBankAccountName", 'XXXX'), XMLElement("BankAccountNumber", 'XXXX'), XMLElement("UserEnteredBankAccountNumber", 'XXXX'), XMLElement("SwiftCode", 'XXXX'), XMLElement("IBANNumber", 'XXXX'), XMLElement("CheckDigits", 'XXXX'), XMLElement("BankAccountType", XMLElement("Code", 'XXXX'), XMLElement("Meaning", 'XXXX') ), XMLElement("BankAccountCurrency", XMLElement("Code", 'XXXX') ), XMLElement("BankAddress", IBY_FD_EXTRACT_GEN_PVT.Get_account_Address(ext_bank_branch_location_id, ext_ba.country_code)), XMLElement("PrimaryOwner", XMLElement("Name", 'XXXX') ), XMLElement("FactorAccount", XMLElement("Code", 'XXXX'), XMLElement("Meaning", 'XXXX') ), XMLElement("DescriptiveFlexField", IBY_EXTRACTGEN_PVT.Get_Dffs( 'IBY_EXT_BANK_ACCOUNTS', external_bank_account_id, NULL)), CASE WHEN IBY_EXTRACTGEN_PVT.Get_Dffs( 'HZ_PARTIES', pmt.ext_bank_branch_party_id, NULL) IS NULL THEN NULL ELSE XMLElement("BranchDescriptiveFlexField", IBY_EXTRACTGEN_PVT.Get_Dffs( 'HZ_PARTIES', pmt.ext_bank_branch_party_id, NULL)) END ), external_bank_account_id, payment_id from iby_payments_all pmt, iby_ext_bank_accounts ext_ba, ce_lookups bank_account_type_lookup, fnd_lookups factor_lookup WHERE ext_ba.ext_bank_account_id = pmt.external_bank_account_id AND ext_ba.bank_account_type = bank_account_type_lookup.lookup_code(+) AND bank_account_type_lookup.lookup_type(+) = 'BANK_ACCOUNT_TYPE' And factor_lookup.lookup_type(+) = 'IBY_YES_NO' And ext_ba.payment_factor_flag = factor_lookup.lookup_code(+)

View Text - HTML Formatted

SELECT XMLCONCAT( XMLELEMENT("BANKACCOUNTINTERNALID"
, 'XXXX')
, XMLELEMENT("BANKNAME"
, 'XXXX')
, XMLELEMENT("ALTERNATEBANKNAME"
, 'XXXX')
, XMLELEMENT("BANKNUMBER"
, 'XXXX')
, XMLELEMENT("BRANCHINTERNALID"
, 'XXXX')
, XMLELEMENT("BRANCHNAME"
, 'XXXX')
, XMLELEMENT("ALTERNATEBRANCHNAME"
, 'XXXX')
, XMLELEMENT("BRANCHNUMBER"
, 'XXXX')
, XMLELEMENT("BANKCODE"
, 'XXXX')
, XMLELEMENT("BANKACCOUNTNAME"
, 'XXXX')
, XMLELEMENT("ALTERNATEBANKACCOUNTNAME"
, 'XXXX')
, XMLELEMENT("BANKACCOUNTNUMBER"
, 'XXXX')
, XMLELEMENT("USERENTEREDBANKACCOUNTNUMBER"
, 'XXXX')
, XMLELEMENT("SWIFTCODE"
, 'XXXX')
, XMLELEMENT("IBANNUMBER"
, 'XXXX')
, XMLELEMENT("CHECKDIGITS"
, 'XXXX')
, XMLELEMENT("BANKACCOUNTTYPE"
, XMLELEMENT("CODE"
, 'XXXX')
, XMLELEMENT("MEANING"
, 'XXXX') )
, XMLELEMENT("BANKACCOUNTCURRENCY"
, XMLELEMENT("CODE"
, 'XXXX') )
, XMLELEMENT("BANKADDRESS"
, IBY_FD_EXTRACT_GEN_PVT.GET_ACCOUNT_ADDRESS(EXT_BANK_BRANCH_LOCATION_ID
, EXT_BA.COUNTRY_CODE))
, XMLELEMENT("PRIMARYOWNER"
, XMLELEMENT("NAME"
, 'XXXX') )
, XMLELEMENT("FACTORACCOUNT"
, XMLELEMENT("CODE"
, 'XXXX')
, XMLELEMENT("MEANING"
, 'XXXX') )
, XMLELEMENT("DESCRIPTIVEFLEXFIELD"
, IBY_EXTRACTGEN_PVT.GET_DFFS( 'IBY_EXT_BANK_ACCOUNTS'
, EXTERNAL_BANK_ACCOUNT_ID
, NULL))
, CASE WHEN IBY_EXTRACTGEN_PVT.GET_DFFS( 'HZ_PARTIES'
, PMT.EXT_BANK_BRANCH_PARTY_ID
, NULL) IS NULL THEN NULL ELSE XMLELEMENT("BRANCHDESCRIPTIVEFLEXFIELD"
, IBY_EXTRACTGEN_PVT.GET_DFFS( 'HZ_PARTIES'
, PMT.EXT_BANK_BRANCH_PARTY_ID
, NULL)) END )
, EXTERNAL_BANK_ACCOUNT_ID
, PAYMENT_ID
FROM IBY_PAYMENTS_ALL PMT
, IBY_EXT_BANK_ACCOUNTS EXT_BA
, CE_LOOKUPS BANK_ACCOUNT_TYPE_LOOKUP
, FND_LOOKUPS FACTOR_LOOKUP
WHERE EXT_BA.EXT_BANK_ACCOUNT_ID = PMT.EXTERNAL_BANK_ACCOUNT_ID
AND EXT_BA.BANK_ACCOUNT_TYPE = BANK_ACCOUNT_TYPE_LOOKUP.LOOKUP_CODE(+)
AND BANK_ACCOUNT_TYPE_LOOKUP.LOOKUP_TYPE(+) = 'BANK_ACCOUNT_TYPE'
AND FACTOR_LOOKUP.LOOKUP_TYPE(+) = 'IBY_YES_NO'
AND EXT_BA.PAYMENT_FACTOR_FLAG = FACTOR_LOOKUP.LOOKUP_CODE(+)