APPS.MSC_PQ_UTILS dependencies on MSC_PERSONAL_QUERIES

Line 25: msc_personal_queries mpq

21:
22: CURSOR detailQCur(p_query_id IN NUMBER) IS
23: SELECT pqt.DETAIL_QUERY_ID query_id,mpq.query_type
24: FROM MSC_PQ_TYPES pqt,
25: msc_personal_queries mpq
26: WHERE pqt.query_id = p_query_id
27: AND mpq.query_id = pqt.DETAIL_QUERY_ID;
28:
29: CURSOR WlExcepCur(p_query_id IN NUMBER) IS

Line 937: FROM msc_personal_queries

933: AND source_type = p_source_type;
934:
935: CURSOR c_and_or IS
936: SELECT count(*)
937: FROM msc_personal_queries
938: WHERE query_id = p_query_id
939: AND NVL(and_or_flag,1) = 1;
940:
941: CURSOR c_excp_and_or (p_object_type NUMBER) IS

Line 1738: msc_personal_queries mpq

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

Line 1775: msc_personal_queries mpq

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

Line 1796: msc_personal_queries mpq

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

Line 1968: FROM msc_personal_queries

1964: where_clause_segment2 VARCHAR2(32000);
1965:
1966: CURSOR c_query_name (p_query NUMBER) IS
1967: SELECT query_name
1968: FROM msc_personal_queries
1969: WHERE query_id = p_query;
1970:
1971: l_query_name VARCHAR2(80);
1972: test BOOLEAN;

Line 2240: msc_personal_queries pq

2236: p_plan_id IN NUMBER) IS
2237: CURSOR cur_queries IS
2238: SELECT plq.query_Id,pq.query_type
2239: FROM msc_plan_queries plq,
2240: msc_personal_queries pq
2241: WHERE plq.plan_id = p_plan_Id
2242: AND plq.query_id = pq.query_id;
2243: --AND pq.query_type = 9;
2244:

Line 2335: msc_personal_queries pq

2331: p_plan_id IN NUMBER) IS
2332: CURSOR cur_worklists IS
2333: SELECT plq.query_Id,QUERY_TYPE
2334: FROM msc_plan_queries plq,
2335: msc_personal_queries pq
2336: WHERE plq.plan_id = p_plan_Id
2337: AND plq.query_id = pq.query_id
2338: AND pq.query_type = 10;
2339:

Line 3623: msc_personal_queries pq

3619: p_plan_id IN NUMBER) IS
3620: CURSOR cur_worksheets IS
3621: SELECT plq.query_Id,QUERY_TYPE,pq.query_name
3622: FROM msc_plan_queries plq,
3623: msc_personal_queries pq
3624: WHERE plq.plan_id = p_plan_Id
3625: AND plq.query_id = pq.query_id
3626: AND pq.query_type = 11;
3627:

Line 3890: FROM msc_personal_queries

3886: ORDER BY source_type, object_type, field_name;
3887:
3888: CURSOR c_and_or IS
3889: SELECT count(*)
3890: FROM msc_personal_queries
3891: WHERE query_id = p_query_id
3892: AND NVL(and_or_flag,1) = 1;
3893:
3894: