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_PARTY_ORIG_SYS_REF_OBJ

Line 85: HZ_PARTY_ORIG_SYS_REF_OBJ(

81: mh.creation_date,
82: mh.last_update_login,
83: mh.last_update_date,
84: mh.last_updated_by,
85: HZ_PARTY_ORIG_SYS_REF_OBJ(
86: tp.party_id,
87: tp.party_number,
88: tp.party_name,
89: tp.party_type,

Line 91: HZ_PARTY_ORIG_SYS_REF_OBJ(

87: tp.party_number,
88: tp.party_name,
89: tp.party_type,
90: HZ_ORIG_SYS_REF_OBJ_TBL()),
91: HZ_PARTY_ORIG_SYS_REF_OBJ(
92: fp.party_id,
93: fp.party_number,
94: fp.party_name,
95: fp.party_type,

Line 330: HZ_PARTY_ORIG_SYS_REF_OBJ(

326: mb.creation_date,
327: mb.last_update_login,
328: mb.last_update_date,
329: mb.last_updated_by,
330: HZ_PARTY_ORIG_SYS_REF_OBJ(
331: tp.party_id,
332: tp.party_number,
333: tp.party_name,
334: tp.party_type,

Line 337: SELECT HZ_PARTY_ORIG_SYS_REF_OBJ(

333: tp.party_name,
334: tp.party_type,
335: HZ_ORIG_SYS_REF_OBJ_TBL()),
336: CAST(MULTISET(
337: SELECT HZ_PARTY_ORIG_SYS_REF_OBJ(
338: fp.party_id,
339: fp.party_number,
340: fp.party_name,
341: fp.party_type,

Line 347: ) AS HZ_PARTY_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),
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,