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_AUTOAPPLY_API dependencies on ARPCURR

Line 1194: ARPCURR.CURRROUND(ps.amount_due_remaining, ps.invoice_currency_code ) amount_applied,

1190: ps.amount_due_original amount_due_original,
1191: ps.amount_due_remaining amount_due_remaining,
1192: ps.discount_taken_earned discount_taken_earned,
1193: ps.discount_taken_unearned discount_taken_unearned,
1194: ARPCURR.CURRROUND(ps.amount_due_remaining, ps.invoice_currency_code ) amount_applied,
1195: ROUND(NVL(ref.trans_to_receipt_rate,
1196: DECODE(ps.invoice_currency_code, cr.currency_code, NULL,
1197: NVL( ARP_AUTOAPPLY_API.get_cross_curr_rate(
1198: ref.amount_applied,

Line 1441: ARPCURR.CURRROUND(ps.amount_due_remaining, ps.invoice_currency_code ) amount_applied,

1437: ps.amount_due_original amount_due_original,
1438: ps.amount_due_remaining amount_due_remaining,
1439: ps.discount_taken_earned discount_taken_earned,
1440: ps.discount_taken_unearned discount_taken_unearned,
1441: ARPCURR.CURRROUND(ps.amount_due_remaining, ps.invoice_currency_code ) amount_applied,
1442: ROUND(NVL(ref.trans_to_receipt_rate,
1443: DECODE(ps.invoice_currency_code, cr.currency_code, NULL,
1444: NVL( ARP_AUTOAPPLY_API.get_cross_curr_rate(
1445: ref.amount_applied,

Line 1682: ARPCURR.CURRROUND(ps.amount_due_remaining, ps.invoice_currency_code ) amount_applied,

1678: ps.amount_due_original amount_due_original,
1679: ps.amount_due_remaining amount_due_remaining,
1680: ps.discount_taken_earned discount_taken_earned,
1681: ps.discount_taken_unearned discount_taken_unearned,
1682: ARPCURR.CURRROUND(ps.amount_due_remaining, ps.invoice_currency_code ) amount_applied,
1683: ROUND(NVL(ref.trans_to_receipt_rate,
1684: DECODE(ps.invoice_currency_code, cr.currency_code, NULL,
1685: NVL( ARP_AUTOAPPLY_API.get_cross_curr_rate(
1686: ref.amount_applied,

Line 1926: ARPCURR.CURRROUND(ps.amount_due_remaining, ps.invoice_currency_code ) amount_applied,

1922: ps.amount_due_original amount_due_original,
1923: ps.amount_due_remaining amount_due_remaining,
1924: ps.discount_taken_earned discount_taken_earned,
1925: ps.discount_taken_unearned discount_taken_unearned,
1926: ARPCURR.CURRROUND(ps.amount_due_remaining, ps.invoice_currency_code ) amount_applied,
1927: ROUND(NVL(ref.trans_to_receipt_rate,
1928: DECODE(ps.invoice_currency_code, cr.currency_code, NULL,
1929: NVL( ARP_AUTOAPPLY_API.get_cross_curr_rate(
1930: ref.amount_applied,

Line 2173: ARPCURR.CURRROUND(ps.amount_due_remaining, ps.invoice_currency_code ) amount_applied,

2169: ps.amount_due_original amount_due_original,
2170: ps.amount_due_remaining amount_due_remaining,
2171: ps.discount_taken_earned discount_taken_earned,
2172: ps.discount_taken_unearned discount_taken_unearned,
2173: ARPCURR.CURRROUND(ps.amount_due_remaining, ps.invoice_currency_code ) amount_applied,
2174: ROUND(NVL(ref.trans_to_receipt_rate,
2175: DECODE(ps.invoice_currency_code, cr.currency_code, NULL,
2176: NVL( ARP_AUTOAPPLY_API.get_cross_curr_rate(
2177: ref.amount_applied,

Line 2434: ARPCURR.CURRROUND(ps.amount_due_remaining, ps.invoice_currency_code ) amount_applied,

2430: ps.amount_due_original amount_due_original,
2431: ps.amount_due_remaining amount_due_remaining,
2432: ps.discount_taken_earned discount_taken_earned,
2433: ps.discount_taken_unearned discount_taken_unearned,
2434: ARPCURR.CURRROUND(ps.amount_due_remaining, ps.invoice_currency_code ) amount_applied,
2435: ROUND(NVL(ref.trans_to_receipt_rate,
2436: DECODE(ps.invoice_currency_code, cr.currency_code, NULL,
2437: NVL( ARP_AUTOAPPLY_API.get_cross_curr_rate(
2438: ref.amount_applied,

Line 2656: ARPCURR.CURRROUND(ps.amount_due_remaining, ps.invoice_currency_code ) amount_applied,

2652: ps.amount_due_original amount_due_original,
2653: ps.amount_due_remaining amount_due_remaining,
2654: ps.discount_taken_earned discount_taken_earned,
2655: ps.discount_taken_unearned discount_taken_unearned,
2656: ARPCURR.CURRROUND(ps.amount_due_remaining, ps.invoice_currency_code ) amount_applied,
2657: ROUND(NVL(ref.trans_to_receipt_rate,
2658: DECODE(ps.invoice_currency_code, cr.currency_code, NULL,
2659: NVL( ARP_AUTOAPPLY_API.get_cross_curr_rate(
2660: ref.amount_applied,

Line 2901: ARPCURR.CURRROUND(ps.amount_due_remaining, ps.invoice_currency_code ) amount_applied,

2897: ps.amount_due_original amount_due_original,
2898: ps.amount_due_remaining amount_due_remaining,
2899: ps.discount_taken_earned discount_taken_earned,
2900: ps.discount_taken_unearned discount_taken_unearned,
2901: ARPCURR.CURRROUND(ps.amount_due_remaining, ps.invoice_currency_code ) amount_applied,
2902: ROUND(NVL(ref.trans_to_receipt_rate,
2903: DECODE(ps.invoice_currency_code, cr.currency_code, NULL,
2904: NVL( ARP_AUTOAPPLY_API.get_cross_curr_rate(
2905: ref.amount_applied,

Line 3170: GROUP BY ref.remit_reference_id, NVL(ref.amount_applied, ARPCURR.CURRROUND((ref.amount_applied_from / NVL(lin.trans_to_receipt_rate, 1)), lin.receipt_currency_code))

3166: AND am.automatch_id = rec.automatch_id
3167: AND am.use_matching_amount = 'ALWAYS'
3168: AND rec.recommendation_id = lin.recommendation_id
3169: AND ref.remit_reference_id = rec.remit_reference_id
3170: GROUP BY ref.remit_reference_id, NVL(ref.amount_applied, ARPCURR.CURRROUND((ref.amount_applied_from / NVL(lin.trans_to_receipt_rate, 1)), lin.receipt_currency_code))
3171: HAVING SUM(lin.amount_applied) <> NVL(ref.amount_applied, ARPCURR.CURRROUND((ref.amount_applied_from / NVL(lin.trans_to_receipt_rate, 1)), lin.receipt_currency_code))
3172: );
3173:
3174: IF (PG_DEBUG IN ('Y', 'C')) THEN

Line 3171: HAVING SUM(lin.amount_applied) <> NVL(ref.amount_applied, ARPCURR.CURRROUND((ref.amount_applied_from / NVL(lin.trans_to_receipt_rate, 1)), lin.receipt_currency_code))

3167: AND am.use_matching_amount = 'ALWAYS'
3168: AND rec.recommendation_id = lin.recommendation_id
3169: AND ref.remit_reference_id = rec.remit_reference_id
3170: GROUP BY ref.remit_reference_id, NVL(ref.amount_applied, ARPCURR.CURRROUND((ref.amount_applied_from / NVL(lin.trans_to_receipt_rate, 1)), lin.receipt_currency_code))
3171: HAVING SUM(lin.amount_applied) <> NVL(ref.amount_applied, ARPCURR.CURRROUND((ref.amount_applied_from / NVL(lin.trans_to_receipt_rate, 1)), lin.receipt_currency_code))
3172: );
3173:
3174: IF (PG_DEBUG IN ('Y', 'C')) THEN
3175: log('No. of recos updated to Amount Mismatch: ' || SQL%ROWCOUNT );

Line 3361: GROUP BY ref.remit_reference_id, NVL(ref.amount_applied, ARPCURR.CURRROUND((ref.amount_applied_from / NVL(lin.trans_to_receipt_rate, 1)), lin.receipt_currency_code))

3357: AND am.automatch_id = rec.automatch_id
3358: AND am.use_matching_amount = 'DUPLICATE'
3359: AND rec.recommendation_id = lin.recommendation_id
3360: AND ref.remit_reference_id = rec1.remit_reference_id
3361: GROUP BY ref.remit_reference_id, NVL(ref.amount_applied, ARPCURR.CURRROUND((ref.amount_applied_from / NVL(lin.trans_to_receipt_rate, 1)), lin.receipt_currency_code))
3362: HAVING SUM(lin.amount_applied) = NVL(ref.amount_applied, ARPCURR.CURRROUND((ref.amount_applied_from / NVL(lin.trans_to_receipt_rate, 1)), lin.receipt_currency_code))
3363: )
3364: GROUP BY resolved_matching_number, match_resolved_using, remit_reference_id, resolved_matching_date
3365: HAVING count(*) = 1

Line 3362: HAVING SUM(lin.amount_applied) = NVL(ref.amount_applied, ARPCURR.CURRROUND((ref.amount_applied_from / NVL(lin.trans_to_receipt_rate, 1)), lin.receipt_currency_code))

3358: AND am.use_matching_amount = 'DUPLICATE'
3359: AND rec.recommendation_id = lin.recommendation_id
3360: AND ref.remit_reference_id = rec1.remit_reference_id
3361: GROUP BY ref.remit_reference_id, NVL(ref.amount_applied, ARPCURR.CURRROUND((ref.amount_applied_from / NVL(lin.trans_to_receipt_rate, 1)), lin.receipt_currency_code))
3362: HAVING SUM(lin.amount_applied) = NVL(ref.amount_applied, ARPCURR.CURRROUND((ref.amount_applied_from / NVL(lin.trans_to_receipt_rate, 1)), lin.receipt_currency_code))
3363: )
3364: GROUP BY resolved_matching_number, match_resolved_using, remit_reference_id, resolved_matching_date
3365: HAVING count(*) = 1
3366: )

Line 3780: NVL(ref.amount_applied, ARPCURR.CURRROUND((ref.amount_applied_from / NVL(lin.trans_to_receipt_rate, 1)), lin.receipt_currency_code)) ref_amount_applied,

3776:
3777: CURSOR app_reco_line_cur(p_remit_reference_id NUMBER) IS
3778: SELECT ref.cash_receipt_id,
3779: rec.remit_reference_id,
3780: NVL(ref.amount_applied, ARPCURR.CURRROUND((ref.amount_applied_from / NVL(lin.trans_to_receipt_rate, 1)), lin.receipt_currency_code)) ref_amount_applied,
3781: lin.amount_applied,
3782: lin.payment_schedule_id,
3783: lin.amount_applied_from,
3784: lin.trans_to_receipt_rate,