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_AGING dependencies on AR_AGING_BUCKET_LINES

Line 51: v_bucket_category ar_aging_bucket_lines.type%TYPE;

47: v_bucket_3 NUMBER;
48: v_bucket_4 NUMBER;
49: v_bucket_5 NUMBER;
50: v_bucket_6 NUMBER;
51: v_bucket_category ar_aging_bucket_lines.type%TYPE;
52: --
53: v_bucket_line_type_0 ar_aging_bucket_lines.type%TYPE;
54: v_bucket_days_from_0 NUMBER;
55: v_bucket_days_to_0 NUMBER;

Line 53: v_bucket_line_type_0 ar_aging_bucket_lines.type%TYPE;

49: v_bucket_5 NUMBER;
50: v_bucket_6 NUMBER;
51: v_bucket_category ar_aging_bucket_lines.type%TYPE;
52: --
53: v_bucket_line_type_0 ar_aging_bucket_lines.type%TYPE;
54: v_bucket_days_from_0 NUMBER;
55: v_bucket_days_to_0 NUMBER;
56: v_bucket_line_type_1 ar_aging_bucket_lines.type%TYPE;
57: v_bucket_days_from_1 NUMBER;

Line 56: v_bucket_line_type_1 ar_aging_bucket_lines.type%TYPE;

52: --
53: v_bucket_line_type_0 ar_aging_bucket_lines.type%TYPE;
54: v_bucket_days_from_0 NUMBER;
55: v_bucket_days_to_0 NUMBER;
56: v_bucket_line_type_1 ar_aging_bucket_lines.type%TYPE;
57: v_bucket_days_from_1 NUMBER;
58: v_bucket_days_to_1 NUMBER;
59: v_bucket_line_type_2 ar_aging_bucket_lines.type%TYPE;
60: v_bucket_days_from_2 NUMBER;

Line 59: v_bucket_line_type_2 ar_aging_bucket_lines.type%TYPE;

55: v_bucket_days_to_0 NUMBER;
56: v_bucket_line_type_1 ar_aging_bucket_lines.type%TYPE;
57: v_bucket_days_from_1 NUMBER;
58: v_bucket_days_to_1 NUMBER;
59: v_bucket_line_type_2 ar_aging_bucket_lines.type%TYPE;
60: v_bucket_days_from_2 NUMBER;
61: v_bucket_days_to_2 NUMBER;
62: v_bucket_line_type_3 ar_aging_bucket_lines.type%TYPE;
63: v_bucket_days_from_3 NUMBER;

Line 62: v_bucket_line_type_3 ar_aging_bucket_lines.type%TYPE;

58: v_bucket_days_to_1 NUMBER;
59: v_bucket_line_type_2 ar_aging_bucket_lines.type%TYPE;
60: v_bucket_days_from_2 NUMBER;
61: v_bucket_days_to_2 NUMBER;
62: v_bucket_line_type_3 ar_aging_bucket_lines.type%TYPE;
63: v_bucket_days_from_3 NUMBER;
64: v_bucket_days_to_3 NUMBER;
65: v_bucket_line_type_4 ar_aging_bucket_lines.type%TYPE;
66: v_bucket_days_from_4 NUMBER;

Line 65: v_bucket_line_type_4 ar_aging_bucket_lines.type%TYPE;

61: v_bucket_days_to_2 NUMBER;
62: v_bucket_line_type_3 ar_aging_bucket_lines.type%TYPE;
63: v_bucket_days_from_3 NUMBER;
64: v_bucket_days_to_3 NUMBER;
65: v_bucket_line_type_4 ar_aging_bucket_lines.type%TYPE;
66: v_bucket_days_from_4 NUMBER;
67: v_bucket_days_to_4 NUMBER;
68: v_bucket_line_type_5 ar_aging_bucket_lines.type%TYPE;
69: v_bucket_days_from_5 NUMBER;

Line 68: v_bucket_line_type_5 ar_aging_bucket_lines.type%TYPE;

64: v_bucket_days_to_3 NUMBER;
65: v_bucket_line_type_4 ar_aging_bucket_lines.type%TYPE;
66: v_bucket_days_from_4 NUMBER;
67: v_bucket_days_to_4 NUMBER;
68: v_bucket_line_type_5 ar_aging_bucket_lines.type%TYPE;
69: v_bucket_days_from_5 NUMBER;
70: v_bucket_days_to_5 NUMBER;
71: v_bucket_line_type_6 ar_aging_bucket_lines.type%TYPE;
72: v_bucket_days_from_6 NUMBER;

Line 71: v_bucket_line_type_6 ar_aging_bucket_lines.type%TYPE;

67: v_bucket_days_to_4 NUMBER;
68: v_bucket_line_type_5 ar_aging_bucket_lines.type%TYPE;
69: v_bucket_days_from_5 NUMBER;
70: v_bucket_days_to_5 NUMBER;
71: v_bucket_line_type_6 ar_aging_bucket_lines.type%TYPE;
72: v_bucket_days_from_6 NUMBER;
73: v_bucket_days_to_6 NUMBER;
74: v_outstanding_balance_1 NUMBER :=0;
75: v_outstanding_balance_2 NUMBER :=0;

Line 125: from ar_aging_bucket_lines lines,

121: lines.days_to,
122: lines.report_heading1,
123: lines.report_heading2,
124: lines.type
125: from ar_aging_bucket_lines lines,
126: ar_aging_buckets buckets
127: where lines.aging_bucket_id = buckets.aging_bucket_id
128: and upper(buckets.bucket_name) = upper(p_bucket_name)
129: and nvl(buckets.status,'A') = 'A'