Oracle EBS R12 AP应付模块 查询发票付款信息SQL

SELECT aia.invoice_num    发票编号
      ,aia.invoice_amount 发票金额
      ,aca.check_number   付款编号
      ,aip.amount         付款金额
      ,aca.check_date     付款日期
      ,aip.reversal_flag  付款无效标志
FROM   ap.ap_invoices_all         aia
      ,ap.ap_invoice_payments_all aip
      ,ap.ap_checks_all           aca
WHERE  aia.invoice_id = aip.invoice_id
AND    aip.check_id = aca.check_id
AND    aia.invoice_num = '';