APPS.JTY_MIGRATION_PVT dependencies on JTF_TERR_TYPE_USGS_ALL

Line 235: from jtf_terr_type_usgs_all jttu

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
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

Line 472: -- jtf_terr_type_usgs_all table

468:
469: BEGIN
470: -- For every row in jtf_terr_type_all table
471: -- insert a corresponding row in
472: -- jtf_terr_type_usgs_all table
473:
474: insert into jtf_terr_type_usgs_all
475: ( TERR_TYPE_USG_ID
476: , LAST_UPDATED_BY

Line 474: insert into jtf_terr_type_usgs_all

470: -- For every row in jtf_terr_type_all table
471: -- insert a corresponding row in
472: -- jtf_terr_type_usgs_all table
473:
474: insert into jtf_terr_type_usgs_all
475: ( TERR_TYPE_USG_ID
476: , LAST_UPDATED_BY
477: , LAST_UPDATE_DATE
478: , CREATED_BY

Line 537: from jtf_terr_type_usgs_all jttu

533: , 2
534: , jttu.terr_type_id
535: , jqtu.qual_type_usg_id
536: , jttu.org_id
537: from jtf_terr_type_usgs_all jttu
538: , jtf_qual_type_usgs_all jqtu
539: where jqtu.source_id = jttu.source_id
540: and jqtu.qual_type_usg_id <> -1005 -- Exclude service account transaction type
541: and jttu.created_by = 2;

Line 581: from jtf_terr_type_usgs_all jttu

577: , sysdate
578: , jqu.QUAL_USG_ID
579: , jttu.terr_type_id
580: , jttu.org_id
581: from jtf_terr_type_usgs_all jttu
582: , jtf_qual_type_usgs_all jqtu
583: , jtf_qual_usgs_all jqu
584: where jttu.created_by = 2
585: and jqu.QUAL_TYPE_USG_ID = jqtu.qual_type_usg_id