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_UNACCOUNTED_TRX_SWEEP dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 53: UPDATE ar_receivable_applications_all

49:
50: arp_standard.debug ('update_ar_acct_date: total records updated in ra_cust_trx_line_gl_dist_all: '||sql%rowcount);
51:
52: <>
53: UPDATE ar_receivable_applications_all
54: SET gl_date = g_sweep_to_date,
55: program_id = ln_conc_program_id,
56: last_update_date = sysdate,
57: last_updated_by = FND_GLOBAL.user_id

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

62: AND EXISTS
63: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id))
64: AND posting_control_id = -3;
65:
66: arp_standard.debug ('update_ar_acct_date: total records updated in ar_receivable_applications_all: '||sql%rowcount);
67:
68: <>
69: UPDATE ar_cash_receipt_history_all
70: SET gl_date = g_sweep_to_date,

Line 85: UPDATE ar_receivable_applications_all

81:
82: arp_standard.debug ('update_ar_acct_date: total records updated in ar_cash_receipt_history_all: '||sql%rowcount);
83:
84: <>
85: UPDATE ar_receivable_applications_all
86: SET gl_date = g_sweep_to_date,
87: program_id = ln_conc_program_id,
88: last_update_date = sysdate,
89: last_updated_by = FND_GLOBAL.user_id

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

94: AND EXISTS
95: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id))
96: AND posting_control_id = -3;
97:
98: arp_standard.debug ('update_ar_acct_date: total records updated in ar_receivable_applications_all: '||sql%rowcount);
99:
100: <>
101: UPDATE ar_misc_cash_distributions_all
102: SET gl_date = g_sweep_to_date,

Line 161: from ar_receivable_applications_all ra, ar_period_close_excps_gt psi

157: ps.gl_date_closed = decode(ps.status,
158: 'CL', (SELECT MAX(a.gl_date)
159: from (
160: select psi.payment_schedule_id payment_schedule_id, max(ra.gl_date) gl_date
161: from ar_receivable_applications_all ra, ar_period_close_excps_gt psi
162: where ra.status = 'APP'
163: and ra.payment_schedule_id = psi.payment_schedule_id
164: group by psi.payment_schedule_id
165: union all

Line 167: from ar_receivable_applications_all ra, ar_period_close_excps_gt psi

163: and ra.payment_schedule_id = psi.payment_schedule_id
164: group by psi.payment_schedule_id
165: union all
166: select psi.payment_schedule_id payment_schedule_id, max(ra.gl_date) gl_date
167: from ar_receivable_applications_all ra, ar_period_close_excps_gt psi
168: where ra.status = 'APP'
169: and ra.applied_payment_schedule_id = psi.payment_schedule_id
170: group by psi.payment_schedule_id
171: union all

Line 201: from ar_receivable_applications_all rai, ar_period_close_excps_gt gt

197: update ar_payment_schedules_all ps
198: set ps.gl_date_closed = g_sweep_to_date,
199: last_update_date = sysdate
200: where payment_schedule_id in (select rai.applied_payment_schedule_id
201: from ar_receivable_applications_all rai, ar_period_close_excps_gt gt
202: where rai.payment_schedule_id = gt.payment_schedule_id
203: and rai.application_type = 'CASH'
204: and rai.applied_payment_schedule_id is not null
205: and rai.applied_payment_schedule_id > 0

Line 212: from ar_receivable_applications_all rai, ar_period_close_excps_gt gt

208: AND EXISTS
209: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id)
210: union
211: select rai.payment_schedule_id
212: from ar_receivable_applications_all rai, ar_period_close_excps_gt gt
213: where rai.payment_schedule_id = gt.payment_schedule_id
214: and rai.application_type = 'CASH'
215: and gt.document_type = G_SRC_TYP_UNACCT_RCT
216: and gt.dist_source_table = 'RA'

Line 221: from ar_receivable_applications_all rai, ar_period_close_excps_gt gt

217: AND EXISTS
218: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id)
219: union
220: select rai.payment_schedule_id
221: from ar_receivable_applications_all rai, ar_period_close_excps_gt gt
222: where rai.payment_schedule_id = gt.payment_schedule_id
223: and rai.application_type = 'CM'
224: and rai.payment_schedule_id is not null
225: and gt.document_type = G_SRC_TYP_UNACCT_TRX

Line 231: from ar_receivable_applications_all rai, ar_period_close_excps_gt gt

227: AND EXISTS
228: ( SELECT 'X' FROM AR_SYSTEM_PARAMETERS where org_id = gt.org_id)
229: union
230: select rai.applied_payment_schedule_id
231: from ar_receivable_applications_all rai, ar_period_close_excps_gt gt
232: where rai.payment_schedule_id = gt.payment_schedule_id
233: and rai.application_type = 'CM'
234: and rai.payment_schedule_id is not null
235: and gt.document_type = G_SRC_TYP_UNACCT_TRX

Line 264: from ar_receivable_applications_all ra, ar_period_close_excps_gt psi

260: ps.gl_date_closed = decode(ps.status,
261: 'CL', (SELECT MAX(a.gl_date)
262: from (
263: select psi.payment_schedule_id payment_schedule_id, max(ra.gl_date) gl_date
264: from ar_receivable_applications_all ra, ar_period_close_excps_gt psi
265: where ra.payment_schedule_id = psi.payment_schedule_id
266: group by psi.payment_schedule_id
267: ) a, ar_payment_schedules_all ps2
268: where ps2.payment_schedule_id = a.payment_schedule_id

Line 295: from ar_receivable_applications_all ra, ar_period_close_excps_gt psi

291: ps.gl_date_closed = decode(ps.status,
292: 'CL', (SELECT MAX(a.gl_date)
293: from (
294: select psi.payment_schedule_id payment_schedule_id, max(ra.gl_date) gl_date
295: from ar_receivable_applications_all ra, ar_period_close_excps_gt psi
296: where ra.status = 'APP'
297: and ra.payment_schedule_id = psi.payment_schedule_id
298: group by psi.payment_schedule_id
299: union all

Line 301: from ar_receivable_applications_all ra, ar_period_close_excps_gt psi

297: and ra.payment_schedule_id = psi.payment_schedule_id
298: group by psi.payment_schedule_id
299: union all
300: select psi.payment_schedule_id payment_schedule_id, max(ra.gl_date) gl_date
301: from ar_receivable_applications_all ra, ar_period_close_excps_gt psi
302: where ra.status = 'APP'
303: and ra.applied_payment_schedule_id = psi.payment_schedule_id
304: group by psi.payment_schedule_id
305: union all

Line 734: , ar_receivable_applications_all ra

730: , ct.bill_to_customer_id
731: , ps.payment_schedule_id
732: , ra.applied_payment_schedule_id
733: from ra_customer_trx_all ct
734: , ar_receivable_applications_all ra
735: , xla_events xle
736: , ar_distributions_all ard
737: , ar_payment_schedules_all ps
738: WHERE ct.complete_flag = 'Y'

Line 972: , ar_receivable_applications_all ra

968: , cr.pay_from_customer
969: , ps.payment_schedule_id
970: , ra.applied_payment_schedule_id
971: FROM ar_cash_receipts_all cr
972: , ar_receivable_applications_all ra
973: , xla_events xle
974: , ar_distributions_all ard
975: , ar_payment_schedules_all ps
976: WHERE cr.cash_receipt_id = ra.cash_receipt_id

Line 1245: FROM ar_period_close_excps_gt pce, ar_receivable_applications_all ra

1241: <>
1242: UPDATE ar_period_close_excps_gt
1243: SET document_type = G_SRC_TYP_OTHER_EXCPS
1244: WHERE customer_trx_id IN (SELECT pce.customer_trx_id
1245: FROM ar_period_close_excps_gt pce, ar_receivable_applications_all ra
1246: WHERE pce.document_type = G_SRC_TYP_UNACCT_TRX
1247: AND pce.account_class = 'REC'
1248: AND pce.customer_trx_id = ra.customer_trx_id
1249: AND ra.gl_date between pce.gl_date and g_period_end_date

Line 1253: FROM ar_period_close_excps_gt pce, ar_receivable_applications_all ra

1249: AND ra.gl_date between pce.gl_date and g_period_end_date
1250: AND ra.posting_control_id <> -3
1251: UNION
1252: SELECT pce.customer_trx_id
1253: FROM ar_period_close_excps_gt pce, ar_receivable_applications_all ra
1254: WHERE pce.document_type = G_SRC_TYP_UNACCT_TRX
1255: AND pce.account_class = 'REC'
1256: AND pce.customer_trx_id = ra.applied_customer_trx_id
1257: AND ra.gl_date between pce.gl_date and g_period_end_date

Line 1267: FROM ar_period_close_excps_gt pce, ar_receivable_applications_all ra

1263: <>
1264: UPDATE ar_period_close_excps_gt
1265: SET document_type = G_SRC_TYP_OTHER_EXCPS
1266: WHERE cash_receipt_id IN (SELECT pce.customer_trx_id
1267: FROM ar_period_close_excps_gt pce, ar_receivable_applications_all ra
1268: WHERE pce.document_type = G_SRC_TYP_UNACCT_RCT
1269: AND ra.receivable_application_id = pce.dist_source_id
1270: AND pce.dist_source_table = 'RA'
1271: AND ra.gl_date between pce.gl_date and g_period_end_date