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.JL_BR_AR_BALANCE_MAINTENANCE dependencies on RA_BATCHES_ALL

Line 87: ra_batches_all batch0,

83: ra_customer_trx_all racust0,
84: hz_cust_accounts_all hzcus0,
85: ra_cust_trx_types_all type0,
86: gl_period_statuses glps0,
87: ra_batches_all batch0,
88: gl_sets_of_books s0,
89: gl_periods r0
90: WHERE gldist0.posting_control_id = par_posting_control_id
91: and gldist0.gl_date is not null

Line 131: ra_batches_all batch1,

127: ra_customer_trx_all racust1,
128: hz_cust_accounts_all hzcus1,
129: ra_cust_trx_types_all type1,
130: gl_period_statuses glps1,
131: ra_batches_all batch1,
132: gl_sets_of_books s1,
133: gl_periods r1
134: WHERE gldist1.posting_control_id = par_posting_control_id
135: and gldist1.gl_date is not null

Line 172: ra_batches_all batch2

168: hz_cust_accounts_all hzcus2,
169: gl_sets_of_books s2,
170: gl_periods r2,
171: gl_period_statuses glps2,
172: ra_batches_all batch2
173: WHERE recapp2.posting_control_id = par_posting_control_id
174: and cash2.cash_receipt_id = recapp2.cash_receipt_id
175: and cash2.pay_from_customer = hzcus2.cust_account_id
176: and cash2.selected_remittance_batch_id = batch2.batch_id (+)

Line 205: ra_batches_all batch3,

201: FROM ar_receivable_applications recapp3,
202: ra_customer_trx_all cm3,
203: ra_customer_trx_all inv3,
204: hz_cust_accounts_all hzcus3,
205: ra_batches_all batch3,
206: gl_period_statuses glps3,
207: gl_periods r3,
208: gl_sets_of_books s3
209: WHERE recapp3.posting_control_id = par_posting_control_id

Line 241: ra_batches_all batch4,

237: cash4.org_id
238: FROM ar_misc_cash_distributions misc4,
239: ar_cash_receipts_all cash4,
240: hz_cust_accounts_all hzcus4,
241: ra_batches_all batch4,
242: gl_sets_of_books s4,
243: gl_periods r4,
244: gl_period_statuses glps4
245: WHERE misc4.posting_control_id = par_posting_control_id

Line 277: ra_batches_all batch5,

273: racust5.org_id
274: FROM ar_adjustments adj5,
275: ra_customer_trx_all racust5,
276: hz_cust_accounts_all hzcus5,
277: ra_batches_all batch5,
278: gl_sets_of_books s5,
279: gl_periods r5,
280: gl_period_statuses glps5,
281: ar_distributions_all dis5

Line 315: ra_batches_all batch6,

311: cash6.org_id
312: FROM ar_cash_receipt_history hist6,
313: ar_cash_receipts_all cash6,
314: hz_cust_accounts_all hzcus6,
315: ra_batches_all batch6,
316: gl_sets_of_books s6,
317: gl_periods r6,
318: gl_period_statuses glps6
319: WHERE hist6.posting_control_id = par_posting_control_id

Line 353: ra_batches_all batch6b,

349: FROM ar_cash_receipt_history hist6b,
350: ar_cash_receipts_all cash6b,
351: hz_cust_accounts_all hzcus6b,
352: gl_period_statuses glps6b,
353: ra_batches_all batch6b,
354: gl_periods r6b,
355: gl_sets_of_books s6b
356: WHERE hist6b.posting_control_id = par_posting_control_id
357: and hist6b.status = 'CLEARED'

Line 392: ra_batches_all batch7,

388: ra_customer_trx_all cm7,
389: ar_receivable_applications_all recapp7,
390: ra_customer_trx_all inv7,
391: hz_cust_accounts_all hzcus7,
392: ra_batches_all batch7,
393: gl_period_statuses glps7,
394: gl_sets_of_books s7,
395: gl_periods r7
396: WHERE gldist7.posting_control_id = par_posting_control_id

Line 431: ra_batches_all batch8,

427: FROM ra_cust_trx_line_gl_dist gldist8,
428: ar_adjustments_all adj8,
429: ra_customer_trx_all racust8,
430: hz_cust_accounts_all hzcus8,
431: ra_batches_all batch8,
432: gl_sets_of_books s8,
433: gl_period_statuses glps8,
434: gl_periods r8,
435: ar_distributions_all dis8