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 561: FROM ap_SELECTed_invoices_all ASI,

557: CURSOR c_sel_invs IS
558: SELECT invoice_id
559: , vendor_id
560: , payment_num
561: FROM ap_SELECTed_invoices_all ASI,
562: ap_system_parameters_all asp,
563: iby_fd_docs_payable_v ibydocs
564: WHERE checkrun_name = l_checkrun_name
565: AND original_invoice_id IS NULL

Line 640: delete from ap_selected_invoices_all

636: where checkrun_id = l_checkrun_id;
637:
638:
639:
640: delete from ap_selected_invoices_all
641: where checkrun_id = l_checkrun_id
642: /* Bug 6950891. Added TO_CHAR */
643: and (TO_CHAR(invoice_id), TO_CHAR(payment_num)) in
644: (select calling_app_doc_unique_ref2,

Line 784: ap_selected_invoices_all si,

780: iby_discount_amount_taken,
781: AP_INVOICES_UTILITY_PKG.get_payment_status(inv.invoice_id),
782: inv.invoice_id
783: FROM ap_invoices_all inv,
784: ap_selected_invoices_all si,
785: (SELECT sum(ibydocs.payment_amount) iby_amount_paid,
786: nvl(sum(ibydocs.payment_curr_discount_taken),0) iby_discount_amount_taken,
787: ibydocs.calling_app_doc_unique_ref1 ref1,
788: ibydocs.calling_app_doc_unique_ref2 ref2,

Line 835: ap_selected_invoices_all si,

831: ps.invoice_id,
832: ps.payment_num
833: FROM ap_payment_schedules_all ps,
834: ap_invoices_all inv,
835: ap_selected_invoices_all si,
836: iby_fd_payments_v ibypmts,
837: iby_fd_docs_payable_v ibydocs
838: WHERE si.checkrun_name = p_checkrun_name
839: AND si.payment_num = ps.payment_num

Line 1206: ap_selected_invoices_all new,

1202: ibypmts.relationship_id
1203: FROM ap_invoices_all orig,
1204: ap_supplier_sites_all aps, -- bug 7673570
1205: iby_fd_payments_v ibypmts,
1206: ap_selected_invoices_all new,
1207: iby_fd_docs_payable_v ibydocs,
1208: fnd_currencies fcinv
1209: /* Bug 6950891. Added TO_CHAR */
1210: WHERE ibydocs.calling_app_doc_unique_ref1 = TO_CHAR(new.checkrun_id)

Line 1407: ap_selected_invoices_all new,

1403: aps.vendor_site_code,
1404: ibypmts.supplier_site_id,
1405: ibypmts.relationship_id
1406: FROM ap_invoices_all orig,
1407: ap_selected_invoices_all new,
1408: ap_supplier_sites_all aps, -- bug 7673570
1409: fnd_currencies fcinv,
1410: iby_fd_payments_v ibypmts,
1411: iby_fd_docs_payable_v ibydocs

Line 1450: ap_selected_invoices_all new,

1446: l_last_updated_by,
1447: SYSDATE,
1448: l_checkrun_name
1449: FROM ap_invoices_all orig,
1450: ap_selected_invoices_all new,
1451: iby_fd_payments_v ibypmts,
1452: iby_fd_docs_payable_v ibydocs
1453: /* Bug 6950891. Added TO_CHAR */
1454: WHERE ibydocs.calling_app_doc_unique_ref1 = TO_CHAR(new.checkrun_id)

Line 1755: l_debug_info := 'UPDATE ap_selected_invoices_all';

1751: END IF;
1752:
1753: --bug8224330
1754:
1755: l_debug_info := 'UPDATE ap_selected_invoices_all';
1756: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1757: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1758: END IF;
1759:

Line 1760: UPDATE ap_selected_invoices_all ASI

1756: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1757: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1758: END IF;
1759:
1760: UPDATE ap_selected_invoices_all ASI
1761: SET ASI.invoice_payment_id = ap_invoice_payments_s.nextval
1762: WHERE ASI.checkrun_id = l_checkrun_id
1763: /* Bug 6950891. Added TO_CHAR */
1764: AND (TO_CHAR(ASI.invoice_id), TO_CHAR(ASI.payment_num)) in

Line 1784: FROM ap_selected_invoices_all ASI

1780:
1781: UPDATE ap_awt_temp_distributions_all AATD
1782: SET AATD.invoice_payment_id =
1783: (SELECT ASI.invoice_payment_id
1784: FROM ap_selected_invoices_all ASI
1785: WHERE ASI.checkrun_id = AATD.checkrun_id
1786: AND ASI.invoice_id = AATD.invoice_id
1787: AND ASI.payment_num = AATD.payment_num
1788: AND asi.org_id = l_current_org_id)

Line 2128: ap_selected_invoices_all SI,

2124: ibypmts.supplier_site_id
2125: FROM
2126: iby_fd_payments_v ibypmts,
2127: iby_fd_docs_payable_v ibydocs,
2128: ap_selected_invoices_all SI,
2129: fnd_currencies FORE,
2130: ap_payment_schedules_all PS,
2131: ap_invoices_all AI,
2132: ap_checks_all ac,

Line 2320: FROM ap_selected_invoices_all SI1,

2316: 0,
2317: decode(SI1.amount_remaining - ibydocs.payment_amount - nvl(ibydocs.payment_curr_discount_taken,0), 0,
2318: 'Y', 'P'),
2319: null --set checkrun_id to null
2320: FROM ap_selected_invoices_all SI1,
2321: iby_fd_docs_payable_v ibydocs
2322: WHERE checkrun_name = l_checkrun_name
2323: AND SI1.payment_num = ps1.payment_num
2324: AND SI1.invoice_id = ps1.invoice_id

Line 2330: FROM ap_selected_invoices_all SI3,

2326: AND ibydocs.calling_app_doc_unique_ref2 = to_char(si1.invoice_id)
2327: AND ibydocs.calling_app_doc_unique_ref3 = to_char(si1.payment_num))
2328: WHERE (ps1.invoice_id, ps1.payment_num) in
2329: (SELECT SI3.invoice_id, SI3.payment_num
2330: FROM ap_selected_invoices_all SI3,
2331: iby_fd_payments_v ibypmts,
2332: iby_fd_docs_payable_v ibydocs,
2333: ap_invoices_all AI
2334: WHERE SI3.checkrun_name = l_checkrun_name

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

2370: AND ibypmts.org_id = l_current_org_id
2371: and
2372: (ibydocs.calling_app_doc_unique_ref1,ibydocs.calling_app_doc_unique_ref2,ibydocs.calling_app_doc_unique_ref3)
2373: in (select si.checkrun_id,si.invoice_id,si.payment_num from
2374: ap_selected_invoices_all si where si.invoice_id=inv1.invoice_id
2375: and checkrun_name = l_checkrun_name)
2376: )
2377: WHERE invoice_id IN
2378: (SELECT ibydocs.calling_app_doc_unique_ref2

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

2457: p_completed_pmts_group_id => p_completed_pmts_group_id,
2458: p_org_id => l_current_org_id);
2459:
2460:
2461: l_debug_info := 'DELETE FROM ap_selected_invoices_all';
2462: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2463: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2464: END IF;
2465:

Line 2466: DELETE FROM ap_selected_invoices_all

2462: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2463: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2464: END IF;
2465:
2466: DELETE FROM ap_selected_invoices_all
2467: WHERE checkrun_id = l_checkrun_id
2468: /* Bug 6950891. Added TO_CHAR */
2469: and (TO_CHAR(invoice_id), TO_CHAR(payment_num)) in
2470: (select ibydocs.calling_app_doc_unique_ref2,