GME Planned Production

SELECT         
                    pm.batch_no,
                    rcp.recipe_no ,
                    rcp.recipe_version ,
                    to_char(pm.plan_start_date,'DD-MON-YYYY HH24:MI:SS') plan_start_date ,
                    to_char(pm.plan_cmplt_date,'DD-MON-YYYY HH24:MI:SS') expct_cmplt_date , 
                    pm.batch_type, 
	GME_GMEPRACT_XMLP_PKG.cf_batch_typeformula(pm.batch_type) CF_batch_type
FROM
                   gme_batch_header pm,
                   gmd_recipes rcp,
	   gmd_recipe_validity_rules val          
  WHERE   &cf_where and 
                 (plan_start_date >= :from_date1 OR :from_date1 IS NULL) and
                 (plan_start_date < (:to_date1+1) OR :to_date1 IS NULL ) and
                  pm.organization_id = :P_ORG_ID                
                 and pm.recipe_validity_rule_id = val.recipe_validity_rule_id(+)    and 
	 val.recipe_id = rcp.recipe_id(+) and
                  pm.delete_mark = 0               and 
                  pm.batch_status = 1                 
                  ORDER BY &Cf_ord_by