eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_TERR_LEVELS_PVT dependencies on JTF_TERR_USGS_ALL

Line 552: FROM JTF_TERR_ALL JTR , JTF_TERR_USGS_ALL JTU , JTF_SOURCES_ALL JSE

548:
549: -- same as value set OZF_SRS_TERR_HIER_START_NODE used for concurrent program start node parameter
550: CURSOR c_get_all_root_nodes IS
551: SELECT JTR.TERR_ID
552: FROM JTF_TERR_ALL JTR , JTF_TERR_USGS_ALL JTU , JTF_SOURCES_ALL JSE
553: WHERE JTU.TERR_ID = JTR.TERR_ID
554: AND JTU.SOURCE_ID = JSE.SOURCE_ID
555: AND JTU.SOURCE_ID = -1003
556: AND JTR.PARENT_TERRITORY_ID = 1