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_INVOICES_ABOVE_THRESHOLD dependencies on AP_INVOICE_LINES_ALL

Line 644: ap_invoice_lines_all ail,

640:
641:
642: FROM ap_invoices_All ai,
643: ap_invoice_distributions_all aid,
644: ap_invoice_lines_all ail,
645: po_vendors pv,
646: po_vendor_sites_all pvs,
647: iby_payment_methods_vl alc, -- ap_lookup_codes alc,
648: (SELECT distinct person_id ,national_identifier

Line 654: ap_invoice_lines_all itemline

650: je_it_setup_doc_seqs_all ds,
651: jg_zz_vat_rep_entities repent,
652: hz_parties hp,
653: ap_invoice_distributions_all itemdist,
654: ap_invoice_lines_all itemline
655:
656: WHERE repent.vat_reporting_entity_id = g_vat_reporting_entity_id
657: AND ( ( repent.entity_type_code = 'LEGAL'
658: AND ai.legal_entity_id = repent.legal_entity_id ))

Line 917: FROM ap_invoice_lines_all ail

913: IF p_application_id = 200 THEN -- AP Transaction
914:
915: SELECT count(*)
916: INTO l_count
917: FROM ap_invoice_lines_all ail
918: WHERE ail.invoice_id = p_parent_trx_id
919: And ail.line_number In ( select aid1.invoice_line_number from ap_invoice_distributions_all aid1,ap_invoice_distributions_all aid2
920: Where aid1.invoice_id = p_parent_trx_id
921: and aid2.invoice_id = p_parent_trx_id