declare
  st_date VARCHAR2( 20 );
  end_date VARCHAR2( 20 );
  psql VARCHAR2( 4000 );
  res VARCHAR2( 1 );
  obj VARCHAR2( 4000 );
  n VARCHAR2( 20 );
  res_time varchar2( 8000 );
begin
  st_date:= :STARTDATE;
  end_date:= :ENDDATE;
  if st_date is null then
    st_date := to_char(sysdate- 7 ,'dd.mm.yyyy') || ' 00:00' ;
  end if;
  if end_date is null then
    end_date := to_char(sysdate- 1 ,'dd.mm.yyyy') || ' 00:00' ;
  end if;
 obj :=  :P50_NE_NAME_LIST;  

  res := :RESOLUTION;
  res_time:=' to_char(t.time, ''dd.mm.yyyy HH24:MI:SS'') ';
  if res is null then
    res := '1';
    res_time:=' to_char(t.time, ''dd.mm.yyyy HH24:MI:SS'') ';
  end if;
  if res= 2  then
    res_time:=' to_char(t.time, ''dd.mm.yyyy'') ';
  end if;
  if res= 4  then
    res_time:=' to_char(t.time, ''mm.yyyy'') ';
  end if;


 if res= 1  then 
psql :=
   'select * from (
    select  null, to_char(trunc(t.time, ''hh''),''dd.mm.yyyy hh24:mi:ss'') as mtime,
           round(sum(t.cp_load)/count(t.cp_load),3) "CP Load"
    from ng_kpi_1 t
    where  ''' || obj || ''' like ''%'' || t.name1 || ''%''
    and t.time >= to_date(''' || st_date || ''', ''dd.mm.yyyy HH24:MI:SS'')  
    and t.time <to_date(''' || end_date || ''', ''dd.mm.yyyy HH24:MI:SS'')     
    group by trunc(t.time, ''hh''), t.name1
    order by t.name1
    ) ';
end if;

if res= 2  then
  psql :=
   'select * from (
    select null, to_char( trunc(t.time, ''dd''), ''dd.mm.yyyy'') as mtime,
           round(sum(t.cp_load)/count(t.cp_load),3) "CP Load"
    from ng_kpi_1 t
    where  ''' || obj || ''' like ''%'' || t.name1 || ''%''
    and t.time >= to_date(''' || st_date || ''', ''dd.mm.yyyy HH24:MI:SS'')  
    and t.time <to_date(''' || end_date || ''', ''dd.mm.yyyy HH24:MI:SS'')     
    group by trunc(t.time, ''dd''), t.name1
    order by t.name1
    ) ';
end if;

  return psql;
end;