create table as temp
select * from emp
where hiredate between :sdate and :edate
and deptno = :dpt

ORA-01036: illegal variable name/number

PROCEDURE TableView IS
BEGIN
  
FORMS_DDL('drop table test');
declare
v_com varchar2(4000);
BEGIN
 
V_COM := 'Create table test as 
  	select * from emp
where hiredate between :sdate and :edate
and deptno = :dpt
';
 
FORMS_DDL(V_COM);
end;

select ddate,fnd_code,fund,co_code,com,dist,rem,units,dp_uprice price,nvl(dp_uprice,0)*units Amount,stat 
		 from  
(
select :sdate-1 dDate ,inv_fnd_code Fnd_code,null Fund, inv_co_code Co_code, null Com,null Dist ,null Rem, 
   nvl(Qry1.Iunit,0) - nvl(qry2.runit,0) Units, null Price
		  ,null Amount,null Stat from (   
		  select inv_co_code,inv_fnd_code,sum(nvl(inv_nofu,0))IUnit, sum(inv_uprice),sum(inv_amount), null from investment 
		  where inv_date < :sdate 
		  and inv_fnd_code = :fnd
		  and inv_co_code = :co_code
		  group by inv_fnd_code,inv_co_code
		  ) qry1,
		  (select red_co_code,red_fnd_code,sum(nvl(red_nofu,0))RUnit, sum(red_uprice),sum(red_amount), null from redemption 
		  where red_date < :sdate 
		  and red_fnd_code = :fnd
		  and red_co_code = :co_code group by red_co_code,red_fnd_code
		  ) qry2 
		  where qry1.inv_co_code = qry2.red_co_code (+)
		  and qry1.inv_fnd_code = qry2.red_fnd_code (+) 
	) Opn1, 	  
---------------  Getting Dp_Uprice = :dd ----------------
(SELECT dp_fnd_code, 
       max(dp_date) keep (dense_rank last order by dp_date) Dp_date, 
       max(dp_uprice) keep (dense_rank last order by dp_date) dp_uprice
  FROM dailyprice 
  where dp_date <= :sdate
  and dp_uprice is not null
  group by dp_fnd_code 
 ) opn2
  ------------------------------------
where opn1.fnd_code = opn2.dp_fnd_code (+)	   
------------------------------------ -------------- End Opening Balance --------------------
		  union all
		  ----------------------- Investment -----------------
		  select inv_date ddate,inv_fnd_code,inv_fnd_name fund,inv_co_code,inv_co_name com,inv_dist_name dist, inv_remarks rem, inv_nofu units, inv_uprice price,
		  inv_amount Amount, 'I' STAT from investment
		   WHERE inv_date BETWEEN :SDATE AND :EDATE
		   and inv_fnd_code = :fnd
		   and inv_co_code = :co_code
		  union all
		  -------------------Redeumption --------------------
		  select red_date,red_fnd_code,red_fnd_name,red_co_code,red_co_name,red_dist_name, red_remarks, 
		  red_nofu - red_nofu - red_nofu red_nofu , 
		  red_uprice,
		  null red_amount, 'R'  from redemption
		  WHERE red_date BETWEEN :SDATE AND :EDATE
		  and red_fnd_code = :fnd
		  and red_co_code = :co_code