EBS获取客户银行信息的SQL

最新推荐文章于 2024-03-11 10:35:21 发布

刚木

最新推荐文章于 2024-03-11 10:35:21 发布

阅读量1.4k

点赞数

分类专栏： SQL

本文链接：https://blog.csdn.net/q290245786/article/details/106599725

版权

SQL 专栏收录该内容

34 篇文章 1 订阅

订阅专栏

SELECT ibybanks.bank_name,                 --银行  
       ibybanks.bank_branch_name,          --分行  
       ibybanks.bank_account_num_electronic--银行帐号  
  FROM iby_external_payers_all iepa,  
       iby_pmt_instr_uses_all  ipiua,  
       iby_ext_bank_accounts_v ibybanks  
  WHERE iepa.payment_function    = 'CUSTOMER_PAYMENT'  
    AND iepa.cust_account_id     = 1128--客户帐号ID  
    AND ibybanks.bank_account_id = ipiua.instrument_id    
    AND ipiua.instrument_type    = 'BANKACCOUNT'  
    AND ipiua.ext_pmt_party_id   = iepa.EXT_PAYER_ID  
    AND ipiua.payment_function   = 'CUSTOMER_PAYMENT'  
    AND sysdate BETWEEN ibybanks.start_date AND nvl(ibybanks.end_date,sysdate+1)