AP Invoice Query

SELECT sites.vendor_site_code||'|'||
inv.attribute4||'|'|| -- transaction_code
inv.invoice_type_lookup_code ||'|'|| -- TYPE
inv.invoice_num||'|'||
inv.attribute5||'|'|| -- rtk_po_number
po.po_number||'|'|| -- oracle_po_number
inv.pay_group_lookup_code||'|'||
inv.invoice_date||'|'||
inv.invoice_amount||'|'|| -- gross_amount
trms.description||'|'|| -- payment_terms
(inv.invoice_date + NVL (trms.due_cutoff_day, 0))||'|'|| -- discount_due_date
psch.due_date||'|'|| -- net_due_date
pay.creation_date||'|'|| -- payment_date
pay.amount ||'|'|| --payment_amount
inv.discount_amount_taken||'|'|| -- discount_amount
inv.invoice_currency_code||'|'||
inv.payment_method_lookup_code||'|'|| -- payment_method
inv.goods_received_date||'|'||
dist.line_type_lookup_code||'|'||
dist.description||'|'||
dist.amount||'|'||
dist.dist_code_combination_id||'|'||-- dist_ccid
glcc.segment1 || glcc.segment2 || glcc.segment3 || glcc.segment4 || glcc.segment5 || glcc.segment6 PAYMENT_TRX_REC
--distribution_account
FROM ap.ap_invoices_all inv
,ap.ap_invoice_payments_all pay
,ap_terms_vl trms
,ap.ap_invoice_distributions_all dist
,gl.gl_code_combinations glcc
,ap_payment_schedules_all psch
,po.po_vendor_sites_all sites
, (SELECT poh.segment1 po_number
,pod.po_distribution_id po_dist_id
FROM po.po_headers_all poh, po.po_distributions_all pod
WHERE poh.po_header_id = pod.po_header_id) po
WHERE inv.payment_status_flag = 'Y'
AND TRUNC (pay.creation_date) >= TO_DATE ('01-10-2009', 'DD-MM-YYYY')
AND TRUNC (pay.creation_date) <= TO_DATE ('31-10-2009', 'DD-MM-YYYY') --and to_char(pay.creation_date,'mm-yyyy') = '09-2010' AND inv.invoice_id = pay.invoice_id AND inv.invoice_id = dist.invoice_id AND pay.invoice_id = psch.invoice_id AND inv.terms_id = trms.term_id AND inv.vendor_site_id = sites.vendor_site_id AND glcc.code_combination_id = dist.dist_code_combination_id AND dist.po_distribution_id = po.po_dist_id(+) AND sites.pay_group_lookup_code <> 'EMPLOYEE'