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 5071: ((SELECT from_party_id FROM hz_merge_parties WHERE to_party_id = p_to_fk_id AND merge_status='PENDING' )) --bug 4867151

5067: FROM HZ_RELATIONSHIPS
5068: WHERE relationship_id = p_from_id
5069: AND DIRECTIONAL_FLAG='F')
5070: AND subject_id NOT IN
5071: ((SELECT from_party_id FROM hz_merge_parties WHERE to_party_id = p_to_fk_id AND merge_status='PENDING' )) --bug 4867151
5072: AND subject_id NOT IN
5073: ((SELECT to_party_id FROM hz_merge_parties WHERE to_party_id = p_to_fk_id AND merge_status='PENDING' )) --bug 4867151
5074: AND relationship_code = (
5075: SELECT relationship_code -- Bug No: 4571969

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

5069: AND DIRECTIONAL_FLAG='F')
5070: AND subject_id NOT IN
5071: ((SELECT from_party_id FROM hz_merge_parties WHERE to_party_id = p_to_fk_id AND merge_status='PENDING' )) --bug 4867151
5072: AND subject_id NOT IN
5073: ((SELECT to_party_id FROM hz_merge_parties WHERE to_party_id = p_to_fk_id AND merge_status='PENDING' )) --bug 4867151
5074: AND relationship_code = (
5075: SELECT relationship_code -- Bug No: 4571969
5076: FROM HZ_RELATIONSHIPS
5077: WHERE relationship_id = p_from_id

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

5460: FROM HZ_RELATIONSHIPS
5461: WHERE relationship_id = p_from_id
5462: AND DIRECTIONAL_FLAG='F')
5463: AND object_id NOT IN
5464: ((SELECT from_party_id FROM hz_merge_parties WHERE to_party_id = p_to_fk_id AND merge_status='PENDING' )) --bug 4867151
5465: AND object_id NOT IN
5466: ((SELECT to_party_id FROM hz_merge_parties WHERE to_party_id = p_to_fk_id AND merge_status='PENDING' )) --bug 4867151
5467: AND relationship_code = (
5468: SELECT relationship_code -- Bug No: 4571969

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

5462: AND DIRECTIONAL_FLAG='F')
5463: AND object_id NOT IN
5464: ((SELECT from_party_id FROM hz_merge_parties WHERE to_party_id = p_to_fk_id AND merge_status='PENDING' )) --bug 4867151
5465: AND object_id NOT IN
5466: ((SELECT to_party_id FROM hz_merge_parties WHERE to_party_id = p_to_fk_id AND merge_status='PENDING' )) --bug 4867151
5467: AND relationship_code = (
5468: SELECT relationship_code -- Bug No: 4571969
5469: FROM HZ_RELATIONSHIPS
5470: WHERE relationship_id = p_from_id

Line 6232: FROM hz_merge_parties mp,

6228: AND mpd.merge_from_entity_id <> nvl(mpd.merge_to_entity_id, -1)
6229: AND ps1.location_id = l_from_location_id
6230: AND merge_from_entity_id <> p_from_id
6231: AND mpd.batch_party_id IN ( SELECT batch_party_id
6232: FROM hz_merge_parties mp,
6233: hz_relationships r
6234: WHERE r.party_id = p_from_fk_id
6235: AND mp.from_party_id = r.object_id
6236: AND mp.batch_id = p_batch_id)

Line 6556: WHERE batch_party_id IN (select batch_party_id from hz_merge_parties

6552: END IF;
6553:
6554: UPDATE hz_merge_party_details
6555: SET merge_to_entity_id = x_to_id
6556: WHERE batch_party_id IN (select batch_party_id from hz_merge_parties
6557: where batch_id = p_batch_id)
6558: AND merge_to_entity_id = p_from_id
6559: AND entity_name = 'HZ_PARTY_SITES';
6560: