1. Tables and Views for Financials
  2. IBY_XML_BA_OWNER_VERIF_1_0_V

IBY_XML_BA_OWNER_VERIF_1_0_V

Details

  • Schema: FUSION

  • Object owner: IBY

  • Object type: VIEW

Columns

Name

EXT_BANK_ACCT_CHANGE_HIST_ID

ACCT_OWNER_CHANGE_HISTORY_ID

BANK_ACCT_OWNER_VERIF_REQUEST

Query

SQL_Statement

SELECT ba_h.EXT_BANK_ACCT_CHANGE_HIST_ID EXT_BANK_ACCT_CHANGE_HIST_ID, ownr_h.ACCT_OWNER_CHANGE_HISTORY_ID ACCT_OWNER_CHANGE_HISTORY_ID,XMLELEMENT("BankAccountVerificationRequest",(XMLELEMENT("RequestId",ownr_h.VERIFICATION_REQ_REFERENCE_ID)),xmlelement("PaymentSystemAccount", xmlelement("AccountName", 'psa'), iby_fd_extract_gen_pvt.get_ins_accountsettingsagg(ownr_h.payment_system_account_id)),

XMLELEMENT("BankAccount",XMLELEMENT("BankAccountNumber",iby_ext_bankacct_pub.Uncipher_User_Bank_Account_Num_Hist(ba_h.EXT_BANK_ACCT_CHANGE_HIST_ID,iby_utility_pvt.get_view_param('SYS_KEY'))),XMLELEMENT("IBAN",iby_ext_bankacct_pub.Uncipher_IBAN_Hist(ba_h.EXT_BANK_ACCT_CHANGE_HIST_ID,iby_utility_pvt.get_view_param('SYS_KEY'))),XMLELEMENT("BankAccountNumberElectronic",iby_ext_bankacct_pub.Uncipher_Bank_Account_Number_Hist(ba_h.EXT_BANK_ACCT_CHANGE_HIST_ID,iby_utility_pvt.get_view_param('SYS_KEY'))),XMLELEMENT("BankName",branch.BANK_NAME),XMLELEMENT("BankNumber",branch.BANK_NUMBER),XMLELEMENT("BranchName",branch.BANK_BRANCH_NAME),XMLELEMENT("BranchNumber",branch.BRANCH_NUMBER),XMLELEMENT("EftSwiftCode",branch.EFT_SWIFT_CODE),XMLELEMENT("BranchType",branch.BANK_BRANCH_TYPE)),

XMLELEMENT("BankAccountOwner",XMLELEMENT("AccountOwnerName",op.PARTY_NAME),XMLELEMENT("OwnerFirstName",op.PERSON_FIRST_NAME),XMLELEMENT("OwnerLastName",op.PERSON_LAST_NAME),XMLELEMENT("OwnerPartyType",op.PARTY_TYPE),XMLELEMENT("PrimaryFlag",ownr_h.primary_flag))) BANK_ACCT_OWNER_VERIF_REQUEST

FROM iby_ext_bank_acct_change_hist ba_h,

iby_bank_acct_owner_chng_hist ownr_h,

iby_ext_bank_accounts ba,

iby_account_owners ownr,

hz_parties op,

ce_all_bank_branches_v branch

WHERE ba.ext_bank_account_id = ownr.ext_bank_account_id

AND ba.ext_bank_account_id = ba_h.ext_bank_account_id

AND ownr.account_owner_id = ownr_h.account_owner_id

AND ownr.account_owner_party_id = op.party_id(+)

AND ba.branch_id = branch.branch_party_id(+)