DBA Data[Home] [Help]

APPS.JL_BR_AR_BALANCE_MAINTENANCE dependencies on HZ_CUST_ACCOUNTS_ALL

Line 84: hz_cust_accounts_all hzcus0,

80: batch0.name bat, batch0.batch_id batid,
81: racust0.org_id
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,

Line 128: hz_cust_accounts_all hzcus1,

124: batch1.name bat, batch1.batch_id batid,
125: racust1.org_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,

Line 168: hz_cust_accounts_all hzcus2,

164: batch2.name bat, batch2.batch_id batid,
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

Line 204: hz_cust_accounts_all hzcus3,

200: inv3.org_id
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

Line 240: hz_cust_accounts_all hzcus4,

236: batch4.name bat, batch4.batch_id batid,
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

Line 276: hz_cust_accounts_all hzcus5,

272: batch5.name bat, batch5.batch_id batid,
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,

Line 314: hz_cust_accounts_all hzcus6,

310: batch6.name bat, batch6.batch_id batid,
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

Line 351: hz_cust_accounts_all hzcus6b,

347: batch6b.name bat, batch6b.batch_id batid,
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

Line 391: hz_cust_accounts_all hzcus7,

387: FROM ra_cust_trx_line_gl_dist gldist7,
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

Line 430: hz_cust_accounts_all hzcus8,

426: racust8.org_id
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,