APPS.MSC_PQ_UTILS dependencies on MSC_PERSONAL_QUERIES

Line 20: msc_personal_queries mpq

16:
17: CURSOR detailQCur(p_query_id IN NUMBER) IS
18: SELECT pqt.DETAIL_QUERY_ID query_id,mpq.query_type
19: FROM MSC_PQ_TYPES pqt,
20: msc_personal_queries mpq
21: WHERE pqt.query_id = p_query_id
22: AND mpq.query_id = pqt.DETAIL_QUERY_ID;
23:
24: CURSOR WlExcepCur(p_query_id IN NUMBER) IS

Line 933: FROM msc_personal_queries

929: AND source_type = p_source_type;
930:
931: CURSOR c_and_or IS
932: SELECT count(*)
933: FROM msc_personal_queries
934: WHERE query_id = p_query_id
935: AND NVL(and_or_flag,1) = 1;
936:
937: CURSOR c_excp_and_or (p_object_type NUMBER) IS

Line 1710: msc_personal_queries mpq

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
1714: AND field_name in ('BUYER_NAME', 'ITEM_SEGMENTS',

Line 1747: msc_personal_queries mpq

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
1750: AND mpt.active_flag = 1
1751: AND msc.folder_id = mpt.query_id

Line 1768: msc_personal_queries mpq

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
1772: AND mpq.query_type = 10

Line 1940: FROM msc_personal_queries

1936: where_clause_segment2 VARCHAR2(32000);
1937:
1938: CURSOR c_query_name (p_query NUMBER) IS
1939: SELECT query_name
1940: FROM msc_personal_queries
1941: WHERE query_id = p_query;
1942:
1943: l_query_name VARCHAR2(80);
1944: test BOOLEAN;

Line 2190: msc_personal_queries pq

2186: p_plan_id IN NUMBER) IS
2187: CURSOR cur_queries IS
2188: SELECT plq.query_Id
2189: FROM msc_plan_queries plq,
2190: msc_personal_queries pq
2191: WHERE plq.plan_id = p_plan_Id
2192: AND plq.query_id = pq.query_id
2193: AND pq.query_type = 9;
2194:

Line 2283: msc_personal_queries pq

2279: p_plan_id IN NUMBER) IS
2280: CURSOR cur_worklists IS
2281: SELECT plq.query_Id,QUERY_TYPE
2282: FROM msc_plan_queries plq,
2283: msc_personal_queries pq
2284: WHERE plq.plan_id = p_plan_Id
2285: AND plq.query_id = pq.query_id
2286: AND pq.query_type = 10;
2287: