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_MIGRATE_MOSR_REFERENCES dependencies on HZ_CONTACT_POINTS

Line 49: from hz_contact_points contact where orig_system_reference is not null and status in ('A','I')

45: -- Bug 4956873
46: cursor contact_points is
47: select /*+ parallel(contact) */ orig_system_reference, contact_point_id, created_by, nvl(created_by_module,'TCA'),
48: nvl(application_id,'222'), creation_date,last_updated_by, last_update_date, nvl(last_update_login,-1)
49: from hz_contact_points contact where orig_system_reference is not null and status in ('A','I')
50: and not exists(select /*+ parallel(osr) */ 'X' from hz_orig_sys_references osr
51: where contact.contact_point_id = osr.owner_table_id
52: and osr.owner_table_name = 'HZ_CONTACT_POINTS'
53: and osr.orig_system = 'UNKNOWN'

Line 52: and osr.owner_table_name = 'HZ_CONTACT_POINTS'

48: nvl(application_id,'222'), creation_date,last_updated_by, last_update_date, nvl(last_update_login,-1)
49: from hz_contact_points contact where orig_system_reference is not null and status in ('A','I')
50: and not exists(select /*+ parallel(osr) */ 'X' from hz_orig_sys_references osr
51: where contact.contact_point_id = osr.owner_table_id
52: and osr.owner_table_name = 'HZ_CONTACT_POINTS'
53: and osr.orig_system = 'UNKNOWN'
54: and contact.orig_system_reference =
55: osr.orig_system_reference
56: and osr.status = 'A')

Line 57: and not exists(select 'N' from hz_orig_sys_mapping where owner_table_name='HZ_CONTACT_POINTS' and multiple_flag='N' and orig_system='UNKNOWN');

53: and osr.orig_system = 'UNKNOWN'
54: and contact.orig_system_reference =
55: osr.orig_system_reference
56: and osr.status = 'A')
57: and not exists(select 'N' from hz_orig_sys_mapping where owner_table_name='HZ_CONTACT_POINTS' and multiple_flag='N' and orig_system='UNKNOWN');
58:
59: -- Bug 4956873
60: cursor org_contact_roles is
61: select /*+ parallel(contact_roles) */ orig_system_reference, org_contact_role_id, created_by, nvl(created_by_module,'TCA'),

Line 245: values(hz_orig_system_ref_s.nextval,'UNKNOWN', orig_sys_ref(i), 'HZ_CONTACT_POINTS', contact_point_id(i),

241: (orig_system_ref_id, orig_system, orig_system_reference, owner_table_name, owner_table_id,
242: status, start_date_active, end_date_active, reason_code, created_by,
243: old_orig_system_reference, created_by_module, application_id, creation_date, last_updated_by,
244: last_update_date,last_update_login, object_version_number)
245: values(hz_orig_system_ref_s.nextval,'UNKNOWN', orig_sys_ref(i), 'HZ_CONTACT_POINTS', contact_point_id(i),
246: 'A', sysdate, null, null, created_by(i), null, created_by_module(i), appl_id(i), creation_date(i), last_updated_by(i),
247: last_update_date(i), last_update_login(i), 1);
248:
249: if l_last_fetch then