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.MSD_DEM_QUERY_UTILITIES dependencies on MSD_DEM_ENTITY_QUERIES

Line 80: msd_dem_entity_queries mdeq

76:
77: cursor c_get_part1_query is
78: select query
79: from msd_dem_queries mdq,
80: msd_dem_entity_queries mdeq
81: where mdeq.part1 = mdq.query_id
82: and mdeq.entity_name = p_entity_name;
83:
84: cursor c_get_part2_query is

Line 87: msd_dem_entity_queries mdeq

83:
84: cursor c_get_part2_query is
85: select query
86: from msd_dem_queries mdq,
87: msd_dem_entity_queries mdeq
88: where mdeq.part2 = mdq.query_id
89: and mdeq.entity_name = p_entity_name;
90:
91: cursor c_get_part3_query is

Line 94: msd_dem_entity_queries mdeq

90:
91: cursor c_get_part3_query is
92: select query
93: from msd_dem_queries mdq,
94: msd_dem_entity_queries mdeq
95: where mdeq.part3 = mdq.query_id
96: and mdeq.entity_name = p_entity_name;
97:
98: begin

Line 173: open c_get_parts for select query from msd_dem_queries mdq,msd_dem_entity_queries mdeq where mdeq.part1 = mdq.query_id and mdeq.entity_name = p_entity_name;

169:
170: /*msd_dem_common_utilities.log_message();*/
171: msd_dem_common_utilities.log_debug('The instance dblink for this query will be: '|| v_srdblink );
172:
173: open c_get_parts for select query from msd_dem_queries mdq,msd_dem_entity_queries mdeq where mdeq.part1 = mdq.query_id and mdeq.entity_name = p_entity_name;
174: fetch c_get_parts into l_part1_query;
175: close c_get_parts;
176:
177: open c_get_parts for select query from msd_dem_queries mdq,msd_dem_entity_queries mdeq where mdeq.part2 = mdq.query_id and mdeq.entity_name = p_entity_name;

Line 177: open c_get_parts for select query from msd_dem_queries mdq,msd_dem_entity_queries mdeq where mdeq.part2 = mdq.query_id and mdeq.entity_name = p_entity_name;

173: open c_get_parts for select query from msd_dem_queries mdq,msd_dem_entity_queries mdeq where mdeq.part1 = mdq.query_id and mdeq.entity_name = p_entity_name;
174: fetch c_get_parts into l_part1_query;
175: close c_get_parts;
176:
177: open c_get_parts for select query from msd_dem_queries mdq,msd_dem_entity_queries mdeq where mdeq.part2 = mdq.query_id and mdeq.entity_name = p_entity_name;
178: fetch c_get_parts into l_part2_query;
179: close c_get_parts;
180:
181: open c_get_parts for select query from msd_dem_queries mdq,msd_dem_entity_queries mdeq where mdeq.part3 = mdq.query_id and mdeq.entity_name = p_entity_name;

Line 181: open c_get_parts for select query from msd_dem_queries mdq,msd_dem_entity_queries mdeq where mdeq.part3 = mdq.query_id and mdeq.entity_name = p_entity_name;

177: open c_get_parts for select query from msd_dem_queries mdq,msd_dem_entity_queries mdeq where mdeq.part2 = mdq.query_id and mdeq.entity_name = p_entity_name;
178: fetch c_get_parts into l_part2_query;
179: close c_get_parts;
180:
181: open c_get_parts for select query from msd_dem_queries mdq,msd_dem_entity_queries mdeq where mdeq.part3 = mdq.query_id and mdeq.entity_name = p_entity_name;
182: fetch c_get_parts into l_part3_query;
183: close c_get_parts;
184: query := l_part1_query || l_part2_query || l_part3_query;
185: cv_name:=p_entity_name||'_V';

Line 191: open c_get_parts for select query from msd_dem_queries mdq,msd_dem_entity_queries mdeq where mdeq.part1 = mdq.query_id and mdeq.entity_name = p_entity_name||'_V';

187: if(flag=1) then
188: cv_name:=view_name;
189: end if;
190: -- Custom view does not exists. Create a new view.
191: open c_get_parts for select query from msd_dem_queries mdq,msd_dem_entity_queries mdeq where mdeq.part1 = mdq.query_id and mdeq.entity_name = p_entity_name||'_V';
192: fetch c_get_parts into l_part1_query;
193: close c_get_parts;
194:
195: open c_get_parts for select query from msd_dem_queries mdq,msd_dem_entity_queries mdeq where mdeq.part2 = mdq.query_id and mdeq.entity_name = p_entity_name||'_V';

Line 195: open c_get_parts for select query from msd_dem_queries mdq,msd_dem_entity_queries mdeq where mdeq.part2 = mdq.query_id and mdeq.entity_name = p_entity_name||'_V';

191: open c_get_parts for select query from msd_dem_queries mdq,msd_dem_entity_queries mdeq where mdeq.part1 = mdq.query_id and mdeq.entity_name = p_entity_name||'_V';
192: fetch c_get_parts into l_part1_query;
193: close c_get_parts;
194:
195: open c_get_parts for select query from msd_dem_queries mdq,msd_dem_entity_queries mdeq where mdeq.part2 = mdq.query_id and mdeq.entity_name = p_entity_name||'_V';
196: fetch c_get_parts into l_part2_query;
197: close c_get_parts;
198:
199: open c_get_parts for select query from msd_dem_queries mdq,msd_dem_entity_queries mdeq where mdeq.part3 = mdq.query_id and mdeq.entity_name = p_entity_name||'_V';

Line 199: open c_get_parts for select query from msd_dem_queries mdq,msd_dem_entity_queries mdeq where mdeq.part3 = mdq.query_id and mdeq.entity_name = p_entity_name||'_V';

195: open c_get_parts for select query from msd_dem_queries mdq,msd_dem_entity_queries mdeq where mdeq.part2 = mdq.query_id and mdeq.entity_name = p_entity_name||'_V';
196: fetch c_get_parts into l_part2_query;
197: close c_get_parts;
198:
199: open c_get_parts for select query from msd_dem_queries mdq,msd_dem_entity_queries mdeq where mdeq.part3 = mdq.query_id and mdeq.entity_name = p_entity_name||'_V';
200: fetch c_get_parts into l_part3_query;
201: close c_get_parts;
202:
203: i:=0;

Line 304: FROM msd_dem_entity_queries mdeq,

300:
301: log_debug ('The instance dblink for this query will be: ' || v_srdblink);
302:
303: OPEN xc_get_parts FOR SELECT query
304: FROM msd_dem_entity_queries mdeq,
305: msd_dem_queries mdq
306: WHERE mdeq.entity_name = p_entity_name
307: AND mdq.query_id = mdeq.part1;
308: FETCH xc_get_parts INTO x_query_part1;

Line 312: FROM msd_dem_entity_queries mdeq,

308: FETCH xc_get_parts INTO x_query_part1;
309: CLOSE xc_get_parts;
310:
311: OPEN xc_get_parts FOR SELECT query
312: FROM msd_dem_entity_queries mdeq,
313: msd_dem_queries mdq
314: WHERE mdeq.entity_name = p_entity_name
315: AND mdq.query_id = mdeq.part2;
316: FETCH xc_get_parts INTO x_query_part2;

Line 320: FROM msd_dem_entity_queries mdeq,

316: FETCH xc_get_parts INTO x_query_part2;
317: CLOSE xc_get_parts;
318:
319: OPEN xc_get_parts FOR SELECT query
320: FROM msd_dem_entity_queries mdeq,
321: msd_dem_queries mdq
322: WHERE mdeq.entity_name = p_entity_name
323: AND mdq.query_id = mdeq.part3;
324: FETCH xc_get_parts INTO x_query_part3;

Line 349: FROM msd_dem_entity_queries mdeq,

345: x_query_part2 := NULL;
346: x_query_part3 := NULL;
347:
348: OPEN xc_get_parts FOR SELECT query
349: FROM msd_dem_entity_queries mdeq,
350: msd_dem_queries mdq
351: WHERE mdeq.entity_name = x_view_name
352: AND mdq.query_id = mdeq.part1;
353: FETCH xc_get_parts INTO x_query_part1;

Line 357: FROM msd_dem_entity_queries mdeq,

353: FETCH xc_get_parts INTO x_query_part1;
354: CLOSE xc_get_parts;
355:
356: OPEN xc_get_parts FOR SELECT query
357: FROM msd_dem_entity_queries mdeq,
358: msd_dem_queries mdq
359: WHERE mdeq.entity_name = x_view_name
360: AND mdq.query_id = mdeq.part2;
361: FETCH xc_get_parts INTO x_query_part2;

Line 365: FROM msd_dem_entity_queries mdeq,

361: FETCH xc_get_parts INTO x_query_part2;
362: CLOSE xc_get_parts;
363:
364: OPEN xc_get_parts FOR SELECT query
365: FROM msd_dem_entity_queries mdeq,
366: msd_dem_queries mdq
367: WHERE mdeq.entity_name = x_view_name
368: AND mdq.query_id = mdeq.part3;
369: FETCH xc_get_parts INTO x_query_part3;