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_TERR_QUAL

Line 94: from jtf_terr_rsc jtr, jtf_terr_qual jtq

90: where NVL(j.end_date_active, sysdate) >= sysdate
91: AND j.start_date_active <= sysdate
92: AND EXISTS
93: ( select jtr.terr_id
94: from jtf_terr_rsc jtr, jtf_terr_qual jtq
95: where jtr.terr_id = jtq.terr_id
96: and jtr.resource_id = decode(lc_resource_id ,null, jtr.resource_id, lc_resource_id)
97: and jtq.qual_usg_id = decode(lc_qual_usg_id ,null, jtq.qual_usg_id, lc_qual_usg_id)
98: AND jtr.terr_id = j.terr_id

Line 116: FROM jtf_terr_qualifiers_v

112: TERR_ID,
113: QUAL_USG_ID,
114: ORG_ID,
115: WF_NOTIFICATION.SubstituteSpecialChars(qualifier_name) qualifier_name
116: FROM jtf_terr_qualifiers_v
117: WHERE qualifier_type_name <> 'RESOURCE'
118: and terr_id = ci_terr_id
119: and terr_qual_id is not null -- added becuse we have some real bad data in jtadom
120: ;

Line 130: JTF_TERR_QUAL_ALL JTQ ,

126: JTQ.QUAL_USG_ID,
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

Line 153: FROM jtf_terr_qualifiers_v

149: TERR_ID,
150: QUAL_USG_ID,
151: ORG_ID,
152: WF_NOTIFICATION.SubstituteSpecialChars(qualifier_name) qualifier_name
153: FROM jtf_terr_qualifiers_v
154: WHERE qualifier_type_name = 'RESOURCE'
155: and terr_id = ci_terr_id;
156:
157:

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

201: , null LOW_VALUE_DATE
202: , null HIGH_VALUE_DATE
203: , DISPLAY_TYPE
204: , CONVERT_TO_ID_FLAG
205: FROM jtf_terr_values_all j1, JTF_QUAL_USGS_ALL j2, JTF_TERR_QUAL_ALL j3
206: WHERE j1.terr_qual_id = ci_terr_qual_id
207: AND j1.terr_qual_id = j3.terr_qual_id
208: AND j2.QUAL_USG_ID = j3.QUAL_USG_ID
209: AND j1.terr_value_id is not null

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

239: , null LOW_VALUE_DATE
240: , null HIGH_VALUE_DATE
241: , DISPLAY_TYPE
242: , CONVERT_TO_ID_FLAG
243: FROM jtf_terr_values_all j1, JTF_QUAL_USGS_ALL j2, JTF_TERR_QUAL_ALL j3
244: WHERE j1.terr_qual_id = ci_terr_qual_id
245: AND j1.terr_qual_id = j3.terr_qual_id
246: AND j2.QUAL_USG_ID = j3.QUAL_USG_ID
247: AND j1.terr_value_id is not null

Line 333: from jtf_terr_rsc jtr, jtf_terr_qual jtq, jtf_terr_usgs jtu

329: TRUNC(j.start_date_active) <= NVL(p_param4, lp_sysdate)
330: )
331: AND EXISTS
332: ( select jtr.terr_id
333: from jtf_terr_rsc jtr, jtf_terr_qual jtq, jtf_terr_usgs jtu
334: where jtr.terr_id = jtq.terr_id
335: and jtr.terr_id = jtu.terr_id
336: and jtr.resource_id = decode(l_resource_id ,null, jtr.resource_id, l_resource_id)
337: /* ARPATEL: 10/16, bug#2832442 */