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.XLA_THIRD_PARTY_MERGE dependencies on XLA_DISTRIBUTION_LINKS

Line 1617: INSERT INTO xla_distribution_links

1613: , p_level => C_LEVEL_PROCEDURE
1614: , p_module => v_module);
1615: END IF; -- IF (C_LEVEL_PROCEDURE >= g_log_level)
1616:
1617: INSERT INTO xla_distribution_links
1618: (
1619: application_id
1620: , event_id
1621: , source_distribution_id_char_1

Line 2797: ,xla_distribution_links xdl

2793: ,ael.encumbrance_type_id
2794: FROM
2795: xla_ae_lines ael
2796: ,xla_ae_headers aeh
2797: ,xla_distribution_links xdl
2798: ,fnd_currencies fcu
2799: WHERE nvl(ael.merge_party_id, ael.party_id) = p_old_party_id
2800: AND nvl(nvl(ael.merge_party_site_id, ael.party_site_id), -1)
2801: = nvl(p_old_site_id, -1)

Line 2824: FROM xla_distribution_links

2820: AND aeh.merge_event_id is null
2821: /*
2822: AND NOT EXISTS (
2823: SELECT 1
2824: FROM xla_distribution_links
2825: WHERE ref_ae_header_id = xdl.ae_header_id
2826: AND ref_temp_line_num = xdl.temp_line_num
2827: -- means it is a third party merge line
2828: And ref_ae_header_id <>ae_header_id

Line 2963: ,xla_distribution_links xdl

2959: ,ael.encumbrance_type_id
2960: FROM
2961: xla_ae_lines ael
2962: ,xla_ae_headers aeh
2963: ,xla_distribution_links xdl
2964: ,fnd_currencies fcu
2965: WHERE nvl(ael.merge_party_id, ael.party_id) = p_old_party_id
2966: AND nvl(nvl(ael.merge_party_site_id, ael.party_site_id), -1)
2967: = nvl(p_old_site_id, -1)

Line 2990: FROM xla_distribution_links

2986: AND aeh.merge_event_id is null
2987: /*
2988: AND NOT EXISTS (
2989: SELECT 1
2990: FROM xla_distribution_links
2991: WHERE ref_ae_header_id = xdl.ae_header_id
2992: AND ref_temp_line_num = xdl.temp_line_num
2993: -- means it is a third party merge line
2994: And ref_ae_header_id <>ae_header_id

Line 3291: ,xla_distribution_links xdl

3287: ,ael.encumbrance_type_id
3288: FROM
3289: xla_ae_lines ael
3290: ,xla_ae_headers aeh
3291: ,xla_distribution_links xdl
3292: ,fnd_currencies fcu
3293: WHERE nvl(ael.merge_party_id, ael.party_id) = p_old_party_id
3294: AND nvl(nvl(ael.merge_party_site_id, ael.party_site_id), -1)
3295: = nvl(p_old_site_id, -1)

Line 3318: FROM xla_distribution_links

3314: AND aeh.merge_event_id is null
3315: /*
3316: AND NOT EXISTS (
3317: SELECT 1
3318: FROM xla_distribution_links
3319: WHERE ref_ae_header_id = xdl.ae_header_id
3320: AND ref_temp_line_num = xdl.temp_line_num
3321: -- means it is a third party merge line
3322: And ref_ae_header_id <>ae_header_id

Line 3477: ,xla_distribution_links xdl

3473: ,ael.encumbrance_type_id
3474: FROM
3475: xla_ae_lines ael
3476: ,xla_ae_headers aeh
3477: ,xla_distribution_links xdl
3478: ,fnd_currencies fcu
3479: WHERE nvl(ael.merge_party_id, ael.party_id) = p_old_party_id
3480: AND nvl(nvl(ael.merge_party_site_id, ael.party_site_id), -1)
3481: = nvl(p_old_site_id, -1)

Line 3504: FROM xla_distribution_links

3500: AND aeh.merge_event_id is null
3501: /*
3502: AND NOT EXISTS (
3503: SELECT 1
3504: FROM xla_distribution_links
3505: WHERE ref_ae_header_id = xdl.ae_header_id
3506: AND ref_temp_line_num = xdl.temp_line_num
3507: -- means it is a third party merge line
3508: And ref_ae_header_id <>ae_header_id

Line 5902: DELETE FROM xla_distribution_links

5898: AND request_id = g_report_request_id);
5899: */
5900:
5901:
5902: DELETE FROM xla_distribution_links
5903: WHERE ae_header_id IN
5904: (SELECT ae_header_id FROM xla_ae_headers
5905: WHERE application_id = p_application_id
5906: AND merge_event_id = p_event_id);