APPS.MSC_SDA_UTILS dependencies on MSC_ANALYSIS_QUERY

Line 98: select msc_analysis_query_s.nextval

94: end getNewFormQueryId;
95:
96: function getNewAnalysisQueryId return number is
97: cursor c_query is
98: select msc_analysis_query_s.nextval
99: from dual;
100: l_query_id number;
101: begin
102: open c_query;

Line 660: from msc_analysis_query

656: p_top_item_id number, p_item_id number, p_orglist_action number, p_itemlist_action number) return number is
657:
658: cursor c_maq_cur is
659: select count(*)
660: from msc_analysis_query
661: where query_id = p_query_id
662: and parent_row_index = p_row_index
663: and nvl(org_list_id, -1) = nvl(p_org_list_id, -1)
664: and nvl(inst_id, -1) = nvl(p_inst_id, -1)

Line 878: msc_analysis_query maq

874: mtp.sr_tp_id org_id,
875: msc_get_name.org_code(mtp.sr_tp_id, mtp.sr_instance_id) org_code,
876: mtp.sr_tp_id sort_column
877: from msc_trading_partners mtp,
878: msc_analysis_query maq
879: where maq.query_id = p_query_id
880: and maq.row_index = p_row_index
881: and mtp.sr_instance_id = maq.inst_id
882: and mtp.sr_tp_id = maq.org_id

Line 895: msc_analysis_query maq

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
899: and mpq.query_id = mpt.query_id