AP 付款凭证

模块：AP

相关表：AP.AP_CHECKS_ALL  ACA   AP付款头信息表

            AP.AP_INVOICE_PAYMENTS_ALL  AIP  AP发票-付款关联信息表

            CE_BANK_ACCOUNTS  CBA  银行帐户信息表
            CE_BANK_ACCT_USES_ALL  CBAU  付款银行关系表

            CE_BANK_BRANCHES_V   CBB

            ce_payment_documents    付款单据

其他：（ACA.CE_BANK_ACCT_USE_ID = CBAU.bank_acct_use_id(+)
           AND CBAU.bank_account_id = CBA.bank_account_id(+)  AND CBA.BANK_BRANCH_ID = CBB.bank_party_id(+)）

SQL：

select  aca.check_number,
       pv.segment1 vendor_code,
       pv.vendor_name,
       aca.check_date,
       aca.currency_code,
       aca.exchange_rate,
       aca.payment_document_id,
       pd.payment_document_name,  -- 付款单据
       aia.invoice_num,
       aia.invoice_amount,
       aip.amount
   from  ap.ap_checks_all           aca,
       ap.ap_invoice_payments_all aip,
       ce.ce_bank_accounts        cba,
       ce.ce_bank_acct_uses_all   cbau,
       ce_bank_branches_v         cbb,
       ap.ap_invoices_all         aia,
       apps.po_vendors            pv,
       ce_payment_documents       pd
  where  aca.check_id  =  aip.check_id
    and  aca.ce_bank_acct_use_id  =  cbau.bank_acct_use_id( + )
    and  cbau.bank_account_id  =  cba.bank_account_id( + )
    and  cbau.org_id  =  aip.org_id( + )
    and  cba.bank_branch_id  =  cbb.bank_party_id( + )
    and  aip.invoice_id  =  aia.invoice_id
    and  aia.vendor_id  =  pv.vendor_id
    and  aca.payment_document_id  =  pd.payment_document_id( + )
    and  aca.check_number  =   ' 9 '