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.ARP_ARXVASUM2 dependencies on ARPCURR

Line 123: 'INV' , arpcurr.functional_amount( ps.amount_due_original,

119: NULL , NULL ,
120: nvl(sum(decode(ps.class, 'BR' , ps.amount_due_remaining, 0)),0)
121: ),
122: nvl(sum(decode(ps.class,
123: 'INV' , arpcurr.functional_amount( ps.amount_due_original,
124: p_func_curr,
125: nvl(p_exc_rate,ps.exchange_rate),
126: p_precision,
127: p_min_acc_unit

Line 132: 'DM' , arpcurr.functional_amount( ps.amount_due_original,

128: ),
129: 0)
130: ), 0),
131: nvl(sum(decode(ps.class,
132: 'DM' , arpcurr.functional_amount( ps.amount_due_original,
133: p_func_curr,
134: nvl(p_exc_rate,ps.exchange_rate),
135: p_precision,
136: p_min_acc_unit

Line 141: 'CB' , arpcurr.functional_amount( ps.amount_due_original,

137: ),
138: 0)
139: ), 0),
140: nvl(sum(decode(ps.class,
141: 'CB' , arpcurr.functional_amount( ps.amount_due_original,
142: p_func_curr,
143: nvl(p_exc_rate, ps.exchange_rate),
144: p_precision,
145: p_min_acc_unit ), 0)), 0),

Line 147: 'DEP' , arpcurr.functional_amount( ps.amount_due_original,

143: nvl(p_exc_rate, ps.exchange_rate),
144: p_precision,
145: p_min_acc_unit ), 0)), 0),
146: nvl(sum(decode(ps.class,
147: 'DEP' , arpcurr.functional_amount( ps.amount_due_original,
148: p_func_curr,
149: nvl(p_exc_rate, ps.exchange_rate),
150: p_precision,
151: p_min_acc_unit ), 0)), 0),

Line 153: 'GUAR' , arpcurr.functional_amount( ps.amount_due_original,

149: nvl(p_exc_rate, ps.exchange_rate),
150: p_precision,
151: p_min_acc_unit ), 0)), 0),
152: nvl(sum(decode(ps.class,
153: 'GUAR' , arpcurr.functional_amount( ps.amount_due_original,
154: p_func_curr,
155: nvl(p_exc_rate, ps.exchange_rate),
156: p_precision,
157: p_min_acc_unit ), 0)), 0),

Line 159: 'CM' , arpcurr.functional_amount( ps.amount_due_original,

155: nvl(p_exc_rate, ps.exchange_rate),
156: p_precision,
157: p_min_acc_unit ), 0)), 0),
158: nvl(sum(decode(ps.class,
159: 'CM' , arpcurr.functional_amount( ps.amount_due_original,
160: p_func_curr,
161: nvl(p_exc_rate, ps.exchange_rate),
162: p_precision,
163: p_min_acc_unit ), 0)), 0),

Line 166: 'BR' , arpcurr.functional_amount( ps.amount_due_original,

162: p_precision,
163: p_min_acc_unit ), 0)), 0),
164: /* 18-MAY-2000 J Rautiainen BR Implementation */
165: nvl(sum(decode(ps.class,
166: 'BR' , arpcurr.functional_amount( ps.amount_due_original,
167: p_func_curr,
168: nvl(p_exc_rate, ps.exchange_rate),
169: p_precision,
170: p_min_acc_unit ), 0)), 0),

Line 174: arpcurr.functional_amount( ps.amount_due_remaining,

170: p_min_acc_unit ), 0)), 0),
171: nvl(sum(decode(ps.class,
172: 'INV' , decode(p_exc_rate,
173: NULL, ps.acctd_amount_due_remaining,
174: arpcurr.functional_amount( ps.amount_due_remaining,
175: p_func_curr,
176: p_exc_rate,
177: p_precision,
178: p_min_acc_unit )) ,0)), 0),

Line 182: arpcurr.functional_amount( ps.amount_due_remaining,

178: p_min_acc_unit )) ,0)), 0),
179: nvl(sum(decode(ps.class,
180: 'DM' , decode(p_exc_rate,
181: NULL, ps.acctd_amount_due_remaining,
182: arpcurr.functional_amount( ps.amount_due_remaining,
183: p_func_curr,
184: p_exc_rate,
185: p_precision,
186: p_min_acc_unit ) ), 0)), 0),

Line 190: arpcurr.functional_amount( ps.amount_due_remaining,

186: p_min_acc_unit ) ), 0)), 0),
187: nvl(sum(decode(ps.class,
188: 'CB' , decode(p_exc_rate,
189: NULL, ps.acctd_amount_due_remaining,
190: arpcurr.functional_amount( ps.amount_due_remaining,
191: p_func_curr,
192: p_exc_rate,
193: p_precision,
194: p_min_acc_unit )), 0)), 0),

Line 198: arpcurr.functional_amount( ps.amount_due_remaining,

194: p_min_acc_unit )), 0)), 0),
195: nvl(sum(decode(ps.class,
196: 'DEP' , decode(p_exc_rate,
197: NULL, ps.acctd_amount_due_remaining,
198: arpcurr.functional_amount( ps.amount_due_remaining,
199: p_func_curr,
200: p_exc_rate,
201: p_precision,
202: p_min_acc_unit )), 0)), 0),

Line 206: arpcurr.functional_amount( ps.amount_due_remaining,

202: p_min_acc_unit )), 0)), 0),
203: nvl(sum(decode(ps.class,
204: 'GUAR' , decode(p_exc_rate,
205: NULL, ps.acctd_amount_due_remaining,
206: arpcurr.functional_amount( ps.amount_due_remaining,
207: p_func_curr,
208: p_exc_rate,
209: p_precision,
210: p_min_acc_unit )), 0)), 0),

Line 214: arpcurr.functional_amount( ps.amount_due_remaining,

210: p_min_acc_unit )), 0)), 0),
211: nvl(sum(decode(ps.class,
212: 'CM' , decode(p_exc_rate,
213: NULL, ps.acctd_amount_due_remaining,
214: arpcurr.functional_amount( ps.amount_due_remaining,
215: p_func_curr,
216: p_exc_rate,
217: p_precision,
218: p_min_acc_unit )), 0)), 0),

Line 223: arpcurr.functional_amount( ps.amount_due_remaining,

219: /* 18-MAY-2000 J Rautiainen BR Implementation */
220: nvl(sum(decode(ps.class,
221: 'BR' , decode(p_exc_rate,
222: NULL, ps.acctd_amount_due_remaining,
223: arpcurr.functional_amount( ps.amount_due_remaining,
224: p_func_curr,
225: p_exc_rate,
226: p_precision,
227: p_min_acc_unit )), 0)), 0),

Line 307: 'PMT', arpcurr.functional_amount( ps.amount_due_original,

303: NULL , NULL ,
304: nvl(sum(decode(ps.class, 'PMT' , ps.amount_due_remaining, 0)),0)
305: ), /* Sum of Amount Due Remaining */
306: nvl(sum(decode(ps.class,
307: 'PMT', arpcurr.functional_amount( ps.amount_due_original,
308: p_func_curr,
309: nvl(p_exc_rate, ps.exchange_rate),
310: p_precision,
311: p_min_acc_unit

Line 317: arpcurr.functional_amount( ps.amount_due_remaining,

313: 0)), 0), /* Sum of Functional Original Amount */
314: nvl(sum(decode(ps.class,
315: 'PMT', decode(p_exc_rate,
316: NULL, ps.acctd_amount_due_remaining,
317: arpcurr.functional_amount( ps.amount_due_remaining,
318: p_func_curr,
319: p_exc_rate,
320: p_precision,
321: p_min_acc_unit

Line 379: 'PMT', arpcurr.functional_amount( ps.amount_due_original,

375: NULL , NULL ,
376: nvl(sum(decode(ps.class, 'PMT' , ps.amount_due_remaining, 0)),0)
377: ), /* Sum of Amount Due Remaining */
378: nvl(sum(decode(ps.class,
379: 'PMT', arpcurr.functional_amount( ps.amount_due_original,
380: p_func_curr,
381: nvl(p_exc_rate, ps.exchange_rate),
382: p_precision,
383: p_min_acc_unit

Line 389: arpcurr.functional_amount( ps.amount_due_remaining,

385: 0)), 0), /* Sum of Functional Original Amount */
386: nvl(sum(decode(ps.class,
387: 'PMT', decode(p_exc_rate,
388: NULL, ps.acctd_amount_due_remaining,
389: arpcurr.functional_amount( ps.amount_due_remaining,
390: p_func_curr,
391: p_exc_rate,
392: p_precision,
393: p_min_acc_unit

Line 468: arpcurr.functional_amount(ra.amount_applied,

464: NULL , NULL ,
465: nvl(sum(decode(sign(ra.apply_date - ps.due_date),1, 0,ra.amount_applied)),0)),
466: nvl(sum(decode(sign(ra.apply_date - ps.due_date),1, decode(p_exc_rate,
467: NULL, ra.acctd_amount_applied_from,
468: arpcurr.functional_amount(ra.amount_applied,
469: p_func_curr,
470: p_exc_rate,
471: p_precision,
472: p_min_acc_unit

Line 477: arpcurr.functional_amount(ra.amount_applied,

473: )),0
474: )),0),
475: nvl(sum(decode(sign(ra.apply_date - ps.due_date),1, 0, decode(p_exc_rate,
476: NULL, ra.acctd_amount_applied_from,
477: arpcurr.functional_amount(ra.amount_applied,
478: p_func_curr,
479: p_exc_rate,
480: p_precision,
481: p_min_acc_unit

Line 528: nvl(sum(arpcurr.functional_amount( cr.amount,

524: SELECT decode(p_currency_code,
525: NULL , NULL ,
526: nvl(sum(cr.amount),0)
527: ),
528: nvl(sum(arpcurr.functional_amount( cr.amount,
529: p_func_curr,
530: nvl(p_exc_rate,ps.exchange_rate),
531: p_precision,
532: p_min_acc_unit

Line 577: arpcurr.functional_amount(a.amount,

573: NULL , NULL , nvl(sum(a.amount),0)
574: ),
575: nvl(sum( decode(p_exc_rate,
576: NULL, a.acctd_amount,
577: arpcurr.functional_amount(a.amount,
578: p_func_curr,
579: p_exc_rate,
580: p_precision,
581: p_min_acc_unit

Line 630: arpcurr.functional_amount(a.amount,

626: NULL , NULL , nvl(sum(a.amount),0)
627: ),
628: nvl(sum( decode(p_exc_rate,
629: NULL, a.acctd_amount,
630: arpcurr.functional_amount(a.amount,
631: p_func_curr,
632: p_exc_rate,
633: p_precision,
634: p_min_acc_unit

Line 690: arpcurr.functional_amount( nvl(ra.earned_discount_taken,0),

686: nvl(sum(ra.unearned_discount_taken),0)
687: ),
688: nvl(sum( decode(p_exc_rate,
689: NULL, ra.acctd_earned_discount_taken,
690: arpcurr.functional_amount( nvl(ra.earned_discount_taken,0),
691: p_func_curr,
692: p_exc_rate, p_precision,
693: p_min_acc_unit
694: )

Line 699: arpcurr.functional_amount( nvl(ra.unearned_discount_taken,0),

695: )
696: ),0),
697: nvl(sum( decode(p_exc_rate,
698: NULL, ra.acctd_unearned_discount_taken,
699: arpcurr.functional_amount( nvl(ra.unearned_discount_taken,0),
700: p_func_curr,
701: p_exc_rate,
702: p_precision,
703: p_min_acc_unit

Line 759: nvl(sum(arpcurr.functional_amount( cr.amount,

755: select decode(p_currency_code,
756: NULL , NULL ,
757: nvl(sum(cr.amount),0)
758: ),
759: nvl(sum(arpcurr.functional_amount( cr.amount,
760: p_func_curr,
761: nvl(p_exc_rate,ps.exchange_rate),
762: p_precision,
763: p_min_acc_unit

Line 848: 'PMT', arpcurr.functional_amount( ps.amount_due_original,

844: NULL , NULL ,
845: nvl(sum(decode(ps.class, 'PMT' , ps.amount_due_remaining, 0)),0)
846: ), /* Sum of Amount Due Remaining */
847: nvl(sum(decode(ps.class,
848: 'PMT', arpcurr.functional_amount( ps.amount_due_original,
849: p_func_curr,
850: nvl(p_exc_rate, ps.exchange_rate),
851: p_precision,
852: p_min_acc_unit

Line 858: arpcurr.functional_amount( ps.amount_due_remaining,

854: 0)), 0), /* Sum of Functional Original Amount */
855: nvl(sum(decode(ps.class,
856: 'PMT', decode(p_exc_rate,
857: NULL, ps.acctd_amount_due_remaining,
858: arpcurr.functional_amount( ps.amount_due_remaining,
859: p_func_curr,
860: p_exc_rate,
861: p_precision,
862: p_min_acc_unit

Line 992: 'PMT', arpcurr.functional_amount( ps.amount_due_original,

988: NULL , NULL ,
989: nvl(sum(decode(ps.class, 'PMT' , ps.amount_due_remaining, 0)),0)
990: ), /* Sum of Amount Due Remaining */
991: nvl(sum(decode(ps.class,
992: 'PMT', arpcurr.functional_amount( ps.amount_due_original,
993: p_func_curr,
994: nvl(p_exc_rate, ps.exchange_rate),
995: p_precision,
996: p_min_acc_unit

Line 1002: arpcurr.functional_amount( ps.amount_due_remaining,

998: 0)), 0), /* Sum of Functional Original Amount */
999: nvl(sum(decode(ps.class,
1000: 'PMT', decode(p_exc_rate,
1001: NULL, ps.acctd_amount_due_remaining,
1002: arpcurr.functional_amount( ps.amount_due_remaining,
1003: p_func_curr,
1004: p_exc_rate,
1005: p_precision,
1006: p_min_acc_unit

Line 1093: arpcurr.functional_amount(ps.amount_due_remaining,

1089: NULL , NULL , nvl(sum(ps.amount_due_remaining),0)
1090: ),
1091: nvl(sum( decode(p_exc_rate,
1092: NULL, ps.acctd_amount_due_remaining,
1093: arpcurr.functional_amount(ps.amount_due_remaining,
1094: p_func_curr,
1095: p_exc_rate,
1096: p_precision,
1097: p_min_acc_unit

Line 1151: arpcurr.functional_amount(ps.amount_due_remaining,

1147: NULL , NULL , nvl(sum(ps.amount_due_remaining),0)
1148: ),
1149: nvl(sum( decode(p_exc_rate,
1150: NULL, ps.acctd_amount_due_remaining,
1151: arpcurr.functional_amount(ps.amount_due_remaining,
1152: p_func_curr,
1153: p_exc_rate,
1154: p_precision,
1155: p_min_acc_unit

Line 1208: arpcurr.functional_amount(ctl.extended_amount,

1204: NULL , NULL , nvl(sum(ctl.extended_amount),0)
1205: ),
1206: nvl(sum( decode(p_exc_rate,
1207: NULL, ctl.extended_acctd_amount,
1208: arpcurr.functional_amount(ctl.extended_amount,
1209: p_func_curr,
1210: p_exc_rate,
1211: p_precision,
1212: p_min_acc_unit