DBA Data[Home] [Help]

APPS.JL_BR_AR_BALANCE_MAINTENANCE dependencies on RA_CUSTOMER_TRX_ALL

Line 83: ra_customer_trx_all racust0,

79: decode(type0.type,'CM','Nota de Credito','Nota de Debito') hist,
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,

Line 127: ra_customer_trx_all racust1,

123: 'Entrada de Dcto' hist,
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,

Line 202: ra_customer_trx_all cm3,

198: 'Nota de Cred (Aplic.)' hist,
199: batch3.name bat, batch3.batch_id batid,
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,

Line 203: ra_customer_trx_all inv3,

199: batch3.name bat, batch3.batch_id batid,
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,

Line 275: ra_customer_trx_all racust5,

271: 'Ajuste' hist,
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,

Line 388: ra_customer_trx_all cm7,

384: 'Nota Cred (Cta Receb)' hist,
385: batch7.name bat, batch7.batch_id batid,
386: inv7.org_id
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,

Line 390: ra_customer_trx_all inv7,

386: inv7.org_id
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,

Line 429: ra_customer_trx_all racust8,

425: batch8.name bat, batch8.batch_id batid,
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,