EBS获取客户银行信息的SQL

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)