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_PAYMENT_SCHEDULES_ALL

Line 152: update ar_payment_schedules_all ps

148:
149: <>
150: -- TRX
151:
152: update ar_payment_schedules_all ps
153: set ps.gl_date = ( select nvl(min(gl_date), ps.gl_date)
154: from ra_cust_trx_line_gl_dist_all
155: where customer_trx_id = ps.customer_trx_id
156: and latest_rec_flag = 'Y'),

Line 178: ) a, ar_payment_schedules_all ps2

174: where adj.status = 'A'
175: and adj.amount <> 0
176: and adj.payment_schedule_id = psi.payment_schedule_id
177: group by psi.payment_schedule_id
178: ) a, ar_payment_schedules_all ps2
179: where ps2.payment_schedule_id = a.payment_schedule_id
180: and ps2.payment_schedule_id = ps.payment_schedule_id
181: group by a.payment_schedule_id
182: ),

Line 197: update ar_payment_schedules_all ps

193: );
194:
195: -- Applied trx/cm app/rec app/Adj
196:
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

Line 255: update ar_payment_schedules_all ps

251:
252:
253: -- PMT
254:
255: update ar_payment_schedules_all ps
256: set ps.gl_date = ( select nvl(min(gl_date), ps.gl_date)
257: from ar_cash_receipt_history_all
258: where cash_receipt_id = ps.cash_receipt_id
259: and first_posted_record_flag = 'Y'),

Line 267: ) a, ar_payment_schedules_all ps2

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
269: and ps2.payment_schedule_id = ps.payment_schedule_id
270: group by a.payment_schedule_id
271: ),

Line 286: update ar_payment_schedules_all ps

282: );
283:
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'),

Line 312: ) a, ar_payment_schedules_all ps2

308: where adj.status = 'A'
309: and adj.amount <> 0
310: and adj.payment_schedule_id = psi.payment_schedule_id
311: group by psi.payment_schedule_id
312: ) a, ar_payment_schedules_all ps2
313: where ps2.payment_schedule_id = a.payment_schedule_id
314: and ps2.payment_schedule_id = ps.payment_schedule_id
315: group by a.payment_schedule_id
316: ),

Line 656: ,ar_payment_schedules_all ps

652: from
653: ra_customer_trx_all ct
654: ,ra_cust_trx_line_gl_dist_all gld
655: ,xla_events xle
656: ,ar_payment_schedules_all ps
657: WHERE ct.complete_flag = 'Y'
658: and ct.customer_trx_id = gld.customer_trx_id
659: and gld.account_set_flag = 'N'
660: and gld.gl_date between g_period_start_date and g_period_end_date

Line 737: , ar_payment_schedules_all ps

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'
739: and ct.customer_trx_id = ra.customer_trx_id
740: and ra.gl_date between g_period_start_date and g_period_end_date
741: and ra.posting_control_id = -3

Line 820: , ar_payment_schedules_all ps

816: FROM ar_cash_receipts_all cr
817: , ar_cash_receipt_history_all crh
818: , xla_events xle
819: , ar_distributions_all ard
820: , ar_payment_schedules_all ps
821: WHERE cr.cash_receipt_id = crh.cash_receipt_id
822: and cr.set_of_books_id = g_ledger_id
823: and crh.gl_date between g_period_start_date and g_period_end_date
824: and crh.posting_control_id = -3

Line 975: , ar_payment_schedules_all ps

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
977: and cr.set_of_books_id = g_ledger_id
978: and ra.gl_date between g_period_start_date and g_period_end_date
979: and ra.posting_control_id = -3

Line 1134: , ar_payment_schedules_all ps

1130: FROM ar_adjustments_all adj
1131: , ar_distributions_all ard
1132: , xla_events xle
1133: , ra_customer_trx_all ct
1134: , ar_payment_schedules_all ps
1135: WHERE adj.set_of_books_id = g_ledger_id
1136: and adj.gl_date between g_period_start_date and g_period_end_date
1137: and adj.posting_control_id = -3
1138: and NVL(postable, 'Y') = 'Y'

Line 1217: , ar_payment_schedules_all ps

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
1218: WHERE th.gl_date between g_period_start_date and g_period_end_date
1219: and th.posting_control_id = -3
1220: and NVL(th.postable_flag, 'Y') = 'Y'
1221: and th.transaction_history_id = ard.source_id