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 ctt

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)
114: AND ct.cust_trx_type_id = ctt.cust_trx_type_id

Line 174: ra_cust_trx_types ctt

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)
178: AND ct.cust_trx_type_id = ctt.cust_trx_type_id

Line 235: ra_cust_trx_types ctt

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)
239: AND ct.cust_trx_type_id = ctt.cust_trx_type_id

Line 327: ra_cust_trx_types ctt

323: l_user_id,
324: ctl.org_id
325: FROM ra_customer_trx_lines ctl,
326: ra_customer_trx ct,
327: ra_cust_trx_types ctt
328: WHERE ctl.request_id = p_request_id
329: AND ctl.customer_trx_id = ct.customer_trx_id
330: AND ct.batch_source_id NOT IN (20, 21)
331: AND ct.cust_trx_type_id = ctt.cust_trx_type_id

Line 389: ra_cust_trx_types ctt

385: l_user_id,
386: ctl.org_id
387: FROM ra_customer_trx_lines ctl,
388: ra_customer_trx ct,
389: ra_cust_trx_types ctt
390: WHERE ctl.request_id = p_request_id
391: AND ctl.customer_trx_id = ct.customer_trx_id
392: AND ct.batch_source_id NOT IN (20, 21)
393: AND ct.cust_trx_type_id = ctt.cust_trx_type_id

Line 448: ra_cust_trx_types ctt

444: l_user_id,
445: ctl.org_id
446: FROM ra_customer_trx_lines ctl,
447: ra_customer_trx ct,
448: ra_cust_trx_types ctt
449: WHERE ctl.customer_trx_line_id = p_customer_trx_line_id
450: AND ctl.customer_trx_id = ct.customer_trx_id
451: AND ct.batch_source_id NOT IN (20, 21)
452: AND ct.cust_trx_type_id = ctt.cust_trx_type_id

Line 1440: ra_cust_trx_types ctt,

1436: l_user_id,
1437: plc.org_id
1438: FROM ra_customer_trx ct,
1439: ra_customer_trx_lines ctl,
1440: ra_cust_trx_types ctt,
1441: ra_interface_lines il,
1442: ar_line_conts plc
1443: WHERE ct.request_id = p_request_id
1444: AND ct.cust_trx_type_id = ctt.cust_trx_type_id

Line 1535: ra_cust_trx_types ctt

1531: FROM
1532: ra_customer_trx ct,
1533: ra_customer_trx_lines ctl,
1534: hz_customer_profiles hcp,
1535: ra_cust_trx_types ctt
1536: WHERE (ctl.customer_trx_line_id = p_customer_trx_line_id)
1537: AND ct.cust_trx_type_id = ctt.cust_trx_type_id
1538: AND ctt.type = 'INV'
1539: AND ct.customer_trx_id = ctl.customer_trx_id

Line 1584: ra_cust_trx_types ctt

1580: FROM
1581: ra_customer_trx ct,
1582: ra_customer_trx_lines ctl,
1583: hz_customer_profiles hcp,
1584: ra_cust_trx_types ctt
1585: WHERE ct.request_id = p_request_id
1586: AND ct.cust_trx_type_id = ctt.cust_trx_type_id
1587: AND ctt.type = 'INV'
1588: AND ct.customer_trx_id = ctl.customer_trx_id

Line 1684: ra_cust_trx_types ctt

1680: FROM fun_rule_bulk_result_gt rbr,
1681: ar_deferral_reasons dr,
1682: ra_customer_trx_lines ctl,
1683: ra_customer_trx ct,
1684: ra_cust_trx_types ctt
1685: WHERE rbr.result_value = dr.contingency_id
1686: AND rbr.id = ctl.customer_trx_line_id
1687: AND ctl.customer_trx_id = ct.customer_trx_id
1688: AND ctl.request_id = p_request_id -- 7039838

Line 1756: ra_cust_trx_types ctt

1752: FROM fun_rule_bulk_result_gt rbr,
1753: ar_deferral_reasons dr,
1754: ra_customer_trx_lines ctl,
1755: ra_customer_trx ct,
1756: ra_cust_trx_types ctt
1757: WHERE rbr.result_value = dr.contingency_id
1758: AND rbr.id = ctl.customer_trx_line_id
1759: AND ctl.customer_trx_id = ct.customer_trx_id
1760: AND ct.cust_trx_type_id = ctt.cust_trx_type_id

Line 1863: ra_cust_trx_types ctt,

1859: l_user_id,
1860: thg.org_id
1861: FROM ar_trx_lines_gt tlg,
1862: ar_trx_header_gt thg,
1863: ra_cust_trx_types ctt,
1864: ar_trx_contingencies_gt tcg,
1865: ar_deferral_reasons dr
1866: WHERE tlg.request_id = p_request_id
1867: AND tlg.trx_header_id = thg.trx_header_id

Line 1969: ra_cust_trx_types ctt,

1965: sysdate,
1966: ct.org_id
1967: FROM ra_customer_trx_lines ctl,
1968: ra_customer_trx ct,
1969: ra_cust_trx_types ctt,
1970: ar_interface_conts ic,
1971: ar_deferral_reasons dr
1972: WHERE ctl.request_id = p_request_id
1973: AND ctl.customer_trx_id = ct.customer_trx_id