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 AR_AGING_BUCKET_LINES

Line 173: l_bucket_line_type ar_aging_bucket_lines.type%TYPE;

169: l_bucket_amount_3 NUMBER := 0;
170: l_bucket_amount_4 NUMBER := 0;
171: l_bucket_amount_5 NUMBER := 0;
172: l_bucket_amount_6 NUMBER := 0;
173: l_bucket_line_type ar_aging_bucket_lines.type%TYPE;
174: l_bucket_days_from NUMBER;
175: l_bucket_days_to NUMBER;
176:
177: CURSOR c_sel_bucket_data is

Line 181: from ar_aging_bucket_lines lines,

177: CURSOR c_sel_bucket_data is
178: select lines.days_start,
179: lines.days_to,
180: lines.type
181: from ar_aging_bucket_lines lines,
182: ar_aging_buckets buckets
183: where lines.aging_bucket_id = buckets.aging_bucket_id
184: and buckets.aging_bucket_id = to_number(p_bucket_name)
185: and nvl(buckets.status,'A') = 'A'

Line 379: v_bucket_category ar_aging_bucket_lines.type%TYPE;

375: v_bucket_3 NUMBER;
376: v_bucket_4 NUMBER;
377: v_bucket_5 NUMBER;
378: v_bucket_6 NUMBER;
379: v_bucket_category ar_aging_bucket_lines.type%TYPE;
380: --
381: v_bucket_line_type_0 ar_aging_bucket_lines.type%TYPE;
382: v_bucket_days_from_0 NUMBER;
383: v_bucket_days_to_0 NUMBER;

Line 381: v_bucket_line_type_0 ar_aging_bucket_lines.type%TYPE;

377: v_bucket_5 NUMBER;
378: v_bucket_6 NUMBER;
379: v_bucket_category ar_aging_bucket_lines.type%TYPE;
380: --
381: v_bucket_line_type_0 ar_aging_bucket_lines.type%TYPE;
382: v_bucket_days_from_0 NUMBER;
383: v_bucket_days_to_0 NUMBER;
384: v_bucket_line_type_1 ar_aging_bucket_lines.type%TYPE;
385: v_bucket_days_from_1 NUMBER;

Line 384: v_bucket_line_type_1 ar_aging_bucket_lines.type%TYPE;

380: --
381: v_bucket_line_type_0 ar_aging_bucket_lines.type%TYPE;
382: v_bucket_days_from_0 NUMBER;
383: v_bucket_days_to_0 NUMBER;
384: v_bucket_line_type_1 ar_aging_bucket_lines.type%TYPE;
385: v_bucket_days_from_1 NUMBER;
386: v_bucket_days_to_1 NUMBER;
387: v_bucket_line_type_2 ar_aging_bucket_lines.type%TYPE;
388: v_bucket_days_from_2 NUMBER;

Line 387: v_bucket_line_type_2 ar_aging_bucket_lines.type%TYPE;

383: v_bucket_days_to_0 NUMBER;
384: v_bucket_line_type_1 ar_aging_bucket_lines.type%TYPE;
385: v_bucket_days_from_1 NUMBER;
386: v_bucket_days_to_1 NUMBER;
387: v_bucket_line_type_2 ar_aging_bucket_lines.type%TYPE;
388: v_bucket_days_from_2 NUMBER;
389: v_bucket_days_to_2 NUMBER;
390: v_bucket_line_type_3 ar_aging_bucket_lines.type%TYPE;
391: v_bucket_days_from_3 NUMBER;

Line 390: v_bucket_line_type_3 ar_aging_bucket_lines.type%TYPE;

386: v_bucket_days_to_1 NUMBER;
387: v_bucket_line_type_2 ar_aging_bucket_lines.type%TYPE;
388: v_bucket_days_from_2 NUMBER;
389: v_bucket_days_to_2 NUMBER;
390: v_bucket_line_type_3 ar_aging_bucket_lines.type%TYPE;
391: v_bucket_days_from_3 NUMBER;
392: v_bucket_days_to_3 NUMBER;
393: v_bucket_line_type_4 ar_aging_bucket_lines.type%TYPE;
394: v_bucket_days_from_4 NUMBER;

Line 393: v_bucket_line_type_4 ar_aging_bucket_lines.type%TYPE;

389: v_bucket_days_to_2 NUMBER;
390: v_bucket_line_type_3 ar_aging_bucket_lines.type%TYPE;
391: v_bucket_days_from_3 NUMBER;
392: v_bucket_days_to_3 NUMBER;
393: v_bucket_line_type_4 ar_aging_bucket_lines.type%TYPE;
394: v_bucket_days_from_4 NUMBER;
395: v_bucket_days_to_4 NUMBER;
396: v_bucket_line_type_5 ar_aging_bucket_lines.type%TYPE;
397: v_bucket_days_from_5 NUMBER;

Line 396: v_bucket_line_type_5 ar_aging_bucket_lines.type%TYPE;

392: v_bucket_days_to_3 NUMBER;
393: v_bucket_line_type_4 ar_aging_bucket_lines.type%TYPE;
394: v_bucket_days_from_4 NUMBER;
395: v_bucket_days_to_4 NUMBER;
396: v_bucket_line_type_5 ar_aging_bucket_lines.type%TYPE;
397: v_bucket_days_from_5 NUMBER;
398: v_bucket_days_to_5 NUMBER;
399: v_bucket_line_type_6 ar_aging_bucket_lines.type%TYPE;
400: v_bucket_days_from_6 NUMBER;

Line 399: v_bucket_line_type_6 ar_aging_bucket_lines.type%TYPE;

395: v_bucket_days_to_4 NUMBER;
396: v_bucket_line_type_5 ar_aging_bucket_lines.type%TYPE;
397: v_bucket_days_from_5 NUMBER;
398: v_bucket_days_to_5 NUMBER;
399: v_bucket_line_type_6 ar_aging_bucket_lines.type%TYPE;
400: v_bucket_days_from_6 NUMBER;
401: v_bucket_days_to_6 NUMBER;
402: --
403: CURSOR c_sel_bucket_data is

Line 409: from ar_aging_bucket_lines lines,

405: lines.days_to,
406: lines.report_heading1,
407: lines.report_heading2,
408: lines.type
409: from ar_aging_bucket_lines lines,
410: ar_aging_buckets buckets
411: where lines.aging_bucket_id = buckets.aging_bucket_id
412: and buckets.aging_bucket_id = to_number(p_bucket_name)
413: and nvl(buckets.status,'A') = 'A'