APPS.AR_REVENUE_MANAGEMENT_PVT dependencies on AR_TRX_ERRORS_GT

Line 121: FROM ar_trx_errors_gt teg,

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

Line 339: FROM ar_trx_errors_gt teg,

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

Line 1286: FROM ar_trx_errors_gt teg,

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

Line 1876: FROM ar_trx_errors_gt err

1872: AND tlg.trx_line_id = tcg.trx_line_id
1873: AND tcg.contingency_id = dr.contingency_id
1874: AND NOT EXISTS
1875: ( SELECT 'errors exist'
1876: FROM ar_trx_errors_gt err
1877: WHERE err.trx_header_id = tlg.trx_header_id
1878: AND err.trx_line_id = tlg.trx_line_id
1879: );
1880:

Line 2398: INSERT INTO ar_trx_errors_gt

2394:
2395: -- we will not validate against start and end date until we expose
2396: -- the table.
2397:
2398: INSERT INTO ar_trx_errors_gt
2399: (
2400: trx_header_id,
2401: trx_line_id,
2402: trx_contingency_id,

Line 2439: INSERT INTO ar_trx_errors_gt

2435: contingencies. We allow import with expiration_date
2436: on completed ones and use that date to set the
2437: event removal date accordingly */
2438:
2439: INSERT INTO ar_trx_errors_gt
2440: (
2441: trx_header_id,
2442: trx_line_id,
2443: trx_contingency_id,

Line 5793: delete from ar_trx_errors_gt;

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