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_MATCHED_PARTIES_GT

Line 2810: from HZ_MATCHED_PARTIES_GT mpgt, HZ_RELATIONSHIPS rel

2806: cursor get_suggested_reln(l_search_ctx_id NUMBER, l_reln_obj_id NUMBER, l_master_party NUMBER
2807: , l_reln_type VARCHAR2, l_reln_code VARCHAR2, l_reln_sbj_type VARCHAR2
2808: , l_reln_obj_type VARCHAR2) is
2809: select relationship_id
2810: from HZ_MATCHED_PARTIES_GT mpgt, HZ_RELATIONSHIPS rel
2811: where mpgt.search_context_id = l_search_ctx_id
2812: and mpgt.party_id <> l_reln_obj_id
2813: and mpgt.party_id = rel.object_id
2814: and rel.subject_id = l_master_party

Line 2964: FROM HZ_MATCHED_PARTIES_GT matchpty

2960: FROM HZ_MERGE_PARTIES_SUGG
2961: WHERE batch_id = p_batch_id )
2962: AND merge_from_entity_id IN
2963: ( SELECT rel.relationship_id
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