[Home] [Help]
82: FROM ra_cust_trx_line_gl_dist gldist0,
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
126: FROM ra_cust_trx_line_gl_dist gldist1,
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
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
175: and cash2.pay_from_customer = hzcus2.cust_account_id
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
210: and recapp3.customer_trx_id = cm3.customer_trx_id
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
248: and cash4.pay_from_customer = hzcus4.cust_account_id
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
284: and racust5.bill_to_customer_id = hzcus5.cust_account_id
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
322: and cash6.pay_from_customer is not null
348: cash6b.org_id
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
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
397: and gldist7.account_class = 'REC'
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
437: and gldist8.account_class = 'REC'