DBA Data[Home] [Help]

APPS.OZF_PARTY_MKT_SEG_LOADER_PVT dependencies on JTF_TERR_USGS_ALL

Line 1918: JTF_TERR_USGS_ALL JTU ,

1914: AND parent_territory_id = 1;
1915: */
1916: select distinct JTR.terr_id
1917: FROM JTF_TERR_ALL JTR ,
1918: JTF_TERR_USGS_ALL JTU ,
1919: JTF_SOURCES_ALL JSE
1920: WHERE JTU.TERR_ID = JTR.TERR_ID
1921: AND JTU.SOURCE_ID = JSE.SOURCE_ID
1922: AND JTU.SOURCE_ID = -1003