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.JE_IT_LISTING_PKG dependencies on AP_INVOICES_ALL

Line 792: FROM ap_invoices_all ih ,

788: DECODE(ih.invoice_currency_code,gv_currency_code, iditem.amount, iditem.base_amount)) amount_item,
789: -- Item Line Amount for Credit Memo Invoices
790: DECODE(ih.invoice_type_lookup_code,'CREDIT',DECODE(ih.invoice_currency_code,gv_currency_code, iditem.amount, iditem.base_amount)
791: ,0) cm_amount_item
792: FROM ap_invoices_all ih ,
793: ap_invoice_lines_all il ,
794: ap_invoice_distributions_all id ,
795: ap_invoice_lines_all ilitem ,
796: ap_invoice_distributions_all iditem ,

Line 833: FROM ap_invoices_all tih

829: -- during the year but applied to invoices issued in the previous years.
830: AND ( ( ih.invoice_type_lookup_code <> 'CREDIT')
831: or( ih.invoice_type_lookup_code = 'CREDIT'
832: and EXISTS (SELECT 1
833: FROM ap_invoices_all tih
834: WHERe tih.invoice_id = id.parent_invoice_id
835: AND TO_CHAR(tih.invoice_date, 'YYYY') =TO_CHAR(add_months(gd_period_end_date,-12), 'YYYY') --bug 7031451
836: ))
837: )