ITPub博客

首页 > 数据库 > Oracle > Oracle EBS ERP银行信息查询视图

Oracle EBS ERP银行信息查询视图

原创 Oracle 作者:SConsulting 时间:2019-03-01 12:25:58 0 删除 编辑

CREATE OR REPLACE VIEW XXX_STD_CE_BANKINFO_V AS

SELECT cbau.org_id,

       cba.account_owner_party_id L_Party_ID,

       cba.account_owner_org_id   Legal_Entity,

       hou.name                   org_name,

       cbv.bank_name,

       cbb.bank_branch_name,

       cba.bank_account_name,

       cba.bank_account_num,

       cba.currency_code,


       cbv.bank_party_id     Bank_ID,

       cba.bank_account_id,

       cbau.bank_acct_use_id,


       nvl(cba.multi_currency_allowed_flag, 'N') Mutii_Flag,

       nvl(cba.payment_multi_currency_flag, 'N') MutiiAP_Flag,

       nvl(cba.receipt_multi_currency_flag, 'N') MutiiAR_Flag,


       gcc.concatenated_segments   Bank_Account,

       gccap.concatenated_segments BankAP_Account,

       gccar.concatenated_segments BankAR_Account,

       gcc.code_combination_id     gl_CCID,

       gccap.code_combination_id   AP_CCID,

       gccar.code_combination_id   AR_CCID,


       cbau.end_date bank_use_end_date,

       cba.end_date  bank_end_date,


       gccap_Clearing.concatenated_segments     BankAPClearing_Account,

       gccap_Clearing.code_combination_id       APClearing_CCID,

       gccap_Charges.concatenated_segments      BankAPCharges_Account,

       gccap_Charges.code_combination_id        APCharges_CCID,

       gccap_BankErrors.concatenated_segments   BankAPBankErrors_Account,

       gccap_BankErrors.code_combination_id     APBankErrors_CCID,

       gccap_RealizedGain.concatenated_segments BankAPRealizedGain_Account,

       gccap_RealizedGain.code_combination_id   APRealizedGain_CCID,

       gccap_RealizedLoss.concatenated_segments BankAPRealizedLoss_Account,

       gccap_RealizedLoss.code_combination_id   APRealizedLoss_CCID,

       gccap_Future.concatenated_segments       BankAPRealizedFuture_Account,

       gccap_Future.code_combination_id         APRealizedFuture_CCID


  FROM ce_banks_v               cbv,

       ce_bank_accounts         cba,

       ce_bank_branches_v       cbb,

       ce_bank_acct_uses_all    cbau,

       ce_gl_accounts_ccid      cga,

       gl_code_combinations_kfv gcc,

       gl_code_combinations_kfv gccap,

       gl_code_combinations_kfv gccar,


       gl_code_combinations_kfv gccap_Clearing,

       gl_code_combinations_kfv gccap_Charges,

       gl_code_combinations_kfv gccap_BankErrors,

       gl_code_combinations_kfv gccap_RealizedGain,

       gl_code_combinations_kfv gccap_RealizedLoss,

       gl_code_combinations_kfv gccap_Future,


       hr_operating_units hou


 Where cbv.bank_party_id = cba.bank_id

   and cbb.bank_party_id = cba.bank_id

   and cbb.branch_party_id = cba.bank_branch_id

   and cbau.bank_account_id = cba.bank_account_id

   and cbau.bank_acct_use_id = cga.bank_acct_use_id

   and cbau.org_id = hou.organization_id

   and gcc.code_combination_id(+) = cba.asset_code_combination_id

   and nvl(cga.ap_asset_ccid, cga.ar_asset_ccid) = gccap.code_combination_id(+)


   and cga.cash_clearing_ccid = gccap_Clearing.code_combination_id(+)

   and cga.bank_charges_ccid = gccap_Charges.code_combination_id(+)

   and cga.bank_errors_ccid = gccap_BankErrors.code_combination_id(+)

   and cga.gain_code_combination_id = gccap_RealizedGain.code_combination_id(+)

   and cga.loss_code_combination_id = gccap_RealizedLoss.code_combination_id(+)

   and cga.future_dated_payment_ccid = gccap_Future.code_combination_id(+)


   and nvl(cga.ar_asset_ccid, cga.ap_asset_ccid) = gccar.code_combination_id(+);


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/31515388/viewspace-2637281/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 没有了~
请登录后发表评论 登录
全部评论

注册时间:2018-12-05

  • 博文量
    3
  • 访问量
    3323