APPS.AR_REVENUE_MANAGEMENT_PVT dependencies on RA_TERMS_LINES

Line 109: ra_terms_lines tl,

105: l_user_id,
106: max(ctl.org_id)
107: FROM ra_customer_trx_lines_all ctl,
108: ra_customer_trx_all ct,
109: ra_terms_lines tl,
110: ra_cust_trx_types_all ctt,
111: pa_implementations pa
112: WHERE ctl.request_id = p_request_id
113: AND ctl.customer_trx_id = ct.customer_trx_id

Line 179: ra_terms_lines tl,

175: l_user_id,
176: max(ctl.org_id)
177: FROM ra_customer_trx_lines_all ctl,
178: ra_customer_trx_all ct,
179: ra_terms_lines tl,
180: ra_cust_trx_types_all ctt,
181: pa_implementations pa
182: WHERE ctl.request_id = p_request_id
183: AND ctl.customer_trx_id = ct.customer_trx_id

Line 246: ra_terms_lines tl,

242: l_user_id,
243: ctl.org_id
244: FROM ra_customer_trx_lines_all ctl,
245: ra_customer_trx_all ct,
246: ra_terms_lines tl,
247: ra_cust_trx_types_all ctt,
248: pa_implementations pa
249: WHERE ctl.customer_trx_line_id = p_customer_trx_line_id
250: AND ctl.customer_trx_id = ct.customer_trx_id

Line 1207: ra_terms_lines tl

1203: WHERE lc.customer_trx_line_id IN
1204: (SELECT customer_trx_line_id
1205: FROM ra_customer_trx_lines ctl,
1206: ra_customer_trx ct,
1207: ra_terms_lines tl
1208: WHERE ctl.customer_trx_id = ct.customer_trx_id
1209: AND ct.term_id = tl.term_id
1210: AND ctl.request_id = p_request_id
1211: GROUP BY ctl.customer_trx_line_id, tl.term_id

Line 1307: ra_terms_lines tl

1303: AND EXISTS
1304: (SELECT 'term exceeds threshold'
1305: FROM ra_customer_trx_lines ctl,
1306: ra_customer_trx ct,
1307: ra_terms_lines tl
1308: WHERE ctl.customer_trx_id = ct.customer_trx_id
1309: AND ct.term_id = tl.term_id
1310: AND ctl.customer_trx_line_id = lc.customer_trx_line_id
1311: GROUP BY ctl.customer_trx_line_id, tl.term_id