APPS.AR_INVOICE_API_PUB dependencies on AR_TRX_HEADER_GT

Line 131: FROM ar_trx_header_gt hgt

127: UPDATE ar_trx_lines_gt lgt
128: SET (customer_trx_id, trx_date, org_id, set_of_books_id,currency_code) =
129: ( SELECT hgt.customer_trx_id, hgt.trx_date, hgt.org_id,
130: hgt.set_of_books_id, trx_currency
131: FROM ar_trx_header_gt hgt
132: WHERE lgt.trx_header_id = trx_header_id),
133: request_id = AR_INVOICE_TABLE_HANDLER.g_request_id;
134:
135: IF pg_debug = 'Y'

Line 196: ar_trx_header_gt h

192: line.customer_trx_line_id,
193: line.trx_header_id,
194: h.gl_date
195: FROM ar_trx_lines_gt line,
196: ar_trx_header_gt h
197: WHERE line.trx_line_id = dist.trx_line_id
198: AND line.trx_header_id = h.trx_header_id
199: UNION
200: SELECT h.customer_trx_id, null_column, h.trx_header_id, h.gl_date

Line 201: FROM ar_trx_header_gt h

197: WHERE line.trx_line_id = dist.trx_line_id
198: AND line.trx_header_id = h.trx_header_id
199: UNION
200: SELECT h.customer_trx_id, null_column, h.trx_header_id, h.gl_date
201: FROM ar_trx_header_gt h
202: WHERE h.trx_header_id = dist.trx_header_id
203: AND dist.account_class = 'REC');
204:
205:

Line 323: delete from ar_trx_header_gt;

319:
320: PROCEDURE clean_gt IS
321:
322: BEGIN
323: delete from ar_trx_header_gt;
324: delete from ar_trx_lines_gt;
325: delete from ar_trx_dist_gt;
326: delete from ar_trx_salescredits_gt;
327: --delete from ar_trx_errors_gt;