APPS.GMD_FETCH_VALIDITY_RULES dependencies on GMD_RECIPE_VALIDITY_RULES

Line 74: FROM gmd_recipe_validity_rules

70: CURSOR get_val(v_orgn_id NUMBER) IS
71: SELECT recipe_validity_rule_id, recipe_id , organization_id, inventory_item_id ,revision, recipe_use,
72: preference, start_date, end_date , min_qty, max_qty , std_qty, detail_uom,
73: inv_min_qty, inv_max_qty, delete_mark, validity_rule_status
74: FROM gmd_recipe_validity_rules
75: WHERE recipe_id = p_recipe_id
76: AND ((validity_rule_status BETWEEN 700 AND 799) OR (validity_rule_status BETWEEN 400 AND 499) )
77: AND (p_recipe_use IS NULL OR recipe_use = p_recipe_use)
78: AND ( organization_id = v_orgn_id OR v_orgn_id IS NULL)

Line 87: FROM gmd_recipe_validity_rules

83: CURSOR get_val_item(v_orgn_id NUMBER, l_quantity NUMBER) IS
84: SELECT recipe_validity_rule_id, recipe_id , organization_id, inventory_item_id ,revision, recipe_use,
85: preference, start_date, end_date , min_qty, max_qty , std_qty, detail_uom,
86: inv_min_qty, inv_max_qty, delete_mark, validity_rule_status
87: FROM gmd_recipe_validity_rules
88: WHERE (inventory_item_id = p_item_id)
89: AND ((validity_rule_status BETWEEN 700 AND 799) OR (validity_rule_status BETWEEN 400 AND 499 ))
90: AND (inv_min_qty <= l_quantity AND inv_max_qty >= l_quantity )
91: AND ((organization_id = v_orgn_id) OR (v_orgn_id IS NULL))