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_ARXVASUM 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 308: 'PMT', arpcurr.functional_amount( ps.amount_due_original,

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

Line 318: arpcurr.functional_amount( ps.amount_due_remaining,

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

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

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

Line 391: arpcurr.functional_amount( ps.amount_due_remaining,

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

Line 471: arpcurr.functional_amount(ra.amount_applied,

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

Line 480: arpcurr.functional_amount(ra.amount_applied,

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

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

528: SELECT decode(p_currency_code,
529: NULL , NULL ,
530: nvl(sum(cr.amount),0)
531: ),
532: nvl(sum(arpcurr.functional_amount( cr.amount,
533: p_func_curr,
534: nvl(p_exc_rate,ps.exchange_rate),
535: p_precision,
536: p_min_acc_unit

Line 582: arpcurr.functional_amount(a.amount,

578: NULL , NULL , nvl(sum(a.amount),0)
579: ),
580: nvl(sum( decode(p_exc_rate,
581: NULL, a.acctd_amount,
582: arpcurr.functional_amount(a.amount,
583: p_func_curr,
584: p_exc_rate,
585: p_precision,
586: p_min_acc_unit

Line 636: arpcurr.functional_amount(a.amount,

632: NULL , NULL , nvl(sum(a.amount),0)
633: ),
634: nvl(sum( decode(p_exc_rate,
635: NULL, a.acctd_amount,
636: arpcurr.functional_amount(a.amount,
637: p_func_curr,
638: p_exc_rate,
639: p_precision,
640: p_min_acc_unit

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

693: nvl(sum(ra.unearned_discount_taken),0)
694: ),
695: nvl(sum( decode(p_exc_rate,
696: NULL, ra.acctd_earned_discount_taken,
697: arpcurr.functional_amount( nvl(ra.earned_discount_taken,0),
698: p_func_curr,
699: p_exc_rate, p_precision,
700: p_min_acc_unit
701: )

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

702: )
703: ),0),
704: nvl(sum( decode(p_exc_rate,
705: NULL, ra.acctd_unearned_discount_taken,
706: arpcurr.functional_amount( nvl(ra.unearned_discount_taken,0),
707: p_func_curr,
708: p_exc_rate,
709: p_precision,
710: p_min_acc_unit

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

763: select decode(p_currency_code,
764: NULL , NULL ,
765: nvl(sum(cr.amount),0)
766: ),
767: nvl(sum(arpcurr.functional_amount( cr.amount,
768: p_func_curr,
769: nvl(p_exc_rate,ps.exchange_rate),
770: p_precision,
771: p_min_acc_unit

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

853: NULL , NULL ,
854: nvl(sum(decode(ps.class, 'PMT' , ps.amount_due_remaining, 0)),0)
855: ), /* Sum of Amount Due Remaining */
856: nvl(sum(decode(ps.class,
857: 'PMT', arpcurr.functional_amount( ps.amount_due_original,
858: p_func_curr,
859: nvl(p_exc_rate, ps.exchange_rate),
860: p_precision,
861: p_min_acc_unit

Line 867: arpcurr.functional_amount( ps.amount_due_remaining,

863: 0)), 0), /* Sum of Functional Original Amount */
864: nvl(sum(decode(ps.class,
865: 'PMT', decode(p_exc_rate,
866: NULL, ps.acctd_amount_due_remaining,
867: arpcurr.functional_amount( ps.amount_due_remaining,
868: p_func_curr,
869: p_exc_rate,
870: p_precision,
871: p_min_acc_unit

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

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

Line 1012: arpcurr.functional_amount( ps.amount_due_remaining,

1008: 0)), 0), /* Sum of Functional Original Amount */
1009: nvl(sum(decode(ps.class,
1010: 'PMT', decode(p_exc_rate,
1011: NULL, ps.acctd_amount_due_remaining,
1012: arpcurr.functional_amount( ps.amount_due_remaining,
1013: p_func_curr,
1014: p_exc_rate,
1015: p_precision,
1016: p_min_acc_unit

Line 1104: arpcurr.functional_amount(ps.amount_due_remaining,

1100: NULL , NULL , nvl(sum(ps.amount_due_remaining),0)
1101: ),
1102: nvl(sum( decode(p_exc_rate,
1103: NULL, ps.acctd_amount_due_remaining,
1104: arpcurr.functional_amount(ps.amount_due_remaining,
1105: p_func_curr,
1106: p_exc_rate,
1107: p_precision,
1108: p_min_acc_unit

Line 1163: arpcurr.functional_amount(ps.amount_due_remaining,

1159: NULL , NULL , nvl(sum(ps.amount_due_remaining),0)
1160: ),
1161: nvl(sum( decode(p_exc_rate,
1162: NULL, ps.acctd_amount_due_remaining,
1163: arpcurr.functional_amount(ps.amount_due_remaining,
1164: p_func_curr,
1165: p_exc_rate,
1166: p_precision,
1167: p_min_acc_unit

Line 1221: arpcurr.functional_amount(ctl.extended_amount,

1217: NULL , NULL , nvl(sum(ctl.extended_amount),0)
1218: ),
1219: nvl(sum( decode(p_exc_rate,
1220: NULL, ctl.extended_acctd_amount,
1221: arpcurr.functional_amount(ctl.extended_amount,
1222: p_func_curr,
1223: p_exc_rate,
1224: p_precision,
1225: p_min_acc_unit