APPS.JTY_MIGRATION_PVT dependencies on JTF_TERR_USGS_ALL

Line 94: , jtf_terr_usgs_all jtu

90: where jtr1.TERR_RSC_ID = jtra.terr_rsc_id)
91: where jtra.terr_rsc_id in
92: (select jtr2.terr_rsc_id
93: from jtf_terr_rsc_all jtr2
94: , jtf_terr_usgs_all jtu
95: where jtr2.terr_id = jtu.terr_id
96: and jtu.source_id = -1001)
97: and jtra.trans_access_code is null;
98:

Line 108: , jtf_terr_usgs_all jtu

104: where jtr1.TERR_RSC_ID = jtra.terr_rsc_id)
105: where jtra.terr_rsc_id in
106: (select jtr2.terr_rsc_id
107: from jtf_terr_rsc_all jtr2
108: , jtf_terr_usgs_all jtu
109: where jtr2.terr_id = jtu.terr_id
110: and jtu.source_id = -1002)
111: and jtra.trans_access_code is null;
112:

Line 122: , jtf_terr_usgs_all jtu

118: where jtr1.TERR_RSC_ID = jtra.terr_rsc_id)
119: where jtra.terr_rsc_id in
120: (select jtr2.terr_rsc_id
121: from jtf_terr_rsc_all jtr2
122: , jtf_terr_usgs_all jtu
123: where jtr2.terr_id = jtu.terr_id
124: and jtu.source_id = -1003)
125: and jtra.trans_access_code is null;
126:

Line 236: , jtf_terr_usgs_all jtu

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
237: where jttu.source_id = jtu.source_id
238: and jt.terr_id = jtu.terr_id
239: and jttu.created_by = 2 -- territory templates shipped by Oracle
240: and jttu.terr_type_id not in (-1, -2) -- Eliminate named account

Line 368: from jtf_terr_usgs_all jtu

364: , source_id
365: from (select distinct jtu.org_id
366: , jtu.source_id
367: , jsa.meaning
368: from jtf_terr_usgs_all jtu
369: , jtf_sources_all jsa
370: where jsa.source_id = jtu.source_id);
371: EXCEPTION
372: when FND_API.G_EXC_ERROR then