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_INVOICES_ALL

Line 165: ap_invoices_all i,

161: CURSOR C_INTEREST_INVOICES IS
162: SELECT i.invoice_id
163: FROM ap_invoice_payments_all aip,
164: ap_checks_all c,
165: ap_invoices_all i,
166: ap_invoice_relationships ir
167: WHERE c.check_id = p_check_id
168: AND c.check_id = aip.check_id
169: AND aip.invoice_id = ir.related_invoice_id

Line 215: update ap_invoices_all

211: return;
212:
213: elsif l_return_code = 0 then
214:
215: update ap_invoices_all
216: set doc_sequence_id = l_int_dbseqid,
217: doc_sequence_value = l_int_seqval,
218: doc_category_code = 'INT INV'
219: where invoice_id = l_invoice_id;

Line 762: AP_Invoices_All AI,

758: SELECT Distinct AC.Check_ID,
759: APR.Reg_Application_ID
760: FROM AP_Checks_All AC,
761: AP_Invoice_Payments_All AIP,
762: AP_Invoices_All AI,
763: AP_Product_Registrations APR
764: WHERE AC.Checkrun_Name = l_checkrun_name
765: AND AC.Completed_Pmts_Group_ID = p_completed_pmts_group_id
766: AND AC.Org_ID = l_current_org_id

Line 783: FROM ap_invoices_all inv,

779: iby_amount_paid,
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,

Line 834: ap_invoices_all inv,

830: Null,
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

Line 1064: INSERT INTO ap_invoices_all(

1060: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1061: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1062: END IF;
1063:
1064: INSERT INTO ap_invoices_all(
1065: invoice_id,
1066: last_update_date,
1067: last_updated_by,
1068: vendor_id,

Line 1203: FROM ap_invoices_all orig,

1199: aps.vendor_id,
1200: aps.vendor_site_code,
1201: ibypmts.supplier_site_id,
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,

Line 1305: ap_invoices_all orig,

1301: 'NOT REQUIRED',
1302: l_current_org_id
1303: FROM
1304: po_vendors pv,
1305: ap_invoices_all orig,
1306: iby_fd_payments_v ibypmts,
1307: iby_fd_docs_payable_v ibydocs,
1308: ap_selected_invoices new,
1309: fnd_currencies fcinv

Line 1406: FROM ap_invoices_all orig,

1402: aps.vendor_id,
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,

Line 1449: FROM ap_invoices_all orig,

1445: new.original_payment_num,
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 */

Line 1494: FROM ap_invoices_all I,

1490: count(*),
1491: SYSDATE,
1492: l_last_updated_by,
1493: i.org_id
1494: FROM ap_invoices_all I,
1495: ap_lookup_codes LC
1496: WHERE I.batch_id= l_int_batch_id
1497: AND LC.lookup_code = 'NLS TRANLSATION'
1498: AND LC.lookup_type = 'INTEREST ON PAYMENTBATCH'

Line 1688: from ap_invoices_all inv,iby_docs_payable_all idp

1684: AND aps.vendor_site_id = iby.supplier_site_id -- 7673570
1685: AND pv.end_date_active IS NULL -- bug7166247
1686: --added condition as per Bug 7196023
1687: AND nvl(pv.vendor_id,-99) = (select decode(inv.invoice_type_lookup_code,'PAYMENT REQUEST',-99,nvl(vendor_id,-99)) --Bug7493630
1688: from ap_invoices_all inv,iby_docs_payable_all idp
1689: where inv.invoice_id=idp.calling_app_doc_unique_ref2
1690: and idp.payment_id=iby.payment_id
1691: and idp.calling_app_doc_unique_ref1=l_checkrun_id
1692: and rownum=1

Line 1906: l_debug_info := 'UPDATE ap_invoices_all';

1902: payment_status_inv_l,
1903: invoice_id_inv_l
1904: LIMIT 1000;
1905:
1906: l_debug_info := 'UPDATE ap_invoices_all';
1907: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1908: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1909: END IF;
1910:

Line 1912: UPDATE ap_invoices_all

1908: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
1909: END IF;
1910:
1911: FORALL i IN 1..invoice_id_inv_l.COUNT
1912: UPDATE ap_invoices_all
1913: SET last_update_date = last_update_date_inv_l(i)
1914: ,last_updated_by = last_updated_by_inv_l(i)
1915: ,amount_paid = nvl(amount_paid,0) + amount_paid_inv_l(i)
1916: ,discount_amount_taken = nvl(discount_amount_taken,0) + discount_taken_inv_l(i)

Line 2131: ap_invoices_all AI,

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,
2133: ap_supplier_sites_all aps, -- bug 7673570
2134: ce_bank_acct_uses_all ceu,
2135: ce_gl_accounts_ccid cegl,

Line 2287: l_debug_info := 'UPDATE ap_invoices_all';

2283: payment_status_inv_l,
2284: invoice_id_inv_l
2285: LIMIT 1000;
2286:
2287: l_debug_info := 'UPDATE ap_invoices_all';
2288: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2289: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2290: END IF;
2291:

Line 2293: UPDATE ap_invoices_all

2289: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2290: END IF;
2291:
2292: FORALL i IN 1..invoice_id_inv_l.COUNT
2293: UPDATE ap_invoices_all
2294: SET last_update_date = last_update_date_inv_l(i)
2295: ,last_updated_by = last_updated_by_inv_l(i)
2296: ,amount_paid = nvl(amount_paid,0) + amount_paid_inv_l(i)
2297: ,discount_amount_taken = nvl(discount_amount_taken,0) + discount_taken_inv_l(i)

Line 2333: ap_invoices_all AI

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
2335: AND ibydocs.calling_app_doc_unique_ref1 = to_char(si3.checkrun_id)
2336: AND ibydocs.calling_app_doc_unique_ref2 = to_char(si3.invoice_id)
2337: AND ibydocs.calling_app_doc_unique_ref3 = to_char(si3.payment_num)

Line 2346: l_debug_info := 'UPDATE ap_invoices_all';

2342: AND AI.invoice_id = SI3.invoice_id
2343: AND AI.invoice_type_lookup_code <> 'INTEREST');
2344:
2345:
2346: l_debug_info := 'UPDATE ap_invoices_all';
2347: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2348: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
2349: END IF;
2350:

Line 2354: UPDATE ap_invoices_all inv1

2350:
2351:
2352: --bug5020577
2353: --Modified the sql to prevent MJC.
2354: UPDATE ap_invoices_all inv1
2355: SET (last_update_date,
2356: last_updated_by,
2357: amount_paid,
2358: discount_amount_taken,