VIEW: APPS.IBY_XML_FD_PEBAM_1_0_V

Source

View Text - Preformatted

SELECT XMLConcat( XMLElement("BankAccountInternalID", 'XXXX'), XMLElement("BankName", 'XXXX'), XMLElement("BankNumber", 'XXXX'), XMLElement("BranchInternalID", 'XXXX'), XMLElement("BranchName", 'XXXX'), XMLElement("BranchNumber", 'XXXX'), XMLElement("BranchType", XMLElement("Code", 'XXXX'), XMLElement("Meaning", '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", xml_hz_addr.address), XMLElement("PrimaryOwner", XMLElement("Name", 'XXXX') ), XMLElement("FactorAccount", XMLElement("Code", 'XXXX'), XMLElement("Meaning", 'XXXX') ), XMLElement("DescriptiveFlexField", IBY_EXTRACTGEN_PVT.Get_Dffs( 'IBY_EXT_BANK_ACCOUNTS', ext_ba.ext_bank_account_id, NULL))), 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, ce_lookups bank_account_type_lookup, iby_xml_hz_addr_1_0_v xml_hz_addr, iby_account_owners owner, hz_parties owner_party, fnd_lookups factor_lookup 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' And ext_ba.ext_bank_account_id = owner.ext_bank_account_id And owner.account_owner_party_id = owner_party.party_id And owner.PRIMARY_FLAG = 'Y' 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("BANKNUMBER"
, 'XXXX')
, XMLELEMENT("BRANCHINTERNALID"
, 'XXXX')
, XMLELEMENT("BRANCHNAME"
, 'XXXX')
, XMLELEMENT("BRANCHNUMBER"
, 'XXXX')
, XMLELEMENT("BRANCHTYPE"
, XMLELEMENT("CODE"
, 'XXXX')
, XMLELEMENT("MEANING"
, '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"
, XML_HZ_ADDR.ADDRESS)
, XMLELEMENT("PRIMARYOWNER"
, XMLELEMENT("NAME"
, 'XXXX') )
, XMLELEMENT("FACTORACCOUNT"
, XMLELEMENT("CODE"
, 'XXXX')
, XMLELEMENT("MEANING"
, 'XXXX') )
, XMLELEMENT("DESCRIPTIVEFLEXFIELD"
, IBY_EXTRACTGEN_PVT.GET_DFFS( 'IBY_EXT_BANK_ACCOUNTS'
, EXT_BA.EXT_BANK_ACCOUNT_ID
, NULL)))
, 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
, CE_LOOKUPS BANK_ACCOUNT_TYPE_LOOKUP
, IBY_XML_HZ_ADDR_1_0_V XML_HZ_ADDR
, IBY_ACCOUNT_OWNERS OWNER
, HZ_PARTIES OWNER_PARTY
, FND_LOOKUPS FACTOR_LOOKUP
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'
AND EXT_BA.EXT_BANK_ACCOUNT_ID = OWNER.EXT_BANK_ACCOUNT_ID
AND OWNER.ACCOUNT_OWNER_PARTY_ID = OWNER_PARTY.PARTY_ID
AND OWNER.PRIMARY_FLAG = 'Y'
AND FACTOR_LOOKUP.LOOKUP_TYPE(+) = 'IBY_YES_NO'
AND EXT_BA.PAYMENT_FACTOR_FLAG = FACTOR_LOOKUP.LOOKUP_CODE(+)