APPS.MSC_SDA_UTILS dependencies on MSC_PERSONAL_QUERIES

Line 494: from msc_personal_queries

490:
491: function getOrgList(p_query_id number) return varchar2 is
492: cursor c_name is
493: select query_name
494: from msc_personal_queries
495: where query_id = p_query_id;
496: l_name varchar2(250);
497: begin
498: open c_name;

Line 507: from msc_personal_queries

503:
504: function getRegionList(p_query_id number) return varchar2 is
505: cursor c_name is
506: select query_name
507: from msc_personal_queries
508: where query_id = p_query_id;
509: l_name varchar2(250);
510: begin
511: open c_name;

Line 704: msc_personal_queries mpq

700: mpt.object_type region_id,
701: msc_sda_utils.getRegionName(mpt.object_type) region_code,
702: mpt.sequence_id sort_column
703: from msc_pq_types mpt,
704: msc_personal_queries mpq
705: where mpq.query_id = p_region_list
706: and mpq.query_id = mpt.query_id
707: and p_region_type = c_reg_list_view
708: and p_view_type = 1

Line 773: msc_personal_queries mpq

769: mpt.object_type org_id,
770: msc_get_name.org_code(mpt.object_type, mpt.source_type) org_code,
771: to_number(null) inventory_item_id
772: from msc_pq_types mpt,
773: msc_personal_queries mpq
774: where mpq.query_id = p_org_list
775: and mpq.query_id = mpt.query_id
776: and p_org_type = c_org_list_view
777: and p_view_type = 2

Line 894: msc_personal_queries mpq,

890: mpt.object_type org_id,
891: msc_get_name.org_code(mpt.object_type, mpt.source_type) org_code,
892: mpt.sequence_id sort_column
893: from msc_pq_types mpt,
894: msc_personal_queries mpq,
895: msc_analysis_query maq
896: where maq.query_id = p_query_id
897: and maq.row_index = p_row_index
898: and mpq.query_id = maq.org_list_id