APPS.JTY_TERR_SPARES_PVT dependencies on JTF_TERR_TYPES_ALL

Line 47: from jtf_terr_types_all

43:
44: BEGIN
45: select 'Y'
46: into l_migration_complete
47: from jtf_terr_types_all
48: where terr_type_id = -9
49: and created_by = 9
50: and rownum < 2;
51: EXCEPTION

Line 80: insert into jtf_terr_types_all

76:
77: -- Insert territory types for service usages
78: -- and org_id
79:
80: insert into jtf_terr_types_all
81: ( TERR_TYPE_ID
82: , LAST_UPDATED_BY
83: , LAST_UPDATE_DATE
84: , CREATED_BY

Line 146: from jtf_terr_types_all

142: , sysdate
143: , terr_type_id
144: , ORIG_SYSTEM_REFERENCE_ID -- Used this column to temp store source_id
145: , org_id
146: from jtf_terr_types_all
147: where ORIG_SYSTEM_REFERENCE_ID is not null
148: and terr_type_id = -9
149: and CREATED_BY = 9;
150:

Line 171: -- jtf_terr_types_all tables

167:
168: -- populate jtf_type_qtype_usgs_all table with
169: -- qual_type_usg_id and terr_type_id
170: -- intersection table for jtf_qual_type_usgs_all and
171: -- jtf_terr_types_all tables
172:
173: insert into jtf_type_qtype_usgs_all
174: ( TYPE_QTYPE_USG_ID
175: , LAST_UPDATED_BY

Line 220: -- jtf_terr_types_all tables

216:
217: -- populate jtf_terr_type_qual_all table with
218: -- QUAL_USG_ID and terr_type_id
219: -- intersection table for jtf_qual_usgs_all and
220: -- jtf_terr_types_all tables
221: insert into jtf_terr_type_qual_all
222: (TERR_TYPE_QUAL_ID
223: , LAST_UPDATED_BY
224: , LAST_UPDATE_DATE