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 AR_TRX_LINES_GT

Line 128: ar_trx_lines_gt tlg

124: AND NVL(ctl.deferral_exclusion_flag, 'N') = 'N'
125: AND NOT EXISTS
126: (SELECT 'errors'
127: FROM ar_trx_errors_gt teg,
128: ar_trx_lines_gt tlg
129: WHERE teg.trx_header_id = tlg.trx_header_id
130: AND teg.trx_line_id = tlg.trx_line_id
131: AND tlg.customer_trx_line_id = ctl.customer_trx_line_id)
132: AND NOT EXISTS

Line 364: ar_trx_lines_gt tlg

360: (ct.bill_to_customer_id, ct.bill_to_site_use_id)= 0
361: AND NOT EXISTS
362: (SELECT 'errors'
363: FROM ar_trx_errors_gt teg,
364: ar_trx_lines_gt tlg
365: WHERE teg.trx_header_id = tlg.trx_header_id
366: AND teg.trx_line_id = tlg.trx_line_id
367: AND tlg.customer_trx_line_id = ctl.customer_trx_line_id)
368: AND NOT EXISTS

Line 1354: ar_trx_lines_gt tlg

1350: FROM ar_line_conts
1351: WHERE customer_trx_line_id IN
1352: (SELECT customer_trx_line_id
1353: FROM ar_trx_errors_gt teg,
1354: ar_trx_lines_gt tlg
1355: WHERE teg.trx_header_id = tlg.trx_header_id
1356: AND teg.trx_line_id = tlg.trx_line_id
1357: AND request_id = p_request_id);
1358:

Line 1965: FROM ar_trx_lines_gt tlg,

1961: l_user_id,
1962: sysdate,
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,

Line 2214: ar_trx_lines_gt tlg,

2210: l_user_id,
2211: sysdate,
2212: thg.org_id
2213: FROM ar_trx_header_gt thg,
2214: ar_trx_lines_gt tlg,
2215: ar_trx_contingencies_gt tcg,
2216: ar_line_conts lrc
2217: WHERE tlg.request_id = p_request_id
2218: AND tlg.customer_trx_id = thg.customer_trx_id

Line 2274: ar_trx_lines_gt tlg,

2270: l_user_id,
2271: sysdate,
2272: thg.org_id
2273: FROM ar_trx_header_gt thg,
2274: ar_trx_lines_gt tlg,
2275: ar_line_conts lrc
2276: WHERE tlg.request_id = p_request_id
2277: AND tlg.customer_trx_id = thg.customer_trx_id
2278: AND tlg.customer_trx_line_id = lrc.customer_trx_line_id

Line 2559: FROM ar_trx_lines_gt lgt,

2555: lgt.trx_line_id,
2556: cgt.trx_contingency_id,
2557: arp_standard.fnd_message('AR_RVMG_INVALID_CONTINGENCY'),
2558: cgt.contingency_id
2559: FROM ar_trx_lines_gt lgt,
2560: ar_trx_header_gt hgt,
2561: ar_trx_contingencies_gt cgt
2562: WHERE lgt.trx_header_id = hgt.trx_header_id
2563: AND cgt.trx_line_id = lgt.trx_line_id

Line 2600: FROM ar_trx_lines_gt lgt,

2596: lgt.trx_line_id,
2597: cgt.trx_contingency_id,
2598: arp_standard.fnd_message('AR_RVMG_NO_EXP_DATE'),
2599: cgt.contingency_id
2600: FROM ar_trx_lines_gt lgt,
2601: ar_trx_header_gt hgt,
2602: ar_trx_contingencies_gt cgt,
2603: ar_deferral_reasons dr
2604: WHERE lgt.trx_header_id = hgt.trx_header_id

Line 5984: delete from ar_trx_lines_gt;

5980: Delete the data in the global temporary tables */
5981: delete from ar_rdr_parameters_gt;
5982: delete from ar_trx_errors_gt;
5983: delete from ar_trx_header_gt;
5984: delete from ar_trx_lines_gt;
5985: delete from ar_reviewed_lines_gt;
5986: delete from fun_rule_bulk_result_gt;
5987: delete from ar_trx_contingencies_gt;
5988: