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.JL_BR_AP_ASSOCIATE_COLLECTION dependencies on AP_PAYMENT_SCHEDULES_ALL

Line 68: FROM ap_payment_schedules_ALL apps,

64: END IF;
65: /* Invoice number AND Due date */
66: SELECT apps.invoice_id, apps.payment_num
67: INTO invoice_id_s, payment_num_s
68: FROM ap_payment_schedules_ALL apps,
69: jl_br_ap_collection_docs jlbl,
70: ap_invoices_ALL apinv
71: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
72: apps.org_id = jlbl.org_id AND --bug 14615620

Line 91: FROM ap_payment_schedules_ALL apps,

87: END IF;
88: /* Supplier Site AND Supplier Name */
89: SELECT apps.invoice_id, apps.payment_num
90: INTO invoice_id_s, payment_num_s
91: FROM ap_payment_schedules_ALL apps,
92: jl_br_ap_collection_docs jlbl,
93: ap_invoices_ALL apinv
94: /* Bug # 635847 / 659227
95: ,

Line 121: FROM ap_payment_schedules_ALL apps,

117: /* Supplier Site OR Supplier Name */
118: BEGIN
119: SELECT apps.invoice_id, apps.payment_num
120: INTO invoice_id_s, payment_num_s
121: FROM ap_payment_schedules_ALL apps,
122: jl_br_ap_collection_docs jlbl,
123: ap_invoices_ALL apinv
124: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
125: apps.org_id = jlbl.org_id AND --bug 14615620

Line 146: FROM ap_payment_schedules_ALL apps,

142: END;
143: IF x_selected = 'N' THEN
144: SELECT apps.invoice_id, apps.payment_num
145: INTO invoice_id_s, payment_num_s
146: FROM ap_payment_schedules_ALL apps,
147: jl_br_ap_collection_docs jlbl,
148: ap_invoices_ALL apinv
149: /* Bug # 635847 / 659227
150: ,

Line 178: FROM ap_payment_schedules_ALL apps,

174: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME || l_procedure_name, l_log_msg);
175: END IF;
176: SELECT apps.invoice_id, apps.payment_num
177: INTO invoice_id_s, payment_num_s
178: FROM ap_payment_schedules_ALL apps,
179: jl_br_ap_collection_docs jlbl,
180: ap_invoices_ALL apinv
181: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
182: apps.org_id = jlbl.org_id AND --bug 14615620

Line 203: FROM ap_payment_schedules_ALL apps,

199: END IF;
200: /* Invoice Number AND Due date AND Supplier Name */
201: SELECT apps.invoice_id, apps.payment_num
202: INTO invoice_id_s, payment_num_s
203: FROM ap_payment_schedules_ALL apps,
204: jl_br_ap_collection_docs jlbl,
205: ap_invoices_ALL apinv
206: /* Bug # 635847 / 659227
207: ,

Line 233: FROM ap_payment_schedules_ALL apps,

229: END IF;
230: /* Invoice number AND Gross Amount AND Due Date */
231: SELECT apps.invoice_id, apps.payment_num
232: INTO invoice_id_s, payment_num_s
233: FROM ap_payment_schedules_ALL apps,
234: jl_br_ap_collection_docs jlbl,
235: ap_invoices_ALL apinv
236: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
237: apps.org_id = jlbl.org_id AND --bug 14615620

Line 259: FROM ap_payment_schedules_ALL apps,

255: END IF;
256: /* Invoice number AND Gross Amount AND Due Date AND Supplier Site */
257: SELECT apps.invoice_id, apps.payment_num
258: INTO invoice_id_s, payment_num_s
259: FROM ap_payment_schedules_ALL apps,
260: jl_br_ap_collection_docs jlbl,
261: ap_invoices_ALL apinv
262: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
263: apps.org_id = jlbl.org_id AND --bug 14615620

Line 287: FROM ap_payment_schedules_ALL apps,

283: END IF;
284: /* Invoice number AND Gross Amount AND Due Date AND Supplier Name */
285: SELECT apps.invoice_id, apps.payment_num
286: INTO invoice_id_s, payment_num_s
287: FROM ap_payment_schedules_ALL apps,
288: jl_br_ap_collection_docs jlbl,
289: ap_invoices_ALL apinv
290: /* Bug # 635847 / 659227
291: ,

Line 321: FROM ap_payment_schedules_ALL apps,

317: /* Invoice number AND Gross Amount AND Due Date AND Supplier Site */
318: /* AND Supplier Name */
319: SELECT apps.invoice_id, apps.payment_num
320: INTO invoice_id_s, payment_num_s
321: FROM ap_payment_schedules_ALL apps,
322: jl_br_ap_collection_docs jlbl,
323: ap_invoices_ALL apinv
324: /* Bug # 635847 / 659227
325: ,

Line 358: FROM ap_payment_schedules_ALL apps,

354: /* AND Supplier Name */
355: BEGIN
356: SELECT apps.invoice_id, apps.payment_num
357: INTO invoice_id_s, payment_num_s
358: FROM ap_payment_schedules_ALL apps,
359: jl_br_ap_collection_docs jlbl,
360: ap_invoices_ALL apinv
361: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
362: apps.org_id = jlbl.org_id AND --bug 14615620

Line 387: FROM ap_payment_schedules_ALL apps,

383: END;
384: IF x_selected = 'N' THEN
385: SELECT apps.invoice_id, apps.payment_num
386: INTO invoice_id_s, payment_num_s
387: FROM ap_payment_schedules_ALL apps,
388: jl_br_ap_collection_docs jlbl,
389: ap_invoices_ALL apinv
390: /* Bug # 635847 / 659227
391: ,

Line 423: FROM ap_payment_schedules_ALL apps,

419: /* Invoice number OR Gross Amount AND Due Date AND Supplier Site */
420: BEGIN
421: SELECT apps.invoice_id, apps.payment_num
422: INTO invoice_id_s, payment_num_s
423: FROM ap_payment_schedules_ALL apps,
424: jl_br_ap_collection_docs jlbl,
425: ap_invoices_ALL apinv
426: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
427: apps.org_id = jlbl.org_id AND --bug 14615620

Line 448: FROM ap_payment_schedules_ALL apps,

444: END;
445: IF x_selected = 'N' THEN
446: SELECT apps.invoice_id, apps.payment_num
447: INTO invoice_id_s, payment_num_s
448: FROM ap_payment_schedules_ALL apps,
449: jl_br_ap_collection_docs jlbl,
450: ap_invoices_ALL apinv
451: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
452: apps.org_id = jlbl.org_id AND --bug 14615620

Line 479: FROM ap_payment_schedules_ALL apps,

475: END IF;
476: /* Gross Amount AND Due Date AND Supplier Site */
477: SELECT apps.invoice_id, apps.payment_num
478: INTO invoice_id_s, payment_num_s
479: FROM ap_payment_schedules_ALL apps,
480: jl_br_ap_collection_docs jlbl,
481: ap_invoices_ALL apinv
482: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
483: apps.org_id = jlbl.org_id AND --bug 14615620

Line 505: FROM ap_payment_schedules_ALL apps,

501: END IF;
502: /* Gross Amount AND Due Date AND Supplier Name */
503: SELECT apps.invoice_id, apps.payment_num
504: INTO invoice_id_s, payment_num_s
505: FROM ap_payment_schedules_ALL apps,
506: jl_br_ap_collection_docs jlbl,
507: ap_invoices_ALL apinv
508: /* Bug # 635847 / 659227
509: ,