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_REVENUE_ASSIGNMENTS dependencies on RA_CUSTOMER_TRX

Line 41: p_request_id IN ra_customer_trx_all.request_id%TYPE,

37:
38: PROCEDURE build_for_credit(
39: p_session_id IN number,
40: p_period_set_name IN gl_periods.period_set_name%TYPE,
41: p_request_id IN ra_customer_trx_all.request_id%TYPE,
42: p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
43: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE)
44: IS
45:

Line 42: p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,

38: PROCEDURE build_for_credit(
39: p_session_id IN number,
40: p_period_set_name IN gl_periods.period_set_name%TYPE,
41: p_request_id IN ra_customer_trx_all.request_id%TYPE,
42: p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
43: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE)
44: IS
45:
46: BEGIN

Line 43: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE)

39: p_session_id IN number,
40: p_period_set_name IN gl_periods.period_set_name%TYPE,
41: p_request_id IN ra_customer_trx_all.request_id%TYPE,
42: p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
43: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE)
44: IS
45:
46: BEGIN
47:

Line 90: ra_customer_trx_lines tl,

86: decode(tl.previous_customer_trx_line_id, NULL, rr.frequency,
87: gsb.accounted_period_type)) period_type,
88: apt.max_regular_period_length
89: from
90: ra_customer_trx_lines tl,
91: ra_customer_trx_lines itl,
92: ra_customer_trx t,
93: ra_rules rr,
94: ra_rule_schedules rrs,

Line 91: ra_customer_trx_lines itl,

87: gsb.accounted_period_type)) period_type,
88: apt.max_regular_period_length
89: from
90: ra_customer_trx_lines tl,
91: ra_customer_trx_lines itl,
92: ra_customer_trx t,
93: ra_rules rr,
94: ra_rule_schedules rrs,
95: ra_rule_schedules rrs_lump,

Line 92: ra_customer_trx t,

88: apt.max_regular_period_length
89: from
90: ra_customer_trx_lines tl,
91: ra_customer_trx_lines itl,
92: ra_customer_trx t,
93: ra_rules rr,
94: ra_rule_schedules rrs,
95: ra_rule_schedules rrs_lump,
96: ar_lookups ral,

Line 158: ra_customer_trx_lines tl,

154: decode(tl.previous_customer_trx_line_id, NULL, rr.frequency,
155: gsb.accounted_period_type)) period_type,
156: apt.max_regular_period_length
157: from
158: ra_customer_trx_lines tl,
159: ra_customer_trx_lines itl,
160: ra_customer_trx t,
161: ra_rules rr,
162: ra_rule_schedules rrs,

Line 159: ra_customer_trx_lines itl,

155: gsb.accounted_period_type)) period_type,
156: apt.max_regular_period_length
157: from
158: ra_customer_trx_lines tl,
159: ra_customer_trx_lines itl,
160: ra_customer_trx t,
161: ra_rules rr,
162: ra_rule_schedules rrs,
163: ra_rule_schedules rrs_lump,

Line 160: ra_customer_trx t,

156: apt.max_regular_period_length
157: from
158: ra_customer_trx_lines tl,
159: ra_customer_trx_lines itl,
160: ra_customer_trx t,
161: ra_rules rr,
162: ra_rule_schedules rrs,
163: ra_rule_schedules rrs_lump,
164: ar_lookups ral,

Line 224: ra_customer_trx_lines tl,

220: decode(tl.previous_customer_trx_line_id, NULL, rr.frequency,
221: gsb.accounted_period_type)) period_type,
222: apt.max_regular_period_length
223: from
224: ra_customer_trx_lines tl,
225: ra_customer_trx_lines itl,
226: ra_customer_trx t,
227: ra_rules rr,
228: ra_rule_schedules rrs,

Line 225: ra_customer_trx_lines itl,

221: gsb.accounted_period_type)) period_type,
222: apt.max_regular_period_length
223: from
224: ra_customer_trx_lines tl,
225: ra_customer_trx_lines itl,
226: ra_customer_trx t,
227: ra_rules rr,
228: ra_rule_schedules rrs,
229: ra_rule_schedules rrs_lump,

Line 226: ra_customer_trx t,

222: apt.max_regular_period_length
223: from
224: ra_customer_trx_lines tl,
225: ra_customer_trx_lines itl,
226: ra_customer_trx t,
227: ra_rules rr,
228: ra_rule_schedules rrs,
229: ra_rule_schedules rrs_lump,
230: ar_lookups ral,