GMI ABC Rank Selection

SELECT 	 
	r.whse_code,
	r.abc_code,
	r.rank_desc,
	r.cnt_intrvl,
	r.percent_warn,
	r.percent_reject,
	r.value_warn,
	r.value_reject,
	r.acceptwarn_ind,
	r.acceptreject_ind,
	r.delete_mark,
	w.whse_name
FROM		ic_rank_mst r,ic_whse_mst w
WHERE		r.whse_code = w.whse_code
AND		 &RangeCF
AND		 	        r.delete_mark=decode(:select_criteria,'1',0,'2',1,'3',r.delete_mark,0)
ORDER BY  &OrdCF