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 36: FROM ap_payment_schedules_ALL apps,

32: IF (association_method_e = 'METHOD1') THEN
33: /* Invoice number AND Due date */
34: SELECT apps.invoice_id, apps.payment_num
35: INTO invoice_id_s, payment_num_s
36: FROM ap_payment_schedules_ALL apps,
37: jl_br_ap_collection_docs jlbl,
38: ap_invoices_ALL apinv
39: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
40: (( substr( apinv.invoice_num,1,10 ) = jlbl.document_number AND

Line 53: FROM ap_payment_schedules_ALL apps,

49: ELSIF (association_method_e = 'METHOD2') THEN
50: /* Supplier Site AND Supplier Name */
51: SELECT apps.invoice_id, apps.payment_num
52: INTO invoice_id_s, payment_num_s
53: FROM ap_payment_schedules_ALL apps,
54: jl_br_ap_collection_docs jlbl,
55: ap_invoices_ALL apinv
56: /* Bug # 635847 / 659227
57: ,

Line 77: FROM ap_payment_schedules_ALL apps,

73: /* Supplier Site OR Supplier Name */
74: BEGIN
75: SELECT apps.invoice_id, apps.payment_num
76: INTO invoice_id_s, payment_num_s
77: FROM ap_payment_schedules_ALL apps,
78: jl_br_ap_collection_docs jlbl,
79: ap_invoices_ALL apinv
80: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
81: (( apinv.vendor_site_id = jlbl.vendor_site_id AND

Line 96: FROM ap_payment_schedules_ALL apps,

92: END;
93: IF x_selected = 'N' THEN
94: SELECT apps.invoice_id, apps.payment_num
95: INTO invoice_id_s, payment_num_s
96: FROM ap_payment_schedules_ALL apps,
97: jl_br_ap_collection_docs jlbl,
98: ap_invoices_ALL apinv
99: /* Bug # 635847 / 659227
100: ,

Line 118: FROM ap_payment_schedules_ALL apps,

114: ELSIF (association_method_e = 'METHOD4') THEN
115: /* Invoice Number AND Due date AND Supplier Site */
116: SELECT apps.invoice_id, apps.payment_num
117: INTO invoice_id_s, payment_num_s
118: FROM ap_payment_schedules_ALL apps,
119: jl_br_ap_collection_docs jlbl,
120: ap_invoices_ALL apinv
121: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
122: (( substr( apinv.invoice_num,1,10 ) = jlbl.document_number AND

Line 137: FROM ap_payment_schedules_ALL apps,

133: ELSIF (association_method_e = 'METHOD5') THEN
134: /* Invoice Number AND Due date AND Supplier Name */
135: SELECT apps.invoice_id, apps.payment_num
136: INTO invoice_id_s, payment_num_s
137: FROM ap_payment_schedules_ALL apps,
138: jl_br_ap_collection_docs jlbl,
139: ap_invoices_ALL apinv
140: /* Bug # 635847 / 659227
141: ,

Line 161: FROM ap_payment_schedules_ALL apps,

157: ELSIF (association_method_e = 'METHOD6') THEN
158: /* Invoice number AND Gross Amount AND Due Date */
159: SELECT apps.invoice_id, apps.payment_num
160: INTO invoice_id_s, payment_num_s
161: FROM ap_payment_schedules_ALL apps,
162: jl_br_ap_collection_docs jlbl,
163: ap_invoices_ALL apinv
164: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
165: (( substr( apinv.invoice_num,1,10 ) = jlbl.document_number AND

Line 181: FROM ap_payment_schedules_ALL apps,

177: ELSIF (association_method_e = 'METHOD7') THEN
178: /* Invoice number AND Gross Amount AND Due Date AND Supplier Site */
179: SELECT apps.invoice_id, apps.payment_num
180: INTO invoice_id_s, payment_num_s
181: FROM ap_payment_schedules_ALL apps,
182: jl_br_ap_collection_docs jlbl,
183: ap_invoices_ALL apinv
184: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
185: (( substr( apinv.invoice_num,1,10 ) = jlbl.document_number AND

Line 203: FROM ap_payment_schedules_ALL apps,

199: ELSIF (association_method_e = 'METHOD8') THEN
200: /* Invoice number AND Gross Amount 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 231: FROM ap_payment_schedules_ALL apps,

227: /* Invoice number AND Gross Amount AND Due Date AND Supplier Site */
228: /* AND Supplier Name */
229: SELECT apps.invoice_id, apps.payment_num
230: INTO invoice_id_s, payment_num_s
231: FROM ap_payment_schedules_ALL apps,
232: jl_br_ap_collection_docs jlbl,
233: ap_invoices_ALL apinv
234: /* Bug # 635847 / 659227
235: ,

Line 262: FROM ap_payment_schedules_ALL apps,

258: /* AND Supplier Name */
259: BEGIN
260: SELECT apps.invoice_id, apps.payment_num
261: INTO invoice_id_s, payment_num_s
262: FROM ap_payment_schedules_ALL apps,
263: jl_br_ap_collection_docs jlbl,
264: ap_invoices_ALL apinv
265: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
266: (( substr( apinv.invoice_num,1,10 ) = jlbl.document_number AND

Line 285: FROM ap_payment_schedules_ALL apps,

281: END;
282: IF x_selected = 'N' THEN
283: SELECT apps.invoice_id, apps.payment_num
284: INTO invoice_id_s, payment_num_s
285: FROM ap_payment_schedules_ALL apps,
286: jl_br_ap_collection_docs jlbl,
287: ap_invoices_ALL apinv
288: /* Bug # 635847 / 659227
289: ,

Line 311: FROM ap_payment_schedules_ALL apps,

307: /* Invoice number OR Gross Amount AND Due Date AND Supplier Site */
308: BEGIN
309: SELECT apps.invoice_id, apps.payment_num
310: INTO invoice_id_s, payment_num_s
311: FROM ap_payment_schedules_ALL apps,
312: jl_br_ap_collection_docs jlbl,
313: ap_invoices_ALL apinv
314: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
315: (( substr( apinv.invoice_num,1,10 ) = jlbl.document_number AND

Line 330: FROM ap_payment_schedules_ALL apps,

326: END;
327: IF x_selected = 'N' THEN
328: SELECT apps.invoice_id, apps.payment_num
329: INTO invoice_id_s, payment_num_s
330: FROM ap_payment_schedules_ALL apps,
331: jl_br_ap_collection_docs jlbl,
332: ap_invoices_ALL apinv
333: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
334: (( nvl(apps.gross_amount,0) = nvl(jlbl.amount,0) AND

Line 351: FROM ap_payment_schedules_ALL apps,

347: ELSIF (association_method_e = 'METHOD12') THEN
348: /* Gross Amount AND Due Date AND Supplier Site */
349: SELECT apps.invoice_id, apps.payment_num
350: INTO invoice_id_s, payment_num_s
351: FROM ap_payment_schedules_ALL apps,
352: jl_br_ap_collection_docs jlbl,
353: ap_invoices_ALL apinv
354: WHERE jlbl.bank_collection_id = bank_collection_id_e AND
355: (( nvl(apps.gross_amount,0) = nvl(jlbl.amount,0) AND

Line 371: FROM ap_payment_schedules_ALL apps,

367: ELSIF (association_method_e = 'METHOD13') THEN
368: /* Gross Amount AND Due Date AND Supplier Name */
369: SELECT apps.invoice_id, apps.payment_num
370: INTO invoice_id_s, payment_num_s
371: FROM ap_payment_schedules_ALL apps,
372: jl_br_ap_collection_docs jlbl,
373: ap_invoices_ALL apinv
374: /* Bug # 635847 / 659227
375: ,