APPS.AR_UNACCOUNTED_TRX_SWEEP dependencies on AR_TRANSACTION_HISTORY_ALL

Line 133: UPDATE ar_transaction_history_all

129:
130: arp_standard.debug ('update_ar_acct_date: total records updated in ar_adjustments_all: '||sql%rowcount);
131:
132: <>
133: UPDATE ar_transaction_history_all
134: SET gl_date = g_sweep_to_date,
135: program_id = ln_conc_program_id,
136: last_update_date = sysdate,
137: last_updated_by = FND_GLOBAL.user_id

Line 146: arp_standard.debug ('update_ar_acct_date: total records updated in ar_transaction_history_all: '||sql%rowcount);

142: AND EXISTS
143: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id))
144: AND posting_control_id = -3;
145:
146: arp_standard.debug ('update_ar_acct_date: total records updated in ar_transaction_history_all: '||sql%rowcount);
147:
148:
149: <>
150: -- TRX

Line 288: from ar_transaction_history_all

284: -- BR
285:
286: update ar_payment_schedules_all ps
287: set ps.gl_date = ( select nvl(min(gl_date), ps.gl_date)
288: from ar_transaction_history_all
289: where customer_trx_id = ps.customer_trx_id
290: and first_posted_record_flag = 'Y'),
291: ps.gl_date_closed = decode(ps.status,
292: 'CL', (SELECT MAX(a.gl_date)

Line 324: from ar_transaction_history_all

320: WHERE EXISTS
321: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id))
322: and class = 'BR'
323: and trunc(ps.gl_date) <> ( select nvl(min(gl_date), ps.gl_date)
324: from ar_transaction_history_all
325: where customer_trx_id = ps.customer_trx_id
326: and first_posted_record_flag = 'Y'
327: );
328:

Line 1213: FROM ar_transaction_history_all th

1209: , ct.invoice_currency_code
1210: , ct.drawee_id
1211: , ps.payment_schedule_id
1212: , null
1213: FROM ar_transaction_history_all th
1214: , xla_events xle
1215: , ar_distributions_all ard
1216: , ra_customer_trx_all ct
1217: , ar_payment_schedules_all ps