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.OZF_CLAIM_AGING_PVT dependencies on OZF_CLAIMS

Line 191: FROM ozf_claims c

187: , b.aging_bucket_line_id aging_bucket_line_id
188: , b.bucket_sequence_num bucket_sequence_num
189: , c.org_id
190: , SUM(c.acctd_amount) amount
191: FROM ozf_claims c
192: , ozf_aging_bucket_dates b
193: WHERE TRUNC(c.claim_date, 'DD') = TRUNC(b.bucket_date, 'DD')
194: AND b.condition_type = 'EQ'
195: AND b.bucket_type = 'CURRENT'

Line 210: FROM ozf_claims c

206: , b.aging_bucket_line_id aging_bucket_line_id
207: , b.bucket_sequence_num bucket_sequence_num
208: , c.org_id
209: , SUM(c.acctd_amount) amount
210: FROM ozf_claims c
211: , ozf_aging_bucket_dates b
212: WHERE TRUNC(c.claim_date, 'DD') <= TRUNC(b.bucket_date, 'DD')
213: AND b.condition_type = 'LT'
214: AND b.bucket_type = 'CURRENT'

Line 229: FROM ozf_claims c

225: , b.aging_bucket_line_id aging_bucket_line_id
226: , b.bucket_sequence_num bucket_sequence_num
227: , c.org_id
228: , SUM(c.acctd_amount) amount
229: FROM ozf_claims c
230: , ozf_aging_bucket_dates b
231: WHERE TRUNC(c.claim_date, 'DD') >= TRUNC(b.bucket_date , 'DD')
232: AND b.condition_type = 'GT'
233: AND b.bucket_type = 'CURRENT'

Line 248: FROM ozf_claims c

244: , b.aging_bucket_line_id aging_bucket_line_id
245: , b.bucket_sequence_num bucket_sequence_num
246: , c.org_id
247: , SUM(c.acctd_amount) amount
248: FROM ozf_claims c
249: , ozf_aging_bucket_dates b
250: WHERE TRUNC(c.due_date, 'DD') = TRUNC(b.bucket_date, 'DD')
251: AND b.condition_type = 'EQ'
252: AND b.bucket_type = 'PAST'

Line 267: FROM ozf_claims c

263: , b.aging_bucket_line_id aging_bucket_line_id
264: , b.bucket_sequence_num bucket_sequence_num
265: , c.org_id
266: , SUM(c.acctd_amount) amount
267: FROM ozf_claims c
268: , ozf_aging_bucket_dates b
269: WHERE TRUNC(c.due_date, 'DD') <= TRUNC(b.bucket_date , 'DD')
270: AND b.condition_type = 'LT'
271: AND b.bucket_type = 'PAST'

Line 286: FROM ozf_claims c

282: , b.aging_bucket_line_id aging_bucket_line_id
283: , b.bucket_sequence_num bucket_sequence_num
284: , c.org_id
285: , SUM(c.acctd_amount) amount
286: FROM ozf_claims c
287: , ozf_aging_bucket_dates b
288: WHERE TRUNC(c.due_date, 'DD') >= TRUNC(b.bucket_date , 'DD')
289: AND b.condition_type = 'GT'
290: AND b.bucket_type = 'PAST'

Line 305: FROM ozf_claims c

301: , b.aging_bucket_line_id aging_bucket_line_id
302: , b.bucket_sequence_num bucket_sequence_num
303: , c.org_id
304: , SUM(c.acctd_amount) amount
305: FROM ozf_claims c
306: , ozf_aging_bucket_dates b
307: WHERE TRUNC(c.due_date, 'DD') = TRUNC(b.bucket_date, 'DD')
308: AND b.condition_type = 'EQ'
309: AND b.bucket_type = 'FUTURE'

Line 324: FROM ozf_claims c

320: , b.aging_bucket_line_id aging_bucket_line_id
321: , b.bucket_sequence_num bucket_sequence_num
322: , c.org_id
323: , SUM(c.acctd_amount) amount
324: FROM ozf_claims c
325: , ozf_aging_bucket_dates b
326: WHERE TRUNC(c.due_date, 'DD') <= TRUNC(b.bucket_date, 'DD')
327: AND b.condition_type = 'LT'
328: AND b.bucket_type = 'FUTURE'

Line 343: FROM ozf_claims c

339: , b.aging_bucket_line_id aging_bucket_line_id
340: , b.bucket_sequence_num bucket_sequence_num
341: , c.org_id
342: , SUM(c.acctd_amount) amount
343: FROM ozf_claims c
344: , ozf_aging_bucket_dates b
345: WHERE TRUNC(c.due_date, 'DD') >= TRUNC(b.bucket_date, 'DD')
346: AND b.condition_type = 'GT'
347: AND b.bucket_type = 'FUTURE'