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.MST_PQ_WORKS dependencies on MST_SELECTION

Line 40: FROM mst_selection_criteria msc,

36: ms.FIELD_TYPE , msc.SEQUENCE ,
37: msc.FILTER_TYPE , msc.FIELD_VALUE_FROM,
38: msc.FIELD_VALUE_TO, msc.MULTI_SELECT ,
39: msc.ACTIVE_FLAG , msc.CREATED_BY
40: FROM mst_selection_criteria msc,
41: mst_selection ms
42: WHERE msc.query_id = p_query_id
43: AND ms.field_name = msc.field_name
44: AND msc.active_flag = 1

Line 41: mst_selection ms

37: msc.FILTER_TYPE , msc.FIELD_VALUE_FROM,
38: msc.FIELD_VALUE_TO, msc.MULTI_SELECT ,
39: msc.ACTIVE_FLAG , msc.CREATED_BY
40: FROM mst_selection_criteria msc,
41: mst_selection ms
42: WHERE msc.query_id = p_query_id
43: AND ms.field_name = msc.field_name
44: AND msc.active_flag = 1
45: ORDER BY msc.SEQUENCE;

Line 856: DELETE mst_selection_criteria

852: BEGIN
853: DELETE mst_personal_query_results
854: WHERE query_id = p_query_id;
855: --IF p_query_type IN (1,2,3,4) THEN
856: DELETE mst_selection_criteria
857: WHERE query_id = p_query_id;
858: --END IF;
859: EXCEPTION
860: WHEN OTHERS THEN

Line 890: DELETE mst_selection_criteria

886: END IF;
887: DELETE mst_personal_query_results
888: WHERE query_id = p_query_id;
889:
890: DELETE mst_selection_criteria
891: WHERE query_id = p_query_id;
892: COMMIT;
893: EXCEPTION
894: WHEN OTHERS THEN

Line 956: l_delete_str := 'DELETE MST_SELECTION_CRITERIA WHERE QUERY_ID = :P_QUERYID';

952: l_sequence := 0;
953: l_multi_select := 2; -- 1 true, 2 false
954: l_active_flag := 1;
955: l_userid := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
956: l_delete_str := 'DELETE MST_SELECTION_CRITERIA WHERE QUERY_ID = :P_QUERYID';
957: l_executed := execute_dyn_sql(l_delete_str,p_query_id);
958: IF l_executed = 0 THEN
959: RAISE execution_failed;
960: END IF;

Line 966: l_insert_begin := 'INSERT INTO MST_SELECTION_CRITERIA '||

962: FND_MESSAGE.set_name('MST','MST_PQ_ALL');
963: g_select_all:= FND_MESSAGE.GET;
964: --g_select_all := 'All';
965: END IF;
966: l_insert_begin := 'INSERT INTO MST_SELECTION_CRITERIA '||
967: '(QUERY_ID , FIELD_NAME , SEQUENCE ,'||
968: 'FILTER_TYPE , FIELD_VALUE_FROM, DISPLAY_VALUE,'||
969: 'FIELD_VALUE_TO, MULTI_SELECT , ACTIVE_FLAG ,'||
970: 'CREATED_BY , CREATION_DATE ) VALUES ';

Line 2394: l_delete_str := 'DELETE MST_SELECTION_CRITERIA WHERE QUERY_ID = :P_QUERYID';

2390: l_sequence := 0;
2391: l_multi_select := 2; -- 1 true, 2 false
2392: l_active_flag := 1;
2393: l_userid := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
2394: l_delete_str := 'DELETE MST_SELECTION_CRITERIA WHERE QUERY_ID = :P_QUERYID';
2395: l_executed := execute_dyn_sql(l_delete_str,p_query_id);
2396: IF l_executed = 0 THEN
2397: RAISE execution_failed;
2398: END IF;

Line 2404: l_insert_begin := 'INSERT INTO MST_SELECTION_CRITERIA '||

2400: FND_MESSAGE.set_name('MST','MST_PQ_ALL');
2401: g_select_all:= FND_MESSAGE.GET;
2402: --g_select_all := 'All';
2403: END IF;
2404: l_insert_begin := 'INSERT INTO MST_SELECTION_CRITERIA '||
2405: '(QUERY_ID , FIELD_NAME , SEQUENCE ,'||
2406: 'FILTER_TYPE , FIELD_VALUE_FROM, DISPLAY_VALUE,'||
2407: 'FIELD_VALUE_TO, MULTI_SELECT , ACTIVE_FLAG ,'||
2408: 'CREATED_BY , CREATION_DATE ) VALUES ';

Line 2658: l_delete_str := 'DELETE MST_SELECTION_CRITERIA WHERE QUERY_ID = :P_QUERYID';

2654: l_sequence := 0;
2655: l_multi_select := 2; -- 1 true, 2 false
2656: l_active_flag := 1;
2657: l_userid := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
2658: l_delete_str := 'DELETE MST_SELECTION_CRITERIA WHERE QUERY_ID = :P_QUERYID';
2659: l_executed := execute_dyn_sql(l_delete_str,p_query_id);
2660: IF l_executed = 0 THEN
2661: RAISE execution_failed;
2662: END IF;

Line 2668: l_insert_begin := 'INSERT INTO MST_SELECTION_CRITERIA '||

2664: FND_MESSAGE.set_name('MST','MST_PQ_ALL');
2665: g_select_all:= FND_MESSAGE.GET;
2666: --g_select_all := 'All';
2667: END IF;
2668: l_insert_begin := 'INSERT INTO MST_SELECTION_CRITERIA '||
2669: '(QUERY_ID , FIELD_NAME , SEQUENCE ,'||
2670: 'FILTER_TYPE , FIELD_VALUE_FROM, DISPLAY_VALUE,'||
2671: 'FIELD_VALUE_TO, MULTI_SELECT , ACTIVE_FLAG ,'||
2672: 'CREATED_BY , CREATION_DATE ) VALUES ';

Line 3821: l_delete_str := 'DELETE MST_SELECTION_CRITERIA WHERE QUERY_ID = :P_QUERYID';

3817: l_sequence := 0;
3818: l_multi_select := 2; -- 1 true, 2 false
3819: l_active_flag := 1;
3820: l_userid := TO_NUMBER(FND_PROFILE.VALUE('USER_ID'));
3821: l_delete_str := 'DELETE MST_SELECTION_CRITERIA WHERE QUERY_ID = :P_QUERYID';
3822: l_executed := execute_dyn_sql(l_delete_str,p_query_id);
3823: IF l_executed = 0 THEN
3824: RAISE execution_failed;
3825: END IF;

Line 3831: l_insert_begin := 'INSERT INTO MST_SELECTION_CRITERIA '||

3827: FND_MESSAGE.set_name('MST','MST_PQ_ALL');
3828: g_select_all:= FND_MESSAGE.GET;
3829: --g_select_all := 'All';
3830: END IF;
3831: l_insert_begin := 'INSERT INTO MST_SELECTION_CRITERIA '||
3832: '(QUERY_ID , FIELD_NAME , SEQUENCE ,'||
3833: 'FILTER_TYPE , FIELD_VALUE_FROM, DISPLAY_VALUE,'||
3834: 'FIELD_VALUE_TO, MULTI_SELECT , ACTIVE_FLAG ,'||
3835: 'CREATED_BY , CREATION_DATE ) VALUES ';