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 122: ar_trx_lines_gt tlg

118: AND NVL(ctl.deferral_exclusion_flag, 'N') = 'N'
119: AND NOT EXISTS
120: (SELECT 'errors'
121: FROM ar_trx_errors_gt teg,
122: ar_trx_lines_gt tlg
123: WHERE teg.trx_header_id = tlg.trx_header_id
124: AND teg.trx_line_id = tlg.trx_line_id
125: AND tlg.customer_trx_line_id = ctl.customer_trx_line_id)
126: AND NOT EXISTS

Line 340: ar_trx_lines_gt tlg

336: (ct.bill_to_customer_id, ct.bill_to_site_use_id)= 0
337: AND NOT EXISTS
338: (SELECT 'errors'
339: FROM ar_trx_errors_gt teg,
340: ar_trx_lines_gt tlg
341: WHERE teg.trx_header_id = tlg.trx_header_id
342: AND teg.trx_line_id = tlg.trx_line_id
343: AND tlg.customer_trx_line_id = ctl.customer_trx_line_id)
344: AND NOT EXISTS

Line 1287: ar_trx_lines_gt tlg

1283: FROM ar_line_conts
1284: WHERE customer_trx_line_id IN
1285: (SELECT customer_trx_line_id
1286: FROM ar_trx_errors_gt teg,
1287: ar_trx_lines_gt tlg
1288: WHERE teg.trx_header_id = tlg.trx_header_id
1289: AND teg.trx_line_id = tlg.trx_line_id
1290: AND request_id = p_request_id);
1291:

Line 1861: FROM ar_trx_lines_gt tlg,

1857: l_user_id,
1858: sysdate,
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

Line 2100: ar_trx_lines_gt tlg,

2096: l_user_id,
2097: sysdate,
2098: thg.org_id
2099: FROM ar_trx_header_gt thg,
2100: ar_trx_lines_gt tlg,
2101: ar_trx_contingencies_gt tcg,
2102: ar_line_conts lrc
2103: WHERE tlg.request_id = p_request_id
2104: AND tlg.customer_trx_id = thg.customer_trx_id

Line 2160: ar_trx_lines_gt tlg,

2156: l_user_id,
2157: sysdate,
2158: thg.org_id
2159: FROM ar_trx_header_gt thg,
2160: ar_trx_lines_gt tlg,
2161: ar_line_conts lrc
2162: WHERE tlg.request_id = p_request_id
2163: AND tlg.customer_trx_id = thg.customer_trx_id
2164: AND tlg.customer_trx_line_id = lrc.customer_trx_line_id

Line 2412: FROM ar_trx_lines_gt lgt,

2408: lgt.trx_line_id,
2409: cgt.trx_contingency_id,
2410: arp_standard.fnd_message('AR_RVMG_INVALID_CONTINGENCY'),
2411: cgt.contingency_id
2412: FROM ar_trx_lines_gt lgt,
2413: ar_trx_header_gt hgt,
2414: ar_trx_contingencies_gt cgt
2415: WHERE lgt.trx_header_id = hgt.trx_header_id
2416: AND cgt.trx_line_id = lgt.trx_line_id

Line 2453: FROM ar_trx_lines_gt lgt,

2449: lgt.trx_line_id,
2450: cgt.trx_contingency_id,
2451: arp_standard.fnd_message('AR_RVMG_NO_EXP_DATE'),
2452: cgt.contingency_id
2453: FROM ar_trx_lines_gt lgt,
2454: ar_trx_header_gt hgt,
2455: ar_trx_contingencies_gt cgt,
2456: ar_deferral_reasons dr
2457: WHERE lgt.trx_header_id = hgt.trx_header_id

Line 5795: delete from ar_trx_lines_gt;

5791: Delete the data in the global temporary tables */
5792: delete from ar_rdr_parameters_gt;
5793: delete from ar_trx_errors_gt;
5794: delete from ar_trx_header_gt;
5795: delete from ar_trx_lines_gt;
5796: delete from ar_reviewed_lines_gt;
5797: delete from fun_rule_bulk_result_gt;
5798: delete from ar_trx_contingencies_gt;
5799: