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.ARI_DB_UTILITIES dependencies on DUAL

Line 244: from dual ;

240: 'PENDADJ_ONLY' , 'OIR_AGING_' || l_bucket_line_type ,
241: 'DISPUTE_PENDADJ', 'OIR_AGING_' || l_bucket_line_type ,
242: 'OIR_AGING_' || to_char(l_bucket_days_from) || '_' || to_char(l_bucket_days_to)
243: ) into p_bucket_status_code0
244: from dual ;
245:
246: FETCH c_sel_bucket_data INTO l_bucket_days_from, l_bucket_days_to , l_bucket_line_type;
247: END IF;
248:

Line 257: from dual ;

253: 'PENDADJ_ONLY' , 'OIR_AGING_' || l_bucket_line_type ,
254: 'DISPUTE_PENDADJ', 'OIR_AGING_' || l_bucket_line_type ,
255: 'OIR_AGING_' || to_char(l_bucket_days_from) || '_' || to_char(l_bucket_days_to)
256: ) into p_bucket_status_code1
257: from dual ;
258:
259: FETCH c_sel_bucket_data INTO l_bucket_days_from, l_bucket_days_to , l_bucket_line_type;
260: END IF;
261:

Line 270: from dual ;

266: 'PENDADJ_ONLY' , 'OIR_AGING_' || l_bucket_line_type ,
267: 'DISPUTE_PENDADJ', 'OIR_AGING_' || l_bucket_line_type ,
268: 'OIR_AGING_' || to_char(l_bucket_days_from) || '_' || to_char(l_bucket_days_to)
269: ) into p_bucket_status_code2
270: from dual ;
271:
272: FETCH c_sel_bucket_data INTO l_bucket_days_from, l_bucket_days_to , l_bucket_line_type;
273: END IF;
274:

Line 283: from dual ;

279: 'PENDADJ_ONLY' , 'OIR_AGING_' || l_bucket_line_type ,
280: 'DISPUTE_PENDADJ', 'OIR_AGING_' || l_bucket_line_type ,
281: 'OIR_AGING_' || to_char(l_bucket_days_from) || '_' || to_char(l_bucket_days_to)
282: ) into p_bucket_status_code3
283: from dual ;
284:
285: FETCH c_sel_bucket_data INTO l_bucket_days_from, l_bucket_days_to , l_bucket_line_type;
286: END IF;
287:

Line 296: from dual ;

292: 'PENDADJ_ONLY' , 'OIR_AGING_' || l_bucket_line_type ,
293: 'DISPUTE_PENDADJ', 'OIR_AGING_' || l_bucket_line_type ,
294: 'OIR_AGING_' || to_char(l_bucket_days_from) || '_' || to_char(l_bucket_days_to)
295: ) into p_bucket_status_code4
296: from dual ;
297:
298: FETCH c_sel_bucket_data INTO l_bucket_days_from, l_bucket_days_to , l_bucket_line_type;
299: END IF;
300:

Line 309: from dual ;

305: 'PENDADJ_ONLY' , 'OIR_AGING_' || l_bucket_line_type ,
306: 'DISPUTE_PENDADJ', 'OIR_AGING_' || l_bucket_line_type ,
307: 'OIR_AGING_' || to_char(l_bucket_days_from) || '_' || to_char(l_bucket_days_to)
308: ) into p_bucket_status_code5
309: from dual ;
310:
311: FETCH c_sel_bucket_data INTO l_bucket_days_from, l_bucket_days_to , l_bucket_line_type;
312: END IF;
313:

Line 322: from dual ;

318: 'PENDADJ_ONLY' , 'OIR_AGING_' || l_bucket_line_type ,
319: 'DISPUTE_PENDADJ', 'OIR_AGING_' || l_bucket_line_type ,
320: 'OIR_AGING_' || to_char(l_bucket_days_from) || '_' || to_char(l_bucket_days_to)
321: ) into p_bucket_status_code6
322: from dual ;
323:
324: END IF;
325:
326: CLOSE c_sel_bucket_data;

Line 1800: select trunc(sysdate)-1 into l_purge_date from dual;

1796: fnd_file.put_line( FND_FILE.LOG, 'Begin Procedure ' || l_procedure_name);
1797: fnd_file.put_line( FND_FILE.LOG, '+---------------------------------------------------------------------------+');
1798:
1799: if(p_creation_date is NULL) then
1800: select trunc(sysdate)-1 into l_purge_date from dual;
1801: else
1802: l_purge_date := FND_CONC_DATE.STRING_TO_DATE(p_creation_date); /* Convert character string to date */
1803: if(l_purge_date is NULL) then
1804: