DBA Data[Home] [Help]

APPS.AR_REVENUE_MANAGEMENT_PVT dependencies on RA_CUSTOMER_TRX_ALL

Line 108: ra_customer_trx_all ct,

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
112: WHERE ctl.request_id = p_request_id

Line 178: ra_customer_trx_all ct,

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
182: WHERE ctl.request_id = p_request_id

Line 245: ra_customer_trx_all ct,

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
249: WHERE ctl.customer_trx_line_id = p_customer_trx_line_id

Line 344: ra_customer_trx_all ct,

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
348: AND ctl.customer_trx_id = ct.customer_trx_id

Line 412: ra_customer_trx_all ct,

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
416: AND ctl.customer_trx_id = ct.customer_trx_id

Line 477: ra_customer_trx_all ct,

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
481: AND ctl.customer_trx_id = ct.customer_trx_id

Line 4147: | from the ra_customer_trx_all.

4143: /*------------------------------------------------------------------------
4144: | If this procedure is being called from receipt reversal then
4145: | the only thing we have is the receivable application id. As a result,
4146: | query the details from ar_receivable_applications_all table. and then
4147: | from the ra_customer_trx_all.
4148: | If this is being called from receipt application then simply copy the
4149: | passed variable into the local variables.
4150: +------------------------------------------------------------------------*/
4151: