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 97: HZ_PARTY_ORIG_SYS_REF_OBJ(

93: mh.creation_date,
94: mh.last_update_login,
95: mh.last_update_date,
96: mh.last_updated_by,
97: HZ_PARTY_ORIG_SYS_REF_OBJ(
98: tp.party_id,
99: tp.party_number,
100: tp.party_name,
101: tp.party_type,

Line 103: HZ_PARTY_ORIG_SYS_REF_OBJ(

99: tp.party_number,
100: tp.party_name,
101: tp.party_type,
102: HZ_ORIG_SYS_REF_OBJ_TBL()),
103: HZ_PARTY_ORIG_SYS_REF_OBJ(
104: fp.party_id,
105: fp.party_number,
106: fp.party_name,
107: fp.party_type,

Line 340: HZ_PARTY_ORIG_SYS_REF_OBJ(

336: mh.creation_date,
337: mh.last_update_login,
338: mh.last_update_date,
339: mh.last_updated_by,
340: HZ_PARTY_ORIG_SYS_REF_OBJ(
341: tp.party_id,
342: tp.party_number,
343: tp.party_name,
344: tp.party_type,

Line 346: HZ_PARTY_ORIG_SYS_REF_OBJ(

342: tp.party_number,
343: tp.party_name,
344: tp.party_type,
345: HZ_ORIG_SYS_REF_OBJ_TBL()),
346: HZ_PARTY_ORIG_SYS_REF_OBJ(
347: fp.party_id,
348: fp.party_number,
349: fp.party_name,
350: fp.party_type,

Line 1500: HZ_PARTY_ORIG_SYS_REF_OBJ(

1496: mb.creation_date,
1497: mb.last_update_login,
1498: mb.last_update_date,
1499: mb.last_updated_by,
1500: HZ_PARTY_ORIG_SYS_REF_OBJ(
1501: tp.party_id,
1502: tp.party_number,
1503: tp.party_name,
1504: tp.party_type,

Line 1507: SELECT HZ_PARTY_ORIG_SYS_REF_OBJ(

1503: tp.party_name,
1504: tp.party_type,
1505: HZ_ORIG_SYS_REF_OBJ_TBL()),
1506: CAST(MULTISET(
1507: SELECT HZ_PARTY_ORIG_SYS_REF_OBJ(
1508: fp.party_id,
1509: fp.party_number,
1510: fp.party_name,
1511: fp.party_type,

Line 1518: ) AS HZ_PARTY_ORIG_SYS_REF_OBJ_TBL),

1514: WHERE mp1.batch_id = p_batch_id
1515: AND mp1.to_party_id = l_merge_to_party_id
1516: AND fp.party_id = mp1.from_party_id
1517: AND mp1.merge_type = mp.merge_type
1518: ) AS HZ_PARTY_ORIG_SYS_REF_OBJ_TBL),
1519: HZ_PARTY_MERGE_DETAIL_OBJ_TBL() --5093366
1520: )
1521: FROM hz_merge_batch mb,
1522: (SELECT DISTINCT merge_type from hz_merge_parties where batch_id = p_batch_id and to_party_id = l_merge_to_party_id) mp,