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_LOCATIONS

Line 22: from hz_locations locations where orig_system_reference is not null

18:
19: cursor locations is
20: select orig_system_reference, location_id, created_by, nvl(created_by_module,'TCA'),
21: nvl(application_id,'222'), creation_date,last_updated_by, last_update_date, nvl(last_update_login,-1)
22: from hz_locations locations where orig_system_reference is not null
23: and not exists(select 'X' from hz_orig_sys_references osr
24: where locations.location_id = osr.owner_table_id
25: and osr.owner_table_name = 'HZ_LOCATIONS'
26: and osr.orig_system = 'UNKNOWN'

Line 25: and osr.owner_table_name = 'HZ_LOCATIONS'

21: nvl(application_id,'222'), creation_date,last_updated_by, last_update_date, nvl(last_update_login,-1)
22: from hz_locations locations where orig_system_reference is not null
23: and not exists(select 'X' from hz_orig_sys_references osr
24: where locations.location_id = osr.owner_table_id
25: and osr.owner_table_name = 'HZ_LOCATIONS'
26: and osr.orig_system = 'UNKNOWN'
27: and locations.orig_system_reference =
28: osr.orig_system_reference
29: and osr.status = 'A')

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

26: and osr.orig_system = 'UNKNOWN'
27: and locations.orig_system_reference =
28: osr.orig_system_reference
29: and osr.status = 'A')
30: and not exists(select 'N' from hz_orig_sys_mapping where owner_table_name='HZ_LOCATIONS' and multiple_flag='N' and orig_system='UNKNOWN');
31:
32: cursor org_contacts is
33: select orig_system_reference, org_contact_id, created_by, nvl(created_by_module,'TCA'),
34: nvl(application_id,'222'), creation_date,last_updated_by, last_update_date, nvl(last_update_login,-1)

Line 180: values(hz_orig_system_ref_s.nextval,'UNKNOWN', orig_sys_ref(i), 'HZ_LOCATIONS', location_id(i),

176: (orig_system_ref_id, orig_system, orig_system_reference, owner_table_name, owner_table_id,
177: status, start_date_active, end_date_active, reason_code, created_by,
178: old_orig_system_reference, created_by_module, application_id, creation_date, last_updated_by,
179: last_update_date,last_update_login, object_version_number)
180: values(hz_orig_system_ref_s.nextval,'UNKNOWN', orig_sys_ref(i), 'HZ_LOCATIONS', location_id(i),
181: 'A', sysdate, null, null, created_by(i), null, created_by_module(i), appl_id(i),
182: creation_date(i), last_updated_by(i), last_update_date(i), last_update_login(i), 1);
183:
184: if l_last_fetch then