应付头行表与采购接收，采购订单表关联

 select aia.invoice_num,
       aia.invoice_date,
       aia.creation_date,
       aia.vendor_id,
       aia.invoice_currency_code,
       ail.amount,
       ail.base_amount,
       aia.description,
       decode(ail.base_amount,
              null,
              1,
              round(ail.base_amount / ail.amount, 4)),
       ail.inventory_item_id,
       ail.quantity_invoiced,
       ail.unit_price,
       ail.amount,
       ail.base_amount,
       ail.rcv_transaction_id,
       msi.segment1,
       msi.description,
       rsh.receipt_num,
       pha.segment1,
       pv.vendor_name,
       rsl.quantity_received
  from ap.ap_invoices_all      aia,
       ap.ap_invoice_lines_all ail,
       po.po_headers_all       pha,
       apps.po_vendors         pv,
       inv.mtl_system_items_b  msi,
       rcv_shipment_headers    rsh, --接收头
       rcv_shipment_lines      rsl --接收行
 where aia.invoice_id = ail.invoice_id
   and ail.po_header_id = pha.po_header_id(+)
   and aia.vendor_id = pv.vendor_id
   and ail.inventory_item_id = msi.inventory_item_id(+)
   and ail.org_id = msi.organization_id(+)
   and ail.rcv_shipment_line_id = rsl.shipment_line_id(+)
   and rsl.shipment_header_id = rsh.shipment_header_id(+)
   and ail.line_type_lookup_code = 'ITEM'