eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_REVENUE_MANAGEMENT_PVT dependencies on RA_CUST_TRX_TYPES

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)

Line 1512: ra_cust_trx_types ctt,

1508: l_user_id,
1509: plc.org_id
1510: FROM ra_customer_trx ct,
1511: ra_customer_trx_lines ctl,
1512: ra_cust_trx_types ctt,
1513: ra_interface_lines il,
1514: ar_line_conts plc
1515: WHERE ct.request_id = p_request_id
1516: AND ct.cust_trx_type_id = ctt.cust_trx_type_id

Line 1620: ra_cust_trx_types ctt

1616: FROM
1617: ra_customer_trx ct,
1618: ra_customer_trx_lines ctl,
1619: hz_customer_profiles hcp,
1620: ra_cust_trx_types ctt
1621: WHERE (ctl.customer_trx_line_id = p_customer_trx_line_id)
1622: AND ct.cust_trx_type_id = ctt.cust_trx_type_id
1623: AND ctt.type = 'INV'
1624: AND ct.customer_trx_id = ctl.customer_trx_id

Line 1670: ra_cust_trx_types ctt

1666: FROM
1667: ra_customer_trx ct,
1668: ra_customer_trx_lines ctl,
1669: hz_customer_profiles hcp,
1670: ra_cust_trx_types ctt
1671: WHERE ct.request_id = p_request_id
1672: AND ct.cust_trx_type_id = ctt.cust_trx_type_id
1673: AND ctt.type = 'INV'
1674: AND ct.customer_trx_id = ctl.customer_trx_id

Line 1775: ra_cust_trx_types ctt,

1771: FROM fun_rule_bulk_result_gt rbr,
1772: ar_deferral_reasons dr,
1773: ra_customer_trx_lines ctl,
1774: ra_customer_trx ct,
1775: ra_cust_trx_types ctt,
1776: pa_implementations pa
1777: WHERE rbr.result_value = dr.contingency_id
1778: AND rbr.id = ctl.customer_trx_line_id
1779: AND ctl.customer_trx_id = ct.customer_trx_id

Line 1852: ra_cust_trx_types ctt,

1848: FROM fun_rule_bulk_result_gt rbr,
1849: ar_deferral_reasons dr,
1850: ra_customer_trx_lines ctl,
1851: ra_customer_trx ct,
1852: ra_cust_trx_types ctt,
1853: pa_implementations pa
1854: WHERE rbr.result_value = dr.contingency_id
1855: AND rbr.id = ctl.customer_trx_line_id
1856: AND ctl.customer_trx_id = ct.customer_trx_id

Line 1967: ra_cust_trx_types ctt,

1963: l_user_id,
1964: thg.org_id
1965: FROM ar_trx_lines_gt tlg,
1966: ar_trx_header_gt thg,
1967: ra_cust_trx_types ctt,
1968: ar_trx_contingencies_gt tcg,
1969: ar_deferral_reasons dr,
1970: pa_implementations pa
1971: WHERE tlg.request_id = p_request_id

Line 2078: ra_cust_trx_types ctt,

2074: sysdate,
2075: ct.org_id
2076: FROM ra_customer_trx_lines ctl,
2077: ra_customer_trx ct,
2078: ra_cust_trx_types ctt,
2079: ar_interface_conts ic,
2080: ar_deferral_reasons dr,
2081: pa_implementations pa
2082: WHERE ctl.request_id = p_request_id

Line 6424: FROM ra_cust_trx_types rtt, ra_customer_trx trx

6420: ---This cursor is to try and avoide -ve unearn in a case where the amount being
6421: ---discussed is an overapplication. This will skip the receipt analyzer
6422: CURSOR over_appl (p_trx_id NUMBER) IS
6423: SELECT nvl(allow_overapplication_flag,'N')
6424: FROM ra_cust_trx_types rtt, ra_customer_trx trx
6425: WHERE customer_trx_id = p_trx_id
6426: AND trx.cust_trx_type_id = rtt.cust_trx_type_id;
6427:
6428: /*-----------------------------------------------------------------------+