APPS.MSC_SDA_UTILS dependencies on MSC_PERSONAL_QUERIES

Line 163: from msc_personal_queries

159:
160: function getOrgList(p_query_id number) return varchar2 is
161: cursor c_name is
162: select query_name
163: from msc_personal_queries
164: where query_id = p_query_id;
165: l_name varchar2(250);
166: begin
167: open c_name;

Line 176: from msc_personal_queries

172:
173: function getRegionList(p_query_id number) return varchar2 is
174: cursor c_name is
175: select query_name
176: from msc_personal_queries
177: where query_id = p_query_id;
178: l_name varchar2(250);
179: begin
180: open c_name;

Line 339: msc_personal_queries mpq

335: mpt.object_type region_id,
336: msc_sda_utils.getRegionName(mpt.object_type) region_code,
337: mpt.sequence_id sort_column
338: from msc_pq_types mpt,
339: msc_personal_queries mpq
340: where mpq.query_id = p_region_list
341: and mpq.query_id = mpt.query_id
342: and p_region_type = c_reg_list_view
343: and p_view_type = 1

Line 408: msc_personal_queries mpq

404: mpt.object_type org_id,
405: msc_get_name.org_code(mpt.object_type, mpt.source_type) org_code,
406: to_number(null) inventory_item_id
407: from msc_pq_types mpt,
408: msc_personal_queries mpq
409: where mpq.query_id = p_org_list
410: and mpq.query_id = mpt.query_id
411: and p_org_type = c_org_list_view
412: and p_view_type = 2

Line 529: msc_personal_queries mpq,

525: mpt.object_type org_id,
526: msc_get_name.org_code(mpt.object_type, mpt.source_type) org_code,
527: mpt.sequence_id sort_column
528: from msc_pq_types mpt,
529: msc_personal_queries mpq,
530: msc_analysis_query maq
531: where maq.query_id = p_query_id
532: and maq.row_index = p_row_index
533: and mpq.query_id = maq.org_list_id