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_TASK_PUB dependencies on DUAL

Line 157: FROM DUAL

153: ( SELECT 'COUNTRY' attribute_name
154: ,null num_value
155: ,p_TerrTask_rec.COUNTRY char_value
156: ,null date_value
157: FROM DUAL
158: UNION ALL
159: SELECT 'CITY' attribute_name
160: ,null num_value
161: ,p_TerrTask_rec.CITY char_value

Line 163: FROM DUAL

159: SELECT 'CITY' attribute_name
160: ,null num_value
161: ,p_TerrTask_rec.CITY char_value
162: ,null date_value
163: FROM DUAL
164: UNION ALL
165: SELECT 'POSTAL_CODE' attribute_name
166: ,null num_value
167: ,p_TerrTask_rec.POSTAL_CODE char_value

Line 169: FROM DUAL

165: SELECT 'POSTAL_CODE' attribute_name
166: ,null num_value
167: ,p_TerrTask_rec.POSTAL_CODE char_value
168: ,null date_value
169: FROM DUAL
170: UNION ALL
171: SELECT 'STATE' attribute_name
172: ,null num_value
173: ,p_TerrTask_rec.STATE char_value

Line 175: FROM DUAL

171: SELECT 'STATE' attribute_name
172: ,null num_value
173: ,p_TerrTask_rec.STATE char_value
174: ,null date_value
175: FROM DUAL
176: UNION ALL
177: SELECT 'AREA_CODE' attribute_name
178: ,null num_value
179: ,p_TerrTask_rec.AREA_CODE char_value

Line 181: FROM DUAL

177: SELECT 'AREA_CODE' attribute_name
178: ,null num_value
179: ,p_TerrTask_rec.AREA_CODE char_value
180: ,null date_value
181: FROM DUAL
182: UNION ALL
183: SELECT 'COUNTY' attribute_name
184: ,null num_value
185: ,p_TerrTask_rec.COUNTY char_value

Line 187: FROM DUAL

183: SELECT 'COUNTY' attribute_name
184: ,null num_value
185: ,p_TerrTask_rec.COUNTY char_value
186: ,null date_value
187: FROM DUAL
188: UNION ALL
189: SELECT 'COMP_NAME_RANGE' attribute_name
190: ,null num_value
191: ,p_TerrTask_rec.COMP_NAME_RANGE char_value

Line 193: FROM DUAL

189: SELECT 'COMP_NAME_RANGE' attribute_name
190: ,null num_value
191: ,p_TerrTask_rec.COMP_NAME_RANGE char_value
192: ,null date_value
193: FROM DUAL
194: UNION ALL
195: SELECT 'PROVINCE' attribute_name
196: ,null num_value
197: ,p_TerrTask_rec.PROVINCE char_value

Line 199: FROM DUAL

195: SELECT 'PROVINCE' attribute_name
196: ,null num_value
197: ,p_TerrTask_rec.PROVINCE char_value
198: ,null date_value
199: FROM DUAL
200: UNION ALL
201: SELECT 'PARTY_ID' attribute_name
202: ,p_TerrTask_rec.PARTY_ID num_value
203: ,null char_value

Line 205: FROM DUAL

201: SELECT 'PARTY_ID' attribute_name
202: ,p_TerrTask_rec.PARTY_ID num_value
203: ,null char_value
204: ,null date_value
205: FROM DUAL
206: UNION ALL
207: SELECT 'PARTY_SITE_ID' attribute_name
208: ,p_TerrTask_rec.PARTY_SITE_ID num_value
209: ,null char_value

Line 211: FROM DUAL

207: SELECT 'PARTY_SITE_ID' attribute_name
208: ,p_TerrTask_rec.PARTY_SITE_ID num_value
209: ,null char_value
210: ,null date_value
211: FROM DUAL
212: UNION ALL
213: SELECT 'NUM_OF_EMPLOYEES' attribute_name
214: ,p_TerrTask_rec.NUM_OF_EMPLOYEES num_value
215: ,null char_value

Line 217: FROM DUAL

213: SELECT 'NUM_OF_EMPLOYEES' attribute_name
214: ,p_TerrTask_rec.NUM_OF_EMPLOYEES num_value
215: ,null char_value
216: ,null date_value
217: FROM DUAL
218: UNION ALL
219: SELECT 'TASK_TYPE_ID' attribute_name
220: ,p_TerrTask_rec.TASK_TYPE_ID num_value
221: ,null char_value

Line 223: FROM DUAL

219: SELECT 'TASK_TYPE_ID' attribute_name
220: ,p_TerrTask_rec.TASK_TYPE_ID num_value
221: ,null char_value
222: ,null date_value
223: FROM DUAL
224: UNION ALL
225: SELECT 'TASK_STATUS_ID' attribute_name
226: ,p_TerrTask_rec.TASK_STATUS_ID num_value
227: ,null char_value

Line 229: FROM DUAL

225: SELECT 'TASK_STATUS_ID' attribute_name
226: ,p_TerrTask_rec.TASK_STATUS_ID num_value
227: ,null char_value
228: ,null date_value
229: FROM DUAL
230: UNION ALL
231: SELECT 'TASK_PRIORITY_ID' attribute_name
232: ,p_TerrTask_rec.TASK_PRIORITY_ID num_value
233: ,null char_value

Line 235: FROM DUAL

231: SELECT 'TASK_PRIORITY_ID' attribute_name
232: ,p_TerrTask_rec.TASK_PRIORITY_ID num_value
233: ,null char_value
234: ,null date_value
235: FROM DUAL
236: UNION ALL
237: SELECT 'TASK_ID' attribute_name
238: ,p_TerrTask_rec.TASK_ID num_value
239: ,null char_value

Line 241: FROM DUAL

237: SELECT 'TASK_ID' attribute_name
238: ,p_TerrTask_rec.TASK_ID num_value
239: ,null char_value
240: ,null date_value
241: FROM DUAL
242: UNION ALL
243: SELECT 'ORGANIZATION_ID' attribute_name
244: ,p_TerrTask_rec.ORGANIZATION_ID num_value
245: ,null char_value

Line 247: FROM DUAL

243: SELECT 'ORGANIZATION_ID' attribute_name
244: ,p_TerrTask_rec.ORGANIZATION_ID num_value
245: ,null char_value
246: ,null date_value
247: FROM DUAL
248: );
249:
250: /*
251: lp_Rec.squal_char01 := jtf_terr_char_360list(p_TerrTask_rec.COUNTRY);