APPS.JL_BR_AR_BALANCE_MAINTENANCE dependencies on GL_SETS_OF_BOOKS

Line 88: gl_sets_of_books s0,

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
92: and racust0.bill_to_customer_id = hzcus0.cust_account_id

Line 132: gl_sets_of_books s1,

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
136: and gldist1.customer_trx_id = racust1.customer_trx_id

Line 169: gl_sets_of_books s2,

165: cash2.org_id
166: FROM ar_receivable_applications recapp2,
167: ar_cash_receipts_all cash2,
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

Line 208: gl_sets_of_books s3

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
210: and recapp3.customer_trx_id = cm3.customer_trx_id
211: and recapp3.applied_customer_trx_id = inv3.customer_trx_id
212: and inv3.bill_to_customer_id = hzcus3.cust_account_id

Line 242: gl_sets_of_books s4,

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
246: and misc4.cash_receipt_id = cash4.cash_receipt_id

Line 278: gl_sets_of_books s5,

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
282: WHERE adj5.posting_control_id = par_posting_control_id

Line 316: gl_sets_of_books s6,

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
320: and hist6.status = 'CLEARED'

Line 355: gl_sets_of_books s6b

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'
358: and hist6b.cash_receipt_id = cash6b.cash_receipt_id
359: and cash6b.status = 'REV'

Line 394: gl_sets_of_books s7,

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
397: and gldist7.account_class = 'REC'
398: and gldist7.customer_trx_id = cm7.customer_trx_id

Line 432: gl_sets_of_books s8,

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
436: WHERE gldist8.posting_control_id = par_posting_control_id