DBA Data[Home] [Help]

APPS.AR_REVENUE_MANAGEMENT_PVT dependencies on RA_CUST_TRX_TYPES_ALL

Line 110: ra_cust_trx_types_all ctt,

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
114: AND ct.batch_source_id NOT IN (20, 21)

Line 180: ra_cust_trx_types_all ctt,

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
184: AND ct.batch_source_id NOT IN (20, 21)

Line 247: ra_cust_trx_types_all ctt,

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
251: AND ct.batch_source_id NOT IN (20, 21)

Line 345: ra_cust_trx_types_all ctt,

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
349: AND ct.batch_source_id NOT IN (20, 21)

Line 413: ra_cust_trx_types_all ctt,

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
417: AND ct.batch_source_id NOT IN (20, 21)

Line 478: ra_cust_trx_types_all ctt,

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
482: AND ct.batch_source_id NOT IN (20, 21)