eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGIPMSDA dependencies on AP_INVOICES_V

Line 35: from ap_invoices_v inv

31: -- This excludes prepayments automatically.
32: */
33: CURSOR c_proper_inv (cp_invoice_id in number) IS
34: SELECT inv.invoice_id, inv.approval_status_lookup_code
35: from ap_invoices_v inv
36: WHERE inv.invoice_id = cp_invoice_id
37: and inv.approval_status_lookup_code
38: in ('APPROVED', 'CANCELLED')
39: ;

Line 364: from ap_invoices_v apinv

360: , p_transfer_id in number ) IS
361: CURSOR c_inv IS
362: SELECT apinv.invoice_id, imit.accounting_rule_id, imit.rowid
363: imit_rowid
364: from ap_invoices_v apinv
365: , igi_mpp_invoice_transfer imit
366: WHERE apinv.approval_status_lookup_code = 'APPROVED'
367: AND imit.invoice_id = apinv.invoice_id
368: AND imit.transfer_id = p_transfer_id

Line 436: from ap_invoices_v apinv

432: , p_batch_name in varchar2
433: ) IS
434: CURSOR c_inv IS
435: SELECT invoice_id
436: from ap_invoices_v apinv
437: where vendor_name = nvl(p_vendor_name, vendor_name)
438: and ( ( p_batch_name is null )
439: OR
440: ( ( p_batch_name is not null ) AND