APPS.ARP_MRC_XLA_UPGRADE dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

Line 213: ra_cust_trx_line_gl_dist_all gld,

209: ctlgd.set_of_books_id sob_id
210: --
211: from ra_mc_customer_trx ct,
212: ra_customer_trx_all trx,
213: ra_cust_trx_line_gl_dist_all gld,
214: xla_upgrade_dates gps,
215: ra_mc_trx_line_gl_dist ctlgd,
216: xla_distribution_links dl,
217: xla_ae_headers hdr

Line 237: and dl.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

233: and ctlgd.posting_control_id <> -3
234: and ctlgd.set_of_books_id = ct.set_of_books_id
235: --
236: and dl.source_distribution_id_num_1 = ctlgd.cust_trx_line_gl_dist_id
237: and dl.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
238: and dl.application_id = 222
239: and dl.upg_batch_id = l_batch_id
240: --
241: and hdr.ae_header_id = dl.ae_header_id

Line 598: 'RA_CUST_TRX_LINE_GL_DIST_ALL' source_table,

594: 'REV', 'REVENUE',
595: 'UNEARN', 'UNEARNED_REVENUE',
596: 'ROUND', 'ROUNDING',
597: ctlgd.account_class) account_class,
598: 'RA_CUST_TRX_LINE_GL_DIST_ALL' source_table,
599: gld.code_combination_id code_combination_id,
600: decode(ctlgd.account_class,
601: 'REC', decode(sign(ctlgd.amount),
602: 1, abs(ctlgd.amount),

Line 649: ra_cust_trx_line_gl_dist_all gld,

645: 1 ln_order
646: --
647: from ra_mc_customer_trx ct,
648: ra_customer_trx_all trx,
649: ra_cust_trx_line_gl_dist_all gld,
650: xla_upgrade_dates gps,
651: ra_mc_trx_line_gl_dist ctlgd,
652: xla_distribution_links dl,
653: xla_ae_headers hdr,

Line 674: and dl.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

670: and ctlgd.posting_control_id <> -3
671: and ctlgd.set_of_books_id = ct.set_of_books_id
672: --
673: and dl.source_distribution_id_num_1 = ctlgd.cust_trx_line_gl_dist_id
674: and dl.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
675: and dl.application_id = 222
676: and dl.upg_batch_id = l_batch_id
677: --
678: and hdr.ae_header_id = dl.ae_header_id