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_PKG dependencies on HZ_MERGE_PARTIES

Line 5079: ((SELECT from_party_id FROM hz_merge_parties WHERE to_party_id = p_to_fk_id AND merge_status='PENDING' )) --bug 4867151

5075: FROM HZ_RELATIONSHIPS
5076: WHERE relationship_id = p_from_id
5077: AND DIRECTIONAL_FLAG='F')
5078: AND subject_id NOT IN
5079: ((SELECT from_party_id FROM hz_merge_parties WHERE to_party_id = p_to_fk_id AND merge_status='PENDING' )) --bug 4867151
5080: AND subject_id NOT IN
5081: ((SELECT to_party_id FROM hz_merge_parties WHERE to_party_id = p_to_fk_id AND merge_status='PENDING' )) --bug 4867151
5082: AND relationship_type||relationship_code = (
5083: SELECT relationship_type||relationship_code -- Bug No: 4571969

Line 5081: ((SELECT to_party_id FROM hz_merge_parties WHERE to_party_id = p_to_fk_id AND merge_status='PENDING' )) --bug 4867151

5077: AND DIRECTIONAL_FLAG='F')
5078: AND subject_id NOT IN
5079: ((SELECT from_party_id FROM hz_merge_parties WHERE to_party_id = p_to_fk_id AND merge_status='PENDING' )) --bug 4867151
5080: AND subject_id NOT IN
5081: ((SELECT to_party_id FROM hz_merge_parties WHERE to_party_id = p_to_fk_id AND merge_status='PENDING' )) --bug 4867151
5082: AND relationship_type||relationship_code = (
5083: SELECT relationship_type||relationship_code -- Bug No: 4571969
5084: FROM HZ_RELATIONSHIPS
5085: WHERE relationship_id = p_from_id

Line 5537: ((SELECT from_party_id FROM hz_merge_parties WHERE to_party_id = p_to_fk_id AND merge_status='PENDING' )) --bug 4867151

5533: FROM HZ_RELATIONSHIPS
5534: WHERE relationship_id = p_from_id
5535: AND DIRECTIONAL_FLAG='F')
5536: AND object_id NOT IN
5537: ((SELECT from_party_id FROM hz_merge_parties WHERE to_party_id = p_to_fk_id AND merge_status='PENDING' )) --bug 4867151
5538: AND object_id NOT IN
5539: ((SELECT to_party_id FROM hz_merge_parties WHERE to_party_id = p_to_fk_id AND merge_status='PENDING' )) --bug 4867151
5540: AND relationship_type||relationship_code = (
5541: SELECT relationship_type||relationship_code -- Bug No: 4571969

Line 5539: ((SELECT to_party_id FROM hz_merge_parties WHERE to_party_id = p_to_fk_id AND merge_status='PENDING' )) --bug 4867151

5535: AND DIRECTIONAL_FLAG='F')
5536: AND object_id NOT IN
5537: ((SELECT from_party_id FROM hz_merge_parties WHERE to_party_id = p_to_fk_id AND merge_status='PENDING' )) --bug 4867151
5538: AND object_id NOT IN
5539: ((SELECT to_party_id FROM hz_merge_parties WHERE to_party_id = p_to_fk_id AND merge_status='PENDING' )) --bug 4867151
5540: AND relationship_type||relationship_code = (
5541: SELECT relationship_type||relationship_code -- Bug No: 4571969
5542: FROM HZ_RELATIONSHIPS
5543: WHERE relationship_id = p_from_id

Line 6362: FROM hz_merge_parties mp,

6358: AND mpd.merge_from_entity_id <> nvl(mpd.merge_to_entity_id, -1)
6359: AND ps1.location_id = l_from_location_id
6360: AND merge_from_entity_id <> p_from_id
6361: AND mpd.batch_party_id IN ( SELECT batch_party_id
6362: FROM hz_merge_parties mp,
6363: hz_relationships r
6364: WHERE r.party_id = p_from_fk_id
6365: AND mp.from_party_id = r.object_id
6366: AND mp.batch_id = p_batch_id)

Line 6686: WHERE batch_party_id IN (select batch_party_id from hz_merge_parties

6682: END IF;
6683:
6684: UPDATE hz_merge_party_details
6685: SET merge_to_entity_id = x_to_id
6686: WHERE batch_party_id IN (select batch_party_id from hz_merge_parties
6687: where batch_id = p_batch_id)
6688: AND merge_to_entity_id = p_from_id
6689: AND entity_name = 'HZ_PARTY_SITES';
6690:

Line 7139: FROM hz_merge_parties

7135:
7136: BEGIN
7137:
7138: SELECT 'Y' INTO l_allow_child_merge
7139: FROM hz_merge_parties
7140: WHERE ((from_party_id = l_from_par_id AND to_party_id = l_to_par_id)
7141: OR (from_party_id = l_to_par_id AND to_party_id = l_from_par_id))
7142: AND rownum = 1;
7143:

Line 7175: FROM hz_merge_parties

7171:
7172: BEGIN
7173:
7174: SELECT 'Y' INTO l_allow_child_merge
7175: FROM hz_merge_parties
7176: WHERE ((from_party_id = l_from_par_id AND to_party_id = l_to_par_id)
7177: OR (from_party_id = l_to_par_id AND to_party_id = l_from_par_id))
7178: AND rownum = 1;
7179: