42: FROM
43: ap_invoices_all i,
44: ap_invoice_distributions_all id,
45: po_distributions_all pd,
46: cpg_oragems_mapping map,
47: po_lines_all pl,
48: mtl_system_items msi,
49: gl_sets_of_books sob
50: WHERE i.invoice_num = invoicenum
109: FROM
110: ap_invoices_all i,
111: ap_invoice_distributions_all id,
112: po_distributions_all pd,
113: cpg_oragems_mapping map,
114: po_lines_all pl,
115: mtl_system_items msi,
116: gl_sets_of_books sob
117: WHERE i.invoice_num LIKE NVL( invoicenum, i.invoice_num)