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

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

353: TRUNC(j.start_date_active) <= NVL(p_param4, lp_sysdate)
354: )
355: AND EXISTS
356: ( select jtr.terr_id
357: from jtf_terr_rsc jtr, jtf_terr_qual jtq, jtf_terr_usgs jtu
358: where jtr.terr_id = jtq.terr_id
359: and jtr.terr_id = jtu.terr_id
360: and jtr.resource_id = decode(l_resource_id ,null, jtr.resource_id, l_resource_id)
361: /* ARPATEL: 10/16, bug#2832442 */