Tuesday, March 9, 2010
from ap_invoices_all aia
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;
Do you think this Article is useful?
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.