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 594: 'RA_CUST_TRX_LINE_GL_DIST_ALL' source_table,

590: hdr1.ae_header_id header_id,
591: hdr.event_id event_id,
592: ctlgd.set_of_books_id sob_id,
593: ctlgd.account_class account_class,
594: 'RA_CUST_TRX_LINE_GL_DIST_ALL' source_table,
595: gld.code_combination_id code_combination_id,
596: decode(ctlgd.account_class,
597: 'REC', decode(sign(ctlgd.amount),
598: 1, abs(ctlgd.amount),

Line 645: ra_cust_trx_line_gl_dist_all gld,

641: 1 ln_order
642: --
643: from ra_mc_customer_trx ct,
644: ra_customer_trx_all trx,
645: ra_cust_trx_line_gl_dist_all gld,
646: xla_upgrade_dates gps,
647: ra_mc_trx_line_gl_dist ctlgd,
648: xla_distribution_links dl,
649: xla_ae_headers hdr,

Line 670: and dl.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'

666: and ctlgd.posting_control_id <> -3
667: and ctlgd.set_of_books_id = ct.set_of_books_id
668: --
669: and dl.source_distribution_id_num_1 = ctlgd.cust_trx_line_gl_dist_id
670: and dl.source_distribution_type = 'RA_CUST_TRX_LINE_GL_DIST_ALL'
671: and dl.application_id = 222
672: and dl.upg_batch_id = l_batch_id
673: --
674: and hdr.ae_header_id = dl.ae_header_id