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 ctl,
108: ra_customer_trx ct,
109: ra_terms_lines tl,
110: ra_cust_trx_types ctt
111: WHERE ctl.request_id = p_request_id
112: AND ctl.customer_trx_id = ct.customer_trx_id
113: AND ct.batch_source_id NOT IN (20, 21)

Line 173: ra_terms_lines tl,

169: l_user_id,
170: max(ctl.org_id)
171: FROM ra_customer_trx_lines ctl,
172: ra_customer_trx ct,
173: ra_terms_lines tl,
174: ra_cust_trx_types ctt
175: WHERE ctl.request_id = p_request_id
176: AND ctl.customer_trx_id = ct.customer_trx_id
177: AND ct.batch_source_id NOT IN (20, 21)

Line 234: ra_terms_lines tl,

230: l_user_id,
231: ctl.org_id
232: FROM ra_customer_trx_lines ctl,
233: ra_customer_trx ct,
234: ra_terms_lines tl,
235: ra_cust_trx_types ctt
236: WHERE ctl.customer_trx_line_id = p_customer_trx_line_id
237: AND ctl.customer_trx_id = ct.customer_trx_id
238: AND ct.batch_source_id NOT IN (20, 21)

Line 1140: ra_terms_lines tl

1136: WHERE lc.customer_trx_line_id IN
1137: (SELECT customer_trx_line_id
1138: FROM ra_customer_trx_lines ctl,
1139: ra_customer_trx ct,
1140: ra_terms_lines tl
1141: WHERE ctl.customer_trx_id = ct.customer_trx_id
1142: AND ct.term_id = tl.term_id
1143: AND ctl.request_id = p_request_id
1144: GROUP BY ctl.customer_trx_line_id, tl.term_id

Line 1240: ra_terms_lines tl

1236: AND EXISTS
1237: (SELECT 'term exceeds threshold'
1238: FROM ra_customer_trx_lines ctl,
1239: ra_customer_trx ct,
1240: ra_terms_lines tl
1241: WHERE ctl.customer_trx_id = ct.customer_trx_id
1242: AND ct.term_id = tl.term_id
1243: AND ctl.customer_trx_line_id = lc.customer_trx_line_id
1244: GROUP BY ctl.customer_trx_line_id, tl.term_id