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_DISTRIBUTIONS_ALL

Line 643: ap_invoice_distributions_all aid,

639: g_created_by
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,

Line 653: ap_invoice_distributions_all itemdist,

649: FROM PER_ALL_PEOPLE_F WHERE trunc(sysdate) BETWEEN effective_start_date AND effective_end_date) papf,
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'

Line 667: From ap_invoice_distributions_all aida1,

663: AND pv.vendor_id = pvs.vendor_id
664: AND ai.vendor_site_id = pvs.vendor_site_id
665: /* --Changed for performance
666: AND repent.tax_regime_code = (select zx.tax_regime_code
667: From ap_invoice_distributions_all aida1,
668: zx_rates_b zx
669: Where aida1.invoice_id = Ai.invoice_id
670: And ( aida1.charge_applicable_to_dist_id= aid.invoice_distribution_id or
671: aida1.invoice_distribution_id = aid.invoice_distribution_id )

Line 679: FROM ap_invoice_distributions_all aida1a,

675: AND
676: (
677: repent.tax_regime_code =
678: (SELECT zx.tax_regime_code
679: FROM ap_invoice_distributions_all aida1a,
680: zx_rates_b zx
681: WHERE aida1a.invoice_id = ai.invoice_id
682: AND aida1a.charge_applicable_to_dist_id = aid.invoice_distribution_id
683: AND zx.tax_rate_id = aida1a.tax_code_id

Line 688: FROM ap_invoice_distributions_all aida1b,

684: AND rownum = 1)
685: OR
686: repent.tax_regime_code =
687: (SELECT zx.tax_regime_code
688: FROM ap_invoice_distributions_all aida1b,
689: zx_rates_b zx
690: WHERE aida1b.invoice_id = ai.invoice_id
691: AND aida1b.invoice_distribution_id = aid.invoice_distribution_id
692: AND zx.tax_rate_id = aida1b.tax_code_id

Line 697: FROM ap_invoice_distributions_all aida1c,

693: AND rownum = 1)
694: OR
695: repent.tax_regime_code =
696: (SELECT zx.tax_regime_code
697: FROM ap_invoice_distributions_all aida1c,
698: zx_rates_b zx
699: WHERE aida1c.invoice_id = ai.invoice_id
700: AND aida1c.charge_applicable_to_dist_id = aid.related_id
701: AND zx.tax_rate_id = aida1c.tax_code_id

Line 706: FROM ap_invoice_distributions_all aid1

702: AND rownum = 1)
703: )
704: AND aid.line_type_lookup_code <> 'AWT'
705: AND NOT EXISTS (SELECT 1
706: FROM ap_invoice_distributions_all aid1
707: WHERE aid1.invoice_id = ai.invoice_id
708: AND NVL(aid1.match_status_flag,'N') <>'A')
709: AND (aid.tax_code_id IS not NULL or exists (select 1
710: from ap_invoice_distributions_all aida

Line 710: from ap_invoice_distributions_all aida

706: FROM ap_invoice_distributions_all aid1
707: WHERE aid1.invoice_id = ai.invoice_id
708: AND NVL(aid1.match_status_flag,'N') <>'A')
709: AND (aid.tax_code_id IS not NULL or exists (select 1
710: from ap_invoice_distributions_all aida
711: WHERE aida.invoice_id = ai.invoice_id
712: AND aida.charge_applicable_to_dist_id= aid.invoice_distribution_id)
713: or exists (select 1
714: from ap_invoice_distributions_all aida

Line 714: from ap_invoice_distributions_all aida

710: from ap_invoice_distributions_all aida
711: WHERE aida.invoice_id = ai.invoice_id
712: AND aida.charge_applicable_to_dist_id= aid.invoice_distribution_id)
713: or exists (select 1
714: from ap_invoice_distributions_all aida
715: WHERE aida.invoice_id = ai.invoice_id
716: AND aida.charge_applicable_to_dist_id= aid.related_id))
717: AND (pv.vat_registration_num IS NOT NULL OR pvs.vat_registration_num IS NOT NULL) -- only B2B invoices for payables.
718: --AND ai.payment_method_code = alc.lookup_code

Line 789: ap_invoice_distributions_all adl

785: FROM je_it_trx_lines_all item_lines
786: WHERE item_lines.trx_id = trx_lines.trx_id
787: AND item_lines.REQUEST_ID = g_conc_request_id
788: AND item_lines.trx_line_id = (SELECT adl.charge_applicable_to_dist_id FROM
789: ap_invoice_distributions_all adl
790: WHERE adl.invoice_distribution_id =trx_lines.trx_line_id
791: AND adl.invoice_id =item_lines.trx_id)
792: )
793: WHERE trx_lines.application_id = 200

Line 815: ap_invoice_distributions_all adl

811: adj_inv_flag,
812: orig_trx_id,
813: inconst_cm_dm_appl_flag
814: FROM je_it_trx_lines_all item_lines,
815: ap_invoice_distributions_all adl
816: WHERE item_lines.trx_id = trx_lines.trx_id
817: AND item_lines.request_id = g_conc_request_id
818: AND item_lines.trx_line_id = adl.charge_applicable_to_dist_id
819: AND adl.invoice_distribution_id = trx_lines.trx_line_id

Line 919: And ail.line_number In ( select aid1.invoice_line_number from ap_invoice_distributions_all aid1,ap_invoice_distributions_all aid2

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
922: and aid2.charge_applicable_to_dist_id=aid1.invoice_distribution_id)
923: --AND aid.line_type_lookup_code = p_line_type