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 204: FROM ozf_claims_all

200: p_limit_currency, sysdate,
201: p_exchange_rate_type,
202: sum(amount_settled)),2) amount_settled,
203: count(*) ded_count
204: FROM ozf_claims_all
205: WHERE status_code = 'CLOSED'
206: AND claim_class = 'DEDUCTION'
207: AND settled_date >= ADD_MONTHS(sysdate,(-p_period))
208: AND cust_account_id IN (

Line 262: FROM ozf_claims_all

258: p_limit_currency, sysdate,
259: p_exchange_rate_type,
260: sum(amount_settled)),2) amount_settled,
261: count(*) ded_count
262: FROM ozf_claims_all
263: WHERE status_code = 'CLOSED'
264: AND claim_class = 'DEDUCTION'
265: AND cust_account_id = p_cust_account_id
266: AND org_id = decode(p_global_exposure_flag,'Y', org_id, 'N',

Line 297: FROM ozf_claims_all

293: p_limit_currency, sysdate,
294: p_exchange_rate_type,
295: sum(amount_settled)),2) amount_settled,
296: count(*) ded_count
297: FROM ozf_claims_all
298: WHERE status_code = 'CLOSED'
299: AND claim_class = 'DEDUCTION'
300: AND settled_date >= ADD_MONTHS(sysdate,(-p_period))
301: AND cust_account_id = p_cust_account_id