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.AP_PMT_CALLOUT_PKG dependencies on AP_SELECTED_INVOICES_ALL

Line 630: FROM ap_SELECTed_invoices_all ASI,

626: CURSOR c_sel_invs IS
627: SELECT invoice_id,
628: vendor_id,
629: payment_num
630: FROM ap_SELECTed_invoices_all ASI,
631: ap_system_parameters_all asp,
632: iby_fd_docs_payable_v ibydocs
633: WHERE checkrun_name = l_checkrun_name
634: AND original_invoice_id IS NULL

Line 714: delete from ap_selected_invoices_all

710:
711: delete from ap_unselected_invoices_all
712: where checkrun_id = l_checkrun_id;
713:
714: delete from ap_selected_invoices_all
715: where checkrun_id = l_checkrun_id
716: /* Bug 6950891. Added TO_CHAR */
717: /* Bug 12679356. Removed to_char */
718: and (invoice_id, payment_num) in

Line 881: ap_selected_invoices_all si,

877: iby_discount_amount_taken,
878: AP_INVOICES_UTILITY_PKG.get_payment_status(inv.invoice_id),
879: inv.invoice_id
880: FROM ap_invoices_all inv,
881: ap_selected_invoices_all si,
882: (SELECT sum(ibydocs.payment_amount) iby_amount_paid,
883: nvl(sum(ibydocs.payment_curr_discount_taken),0) iby_discount_amount_taken,
884: ibydocs.calling_app_doc_unique_ref1 ref1,
885: ibydocs.calling_app_doc_unique_ref2 ref2,

Line 934: ap_selected_invoices_all si,

930: ps.invoice_id,
931: ps.payment_num
932: FROM ap_payment_schedules_all ps,
933: ap_invoices_all inv,
934: ap_selected_invoices_all si,
935: /*iby_fd_payments_v ibypmts, Commented for Bug#9459810 */
936: iby_fd_docs_payable_v ibydocs
937: WHERE si.checkrun_name = p_checkrun_name
938: AND si.payment_num = ps.payment_num

Line 1393: ap_selected_invoices_all new,

1389: ibypmts.relationship_id
1390: FROM ap_invoices_all orig,
1391: ap_supplier_sites_all aps, -- bug 7673570
1392: iby_fd_payments_v ibypmts,
1393: ap_selected_invoices_all new,
1394: iby_fd_docs_payable_v ibydocs,
1395: fnd_currencies fcinv
1396: /* Bug 6950891 . Added TO_CHAR */
1397: WHERE ibydocs.calling_app_doc_unique_ref1 = TO_CHAR(new.checkrun_id)

Line 1478: ap_selected_invoices_all new, -- Modified for bug 8744658

1474: po_vendors pv,
1475: ap_invoices_all orig,
1476: iby_fd_payments_v ibypmts,
1477: iby_fd_docs_payable_v ibydocs,
1478: ap_selected_invoices_all new, -- Modified for bug 8744658
1479: fnd_currencies fcinv
1480: /* Bug 6950891 Added TO_CHAR */
1481: WHERE ibydocs.calling_app_doc_unique_ref1 = TO_CHAR(new.checkrun_id)
1482: AND ibydocs.calling_app_doc_unique_ref2 = TO_CHAR(new.invoice_id)

Line 1579: ap_selected_invoices_all new,

1575: aps.vendor_site_code,
1576: NVL(ibypmts.supplier_site_id, -222), --modifed for bug 8405513
1577: ibypmts.relationship_id
1578: FROM ap_invoices_all orig,
1579: ap_selected_invoices_all new,
1580: ap_supplier_sites_all aps, -- bug 7673570
1581: fnd_currencies fcinv,
1582: iby_fd_payments_v ibypmts,
1583: iby_fd_docs_payable_v ibydocs

Line 1623: ap_selected_invoices_all new,

1619: l_last_updated_by,
1620: SYSDATE,
1621: l_checkrun_name
1622: FROM ap_invoices_all orig,
1623: ap_selected_invoices_all new,
1624: iby_fd_payments_v ibypmts,
1625: iby_fd_docs_payable_v ibydocs
1626: /* Bug 6950891 Added TO_CHAR */
1627: WHERE ibydocs.calling_app_doc_unique_ref1 = TO_CHAR(new.checkrun_id)

Line 1944: l_debug_info := 'UPDATE ap_selected_invoices_all';

1940: END IF;
1941:
1942: --bug8224330
1943:
1944: l_debug_info := 'UPDATE ap_selected_invoices_all';
1945: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
1946: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1947: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1948: END IF;

Line 1950: UPDATE ap_selected_invoices_all ASI

1946: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1947: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1948: END IF;
1949:
1950: UPDATE ap_selected_invoices_all ASI
1951: SET ASI.invoice_payment_id = ap_invoice_payments_s.nextval
1952: WHERE ASI.checkrun_id = l_checkrun_id
1953: /* Bug 6950891. Added TO_CHAR */
1954: AND (TO_CHAR(ASI.invoice_id), TO_CHAR(ASI.payment_num)) in

Line 1975: FROM ap_selected_invoices_all ASI

1971:
1972: UPDATE ap_awt_temp_distributions_all AATD
1973: SET AATD.invoice_payment_id =
1974: (SELECT ASI.invoice_payment_id
1975: FROM ap_selected_invoices_all ASI
1976: WHERE ASI.checkrun_id = AATD.checkrun_id
1977: AND ASI.invoice_id = AATD.invoice_id
1978: AND ASI.payment_num = AATD.payment_num
1979: AND asi.org_id = l_current_org_id)

Line 2321: ap_selected_invoices_all SI,

2317: 'U' -- bug 8741899: add
2318: FROM
2319: iby_fd_payments_v ibypmts,
2320: iby_fd_docs_payable_v ibydocs,
2321: ap_selected_invoices_all SI,
2322: fnd_currencies FORE,
2323: ap_payment_schedules_all PS,
2324: ap_invoices_all AI,
2325: ap_checks_all ac,

Line 2534: FROM ap_selected_invoices_all SI1,

2530: 0,
2531: decode(SI1.amount_remaining - ibydocs.payment_amount - nvl(ibydocs.payment_curr_discount_taken,0), 0,
2532: 'Y', 'P'),
2533: null --set checkrun_id to null
2534: FROM ap_selected_invoices_all SI1,
2535: iby_fd_docs_payable_v ibydocs
2536: WHERE checkrun_name = l_checkrun_name
2537: AND SI1.payment_num = ps1.payment_num
2538: AND SI1.invoice_id = ps1.invoice_id

Line 2544: FROM ap_selected_invoices_all SI3,

2540: AND ibydocs.calling_app_doc_unique_ref2 = to_char(si1.invoice_id)
2541: AND ibydocs.calling_app_doc_unique_ref3 = to_char(si1.payment_num))
2542: WHERE (ps1.invoice_id, ps1.payment_num) in
2543: (SELECT SI3.invoice_id, SI3.payment_num
2544: FROM ap_selected_invoices_all SI3,
2545: iby_fd_payments_v ibypmts,
2546: iby_fd_docs_payable_v ibydocs,
2547: ap_invoices_all AI
2548: WHERE SI3.checkrun_name = l_checkrun_name

Line 2588: ap_selected_invoices_all si where si.invoice_id=inv1.invoice_id

2584: AND ibypmts.org_id = l_current_org_id
2585: and
2586: (ibydocs.calling_app_doc_unique_ref1,ibydocs.calling_app_doc_unique_ref2,ibydocs.calling_app_doc_unique_ref3)
2587: in (select si.checkrun_id,si.invoice_id,si.payment_num from
2588: ap_selected_invoices_all si where si.invoice_id=inv1.invoice_id
2589: and checkrun_name = l_checkrun_name)
2590: )
2591: WHERE invoice_id IN
2592: (SELECT ibydocs.calling_app_doc_unique_ref2

Line 2703: l_debug_info := 'DELETE FROM ap_selected_invoices_all';

2699: END IF;
2700: /* Added for Bug#9459810 End */
2701:
2702:
2703: l_debug_info := 'DELETE FROM ap_selected_invoices_all';
2704: fnd_file.put_line(FND_FILE.LOG,l_debug_info||' - '||systimestamp);
2705: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2706: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2707: END IF;

Line 2709: DELETE FROM ap_selected_invoices_all

2705: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2706: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2707: END IF;
2708:
2709: DELETE FROM ap_selected_invoices_all
2710: WHERE checkrun_id = l_checkrun_id
2711: /* Bug 6950891. Added TO_CHAR */
2712: and (TO_CHAR(invoice_id), TO_CHAR(payment_num)) in
2713: (select ibydocs.calling_app_doc_unique_ref2,