APPS.AR_REVENUE_MANAGEMENT_PVT dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 107: FROM ra_customer_trx_lines_all ctl,

103: l_user_id,
104: sysdate,
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

Line 177: FROM ra_customer_trx_lines_all ctl,

173: l_user_id,
174: sysdate,
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

Line 244: FROM ra_customer_trx_lines_all ctl,

240: l_user_id,
241: sysdate,
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

Line 343: FROM ra_customer_trx_lines_all ctl,

339: l_user_id,
340: sysdate,
341: l_user_id,
342: ctl.org_id
343: FROM ra_customer_trx_lines_all ctl,
344: ra_customer_trx_all ct,
345: ra_cust_trx_types_all ctt,
346: pa_implementations pa
347: WHERE ctl.request_id = p_request_id

Line 411: FROM ra_customer_trx_lines_all ctl,

407: l_user_id,
408: sysdate,
409: l_user_id,
410: ctl.org_id
411: FROM ra_customer_trx_lines_all ctl,
412: ra_customer_trx_all ct,
413: ra_cust_trx_types_all ctt,
414: pa_implementations pa
415: WHERE ctl.request_id = p_request_id

Line 476: FROM ra_customer_trx_lines_all ctl,

472: l_user_id,
473: sysdate,
474: l_user_id,
475: ctl.org_id
476: FROM ra_customer_trx_lines_all ctl,
477: ra_customer_trx_all ct,
478: ra_cust_trx_types_all ctt,
479: pa_implementations pa
480: WHERE ctl.customer_trx_line_id = p_customer_trx_line_id

Line 1395: l_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type;

1391: l_line_flex_rec ar_deferral_reasons_grp.line_flex_rec;
1392: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1393: l_msg_count NUMBER;
1394: l_msg_data VARCHAR2(2000);
1395: l_customer_trx_line_id ra_customer_trx_lines_all.customer_trx_line_id%type;
1396: BEGIN
1397: /* Call OM to get the DFF attributes for the parent line */
1398: OE_AR_Acceptance_GRP.Get_interface_attributes
1399: (p_line_id => p_so_line_id,

Line 2473: FROM ra_customer_trx_lines_all ctl,

2469: set original_collectibility_flag = 'Y'
2470: WHERE dl.request_id = p_request_id
2471: and dl.customer_trx_id in
2472: (SELECT ctl.customer_trx_id /* its a pre-billing contingency */
2473: FROM ra_customer_trx_lines_all ctl,
2474: ar_line_conts_all lrc,
2475: ar_deferral_reasons dr
2476: WHERE ctl.customer_trx_line_id = dl.customer_trx_line_id
2477: and ctl.customer_trx_line_id=lrc.customer_trx_line_id

Line 2500: FROM ra_customer_trx_lines_all ctl,

2496: set original_collectibility_flag = 'Y'
2497: WHERE dl.customer_trx_line_id = p_customer_trx_line_id
2498: and dl.customer_trx_id in
2499: (SELECT ctl.customer_trx_id /* its a pre-billing contingency */
2500: FROM ra_customer_trx_lines_all ctl,
2501: ar_line_conts_all lrc,
2502: ar_deferral_reasons dr
2503: WHERE ctl.customer_trx_line_id = dl.customer_trx_line_id
2504: and ctl.customer_trx_line_id=lrc.customer_trx_line_id

Line 4747: FROM ra_customer_trx_lines_all ctl,

4743:
4744: /* Bug 12813416 */
4745: CURSOR c1 IS
4746: SELECT 'its a pre-billing contingency'
4747: FROM ra_customer_trx_lines_all ctl,
4748: ar_line_conts_all lrc,
4749: ar_deferral_reasons dr
4750: WHERE ctl.customer_trx_id = p_customer_trx_id
4751: and ctl.customer_trx_line_id=lrc.customer_trx_line_id