903: -- Bug#5131075(4683207). Added by Lakshmi Gopalsami
904: ai.invoice_type_lookup_code,
905: ai.invoice_num, /*added for bug 6493858 ref-6318997*/
906: pv.vendor_type_lookup_code /* Bug 8330522. Added by Lakshmi Gopalsami */
907: from ap_invoices_all ai, po_vendors pv
908: where ai.invoice_id = pr_new.invoice_id
909: and ai.vendor_id = pv.vendor_id;
910:
911: --Added by Sanjikum for Bug#5131075(4722011)