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.HZ_MERGE_DUP_PVT dependencies on HZ_ORIG_SYSTEMS_B

Line 2408: from hz_party_sites ps, hz_orig_systems_b o

2404:
2405: --4114254
2406: CURSOR c_get_orig_system(p_party_site_id NUMBER) IS
2407: select o.orig_system
2408: from hz_party_sites ps, hz_orig_systems_b o
2409: where ps.party_site_id = p_party_site_id
2410: and o.orig_system = ps.actual_content_source
2411: and o.orig_system_type = 'PURCHASED';
2412:

Line 2453: l_from_orig_system HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM%TYPE;

2449: l_from_location_id NUMBER;
2450: l_to_location_id NUMBER;
2451:
2452: --4114254
2453: l_from_orig_system HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM%TYPE;
2454: l_to_orig_system HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM%TYPE;
2455: l_flag_merge varchar2(1);
2456:
2457: BEGIN

Line 2454: l_to_orig_system HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM%TYPE;

2450: l_to_location_id NUMBER;
2451:
2452: --4114254
2453: l_from_orig_system HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM%TYPE;
2454: l_to_orig_system HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM%TYPE;
2455: l_flag_merge varchar2(1);
2456:
2457: BEGIN
2458:

Line 2839: from hz_orig_systems_b o,hz_relationships r

2835:
2836: --4114254
2837: CURSOR c_get_orig_system_r(rel_id NUMBER) IS
2838: select o.orig_system
2839: from hz_orig_systems_b o,hz_relationships r
2840: where r.relationship_id = rel_id
2841: and o.orig_system = r.actual_content_source
2842: and o.orig_system_type = 'PURCHASED'
2843: and directional_flag = 'F';

Line 2878: l_from_orig_system HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM%TYPE;

2874: l_msg_count NUMBER;
2875: l_msg_data VARCHAR2(2000);
2876:
2877: --4114254
2878: l_from_orig_system HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM%TYPE;
2879: l_to_orig_system HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM%TYPE;
2880: l_to_orig_system_type HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM_TYPE%TYPE;
2881: l_flag_merge VARCHAR2(1);
2882: l_rel_status varchar2(1);

Line 2879: l_to_orig_system HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM%TYPE;

2875: l_msg_data VARCHAR2(2000);
2876:
2877: --4114254
2878: l_from_orig_system HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM%TYPE;
2879: l_to_orig_system HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM%TYPE;
2880: l_to_orig_system_type HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM_TYPE%TYPE;
2881: l_flag_merge VARCHAR2(1);
2882: l_rel_status varchar2(1);
2883:

Line 2880: l_to_orig_system_type HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM_TYPE%TYPE;

2876:
2877: --4114254
2878: l_from_orig_system HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM%TYPE;
2879: l_to_orig_system HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM%TYPE;
2880: l_to_orig_system_type HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM_TYPE%TYPE;
2881: l_flag_merge VARCHAR2(1);
2882: l_rel_status varchar2(1);
2883:
2884: BEGIN

Line 2927: from hz_orig_systems_b o,hz_relationships r

2923: -- if found any matches
2924: IF (l_num_matches > 0) THEN
2925:
2926: select o.orig_system,o.orig_system_type into l_to_orig_system,l_to_orig_system_type
2927: from hz_orig_systems_b o,hz_relationships r
2928: where r.relationship_id = l_reln_id
2929: and o.orig_system = r.actual_content_source
2930: and directional_flag = 'F';
2931:

Line 2968: , HZ_ORIG_SYSTEMS_B O

2964: FROM HZ_MATCHED_PARTIES_GT matchpty
2965: , HZ_MERGE_PARTYDTLS_SUGG mpd
2966: , HZ_MERGE_PARTIES_SUGG mps
2967: , HZ_RELATIONSHIPS rel
2968: , HZ_ORIG_SYSTEMS_B O
2969: WHERE matchpty.search_context_id = l_search_ctx_id
2970: AND matchpty.party_id = rel.object_id
2971: AND rel.relationship_code = l_reln_code
2972: AND rel.relationship_type = l_reln_type