eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_MRC_XLA_UPGRADE dependencies on AR_DISTRIBUTIONS_ALL

Line 306: and dl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

302: and dist.set_of_books_id = app.set_of_books_id
303: and dist.source_table = 'RA'
304: --
305: and dl.source_distribution_id_num_1 = dist.line_id
306: and dl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
307: and dl.application_id = 222
308: and dl.upg_batch_id = l_batch_id
309: --
310: and hdr.ae_header_id = dl.ae_header_id

Line 375: and dl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

371: and dist.source_table = 'TH'
372: and dist.set_of_books_id = trh.set_of_books_id
373: --
374: and dl.source_distribution_id_num_1 = dist.line_id
375: and dl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
376: and dl.application_id = 222
377: and dl.upg_batch_id = l_batch_id
378: --
379: and hdr.ae_header_id = dl.ae_header_id

Line 703: 'AR_DISTRIBUTIONS_ALL' source_table,

699: hdr1.ae_header_id header_id,
700: hdr.event_id event_id,
701: dist.set_of_books_id sob_id,
702: dist.source_type account_class,
703: 'AR_DISTRIBUTIONS_ALL' source_table,
704: dist.code_combination_id code_combination_id,
705: dist.amount_dr amount_dr,
706: dist.amount_cr amount_cr,
707: dist.acctd_amount_dr acctd_amount_dr,

Line 759: and dl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

755: and dist.set_of_books_id = app.set_of_books_id
756: and dist.source_table = 'RA'
757: --
758: and dl.source_distribution_id_num_1 = dist.line_id
759: and dl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
760: and dl.application_id = 222
761: and dl.upg_batch_id = l_batch_id
762: --
763: and hdr.ae_header_id = dl.ae_header_id

Line 791: 'AR_DISTRIBUTIONS_ALL' source_table,

787: hdr1.ae_header_id header_id,
788: hdr.event_id event_id,
789: dist.set_of_books_id sob_id,
790: dist.source_type account_class,
791: 'AR_DISTRIBUTIONS_ALL' source_table,
792: dist.code_combination_id code_combination_id,
793: dist.amount_dr amount_dr,
794: dist.amount_cr amount_cr,
795: dist.acctd_amount_dr acctd_amount_dr,

Line 843: and dl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

839: and dist.source_table = 'TH'
840: and dist.set_of_books_id = trh.set_of_books_id
841: --
842: and dl.source_distribution_id_num_1 = dist.line_id
843: and dl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
844: and dl.application_id = 222
845: and dl.upg_batch_id = l_batch_id
846: --
847: and hdr.ae_header_id = dl.ae_header_id

Line 1135: and dl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

1131: and dist.source_table = 'CRH'
1132: and dist.set_of_books_id = mccrh.set_of_books_id
1133: --
1134: and dl.source_distribution_id_num_1 = dist.line_id
1135: and dl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
1136: and dl.application_id = 222
1137: and dl.upg_batch_id = l_batch_id
1138: --
1139: and hdr.ae_header_id = dl.ae_header_id

Line 1203: and dl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

1199: and dist.source_table = 'RA'
1200: and dist.set_of_books_id = app.set_of_books_id
1201: --
1202: and dl.source_distribution_id_num_1 = dist.line_id
1203: and dl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
1204: and dl.application_id = 222
1205: and dl.upg_batch_id = l_batch_id
1206: --
1207: and hdr.ae_header_id = dl.ae_header_id

Line 1271: and dl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

1267: and dist.source_table = 'MCD'
1268: and dist.set_of_books_id = mcmcd.set_of_books_id
1269: --
1270: and dl.source_distribution_id_num_1 = dist.line_id
1271: and dl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
1272: and dl.application_id = 222
1273: and dl.upg_batch_id = l_batch_id
1274: --
1275: and hdr.ae_header_id = dl.ae_header_id

Line 1489: 'AR_DISTRIBUTIONS_ALL' source_table,

1485: hdr1.ae_header_id header_id,
1486: hdr.event_id event_id,
1487: dist.set_of_books_id sob_id,
1488: dist.source_type account_class,
1489: 'AR_DISTRIBUTIONS_ALL' source_table,
1490: dist.code_combination_id code_combination_id,
1491: dist.amount_dr amount_dr,
1492: dist.amount_cr amount_cr,
1493: dist.acctd_amount_dr acctd_amount_dr,

Line 1541: and dl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

1537: and dist.source_table = 'CRH'
1538: and dist.set_of_books_id = mccrh.set_of_books_id
1539: --
1540: and dl.source_distribution_id_num_1 = dist.line_id
1541: and dl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
1542: and dl.application_id = 222
1543: and dl.upg_batch_id = l_batch_id
1544: --
1545: and hdr.ae_header_id = dl.ae_header_id

Line 1573: 'AR_DISTRIBUTIONS_ALL' source_table,

1569: hdr1.ae_header_id header_id,
1570: hdr.event_id event_id,
1571: dist.set_of_books_id sob_id,
1572: dist.source_type account_class,
1573: 'AR_DISTRIBUTIONS_ALL' source_table,
1574: dist.code_combination_id code_combination_id,
1575: dist.amount_dr amount_dr,
1576: dist.amount_cr amount_cr,
1577: dist.acctd_amount_dr acctd_amount_dr,

Line 1628: and dl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

1624: and dist.source_table = 'RA'
1625: and dist.set_of_books_id = app.set_of_books_id
1626: --
1627: and dl.source_distribution_id_num_1 = dist.line_id
1628: and dl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
1629: and dl.application_id = 222
1630: and dl.upg_batch_id = l_batch_id
1631: --
1632: and hdr.ae_header_id = dl.ae_header_id

Line 1660: 'AR_DISTRIBUTIONS_ALL' source_table,

1656: hdr1.ae_header_id header_id,
1657: hdr.event_id event_id,
1658: dist.set_of_books_id sob_id,
1659: dist.source_type account_class,
1660: 'AR_DISTRIBUTIONS_ALL' source_table,
1661: dist.code_combination_id code_combination_id,
1662: dist.amount_dr amount_dr,
1663: dist.amount_cr amount_cr,
1664: dist.acctd_amount_dr acctd_amount_dr,

Line 1711: and dl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

1707: and dist.source_table = 'MCD'
1708: and dist.set_of_books_id = mcmcd.set_of_books_id
1709: --
1710: and dl.source_distribution_id_num_1 = dist.line_id
1711: and dl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
1712: and dl.application_id = 222
1713: and dl.upg_batch_id = l_batch_id
1714: --
1715: and hdr.ae_header_id = dl.ae_header_id

Line 1993: and dl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

1989: and dist.source_table = 'ADJ'
1990: and dist.set_of_books_id = adj.set_of_books_id
1991: --
1992: and dl.source_distribution_id_num_1 = dist.line_id
1993: and dl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
1994: and dl.application_id = 222
1995: and dl.upg_batch_id = l_batch_id
1996: --
1997: and hdr.ae_header_id = dl.ae_header_id

Line 2210: 'AR_DISTRIBUTIONS_ALL' source_table,

2206: hdr1.ae_header_id header_id,
2207: hdr.event_id event_id,
2208: dist.set_of_books_id sob_id,
2209: dist.source_type account_class,
2210: 'AR_DISTRIBUTIONS_ALL' source_table,
2211: dist.code_combination_id code_combination_id,
2212: dist.amount_dr amount_dr,
2213: dist.amount_cr amount_cr,
2214: dist.acctd_amount_dr acctd_amount_dr,

Line 2253: and dl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

2249: and dist.source_table = 'ADJ'
2250: and dist.set_of_books_id = adj.set_of_books_id
2251: --
2252: and dl.source_distribution_id_num_1 = dist.line_id
2253: and dl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
2254: and dl.application_id = 222
2255: and dl.upg_batch_id = l_batch_id
2256: --
2257: and hdr.ae_header_id = dl.ae_header_id

Line 2536: 'AR_DISTRIBUTIONS_ALL' source_table,

2532: hdr.ae_header_id ae_header_id,
2533: hdr.event_id event_id,
2534: dist.set_of_books_id sob_id,
2535: dist.source_type account_class,
2536: 'AR_DISTRIBUTIONS_ALL' source_table,
2537: dist.code_combination_id code_combination_id,
2538: dist.amount_dr amount_dr,
2539: dist.amount_cr amount_cr,
2540: dist.acctd_amount_dr acctd_amount_dr,

Line 2593: from ar_distributions_all

2589: and dist.set_of_books_id = ra.set_of_books_id
2590: and dist.source_table = 'RA'
2591: and dist.source_type in ('EXCH_GAIN','EXCH_LOSS','CURR_ROUND')
2592: and not exists (select 'X'
2593: from ar_distributions_all
2594: where source_id = dist.source_id
2595: and source_table = 'RA'
2596: and source_type = dist.source_type)
2597: --

Line 2604: and dl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

2600: and dist1.source_table = 'RA'
2601: and dist1.source_type = 'REC'
2602: --
2603: and dl.source_distribution_id_num_1 = dist1.line_id
2604: and dl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
2605: and dl.application_id = 222
2606: and dl.upg_batch_id = l_batch_id
2607: and dl.accounting_line_code = 'REC'
2608: --

Line 2819: 'AR_DISTRIBUTIONS_ALL' source_table,

2815: hdr.ae_header_id ae_header_id,
2816: hdr.event_id event_id,
2817: dist.set_of_books_id sob_id,
2818: dist.source_type account_class,
2819: 'AR_DISTRIBUTIONS_ALL' source_table,
2820: dist.code_combination_id code_combination_id,
2821: dist.amount_dr amount_dr,
2822: dist.amount_cr amount_cr,
2823: dist.acctd_amount_dr acctd_amount_dr,

Line 2876: from ar_distributions_all

2872: and dist.set_of_books_id = ra.set_of_books_id
2873: and dist.source_table = 'RA'
2874: and dist.source_type in ('EXCH_GAIN','EXCH_LOSS','CURR_ROUND')
2875: and not exists (select 'X'
2876: from ar_distributions_all
2877: where source_id = dist.source_id
2878: and source_table = 'RA'
2879: and source_type = dist.source_type)
2880: --

Line 2888: and dl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'

2884: and dist1.source_type = 'REC'
2885: and dist1.amount_dr is null
2886: --
2887: and dl.source_distribution_id_num_1 = dist1.line_id
2888: and dl.source_distribution_type = 'AR_DISTRIBUTIONS_ALL'
2889: and dl.application_id = 222
2890: and dl.upg_batch_id = l_batch_id
2891: and dl.accounting_line_code = 'REC'
2892: --