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.JTF_TERR_JSP_REPORTS dependencies on JTF_QUAL_USGS_ALL

Line 131: JTF_QUAL_USGS_ALL JQU ,

127: JTQ.ORG_ID,
128: WF_NOTIFICATION.SUBSTITUTESPECIALCHARS(JSQ.NAME) QUALIFIER_NAME
129: FROM
130: JTF_TERR_QUAL_ALL JTQ ,
131: JTF_QUAL_USGS_ALL JQU ,
132: JTF_SEEDED_QUAL_ALL_TL JSQ ,
133: JTF_QUAL_TYPE_USGS_ALL JQTU ,
134: JTF_QUAL_TYPES JQT
135: WHERE JTQ.QUAL_USG_ID = JQU.QUAL_USG_ID

Line 216: FROM jtf_terr_values_all j1, JTF_QUAL_USGS_ALL j2, JTF_TERR_QUAL_ALL j3

212: , null LOW_VALUE_DATE
213: , null HIGH_VALUE_DATE
214: , DISPLAY_TYPE
215: , CONVERT_TO_ID_FLAG
216: FROM jtf_terr_values_all j1, JTF_QUAL_USGS_ALL j2, JTF_TERR_QUAL_ALL j3
217: WHERE j1.terr_qual_id = ci_terr_qual_id
218: AND j1.terr_qual_id = j3.terr_qual_id
219: AND j2.QUAL_USG_ID = j3.QUAL_USG_ID
220: AND j1.terr_value_id is not null

Line 267: FROM jtf_terr_values_all j1, JTF_QUAL_USGS_ALL j2, JTF_TERR_QUAL_ALL j3

263: , null LOW_VALUE_DATE
264: , null HIGH_VALUE_DATE
265: , DISPLAY_TYPE
266: , CONVERT_TO_ID_FLAG
267: FROM jtf_terr_values_all j1, JTF_QUAL_USGS_ALL j2, JTF_TERR_QUAL_ALL j3
268: WHERE j1.terr_qual_id = ci_terr_qual_id
269: AND j1.terr_qual_id = j3.terr_qual_id
270: AND j2.QUAL_USG_ID = j3.QUAL_USG_ID
271: AND j1.terr_value_id is not null