PO to AP full Query in Oracle Apps

PO to AP full Query in Oracle Apps:
==========================

SELECT aia.invoice_num invoicenumber, aia.invoice_date, aia.gl_date,
       aida.amount, pha.segment1 ponumber, asa.vendor_name vendorname,
       glcc.segment2 account_number, glh.posted_date postedate,
       glh.period_name perioddate, asa.creation_date
  FROM gl.gl_je_headers glh,
       gl.gl_je_lines gll,
       gl.gl_import_references glir,
       xla.xla_ae_lines xll,
       xla.xla_ae_headers xlh,
       xla.xla_events xle,
       xla.xla_transaction_entities xlte,
       ap_invoices_all aia,
       ap_invoice_lines_all ail,
       ap_invoice_distributions_all aida,
       po_distributions_all pda,
       po_headers_all pha,
       ap_suppliers asa,
       gl_code_combinations_kfv glcc
 WHERE glh.je_header_id = gll.je_header_id
   AND gll.je_header_id = glir.je_header_id
   AND glh.je_header_id = glir.je_header_id                      
   AND gll.je_line_num = glir.je_line_num
   AND glir.gl_sl_link_table = xll.gl_sl_link_table
   AND glir.gl_sl_link_id = xll.gl_sl_link_id
   AND xll.application_id = xlh.application_id
   AND xll.ae_header_id = xlh.ae_header_id
   AND xlh.application_id = xle.application_id
   AND xlh.event_id = xle.event_id
   AND xle.application_id = xlte.application_id
   AND xle.entity_id = xlte.entity_id
   AND xlh.entity_id = xlte.entity_id                            
   AND xlte.source_id_int_1 = aia.invoice_id
   AND aia.invoice_id = ail.invoice_id
   AND ail.invoice_id = aida.invoice_id
   AND ail.line_number = aida.invoice_line_number
   AND aia.invoice_num = '12345'
   AND aida.po_distribution_id = pda.po_distribution_id(+)
   AND pda.po_header_id = pha.po_header_id(+)
   AND aia.vendor_id = asa.vendor_id
   AND aida.dist_code_combination_id = glcc.code_combination_id
   AND xll.code_combination_id = glcc.code_combination_id  ;