APPS.JTF_TERR_RPT dependencies on JTF_TERR_RSC_ALL

Line 92: ' , APPS.jtf_terr_rsc_all jtr ' ||

88: ' , APPS.hz_locations hzl ' ||
89: ' , APPS.hz_party_sites hzps ' ||
90: ' , APPS.hz_parties hzp ' ||
91: ' , APPS.as_accesses_all aaa ' ||
92: ' , APPS.jtf_terr_rsc_all jtr ' ||
93: ' WHERE ' ||
94: ' ( ( hzl.postal_code = Q1007R1.low_value_char AND ' ||
95: ' Q1007R1.comparison_operator = ''='' ) ' ||
96: ' OR ' ||

Line 130: ' , APPS.jtf_terr_rsc_all jtr ' ||

126: ' , APPS.hz_locations hzl ' ||
127: ' , APPS.hz_party_sites hzps ' ||
128: ' , APPS.hz_parties hzp ' ||
129: ' , APPS.as_accesses_all aaa ' ||
130: ' , APPS.jtf_terr_rsc_all jtr ' ||
131: ' WHERE ' ||
132: ' ( ( hzl.postal_code = Q1007R1.low_value_char AND ' ||
133: ' Q1007R1.comparison_operator = ''='' ) ' ||
134: ' OR ' ||

Line 168: ' , APPS.jtf_terr_rsc_all jtr ' ||

164: ' , APPS.hz_locations hzl ' ||
165: ' , APPS.hz_party_sites hzps ' ||
166: ' , APPS.hz_parties hzp ' ||
167: ' , APPS.as_accesses_all aaa ' ||
168: ' , APPS.jtf_terr_rsc_all jtr ' ||
169: ' WHERE ' ||
170: ' ( ( hzl.postal_code = Q1007R1.low_value_char AND ' ||
171: ' Q1007R1.comparison_operator = ''='' ) ' ||
172: ' OR ' ||

Line 206: ' , APPS.jtf_terr_rsc_all jtr ' ||

202: ' , APPS.hz_locations hzl ' ||
203: ' , APPS.hz_party_sites hzps ' ||
204: ' , APPS.hz_parties hzp ' ||
205: ' , APPS.as_accesses_all aaa ' ||
206: ' , APPS.jtf_terr_rsc_all jtr ' ||
207: ' WHERE ' ||
208: ' ( ( hzl.postal_code = Q1007R1.low_value_char AND ' ||
209: ' Q1007R1.comparison_operator = ''='' ) ' ||
210: ' OR ' ||

Line 294: jtf_terr_rsc_all jtra

290: jta.name,
291: jta.rank,
292: p_session_id
293: from jtf_terr_all jta,
294: jtf_terr_rsc_all jtra
295: where jta.terr_id = jtra.terr_id
296: and (jtra.resource_id = p_resource_id or p_resource_id = -999)
297: and (jtra.group_id = p_group_id or p_group_id =-999)
298: AND NOT EXISTS (