APPS.HZ_MIGRATE_MOSR_REFERENCES dependencies on HZ_ORIG_SYS_MAPPING

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

13: and osr.orig_system = 'UNKNOWN'
14: and party.orig_system_reference =
15: osr.orig_system_reference
16: and osr.status = 'A')
17: and not exists(select 'N' from hz_orig_sys_mapping where owner_table_name='HZ_PARTIES' and multiple_flag='N' and orig_system='UNKNOWN');
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)

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 43: and not exists(select 'N' from hz_orig_sys_mapping where owner_table_name='HZ_ORG_CONTACTS' and multiple_flag='N' and orig_system='UNKNOWN');

39: and osr.orig_system = 'UNKNOWN'
40: and org_contacts.orig_system_reference =
41: osr.orig_system_reference
42: and osr.status = 'A')
43: and not exists(select 'N' from hz_orig_sys_mapping where owner_table_name='HZ_ORG_CONTACTS' and multiple_flag='N' and orig_system='UNKNOWN');
44:
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'),

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 71: and not exists(select 'N' from hz_orig_sys_mapping where owner_table_name='HZ_ORG_CONTACT_ROLES' and multiple_flag='N' and orig_system='UNKNOWN');

67: and osr.orig_system = 'UNKNOWN'
68: and contact_roles.orig_system_reference =
69: osr.orig_system_reference
70: and osr.status = 'A')
71: and not exists(select 'N' from hz_orig_sys_mapping where owner_table_name='HZ_ORG_CONTACT_ROLES' and multiple_flag='N' and orig_system='UNKNOWN');
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)

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;