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 2808: from HZ_MATCHED_PARTIES_GT mpgt, HZ_RELATIONSHIPS rel

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

Line 2962: FROM HZ_MATCHED_PARTIES_GT matchpty

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