AP Invoice Distributions SQL Query

select

i.invoice_num,

i.doc_sequence_value voucher_sequence_number,

v.segment1 vendor_number,

v.vendor_name,

i.invoice_date,

d.amount,

d.dist_code_combination_id

from

ap_invoices_all i,

ap_invoice_distributions_all d,

po_vendors v,

gl_code_combinations c

where

i.vendor_id=v.vendor_id

and i.invoice_id=d.invoice_id

and c.code_combination_id=d.dist_code_combination_id

and d.line_type_lookup_code='freight'

and d.accounting_date between '01-jan-2014' and '31-jan-2014'

order by

i.invoice_date,

doc_sequence_value