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.MSC_PQ_UTILS dependencies on MSC_PQ_RESULTS

Line 1950: DELETE msc_pq_results

1946: PROCEDURE delete_from_results_table(p_query_id IN NUMBER,
1947: p_plan_id IN NUMBER) IS
1948: BEGIN
1949: --KSA_DEBUG(SYSDATE,' p_query_id <> '||p_query_id,'delete_from_results_table');
1950: DELETE msc_pq_results
1951: WHERE query_id = p_query_id
1952: AND plan_id = p_plan_id ;
1953: END delete_from_results_table;
1954:

Line 2297: l_stmt := 'SELECT DISTINCT TRANSACTION_ID FROM MSC_PQ_RESULTS '||

2293: END LOOP;
2294: /*
2295: IF l_List IS NOT NULL THEN
2296: l_list := '('||l_list||')';
2297: l_stmt := 'SELECT DISTINCT TRANSACTION_ID FROM MSC_PQ_RESULTS '||
2298: 'WHERE QUERy_ID IN '||l_lIST;
2299: OPEN t_cur FOR l_stmt;
2300: LOOP
2301: FETCH t_cur INTO l_transaction_id;

Line 2371: from msc_pq_results

2367: --AND pqt.DETAIL_QUERY_ID is not null;
2368:
2369: cursor c_top_actions is
2370: select distinct priority
2371: from msc_pq_results
2372: where plan_id = p_plan_id
2373: and query_id = p_query_id
2374: and SUMMARY_DATA = 1;
2375: l_query_id number;

Line 2383: update msc_pq_results

2379: open c_top_priority(rec_top_actions.priority);
2380: fetch c_top_priority into l_query_id;
2381: close c_top_priority;
2382: if nvl(l_query_id,0) <> 0 then
2383: update msc_pq_results
2384: set DETAIL_QUERY_ID = l_query_id
2385: where plan_id = p_plan_id
2386: and query_id = p_query_id
2387: and SUMMARY_DATA = 1