AP Invoice Details From SO Number.sql

select
	dh.source_order_number
  , df.source_line_number as SO_LINE_NUMBER
  , df.fulfill_line_number
  , ddr.doc_user_key as PO_NUMBER
  , ai.invoice_num
  , ail.quantity_invoiced
  , ail.amount
  , ail.line_number as AP_INVOICE_LINE_NUMBER
from
	fusion.ap_invoices_all         ai
  , fusion.ap_invoice_lines_all    ail
  , fusion.doo_document_references ddr
  , fusion.doo_headers_all         dh
  , fusion.doo_fulfill_lines_all   df
where
	ai.invoice_id              = ail.invoice_id
	and dh.source_order_number = 
	and ddr.doc_id             = to_char(ai.po_header_id)
	and ddr.fulfill_line_id    = df.fulfill_line_id
	and df.header_id           = dh.header_id
;