Query : AP Invoice

Tables:
AP Header:  AP_INVOICES_ALL
AP Lines:  AP_INVOICE_LINES_ALL
AP Distributions:  AP_INVOICE_DISTRIBUTIONS_ALL

______________________________


Select inv.invoice_id, inv.invoice_num, line.line_number, dist.

from
ap_invoices_all inv,
ap_invoice_lines_all line,
ap_invoice_distributions_all dist

where
inv.invoice_id = line.invoice_id and
inv.invoice_id = dist.invoice_id

and
inv.invoice_num = '191015SH'





--Payment schedule
select aia.invoice_num, apsa.due_date
from
ap_invoices_all aia,
ap_payment_schedules_all apsa
where aia.invoice_id = apsa.invoice_id
and aia.invoice_num = '191015SH'


--GL Dist
Select inv.invoice_id "INV ID", inv.invoice_num "INV NUM", line.line_number, dist.dist_code_combination_id, gcc.segment1, gcc.segment2, gcc.segment3, gcc.segment4, gcc.segment5, gcc.segment6

from
ap_invoices_all inv,
ap_invoice_lines_all line,
ap_invoice_distributions_all dist,
gl_code_combinations gcc

where
inv.invoice_id = line.invoice_id and
inv.invoice_id = dist.invoice_id and
dist.dist_code_combination_id = gcc.code_combination_id

and 1=1
and inv.invoice_num = 'HQ217-0000001525'
and gcc.segment1 = 'HISCO'