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,
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,
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,
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,
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,
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,
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,
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,