[Home] [Help]
264: tty.name CAT_CODE ,
265: te.entity_id ENTITY_ID
266: FROM
267: ra_customer_trx_all ct,
268: ra_cust_trx_line_gl_dist_all ctlgd,
269: xla_upgrade_dates gps,
270: ar_system_parameters_all sys,
271: ra_cust_trx_types_all tty,
272: ra_cust_trx_line_gl_dist_all ctlgd1,
268: ra_cust_trx_line_gl_dist_all ctlgd,
269: xla_upgrade_dates gps,
270: ar_system_parameters_all sys,
271: ra_cust_trx_types_all tty,
272: ra_cust_trx_line_gl_dist_all ctlgd1,
273: xla_transaction_entities_upg te
274: WHERE ct.rowid >= l_start_rowid
275: AND ct.rowid <= l_end_rowid
276: AND NVL(ct.ax_accounted_flag,'N') = 'N'
373: ar_receivable_applications_all app,
374: xla_upgrade_dates gps,
375: ar_system_parameters_all sys,
376: ra_cust_trx_types_all tty,
377: ra_cust_trx_line_gl_dist_all ctlgd,
378: xla_transaction_entities_upg te
379: WHERE ct.rowid >= l_start_rowid
380: AND ct.rowid <= l_end_rowid
381: AND NVL(ct.ax_accounted_flag,'N') = 'N'
658: 'REV', 'REVENUE',
659: 'UNEARN', 'UNEARNED_REVENUE',
660: 'ROUND', 'ROUNDING',
661: ctlgd.account_class) account_class,
662: 'RA_CUST_TRX_LINE_GL_DIST_ALL' source_table,
663: ctlgd.code_combination_id code_combination_id,
664: decode(ctlgd.account_class,
665: 'REC', decode(sign(ctlgd.amount),
666: 1, abs(ctlgd.amount),
721: hdr.ledger_id ledger_id,
722: 1 ln_order
723: from
724: ra_customer_trx_all ct,
725: ra_cust_trx_line_gl_dist_all ctlgd,
726: xla_upgrade_dates gps,
727: xla_transaction_entities_upg ent,
728: xla_events ev,
729: xla_ae_headers hdr,
3220: AND LNK.APPLICATION_ID = 222
3221: AND LNK.SOURCE_DISTRIBUTION_ID_NUM_1 = GIMP.REFERENCE_3
3222: AND LNK.SOURCE_DISTRIBUTION_TYPE =
3223: (CASE WHEN GIMP.REFERENCE_10 = 'RA_CUST_TRX_LINE_GL_DIST'
3224: THEN 'RA_CUST_TRX_LINE_GL_DIST_ALL'
3225: WHEN GIMP.REFERENCE_10 IN
3226: ('AR_TRANSACTION_HISTORY','AR_ADJUSTMENTS',
3227: 'AR_MISC_CASH_DISTRIBUTIONS',
3228: 'AR_RECEIVABLE_APPLICATIONS', 'AR_CASH_RECEIPT_HISTORY')