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.ARP_CUSTOMER_AGING dependencies on AR_AGING_BUCKET_LINES

Line 49: v_bucket_category ar_aging_bucket_lines.type%TYPE;

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

Line 51: v_bucket_line_type_0 ar_aging_bucket_lines.type%TYPE;

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

Line 54: v_bucket_line_type_1 ar_aging_bucket_lines.type%TYPE;

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

Line 57: v_bucket_line_type_2 ar_aging_bucket_lines.type%TYPE;

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

Line 60: v_bucket_line_type_3 ar_aging_bucket_lines.type%TYPE;

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

Line 63: v_bucket_line_type_4 ar_aging_bucket_lines.type%TYPE;

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

Line 66: v_bucket_line_type_5 ar_aging_bucket_lines.type%TYPE;

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

Line 69: v_bucket_line_type_6 ar_aging_bucket_lines.type%TYPE;

65: v_bucket_days_to_4 NUMBER;
66: v_bucket_line_type_5 ar_aging_bucket_lines.type%TYPE;
67: v_bucket_days_from_5 NUMBER;
68: v_bucket_days_to_5 NUMBER;
69: v_bucket_line_type_6 ar_aging_bucket_lines.type%TYPE;
70: v_bucket_days_from_6 NUMBER;
71: v_bucket_days_to_6 NUMBER;
72: --
73: CURSOR c_sel_bucket_data is

Line 79: from ar_aging_bucket_lines lines,

75: lines.days_to,
76: lines.report_heading1,
77: lines.report_heading2,
78: lines.type
79: from ar_aging_bucket_lines lines,
80: ar_aging_buckets buckets
81: where lines.aging_bucket_id = buckets.aging_bucket_id
82: and upper(buckets.bucket_name) = upper(p_bucket_name)
83: and nvl(buckets.status,'A') = 'A'