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 1631: INSERT INTO xla_distribution_links

1627: , p_level => C_LEVEL_PROCEDURE
1628: , p_module => v_module);
1629: END IF; -- IF (C_LEVEL_PROCEDURE >= g_log_level)
1630:
1631: INSERT INTO xla_distribution_links
1632: (
1633: application_id
1634: , event_id
1635: , source_distribution_id_char_1

Line 2815: ,xla_distribution_links xdl

2811: ,ael.encumbrance_type_id
2812: FROM
2813: xla_ae_lines ael
2814: ,xla_ae_headers aeh
2815: ,xla_distribution_links xdl
2816: ,fnd_currencies fcu
2817: WHERE nvl(ael.merge_party_id, ael.party_id) = p_old_party_id
2818: AND nvl(nvl(ael.merge_party_site_id, ael.party_site_id), -1)
2819: = nvl(p_old_site_id, -1)

Line 2842: FROM xla_distribution_links

2838: AND aeh.merge_event_id is null
2839: /*
2840: AND NOT EXISTS (
2841: SELECT 1
2842: FROM xla_distribution_links
2843: WHERE ref_ae_header_id = xdl.ae_header_id
2844: AND ref_temp_line_num = xdl.temp_line_num
2845: -- means it is a third party merge line
2846: And ref_ae_header_id <>ae_header_id

Line 2981: ,xla_distribution_links xdl

2977: ,ael.encumbrance_type_id
2978: FROM
2979: xla_ae_lines ael
2980: ,xla_ae_headers aeh
2981: ,xla_distribution_links xdl
2982: ,fnd_currencies fcu
2983: WHERE nvl(ael.merge_party_id, ael.party_id) = p_old_party_id
2984: AND nvl(nvl(ael.merge_party_site_id, ael.party_site_id), -1)
2985: = nvl(p_old_site_id, -1)

Line 3008: FROM xla_distribution_links

3004: AND aeh.merge_event_id is null
3005: /*
3006: AND NOT EXISTS (
3007: SELECT 1
3008: FROM xla_distribution_links
3009: WHERE ref_ae_header_id = xdl.ae_header_id
3010: AND ref_temp_line_num = xdl.temp_line_num
3011: -- means it is a third party merge line
3012: And ref_ae_header_id <>ae_header_id

Line 3309: ,xla_distribution_links xdl

3305: ,ael.encumbrance_type_id
3306: FROM
3307: xla_ae_lines ael
3308: ,xla_ae_headers aeh
3309: ,xla_distribution_links xdl
3310: ,fnd_currencies fcu
3311: WHERE nvl(ael.merge_party_id, ael.party_id) = p_old_party_id
3312: AND nvl(nvl(ael.merge_party_site_id, ael.party_site_id), -1)
3313: = nvl(p_old_site_id, -1)

Line 3336: FROM xla_distribution_links

3332: AND aeh.merge_event_id is null
3333: /*
3334: AND NOT EXISTS (
3335: SELECT 1
3336: FROM xla_distribution_links
3337: WHERE ref_ae_header_id = xdl.ae_header_id
3338: AND ref_temp_line_num = xdl.temp_line_num
3339: -- means it is a third party merge line
3340: And ref_ae_header_id <>ae_header_id

Line 3495: ,xla_distribution_links xdl

3491: ,ael.encumbrance_type_id
3492: FROM
3493: xla_ae_lines ael
3494: ,xla_ae_headers aeh
3495: ,xla_distribution_links xdl
3496: ,fnd_currencies fcu
3497: WHERE nvl(ael.merge_party_id, ael.party_id) = p_old_party_id
3498: AND nvl(nvl(ael.merge_party_site_id, ael.party_site_id), -1)
3499: = nvl(p_old_site_id, -1)

Line 3522: FROM xla_distribution_links

3518: AND aeh.merge_event_id is null
3519: /*
3520: AND NOT EXISTS (
3521: SELECT 1
3522: FROM xla_distribution_links
3523: WHERE ref_ae_header_id = xdl.ae_header_id
3524: AND ref_temp_line_num = xdl.temp_line_num
3525: -- means it is a third party merge line
3526: And ref_ae_header_id <>ae_header_id

Line 6140: DELETE FROM xla_distribution_links

6136: AND request_id = g_report_request_id);
6137: */
6138:
6139:
6140: DELETE FROM xla_distribution_links
6141: WHERE ae_header_id IN
6142: (SELECT ae_header_id FROM xla_ae_headers
6143: WHERE application_id = p_application_id
6144: AND merge_event_id = p_event_id);