APPS.MSC_PQ_UTILS dependencies on MSC_SELECTION_CRITERIA_V

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 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 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%'