APPS.MSC_PQ_UTILS dependencies on MSC_SELECTION_CRITERIA

Line 793: FROM msc_selection_criteria_v

789: object_type,
790: lov_type,
791: sequence,
792: object_sequence_id
793: FROM msc_selection_criteria_v
794: WHERE folder_id = p_query_id
795: AND active_flag = 1
796: AND condition IS NOT NULL
797: AND source_type = p_source_type

Line 898: FROM msc_selection_criteria_v

894: object_type,
895: lov_type,
896: sequence,
897: object_sequence_id
898: FROM msc_selection_criteria_v
899: WHERE folder_id = p_query_id
900: AND active_flag = 1
901: AND condition IS NOT NULL
902: ORDER BY source_type, object_type, field_name;

Line 917: FROM msc_selection_criteria_v

913: object_type,
914: lov_type,
915: sequence,
916: object_sequence_id
917: FROM msc_selection_criteria_v
918: WHERE folder_id = p_query_id
919: AND active_flag = 1
920: AND condition IS NOT NULL
921: AND source_type = p_source_type

Line 926: FROM msc_selection_criteria_v

922: AND object_type = p_object_type;
923:
924: CURSOR c_excp_type IS
925: SELECT DISTINCT object_type
926: FROM msc_selection_criteria_v
927: WHERE folder_id = p_query_id
928: AND active_flag = 1
929: AND source_type = p_source_type;
930:

Line 1092: FROM msc_selection_criteria_v

1088: object_type,
1089: lov_type,
1090: sequence,
1091: object_sequence_id
1092: FROM msc_selection_criteria_v
1093: WHERE folder_id = p_query_id
1094: AND active_flag = 1
1095: AND condition IS NOT NULL
1096: AND source_type = p_source_type

Line 1455: msc_selection_criteria msc,

1451: mav.or_values),
1452: mav.or_values) or_values,
1453: mav.hidden_values
1454: FROM msc_among_values mav,
1455: msc_selection_criteria msc,
1456: msc_criteria mc
1457: WHERE mav.folder_id = p_folder_id
1458: AND msc.folder_id=mav.folder_id
1459: AND mc.folder_object =msc.folder_object

Line 1709: FROM msc_selection_criteria msc,

1705: p_query_type IN NUMBER) RETURN NUMBER IS
1706:
1707: CURSOR c_validate IS
1708: SELECT count(*)
1709: FROM msc_selection_criteria msc,
1710: msc_personal_queries mpq
1711: WHERE (mpq.query_id = msc.folder_id
1712: AND mpq.query_id = p_query_id and msc.active_flag=1)
1713: AND ( ( mpq.query_type = 1

Line 1745: FROM msc_selection_criteria msc,

1741: P_source_type IN NUMBER,
1742: P_object_type IN NUMBER,
1743: P_sequence_id IN NUMBER) IS
1744: SELECT COUNT(*)
1745: FROM msc_selection_criteria msc,
1746: msc_pq_types mpt,
1747: msc_personal_queries mpq
1748: WHERE (mpq.query_id = mpt.query_id
1749: AND mpq.query_id = p_query_id

Line 1767: FROM msc_selection_criteria msc,

1763: OR msc.field_name like '%ITEM_NAME%');--orders
1764:
1765: CURSOR c_validate_wl IS
1766: SELECT count(*)
1767: FROM msc_selection_criteria msc,
1768: msc_personal_queries mpq
1769: WHERE mpq.query_id = msc.folder_id
1770: AND mpq.query_id = p_query_id
1771: AND msc.active_flag = 1

Line 1787: FROM msc_selection_criteria

1783: l_temp number;
1784:
1785: CURSOR c_groupby is
1786: SELECT distinct field_name
1787: FROM msc_selection_criteria
1788: WHERE folder_id = p_query_id
1789: AND NVL(count_by,2) = 1;
1790:
1791: l_dummy_field varchar2(100);