select mr.mrn_no,
	trunc(mr.mrn_date) mrn_date,
	trunc(mr.approval_date)grs_approval_date,
	mr.bill_no as challan_no,
	mr.bill_date as challan_date,mr.supp_code,
	pm.party_name,
	mr.store_code,
	mr.manual_gate_sr_no ,
	mr.manual_gate_sr_date,
	case when nvl(trunc(mr.approval_date),trunc(mr.mrn_date)) - mr.manual_gate_sr_date >=2  then
	(nvl(trunc(mr.approval_date),trunc(mr.mrn_date)) - mr.manual_gate_sr_date)  -2
	else 
	0
	end  days_from_grs_approval,
	insp_no,
	trunc(insp_date)insp_date
from material_receipt mr,party_master pm,inspection
where trunc(mr.mrn_date) between :fromdate and :todate
and mr.supp_code = pm.party_code
and mr.ccode	 = pm.ccode
and mr.mrn_no 	 = inspection.mrn_no(+)
and trunc(mr.mrn_date) = trunc(inspection.mrn_date(+))
&approval_status
and mr.ccode	 = :ccode
and mr.fycode 	 = :fycode
and mr.store_code like :store_code
and nvl(mr.grs_type,'p') = :type
&req
order by 2

IND> select a.name,a.id
  2  from
  3  (select 'sriram' name,1 id from dual
  4  union
  5  select 'Littlefoot',2 from dual) a
  6  where &rec
  7  order by 2;
Enter value for rec: 1=1
old   6: where &rec
new   6: where 1=1

NAME               ID
---------- ----------
sriram              1
Littlefoot          2

2 rows selected.

IND> select a.name,a.id
  2  from
  3  (select 'sriram' name,1 id from dual
  4  union
  5  select 'Littlefoot',2 from dual) a
  6  where id=1 &rec
  7  /
Enter value for rec: 1=1
old   6: where id=1 &rec
new   6: where id=1 1=1
where id=1 1=1
           *
ERROR at line 6:
ORA-00933: SQL command not properly ended


IND> select a.name,a.id
  2  from
  3  (select 'sriram' name,1 id from dual
  4  union
  5  select 'Littlefoot',2 from dual) a
  6  where id=1 &rec
  7  /
Enter value for rec: and 1=1
old   6: where id=1 &rec
new   6: where id=1 and 1=1

NAME               ID
---------- ----------
sriram              1

1 row selected.