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_IL_TAX_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 43: ap_invoice_payments_all aip,

39: --------------------------------------------------------------------------------
40: C_PAYMENT_INFO_QUERY VARCHAR2(8000) :=
41: 'SELECT aag.name awt_group_name, ''A'' awt_flag
42: FROM ap_invoices_all ai,
43: ap_invoice_payments_all aip,
44: ap_awt_groups aag,
45: ap_checks_all ac
46: WHERE ac.check_id = :check_id
47: AND ac.check_id = aip.check_id

Line 420: ap_invoice_payments_all aip,

416: END) countv
417: FROM ap_invoices_all ai,
418: ap_invoice_distributions_all aid,
419: ap_checks_all ac,
420: ap_invoice_payments_all aip,
421: po_vendors pvend,
422: po_vendor_sites_all pvs,
423: (SELECT distinct person_id,
424: national_identifier

Line 464: ,ap_invoice_payments_all aip

460: COUNT(distinct(ac.vendor_site_id)) countt
461: FROM ap_invoices_all ai
462: ,ap_invoice_distributions_all aid
463: ,ap_checks_all ac
464: ,ap_invoice_payments_all aip
465: WHERE ai.invoice_id = aid.invoice_id
466: AND ac.check_id=aip.check_id
467: AND aip.invoice_id=ai.invoice_id
468: AND ai.set_of_books_id = ' || l_primary_ledger_id || '

Line 485: FROM AP_INVOICE_PAYMENTS_ALL aip1

481: THEN 0
482: ELSE 1
483: END ) countv,
484: COUNT(distinct(ac1.vendor_site_id)) countt
485: FROM AP_INVOICE_PAYMENTS_ALL aip1
486: ,AP_CHECKS_ALL ac1
487: ,PO_VENDORS pvend1
488: ,PO_VENDOR_SITES_ALL pvs1
489: WHERE aip1.check_id = ac1.check_id

Line 602: FROM (select distinct a.invoice_id,a.accounting_event_id from ap_invoice_payments_all a

598: CURSOR c_get_gross IS
599: SELECT xlah.event_id pay_event_id ,
600: aip.invoice_id invoice_id,
601: SUM(nvl(xdln.unrounded_accounted_dr,0)) - SUM(nvl(xdln.unrounded_accounted_cr,0)) gross_amount
602: FROM (select distinct a.invoice_id,a.accounting_event_id from ap_invoice_payments_all a
603: WHERE a.invoice_id = pn_invoice_id
604: AND a.check_id = pn_check_id
605: AND a.accounting_date >= pd_start_date
606: AND a.accounting_date <= pd_end_date

Line 623: FROM (select distinct a.invoice_id,a.accounting_event_id from ap_invoice_payments_all a

619: CURSOR c_get_gross_void IS
620: SELECT xlah.event_id pay_event_id ,
621: aip.invoice_id invoice_id,
622: SUM(nvl(xdln.unrounded_accounted_cr,0)) - SUM(nvl(xdln.unrounded_accounted_dr,0)) gross_amount
623: FROM (select distinct a.invoice_id,a.accounting_event_id from ap_invoice_payments_all a
624: WHERE a.invoice_id = pn_invoice_id
625: AND a.check_id = pn_check_id
626: AND a.accounting_date >= pd_start_date
627: AND a.accounting_date <= pd_end_date

Line 645: ap_invoice_payments_all aip

641: SELECT xlah.event_id event,
642: SUM(nvl(xdln.unrounded_accounted_cr,0)) - SUM(nvl(xdln.unrounded_accounted_dr,0)) pay_amount --modified for bug10262743
643: FROM xla_ae_lines xdln,
644: xla_ae_headers xlah ,
645: ap_invoice_payments_all aip
646: WHERE aip.invoice_id = cn_invoice_id
647: AND aip.check_id = pn_check_id
648: AND aip.accounting_event_id = cn_event_id
649: AND (xdln.unrounded_accounted_dr IS NOT NULL

Line 663: FROM ap_invoice_payments_all aip,

659: xlah.event_id;
660:
661: CURSOR c_get_invwht_check (cn_invoice_id NUMBER) IS
662: SELECT ai.invoice_id invoice_id
663: FROM ap_invoice_payments_all aip,
664: ap_invoice_distributions_all aid,
665: ap_invoices_all ai
666: WHERE ai.invoice_id = cn_invoice_id
667: AND ai.invoice_id = aip.invoice_id

Line 807: FROM ap_invoice_payments_all aip

803: BEGIN
804: IF ln_invoice_id = ln_pay_invoice_id or ln_bank_awt_check = 1 THEN
805:
806: SELECT SIGN(SUM(NVL(aip.payment_base_amount,aip.amount))) INTO ln_sign
807: FROM ap_invoice_payments_all aip
808: WHERE aip.accounting_event_id = ln_event_id;
809: /* Bug 12668719 - changed ln_sign to 1,when payment done is 0 in case of full withheld invoices */
810: IF ln_sign = 0 THEN
811: ln_sign := 1;

Line 817: FROM ap_invoice_payments_all aip

813: /* Bug 12668719 */
814: ELSE
815:
816: SELECT SIGN(NVL(aip.payment_base_amount,aip.amount)) INTO ln_sign
817: FROM ap_invoice_payments_all aip
818: WHERE aip.invoice_id = ln_invoice_id
819: AND aip.accounting_event_id = ln_event_id;
820:
821: END IF;

Line 884: FROM ap_invoice_payments_all aip,

880: l_bank_awt_check number;
881:
882: CURSOR c_get_invwht_check (cn_invoice_id NUMBER) IS
883: SELECT ai.invoice_id invoice_id
884: FROM ap_invoice_payments_all aip,
885: ap_invoice_distributions_all aid,
886: ap_invoices_all ai
887: WHERE ai.invoice_id = cn_invoice_id
888: AND ai.invoice_id = aip.invoice_id

Line 998: select invoice_id from ap_invoice_payments_all where check_id = pn_check_id);

994:
995: if t=0 then
996:
997: select count(1) into v_tot_cnt from ap_invoices_all where invoice_id in (
998: select invoice_id from ap_invoice_payments_all where check_id = pn_check_id);
999:
1000: select count(1) into v_cre_cnt from ap_invoices_all where invoice_id in (
1001: select invoice_id from ap_invoice_payments_all where check_id = pn_check_id)
1002: and INVOICE_TYPE_LOOKUP_CODE = 'CREDIT';

Line 1001: select invoice_id from ap_invoice_payments_all where check_id = pn_check_id)

997: select count(1) into v_tot_cnt from ap_invoices_all where invoice_id in (
998: select invoice_id from ap_invoice_payments_all where check_id = pn_check_id);
999:
1000: select count(1) into v_cre_cnt from ap_invoices_all where invoice_id in (
1001: select invoice_id from ap_invoice_payments_all where check_id = pn_check_id)
1002: and INVOICE_TYPE_LOOKUP_CODE = 'CREDIT';
1003:
1004: if nvl(v_tot_cnt,0) > nvl(v_cre_cnt,0) then
1005: begin