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_ORIG_SYS_REFERENCES

Line 10: and not exists(select 'X' from hz_orig_sys_references osr

6: cursor parties is
7: select orig_system_reference, party_id, created_by, nvl(created_by_module,'TCA'),
8: nvl(application_id,'222'), creation_date,last_updated_by, last_update_date, nvl(last_update_login,-1)
9: from hz_parties party where orig_system_reference is not null and status in ('A','I')
10: and not exists(select 'X' from hz_orig_sys_references osr
11: where party.party_id = osr.owner_table_id
12: and osr.owner_table_name = 'HZ_PARTIES'
13: and osr.orig_system = 'UNKNOWN'
14: and party.orig_system_reference =

Line 23: and not exists(select 'X' from hz_orig_sys_references osr

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'
27: and locations.orig_system_reference =

Line 36: and not exists(select 'X' from hz_orig_sys_references osr

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)
35: from hz_org_contacts org_contacts where orig_system_reference is not null and status in ('A','I')
36: and not exists(select 'X' from hz_orig_sys_references osr
37: where org_contacts.org_contact_id = osr.owner_table_id
38: and osr.owner_table_name = 'HZ_ORG_CONTACTS'
39: and osr.orig_system = 'UNKNOWN'
40: and org_contacts.orig_system_reference =

Line 50: and not exists(select /+ parallel(osr) / 'X' from hz_orig_sys_references osr

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'
54: and contact.orig_system_reference =

Line 64: and not exists(select /+ parallel(osr) / 'X' from hz_orig_sys_references osr

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'),
62: nvl(application_id,'222'), creation_date,last_updated_by, last_update_date, nvl(last_update_login,-1)
63: from hz_org_contact_roles contact_roles where orig_system_reference is not null and status in ('A','I')
64: and not exists(select /*+ parallel(osr) */ 'X' from hz_orig_sys_references osr
65: where contact_roles.org_contact_role_id = osr.owner_table_id
66: and osr.owner_table_name = 'HZ_ORG_CONTACT_ROLES'
67: and osr.orig_system = 'UNKNOWN'
68: and contact_roles.orig_system_reference =

Line 77: and not exists(select 'X' from hz_orig_sys_references osr

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'
81: and party_sites.orig_system_reference =

Line 86: TYPE orig_sys_ref_type is TABLE OF HZ_ORIG_SYS_REFERENCES.orig_system_reference%TYPE;

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;
89: Type appl_id_type is TABLE of HZ_ORIG_SYS_REFERENCES.application_id%TYPE;
90: Type last_updated_by_type is TABLE of HZ_ORIG_SYS_REFERENCES.last_updated_by%TYPE;

Line 87: Type created_by_type is TABLE of HZ_ORIG_SYS_REFERENCES.created_by%TYPE;

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;
89: Type appl_id_type is TABLE of HZ_ORIG_SYS_REFERENCES.application_id%TYPE;
90: Type last_updated_by_type is TABLE of HZ_ORIG_SYS_REFERENCES.last_updated_by%TYPE;
91: Type creation_date_type is TABLE of HZ_ORIG_SYS_REFERENCES.creation_date%TYPE;

Line 88: Type created_by_module_type is TABLE of HZ_ORIG_SYS_REFERENCES.created_by_module%TYPE;

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;
89: Type appl_id_type is TABLE of HZ_ORIG_SYS_REFERENCES.application_id%TYPE;
90: Type last_updated_by_type is TABLE of HZ_ORIG_SYS_REFERENCES.last_updated_by%TYPE;
91: Type creation_date_type is TABLE of HZ_ORIG_SYS_REFERENCES.creation_date%TYPE;
92: Type last_update_date_type is TABLE of HZ_ORIG_SYS_REFERENCES.last_update_date%TYPE;

Line 89: Type appl_id_type is TABLE of HZ_ORIG_SYS_REFERENCES.application_id%TYPE;

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;
89: Type appl_id_type is TABLE of HZ_ORIG_SYS_REFERENCES.application_id%TYPE;
90: Type last_updated_by_type is TABLE of HZ_ORIG_SYS_REFERENCES.last_updated_by%TYPE;
91: Type creation_date_type is TABLE of HZ_ORIG_SYS_REFERENCES.creation_date%TYPE;
92: Type last_update_date_type is TABLE of HZ_ORIG_SYS_REFERENCES.last_update_date%TYPE;
93: Type last_update_login_type is TABLE of HZ_ORIG_SYS_REFERENCES.last_update_login%TYPE;

Line 90: Type last_updated_by_type is TABLE of HZ_ORIG_SYS_REFERENCES.last_updated_by%TYPE;

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;
89: Type appl_id_type is TABLE of HZ_ORIG_SYS_REFERENCES.application_id%TYPE;
90: Type last_updated_by_type is TABLE of HZ_ORIG_SYS_REFERENCES.last_updated_by%TYPE;
91: Type creation_date_type is TABLE of HZ_ORIG_SYS_REFERENCES.creation_date%TYPE;
92: Type last_update_date_type is TABLE of HZ_ORIG_SYS_REFERENCES.last_update_date%TYPE;
93: Type last_update_login_type is TABLE of HZ_ORIG_SYS_REFERENCES.last_update_login%TYPE;
94:

Line 91: Type creation_date_type is TABLE of HZ_ORIG_SYS_REFERENCES.creation_date%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;
89: Type appl_id_type is TABLE of HZ_ORIG_SYS_REFERENCES.application_id%TYPE;
90: Type last_updated_by_type is TABLE of HZ_ORIG_SYS_REFERENCES.last_updated_by%TYPE;
91: Type creation_date_type is TABLE of HZ_ORIG_SYS_REFERENCES.creation_date%TYPE;
92: Type last_update_date_type is TABLE of HZ_ORIG_SYS_REFERENCES.last_update_date%TYPE;
93: Type last_update_login_type is TABLE of HZ_ORIG_SYS_REFERENCES.last_update_login%TYPE;
94:
95: TYPE owner_tableid_type IS TABLE OF HZ_ORIG_SYS_REFERENCES.owner_table_id%TYPE;

Line 92: Type last_update_date_type is TABLE of HZ_ORIG_SYS_REFERENCES.last_update_date%TYPE;

88: Type created_by_module_type is TABLE of HZ_ORIG_SYS_REFERENCES.created_by_module%TYPE;
89: Type appl_id_type is TABLE of HZ_ORIG_SYS_REFERENCES.application_id%TYPE;
90: Type last_updated_by_type is TABLE of HZ_ORIG_SYS_REFERENCES.last_updated_by%TYPE;
91: Type creation_date_type is TABLE of HZ_ORIG_SYS_REFERENCES.creation_date%TYPE;
92: Type last_update_date_type is TABLE of HZ_ORIG_SYS_REFERENCES.last_update_date%TYPE;
93: Type last_update_login_type is TABLE of HZ_ORIG_SYS_REFERENCES.last_update_login%TYPE;
94:
95: TYPE owner_tableid_type IS TABLE OF HZ_ORIG_SYS_REFERENCES.owner_table_id%TYPE;
96:

Line 93: Type last_update_login_type is TABLE of HZ_ORIG_SYS_REFERENCES.last_update_login%TYPE;

89: Type appl_id_type is TABLE of HZ_ORIG_SYS_REFERENCES.application_id%TYPE;
90: Type last_updated_by_type is TABLE of HZ_ORIG_SYS_REFERENCES.last_updated_by%TYPE;
91: Type creation_date_type is TABLE of HZ_ORIG_SYS_REFERENCES.creation_date%TYPE;
92: Type last_update_date_type is TABLE of HZ_ORIG_SYS_REFERENCES.last_update_date%TYPE;
93: Type last_update_login_type is TABLE of HZ_ORIG_SYS_REFERENCES.last_update_login%TYPE;
94:
95: TYPE owner_tableid_type IS TABLE OF HZ_ORIG_SYS_REFERENCES.owner_table_id%TYPE;
96:
97: orig_sys_ref orig_sys_ref_type;

Line 95: TYPE owner_tableid_type IS TABLE OF HZ_ORIG_SYS_REFERENCES.owner_table_id%TYPE;

91: Type creation_date_type is TABLE of HZ_ORIG_SYS_REFERENCES.creation_date%TYPE;
92: Type last_update_date_type is TABLE of HZ_ORIG_SYS_REFERENCES.last_update_date%TYPE;
93: Type last_update_login_type is TABLE of HZ_ORIG_SYS_REFERENCES.last_update_login%TYPE;
94:
95: TYPE owner_tableid_type IS TABLE OF HZ_ORIG_SYS_REFERENCES.owner_table_id%TYPE;
96:
97: orig_sys_ref orig_sys_ref_type;
98: created_by created_by_type;
99: created_by_module created_by_module_type;

Line 141: insert into hz_orig_sys_references

137: exit;
138: end if;
139:
140: forall i in party_id.FIRST..party_id.LAST
141: insert into hz_orig_sys_references
142: (orig_system_ref_id, orig_system, orig_system_reference, owner_table_name, owner_table_id,
143: status, start_date_active, end_date_active, reason_code, created_by,
144: old_orig_system_reference, created_by_module, application_id, creation_date, last_updated_by,
145: last_update_date,last_update_login, object_version_number)

Line 175: insert into hz_orig_sys_references

171: exit;
172: end if;
173:
174: forall i in location_id.first..location_id.last
175: insert into hz_orig_sys_references
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)

Line 208: insert into hz_orig_sys_references

204: if org_contact_id.COUNT=0 and l_last_fetch then
205: exit;
206: end if;
207: forall i in org_contact_id.first..org_contact_id.last
208: insert into hz_orig_sys_references
209: (orig_system_ref_id, orig_system, orig_system_reference, owner_table_name, owner_table_id,
210: status, start_date_active, end_date_active, reason_code, created_by,
211: old_orig_system_reference, created_by_module, application_id, creation_date, last_updated_by,
212: last_update_date,last_update_login, object_version_number)

Line 240: insert into hz_orig_sys_references

236: if contact_point_id.COUNT=0 and l_last_fetch then
237: exit;
238: end if;
239: forall i in contact_point_id.first..contact_point_id.last
240: insert into hz_orig_sys_references
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)

Line 272: insert into hz_orig_sys_references

268: if org_contact_role_id.COUNT=0 and l_last_fetch then
269: exit;
270: end if;
271: forall i in org_contact_role_id.first..org_contact_role_id.last
272: insert into hz_orig_sys_references
273: (orig_system_ref_id, orig_system, orig_system_reference, owner_table_name, owner_table_id,
274: status, start_date_active, end_date_active, reason_code, created_by,
275: old_orig_system_reference, created_by_module, application_id, creation_date, last_updated_by,
276: last_update_date,last_update_login, object_version_number)

Line 304: insert into hz_orig_sys_references

300: if party_site_id.COUNT=0 and l_last_fetch then
301: exit;
302: end if;
303: forall i in party_site_id.first..party_site_id.last
304: insert into hz_orig_sys_references
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)