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_LINES

Line 51: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE)

47: p_period_set_name IN gl_periods.period_set_name%TYPE,
48: p_use_inv_acctg IN varchar2,
49: p_request_id IN ra_customer_trx_all.request_id%TYPE,
50: p_customer_trx_id IN ra_customer_trx_all.customer_trx_id%TYPE,
51: p_customer_trx_line_id IN ra_customer_trx_lines_all.customer_trx_line_id%TYPE)
52: IS
53:
54: BEGIN
55: IF PG_DEBUG IN ('Y','C')

Line 108: ra_customer_trx_lines tl,

104: decode(tl.previous_customer_trx_line_id, NULL, rr.frequency,
105: gsb.accounted_period_type)) period_type,
106: apt.max_regular_period_length
107: from
108: ra_customer_trx_lines tl,
109: ra_customer_trx_lines itl,
110: ra_customer_trx t,
111: ra_rules rr,
112: ra_rule_schedules rrs,

Line 109: ra_customer_trx_lines itl,

105: gsb.accounted_period_type)) period_type,
106: apt.max_regular_period_length
107: from
108: ra_customer_trx_lines tl,
109: ra_customer_trx_lines itl,
110: ra_customer_trx t,
111: ra_rules rr,
112: ra_rule_schedules rrs,
113: ra_rule_schedules rrs_lump,

Line 177: ra_customer_trx_lines tl,

173: decode(tl.previous_customer_trx_line_id, NULL, rr.frequency,
174: gsb.accounted_period_type)) period_type,
175: apt.max_regular_period_length
176: from
177: ra_customer_trx_lines tl,
178: ra_customer_trx_lines itl,
179: ra_customer_trx t,
180: ra_rules rr,
181: ra_rule_schedules rrs,

Line 178: ra_customer_trx_lines itl,

174: gsb.accounted_period_type)) period_type,
175: apt.max_regular_period_length
176: from
177: ra_customer_trx_lines tl,
178: ra_customer_trx_lines itl,
179: ra_customer_trx t,
180: ra_rules rr,
181: ra_rule_schedules rrs,
182: ra_rule_schedules rrs_lump,

Line 244: ra_customer_trx_lines tl,

240: decode(tl.previous_customer_trx_line_id, NULL, rr.frequency,
241: gsb.accounted_period_type)) period_type,
242: apt.max_regular_period_length
243: from
244: ra_customer_trx_lines tl,
245: ra_customer_trx_lines itl,
246: ra_customer_trx t,
247: ra_rules rr,
248: ra_rule_schedules rrs,

Line 245: ra_customer_trx_lines itl,

241: gsb.accounted_period_type)) period_type,
242: apt.max_regular_period_length
243: from
244: ra_customer_trx_lines tl,
245: ra_customer_trx_lines itl,
246: ra_customer_trx t,
247: ra_rules rr,
248: ra_rule_schedules rrs,
249: ra_rule_schedules rrs_lump,

Line 281: FROM ra_customer_trx_lines il,

277: /* 10144015 - changed from gl_date to original_gl_date */
278: UPDATE ar_revenue_assignments_gt ragt
279: SET pprr_amount =
280: (SELECT Sum(ilgd.amount)
281: FROM ra_customer_trx_lines il,
282: ra_cust_trx_line_gl_dist ilgd,
283: ar_periods arp1, -- first period
284: ar_periods arp2 -- current period
285: WHERE ragt.customer_trx_line_id = il.customer_trx_line_id