[Home] [Help]
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
93: and gldist0.customer_trx_id = racust0.customer_trx_id
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
137: and racust1.bill_to_customer_id = hzcus1.cust_account_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
174: and cash2.cash_receipt_id = recapp2.cash_receipt_id
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
210: and recapp3.customer_trx_id = cm3.customer_trx_id
211: and recapp3.applied_customer_trx_id = inv3.customer_trx_id
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
247: and cash4.pay_from_customer is not null
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
283: and adj5.customer_trx_id = racust5.customer_trx_id
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'
321: and hist6.cash_receipt_id = cash6.cash_receipt_id
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'
358: and hist6b.cash_receipt_id = cash6b.cash_receipt_id
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
399: and cm7.customer_trx_id = recapp7.customer_trx_id
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
437: and gldist8.account_class = 'REC'
438: and gldist8.customer_trx_id = adj8.customer_trx_id