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

Line 343: FROM hz_parties fp, hz_merge_parties mp1

339: fp.party_number,
340: fp.party_name,
341: fp.party_type,
342: HZ_ORIG_SYS_REF_OBJ_TBL())
343: FROM hz_parties fp, hz_merge_parties mp1
344: WHERE mp1.batch_id = p_batch_id
345: AND mp1.to_party_id = p_merge_to_party_id
346: AND fp.party_id = mp1.from_party_id
347: ) AS HZ_PARTY_ORIG_SYS_REF_OBJ_TBL),

Line 351: (SELECT DISTINCT merge_type from hz_merge_parties where batch_id = p_batch_id and to_party_id = p_merge_to_party_id) mp,

347: ) AS HZ_PARTY_ORIG_SYS_REF_OBJ_TBL),
348: HZ_PARTY_MERGE_DETAIL_OBJ_TBL() --5093366
349: )
350: FROM hz_merge_batch mb,
351: (SELECT DISTINCT merge_type from hz_merge_parties where batch_id = p_batch_id and to_party_id = p_merge_to_party_id) mp,
352: hz_dup_batch db,
353: hz_dup_sets dset,
354: hz_parties tp
355: WHERE mb.batch_id = p_batch_id

Line 562: FROM hz_merge_parties mp2,

558:
559: )AS HZ_ORIG_SYS_REF_OBJ_TBL)
560:
561: )
562: FROM hz_merge_parties mp2,
563: hz_merge_party_history mph,
564: hz_merge_dictionary md
565: WHERE mp2.batch_id = p_batch_id
566: AND mph.batch_party_id = mp2.batch_party_id