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 295: from msc_analysis_query

291: p_top_item_id number, p_item_id number, p_orglist_action number, p_itemlist_action number) return number is
292:
293: cursor c_maq_cur is
294: select count(*)
295: from msc_analysis_query
296: where query_id = p_query_id
297: and parent_row_index = p_row_index
298: and nvl(org_list_id, -1) = nvl(p_org_list_id, -1)
299: and nvl(inst_id, -1) = nvl(p_inst_id, -1)

Line 513: msc_analysis_query maq

509: mtp.sr_tp_id org_id,
510: msc_get_name.org_code(mtp.sr_tp_id, mtp.sr_instance_id) org_code,
511: mtp.sr_tp_id sort_column
512: from msc_trading_partners mtp,
513: msc_analysis_query maq
514: where maq.query_id = p_query_id
515: and maq.row_index = p_row_index
516: and mtp.sr_instance_id = maq.inst_id
517: and mtp.sr_tp_id = maq.org_id

Line 530: msc_analysis_query maq

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