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_SELECTION_CRITERIA

Line 797: FROM msc_selection_criteria_v

793: object_type,
794: lov_type,
795: sequence,
796: object_sequence_id
797: FROM msc_selection_criteria_v
798: WHERE folder_id = p_query_id
799: AND active_flag = 1
800: AND condition IS NOT NULL
801: AND source_type = p_source_type

Line 902: FROM msc_selection_criteria_v

898: object_type,
899: lov_type,
900: sequence,
901: object_sequence_id
902: FROM msc_selection_criteria_v
903: WHERE folder_id = p_query_id
904: AND active_flag = 1
905: AND condition IS NOT NULL
906: ORDER BY source_type, object_type, field_name;

Line 921: FROM msc_selection_criteria_v

917: object_type,
918: lov_type,
919: sequence,
920: object_sequence_id
921: FROM msc_selection_criteria_v
922: WHERE folder_id = p_query_id
923: AND active_flag = 1
924: AND condition IS NOT NULL
925: AND source_type = p_source_type

Line 930: FROM msc_selection_criteria_v

926: AND object_type = p_object_type;
927:
928: CURSOR c_excp_type IS
929: SELECT DISTINCT object_type
930: FROM msc_selection_criteria_v
931: WHERE folder_id = p_query_id
932: AND active_flag = 1
933: AND source_type = p_source_type;
934:

Line 1096: FROM msc_selection_criteria_v

1092: object_type,
1093: lov_type,
1094: sequence,
1095: object_sequence_id
1096: FROM msc_selection_criteria_v
1097: WHERE folder_id = p_query_id
1098: AND active_flag = 1
1099: AND condition IS NOT NULL
1100: AND source_type = p_source_type

Line 1472: msc_selection_criteria msc,

1468: mav.or_values),
1469: mav.or_values) or_values,
1470: mav.hidden_values
1471: FROM msc_among_values mav,
1472: msc_selection_criteria msc,
1473: msc_criteria mc
1474: WHERE mav.folder_id = p_folder_id
1475: AND msc.folder_id=mav.folder_id
1476: AND mc.folder_object =msc.folder_object

Line 1737: FROM msc_selection_criteria msc,

1733: p_query_type IN NUMBER) RETURN NUMBER IS
1734:
1735: CURSOR c_validate IS
1736: SELECT count(*)
1737: FROM msc_selection_criteria msc,
1738: msc_personal_queries mpq
1739: WHERE (mpq.query_id = msc.folder_id
1740: AND mpq.query_id = p_query_id and msc.active_flag=1)
1741: AND ( ( mpq.query_type = 1

Line 1773: FROM msc_selection_criteria msc,

1769: P_source_type IN NUMBER,
1770: P_object_type IN NUMBER,
1771: P_sequence_id IN NUMBER) IS
1772: SELECT COUNT(*)
1773: FROM msc_selection_criteria msc,
1774: msc_pq_types mpt,
1775: msc_personal_queries mpq
1776: WHERE (mpq.query_id = mpt.query_id
1777: AND mpq.query_id = p_query_id

Line 1795: FROM msc_selection_criteria msc,

1791: OR msc.field_name like '%ITEM_NAME%');--orders
1792:
1793: CURSOR c_validate_wl IS
1794: SELECT count(*)
1795: FROM msc_selection_criteria msc,
1796: msc_personal_queries mpq
1797: WHERE mpq.query_id = msc.folder_id
1798: AND mpq.query_id = p_query_id
1799: AND msc.active_flag = 1

Line 1815: FROM msc_selection_criteria

1811: l_temp number;
1812:
1813: CURSOR c_groupby is
1814: SELECT distinct field_name
1815: FROM msc_selection_criteria
1816: WHERE folder_id = p_query_id
1817: AND NVL(count_by,2) = 1;
1818:
1819: l_dummy_field varchar2(100);

Line 2414: FROM msc_selection_criteria_v

2410: CURSOR c_criteria (p_folder_object VARCHAR2)
2411: IS
2412: SELECT field_name ,
2413: data_set
2414: FROM msc_selection_criteria_v
2415: WHERE folder_id=p_query_id
2416: AND active_flag =1
2417: AND condition IS NOT NULL
2418: AND folder_object =p_folder_object

Line 2424: FROM msc_selection_criteria_v

2420: data_set ;
2421: CURSOR c_folder_criteria
2422: IS
2423: SELECT DISTINCT FOLDER_objecT
2424: FROM msc_selection_criteria_v
2425: WHERE folder_id=p_query_id
2426: AND active_flag =1
2427: AND FOLDER_objecT LIKE 'MSC_WRKSH_FLTR%'
2428: AND condition IS NOT NULL

Line 2438: FROM msc_selection_criteria_v mc,

2434: mc.field_name ,
2435: mc.sql_statement ,
2436: mc.sql_statement2 ,
2437: fl.meaning
2438: FROM msc_selection_criteria_v mc,
2439: fnd_lookups fl
2440: WHERE mc.folder_id=p_query_id
2441: AND mc.active_flag =1
2442: AND mc.condition IS NULL

Line 2452: FROM msc_selection_criteria_v

2448:
2449: CURSOR c_folder_criteria_2
2450: IS
2451: SELECT DISTINCT FOLDER_objecT
2452: FROM msc_selection_criteria_v
2453: WHERE folder_id=p_query_id
2454: AND active_flag =1
2455: AND FOLDER_objecT LIKE 'MSC_WRKSH_RSLT%'
2456: AND condition IS NULL

Line 2465: FROM msc_selection_criteria

2461: IS
2462: SELECT field_name ,
2463: hidden_from_field,
2464: from_field,folder_object
2465: FROM msc_selection_criteria
2466: WHERE folder_id=p_query_id
2467: AND active_flag =1
2468: AND condition IS NULL
2469: AND folder_object ='MSC_WRKSH_FLTR_OTHER'

Line 3880: FROM msc_selection_criteria_v

3876: object_type,
3877: lov_type,
3878: sequence,
3879: object_sequence_id
3880: FROM msc_selection_criteria_v
3881: WHERE folder_id = p_query_id
3882: AND active_flag = 1
3883: AND condition IS NOT NULL
3884: AND folder_object LIKE 'MSC_WRKSH_FLTR%'