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 2407: from hz_party_sites ps, hz_orig_systems_b o

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

Line 2452: l_from_orig_system HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM%TYPE;

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

Line 2453: l_to_orig_system HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM%TYPE;

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

Line 2837: from hz_orig_systems_b o,hz_relationships r

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

Line 2876: l_from_orig_system HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM%TYPE;

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

Line 2877: l_to_orig_system HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM%TYPE;

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

Line 2878: l_to_orig_system_type HZ_ORIG_SYSTEMS_B.ORIG_SYSTEM_TYPE%TYPE;

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

Line 2925: from hz_orig_systems_b o,hz_relationships r

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

Line 2966: , HZ_ORIG_SYSTEMS_B O

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