Loading

Tuesday, March 9, 2010

Query joining the Main Account Payables Invoice Tables with their important columns listed.

select  aia.invoice_id
            ,aia.invoice_num
            ,aia.invoice_date 
            ,aia.invoice_amount
            ,aial.line_number
            ,fit.description line_type 
           ,aial.amount line_amount
            ,aial.po_header_id
            ,aial.po_line_id
             ,aial.po_line_location_id
            ,aial.po_distribution_id
              ,aial.po_release_id
           ,aida.distribution_line_number
          ,aida.line_type_lookup_code
          ,aida.dist_code_combination_id
          ,aida.amount distribution_amount
  from ap_invoices_all aia
            ,ap_invoice_lines_all aial
            ,fnd_lookup_values fit
            ,ap_invoice_distributions_all aida
 WHERE 1 = 1 
   AND aia.invoice_id = aial.invoice_id
   AND aial.invoice_id = aida.invoice_id
   AND aial.line_number = aida.invoice_line_number
   AND aial.line_type_lookup_code = fit.lookup_code
   AND fit.lookup_type = 'INVOICE LINE TYPE'
   AND aia.invoice_date > sysdate - 200
   AND aia.invoice_id =
   order by aial.line_number;

0 Responses to “Query joining the Main Account Payables Invoice Tables with their important columns listed.”

Post a Comment

Disclaimer

The ideas, thoughts and concepts expressed here are my own. They, in no way reflect those of my employer or any other organization/client that I am associated. The articles presented doesn't imply to any particular organization or client and are meant only for knowledge Sharing purpose. The articles can't be reproduced or copied without the Owner's knowledge or permission.