create procedure dbo.%PROC% @sid varchar(30) = null
   .ARGLIST_FILTER
as
declare
        @action_id numeric,
        @user_id numeric,
        @state_id numeric,
        @type_id numeric,
        @new_state_id numeric

begin

  select @action_id = %ACTION_ID%



.CHECK_USER
.CHECK_VIEW

.ARGCONVERT_FILTER



  select
  type_name=(select t_types.type_name from t_types where t_types.id=t_items.type_id),
  sid = convert(varchar, t_items.id),
  state_sid = convert(varchar, t_items.state_id),
  type_sid = convert(varchar, t_items.type_id),
  convert(varchar(30),t_items.item_name) ,
  state_name=(select t_states.state_name from t_states where t_states.id=t_items.state_id),

  convert(varchar,t_plans2partner.plan_id) as plan_id_s,
 r1122103038_10200000000000438.plan_name as plan_name,
  convert(varchar,t_plans2partner.partner_id) as partner_id_s,
 r786101841_10200000000000437.partner_short_name as partner_short_name

--.VIEW_CALC

from
  #state_list,
  t_items ,
  #folders_list,
 t_plans2partner ,
 t_plans r1122103038_10200000000000438 ,
 t_partners r786101841_10200000000000437

where
 #state_list.state_id = t_items.state_id
 and
  t_items.id = #folders_list.folder_id
 and
  .ITEMS_EXISTS_BY_TYPE(t_plans2partner.id,'PLANS2PARTNER')
 and
 t_items.id = t_plans2partner.id and
 t_plans2partner.plan_id *= r1122103038_10200000000000438.id

 and  t_plans2partner.partner_id *= r786101841_10200000000000437.id
 and (t_plans2partner.plan_id is null or exists(select 1 from #folders_list where folder_id=t_plans2partner.plan_id))

  and (t_plans2partner.plan_id between @plan_id_bb and @plan_id_ee
       or @plan_id_nn is null
      )
  and (t_plans2partner.partner_id between @partner_id_bb and @partner_id_ee
       or @partner_id_nn is null
      )

end