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_PARTY_SITES

Line 76: from hz_party_sites party_sites where orig_system_reference is not null and status in ('A','I')

72:
73: cursor party_sites is
74: select orig_system_reference, party_site_id, created_by, nvl(created_by_module,'TCA'),
75: nvl(application_id,'222'), creation_date,last_updated_by, last_update_date, nvl(last_update_login,-1)
76: from hz_party_sites party_sites where orig_system_reference is not null and status in ('A','I')
77: and not exists(select 'X' from hz_orig_sys_references osr
78: where party_sites.party_site_id = osr.owner_table_id
79: and osr.owner_table_name = 'HZ_PARTY_SITES'
80: and osr.orig_system = 'UNKNOWN'

Line 79: and osr.owner_table_name = 'HZ_PARTY_SITES'

75: nvl(application_id,'222'), creation_date,last_updated_by, last_update_date, nvl(last_update_login,-1)
76: from hz_party_sites party_sites where orig_system_reference is not null and status in ('A','I')
77: and not exists(select 'X' from hz_orig_sys_references osr
78: where party_sites.party_site_id = osr.owner_table_id
79: and osr.owner_table_name = 'HZ_PARTY_SITES'
80: and osr.orig_system = 'UNKNOWN'
81: and party_sites.orig_system_reference =
82: osr.orig_system_reference
83: and osr.status = 'A')

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

80: and osr.orig_system = 'UNKNOWN'
81: and party_sites.orig_system_reference =
82: osr.orig_system_reference
83: and osr.status = 'A')
84: and not exists(select 'N' from hz_orig_sys_mapping where owner_table_name='HZ_PARTY_SITES' and multiple_flag='N' and orig_system='UNKNOWN');
85:
86: TYPE orig_sys_ref_type is TABLE OF HZ_ORIG_SYS_REFERENCES.orig_system_reference%TYPE;
87: Type created_by_type is TABLE of HZ_ORIG_SYS_REFERENCES.created_by%TYPE;
88: Type created_by_module_type is TABLE of HZ_ORIG_SYS_REFERENCES.created_by_module%TYPE;

Line 309: values(hz_orig_system_ref_s.nextval,'UNKNOWN', orig_sys_ref(i), 'HZ_PARTY_SITES', party_site_id(i),

305: (orig_system_ref_id, orig_system, orig_system_reference, owner_table_name, owner_table_id,
306: status, start_date_active, end_date_active, reason_code, created_by,
307: old_orig_system_reference, created_by_module, application_id, creation_date, last_updated_by,
308: last_update_date,last_update_login, object_version_number)
309: values(hz_orig_system_ref_s.nextval,'UNKNOWN', orig_sys_ref(i), 'HZ_PARTY_SITES', party_site_id(i),
310: 'A', sysdate, null, null, created_by(i), null, created_by_module(i), appl_id(i), creation_date(i),
311: last_updated_by(i), last_update_date(i), last_update_login(i), 1);
312:
313: if l_last_fetch then