APPS.GMD_FORMULA_IBOM SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 24

    	SELECT fm.formula_id, fm.formula_no, fm.formula_vers,fe.min_qty, fe.max_qty,
             	fe.std_qty, fe.detail_uom, fe.preference,fe.last_update_date
	FROM   gmd_recipe_validity_rules fe, fm_form_mst fm, gmd_recipes_b r
      	WHERE  fe.inventory_item_id = V_item_id
        AND 	fe.recipe_use =  eff_type
        AND 	fm.formula_status LIKE NVL(inact_status,'%')
        AND 	TRUNC(fe.start_date) <= TRUNC(TO_DATE(eff_date,'DD-MM-RRRR'))
        AND 	(
                      TRUNC(fe.end_date) >= TRUNC(TO_DATE(eff_date,'DD-MM-RRRR'))
		OR    fe.end_date IS NULL
		)
        AND 	fe.delete_mark = 0
	AND	r.formula_id = fm.formula_id
	AND     fe.recipe_id = r.recipe_id
        AND 	fm.delete_mark = 0
	AND 	(pvalidity_organization_type = 2
                OR fe.organization_id IS NULL
                OR (pvalidity_organization_type = 0 AND fe.organization_id = porganization_id )
                OR (pvalidity_organization_type = 1 AND fe.organization_id IN ( SELECT organization_id
                                        				   FROM org_access_view
                                        				   WHERE responsibility_id = presp_id)))
      -- Bug 4777885  KSHUKLA : Start

  	ORDER BY fe.orgn_code asc, 8, fe.start_date desc;