APPS.MSC_IMPORT_UTIL dependencies on MSC_SYSTEM_ITEMS

Line 385: from msc_system_items

381: where simulation_set_name = l_simset_name;
382:
383: cursor c_get_item_id(l_item_name varchar2,l_org_id number,l_inst_id number) is
384: select distinct inventory_item_id
385: from msc_system_items
386: where item_name = l_item_name and
387: organization_id = l_org_id and
388: sr_instance_id = l_inst_id and
389: plan_id = -1;

Line 921: l_sql := 'update msc_system_items set '||p_attr_name||'='||l_attr_val||

917: else
918: l_attr_val := p_attr_val;
919: end if;
920:
921: l_sql := 'update msc_system_items set '||p_attr_name||'='||l_attr_val||
922: ' where plan_id='||p_plan_id||' and inventory_item_id ='||p_item_id||' and organization_id='||p_org_id||' and sr_instance_id='||p_sr_instance_id;
923:
924: msc_get_name.execute_dsql(l_sql);
925: