APPS.JTY_MIGRATION_PVT dependencies on JTF_TERR_ALL

Line 149: /* replaced by the script jtftterr.sql(jtf_terr_all) and jtftjtrr.sql(jtf_terr_rsc_all) */

145:
146: -- This procedure will update the territory and resource end_date_active
147: -- to start_date_active + 10 years
148:
149: /* replaced by the script jtftterr.sql(jtf_terr_all) and jtftjtrr.sql(jtf_terr_rsc_all) */
150: /*
151: Procedure update_terr_enddate_active
152: IS
153:

Line 156: Update jtf_terr_all jterr

152: IS
153:
154: BEGIN
155:
156: Update jtf_terr_all jterr
157: set jterr.end_date_active = jterr.start_date_active + 3652
158: where jterr.end_date_active is null;
159:
160: Update jtf_terr_rsc_all jtr

Line 187: Update jtf_terr_all jtabs

183: IS
184:
185: BEGIN
186:
187: Update jtf_terr_all jtabs
188: set enable_self_service = 'Y'
189: where (GEO_TERR_FLAG = 'Y' or NAMED_ACCOUNT_FLAG = 'Y')
190: and enable_self_service is null;
191:

Line 218: update jtf_terr_all jt

214: BEGIN
215:
216: -- Update the named account terrtories with territory template
217:
218: update jtf_terr_all jt
219: set jt.territory_type_id = -1
220: where jt.named_account_flag = 'Y'
221: and jt.territory_type_id is null;
222:

Line 225: update jtf_terr_all jt

221: and jt.territory_type_id is null;
222:
223: -- Update the self service geo terrtories with territory template
224:
225: update jtf_terr_all jt
226: set jt.territory_type_id = -2
227: where jt.GEO_TERR_FLAG = 'Y'
228: and jt.territory_type_id is null;
229:

Line 232: update jtf_terr_all jt

228: and jt.territory_type_id is null;
229:
230: -- Update non named account terrtories with territory template
231:
232: update jtf_terr_all jt
233: set jt.territory_type_id =
234: (select jttu.terr_type_id
235: from jtf_terr_type_usgs_all jttu
236: , jtf_terr_usgs_all jtu

Line 451: from jtf_terr_all

447: , sysdate
448: , org_id
449: , -1001
450: from (select distinct org_id
451: from jtf_terr_all
452: where geo_terr_flag = 'Y');
453:
454: EXCEPTION
455: when FND_API.G_EXC_ERROR then