APPS.AR_REVENUE_MANAGEMENT_PVT dependencies on AR_TRX_ERRORS_GT

Line 127: FROM ar_trx_errors_gt teg,

123: AND ct.term_id = tl.term_id
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)

Line 363: FROM ar_trx_errors_gt teg,

359: AND ar_revenue_management_pvt.creditworthy
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)

Line 1353: FROM ar_trx_errors_gt teg,

1349: DELETE
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);

Line 1985: FROM ar_trx_errors_gt err

1981: AND tlg.trx_line_id = tcg.trx_line_id
1982: AND tcg.contingency_id = dr.contingency_id
1983: AND NOT EXISTS
1984: ( SELECT 'errors exist'
1985: FROM ar_trx_errors_gt err
1986: WHERE err.trx_header_id = tlg.trx_header_id
1987: AND err.trx_line_id = tlg.trx_line_id
1988: );
1989:

Line 2545: INSERT INTO ar_trx_errors_gt

2541:
2542: -- we will not validate against start and end date until we expose
2543: -- the table.
2544:
2545: INSERT INTO ar_trx_errors_gt
2546: (
2547: trx_header_id,
2548: trx_line_id,
2549: trx_contingency_id,

Line 2586: INSERT INTO ar_trx_errors_gt

2582: contingencies. We allow import with expiration_date
2583: on completed ones and use that date to set the
2584: event removal date accordingly */
2585:
2586: INSERT INTO ar_trx_errors_gt
2587: (
2588: trx_header_id,
2589: trx_line_id,
2590: trx_contingency_id,

Line 5982: delete from ar_trx_errors_gt;

5978: mo_global.set_policy_context('S',morgs.org_id);
5979: /* Bug fix 5351734
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;