DBA Data[Home] [Help]

APPS.ARP_XLA_UPGRADE dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

Line 268: ra_cust_trx_line_gl_dist_all ctlgd,

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,

Line 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'

Line 377: ra_cust_trx_line_gl_dist_all ctlgd,

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'

Line 662: 'RA_CUST_TRX_LINE_GL_DIST_ALL' source_table,

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

Line 725: ra_cust_trx_line_gl_dist_all ctlgd,

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,

Line 3410: THEN 'RA_CUST_TRX_LINE_GL_DIST_ALL'

3406: AND LNK.APPLICATION_ID = 222
3407: AND LNK.SOURCE_DISTRIBUTION_ID_NUM_1 = GIMP.REFERENCE_3
3408: AND LNK.SOURCE_DISTRIBUTION_TYPE =
3409: (CASE WHEN GIMP.REFERENCE_10 = 'RA_CUST_TRX_LINE_GL_DIST'
3410: THEN 'RA_CUST_TRX_LINE_GL_DIST_ALL'
3411: WHEN GIMP.REFERENCE_10 IN
3412: ('AR_TRANSACTION_HISTORY','AR_ADJUSTMENTS',
3413: 'AR_MISC_CASH_DISTRIBUTIONS',
3414: 'AR_RECEIVABLE_APPLICATIONS', 'AR_CASH_RECEIPT_HISTORY')

Line 3743: ra_cust_trx_line_gl_dist_all ctlgd

3739: ar_cash_receipts_all cr,
3740: xla_events ev,
3741: xla_ae_headers hdr,
3742: ar_cash_basis_dists_all cbs,
3743: ra_cust_trx_line_gl_dist_all ctlgd
3744: where app.rowid >= l_start_rowid
3745: and app.rowid <= l_end_rowid
3746: and nvl(app.postable,'Y') = 'Y'
3747: and nvl(app.confirmed_flag,'Y') = 'Y'

Line 5090: ra_cust_trx_line_gl_dist_all ctlgd

5086: ar_cash_receipts_all cr,
5087: xla_events ev,
5088: xla_ae_headers hdr,
5089: ar_cash_basis_dists_all cbs,
5090: ra_cust_trx_line_gl_dist_all ctlgd
5091: where nvl(app.postable,'Y') = 'Y'
5092: and cr.cash_receipt_id = p_cash_receipt_id
5093: and nvl(sys.org_id,-9999) = nvl(cr.org_id, -9999)
5094: and sys.accounting_method = 'CASH'