APPS.AR_CMGT_AGING dependencies on ARPT_SQL_FUNC_UTIL

Line 145: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_0,

141: p_currency_code,
142: sysdate,
143: p_exchange_rate_type,
144: ps.amount_due_remaining)) adr,
145: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_0,
146: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_0,
147: v_bucket_days_to_0,ps.due_date,v_bucket_category,l_as_of_date)
148: * gl_currency_api.convert_amount(
149: ps.invoice_currency_code,

Line 154: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_1,

150: p_currency_code,
151: sysdate,
152: p_exchange_rate_type,
153: ps.amount_due_remaining)) bucket0 ,
154: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_1,
155: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_1,
156: v_bucket_days_to_1,ps.due_date,v_bucket_category,l_as_of_date)
157: * gl_currency_api.convert_amount(
158: ps.invoice_currency_code,

Line 163: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_2,

159: p_currency_code,
160: sysdate,
161: p_exchange_rate_type,
162: ps.amount_due_remaining)) bucket1 ,
163: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_2,
164: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_2,
165: v_bucket_days_to_2,ps.due_date,v_bucket_category,l_as_of_date)
166: * gl_currency_api.convert_amount(
167: ps.invoice_currency_code,

Line 172: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_3,

168: p_currency_code,
169: sysdate,
170: p_exchange_rate_type,
171: ps.amount_due_remaining)) bucket2 ,
172: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_3,
173: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_3,
174: v_bucket_days_to_3,ps.due_date,v_bucket_category,l_as_of_date)
175: * gl_currency_api.convert_amount(
176: ps.invoice_currency_code,

Line 181: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_4,

177: p_currency_code,
178: sysdate,
179: p_exchange_rate_type,
180: ps.amount_due_remaining)) bucket3 ,
181: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_4,
182: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_4,
183: v_bucket_days_to_4,ps.due_date,v_bucket_category,l_as_of_date)
184: * gl_currency_api.convert_amount(
185: ps.invoice_currency_code,

Line 190: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_5,

186: p_currency_code,
187: sysdate,
188: p_exchange_rate_type,
189: ps.amount_due_remaining)) bucket4 ,
190: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_5,
191: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_5,
192: v_bucket_days_to_5,ps.due_date,v_bucket_category,l_as_of_date)
193: * gl_currency_api.convert_amount(
194: ps.invoice_currency_code,

Line 199: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_6,

195: p_currency_code,
196: sysdate,
197: p_exchange_rate_type,
198: ps.amount_due_remaining)) bucket5 ,
199: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_6,
200: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_6,
201: v_bucket_days_to_6,ps.due_date,v_bucket_category,l_as_of_date)
202: * gl_currency_api.convert_amount(
203: ps.invoice_currency_code,

Line 268: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_0,

264: p_exchange_rate_type,
265: (ra.amount_applied +
266: NVL(ra.earned_discount_taken,0)
267: + NVL(ra.unearned_discount_taken,0) ))) adr,
268: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_0,
269: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_0,
270: v_bucket_days_to_0,ps.due_date,v_bucket_category,l_as_of_date)
271: * gl_currency_api.convert_amount(
272: ps.invoice_currency_code,

Line 279: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_1,

275: p_exchange_rate_type,
276: (ra.amount_applied +
277: NVL(ra.earned_discount_taken,0)
278: + NVL(ra.unearned_discount_taken,0) ))) bucket0 ,
279: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_1,
280: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_1,
281: v_bucket_days_to_1,ps.due_date,v_bucket_category,l_as_of_date)
282: * gl_currency_api.convert_amount(
283: ps.invoice_currency_code,

Line 290: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_2,

286: p_exchange_rate_type,
287: (ra.amount_applied +
288: NVL(ra.earned_discount_taken,0)
289: + NVL(ra.unearned_discount_taken,0) ))) bucket1 ,
290: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_2,
291: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_2,
292: v_bucket_days_to_2,ps.due_date,v_bucket_category,l_as_of_date)
293: * gl_currency_api.convert_amount(
294: ps.invoice_currency_code,

Line 301: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_3,

297: p_exchange_rate_type,
298: (ra.amount_applied +
299: NVL(ra.earned_discount_taken,0)
300: + NVL(ra.unearned_discount_taken,0) ))) bucket2 ,
301: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_3,
302: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_3,
303: v_bucket_days_to_3,ps.due_date,v_bucket_category,l_as_of_date)
304: * gl_currency_api.convert_amount(
305: ps.invoice_currency_code,

Line 312: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_4,

308: p_exchange_rate_type,
309: (ra.amount_applied +
310: NVL(ra.earned_discount_taken,0)
311: + NVL(ra.unearned_discount_taken,0) ))) bucket3 ,
312: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_4,
313: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_4,
314: v_bucket_days_to_4,ps.due_date,v_bucket_category,l_as_of_date)
315: * gl_currency_api.convert_amount(
316: ps.invoice_currency_code,

Line 323: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_5,

319: p_exchange_rate_type,
320: (ra.amount_applied +
321: NVL(ra.earned_discount_taken,0)
322: + NVL(ra.unearned_discount_taken,0) ))) bucket4 ,
323: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_5,
324: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_5,
325: v_bucket_days_to_5,ps.due_date,v_bucket_category,l_as_of_date)
326: * gl_currency_api.convert_amount(
327: ps.invoice_currency_code,

Line 334: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_6,

330: p_exchange_rate_type,
331: (ra.amount_applied +
332: NVL(ra.earned_discount_taken,0)
333: + NVL(ra.unearned_discount_taken,0) ))) bucket5 ,
334: sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_6,
335: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_6,
336: v_bucket_days_to_6,ps.due_date,v_bucket_category,l_as_of_date)
337: * gl_currency_api.convert_amount(
338: ps.invoice_currency_code,

Line 409: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_0,

405: p_currency_code,
406: sysdate,
407: p_exchange_rate_type,
408: adj.amount)) adr,
409: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_0,
410: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_0,
411: v_bucket_days_to_0,ps.due_date,v_bucket_category,l_as_of_date)
412: * gl_currency_api.convert_amount(
413: ps.invoice_currency_code,

Line 418: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_1,

414: p_currency_code,
415: sysdate,
416: p_exchange_rate_type,
417: adj.amount)) bucket0 ,
418: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_1,
419: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_1,
420: v_bucket_days_to_1,ps.due_date,v_bucket_category,l_as_of_date)
421: * gl_currency_api.convert_amount(
422: ps.invoice_currency_code,

Line 427: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_2,

423: p_currency_code,
424: sysdate,
425: p_exchange_rate_type,
426: adj.amount)) bucket1 ,
427: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_2,
428: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_2,
429: v_bucket_days_to_2,ps.due_date,v_bucket_category,l_as_of_date)
430: * gl_currency_api.convert_amount(
431: ps.invoice_currency_code,

Line 436: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_3,

432: p_currency_code,
433: sysdate,
434: p_exchange_rate_type,
435: adj.amount)) bucket2 ,
436: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_3,
437: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_3,
438: v_bucket_days_to_3,ps.due_date,v_bucket_category,l_as_of_date)
439: * gl_currency_api.convert_amount(
440: ps.invoice_currency_code,

Line 445: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_4,

441: p_currency_code,
442: sysdate,
443: p_exchange_rate_type,
444: adj.amount)) bucket3 ,
445: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_4,
446: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_4,
447: v_bucket_days_to_4,ps.due_date,v_bucket_category,l_as_of_date)
448: * gl_currency_api.convert_amount(
449: ps.invoice_currency_code,

Line 454: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_5,

450: p_currency_code,
451: sysdate,
452: p_exchange_rate_type,
453: adj.amount)) bucket4 ,
454: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_5,
455: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_5,
456: v_bucket_days_to_5,ps.due_date,v_bucket_category,l_as_of_date)
457: * gl_currency_api.convert_amount(
458: ps.invoice_currency_code,

Line 463: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_6,

459: p_currency_code,
460: sysdate,
461: p_exchange_rate_type,
462: adj.amount)) bucket5 ,
463: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_6,
464: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_6,
465: v_bucket_days_to_6,ps.due_date,v_bucket_category,l_as_of_date)
466: * gl_currency_api.convert_amount(
467: ps.invoice_currency_code,

Line 534: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_0,

530: p_exchange_rate_type,
531: (ra.amount_applied_from +
532: NVL(ra.earned_discount_taken,0)
533: + NVL(ra.unearned_discount_taken,0) ))) adr,
534: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_0,
535: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_0,
536: v_bucket_days_to_0,ps.due_date,v_bucket_category,l_as_of_date)
537: * gl_currency_api.convert_amount(
538: ps.invoice_currency_code,

Line 545: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_1,

541: p_exchange_rate_type,
542: (ra.amount_applied_from +
543: NVL(ra.earned_discount_taken,0)
544: + NVL(ra.unearned_discount_taken,0) ))) bucket0 ,
545: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_1,
546: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_1,
547: v_bucket_days_to_1,ps.due_date,v_bucket_category,l_as_of_date)
548: * gl_currency_api.convert_amount(
549: ps.invoice_currency_code,

Line 556: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_2,

552: p_exchange_rate_type,
553: (ra.amount_applied_from +
554: NVL(ra.earned_discount_taken,0)
555: + NVL(ra.unearned_discount_taken,0) ))) bucket1 ,
556: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_2,
557: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_2,
558: v_bucket_days_to_2,ps.due_date,v_bucket_category,l_as_of_date)
559: * gl_currency_api.convert_amount(
560: ps.invoice_currency_code,

Line 567: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_3,

563: p_exchange_rate_type,
564: (ra.amount_applied_from +
565: NVL(ra.earned_discount_taken,0)
566: + NVL(ra.unearned_discount_taken,0) ))) bucket2 ,
567: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_3,
568: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_3,
569: v_bucket_days_to_3,ps.due_date,v_bucket_category,l_as_of_date)
570: * gl_currency_api.convert_amount(
571: ps.invoice_currency_code,

Line 578: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_4,

574: p_exchange_rate_type,
575: (ra.amount_applied_from +
576: NVL(ra.earned_discount_taken,0)
577: + NVL(ra.unearned_discount_taken,0) ))) bucket3 ,
578: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_4,
579: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_4,
580: v_bucket_days_to_4,ps.due_date,v_bucket_category,l_as_of_date)
581: * gl_currency_api.convert_amount(
582: ps.invoice_currency_code,

Line 589: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_5,

585: p_exchange_rate_type,
586: (ra.amount_applied_from +
587: NVL(ra.earned_discount_taken,0)
588: + NVL(ra.unearned_discount_taken,0) ))) bucket4 ,
589: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_5,
590: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_5,
591: v_bucket_days_to_5,ps.due_date,v_bucket_category,l_as_of_date)
592: * gl_currency_api.convert_amount(
593: ps.invoice_currency_code,

Line 600: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_6,

596: p_exchange_rate_type,
597: (ra.amount_applied_from +
598: NVL(ra.earned_discount_taken,0)
599: + NVL(ra.unearned_discount_taken,0) ))) bucket5 ,
600: -sum(arpt_sql_func_util.bucket_function(v_bucket_line_type_6,
601: ps.amount_in_dispute,ps.amount_adjusted_pending,v_bucket_days_from_6,
602: v_bucket_days_to_6,ps.due_date,v_bucket_category,l_as_of_date)
603: * gl_currency_api.convert_amount(
604: ps.invoice_currency_code,