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.AR_CMGT_DATA_POINTS_PKG dependencies on OZF_CLAIMS_ALL

Line 263: FROM ozf_claims_all

259: p_limit_currency, sysdate,
260: p_exchange_rate_type,
261: sum(amount_settled)),2) amount_settled,
262: count(*) ded_count
263: FROM ozf_claims_all
264: WHERE status_code = 'CLOSED'
265: AND claim_class = 'DEDUCTION'
266: AND settled_date >= ADD_MONTHS(sysdate,(-p_period))
267: AND cust_account_id IN (

Line 321: FROM ozf_claims_all

317: p_limit_currency, sysdate,
318: p_exchange_rate_type,
319: sum(amount_settled)),2) amount_settled,
320: count(*) ded_count
321: FROM ozf_claims_all
322: WHERE status_code = 'CLOSED'
323: AND claim_class = 'DEDUCTION'
324: AND cust_account_id = p_cust_account_id
325: AND org_id = decode(p_global_exposure_flag,'Y', org_id, 'N',

Line 356: FROM ozf_claims_all

352: p_limit_currency, sysdate,
353: p_exchange_rate_type,
354: sum(amount_settled)),2) amount_settled,
355: count(*) ded_count
356: FROM ozf_claims_all
357: WHERE status_code = 'CLOSED'
358: AND claim_class = 'DEDUCTION'
359: AND settled_date >= ADD_MONTHS(sysdate,(-p_period))
360: AND cust_account_id = p_cust_account_id