APPS.GMD_VALIDITY_RULES dependencies on GMD_RECIPES_B

Line 123: FROM gmd_recipe_validity_rules v, gmd_recipes_b r, gmd_status_b s,

119:
120: /* Cursor to get data based on item. */
121: CURSOR get_val_item(l_quantity NUMBER) IS
122: SELECT v.*
123: FROM gmd_recipe_validity_rules v, gmd_recipes_b r, gmd_status_b s,
124: mtl_system_items_kfv I, fm_matl_dtl d
125: WHERE v.recipe_id = r.recipe_id
126: AND v.validity_rule_status = s.status_code
127: AND i.inventory_item_id = v.inventory_item_id

Line 189: FROM gmd_recipes_b

185:
186:
187: CURSOR Cur_get_recipe (V_recipe_no VARCHAR2, V_recipe_vers NUMBER) IS
188: SELECT recipe_id
189: FROM gmd_recipes_b
190: WHERE recipe_no = V_recipe_no
191: AND recipe_version = V_recipe_vers;
192:
193: CURSOR Cur_get_orgn_code IS

Line 211: FROM gmd_recipes_b

207: AND line_no = 1;
208:
209: CURSOR Cur_get_formula (V_recipe_id NUMBER) IS
210: SELECT formula_id
211: FROM gmd_recipes_b
212: WHERE recipe_id = V_recipe_id;
213:
214:
215: /* Exceptions */

Line 1475: FROM gmd_recipes_b r, fm_matl_dtl d

1471: x_scale_factor OUT NOCOPY NUMBER,
1472: x_return_status OUT NOCOPY VARCHAR2) IS
1473: CURSOR Cur_get_product_lines IS
1474: SELECT qty, detail_uom
1475: FROM gmd_recipes_b r, fm_matl_dtl d
1476: WHERE r.recipe_id = p_recipe_id
1477: AND r.formula_id = d.formula_id
1478: AND d.line_type = 1
1479: AND d.inventory_item_id = p_item_id;

Line 1561: FROM fm_form_mst_b f, gmd_recipes_b r

1557: x_scale_factor OUT NOCOPY NUMBER,
1558: x_return_status OUT NOCOPY VARCHAR2) IS
1559: CURSOR Cur_get_tot_qty IS
1560: SELECT f.formula_id, total_output_qty, yield_uom
1561: FROM fm_form_mst_b f, gmd_recipes_b r
1562: WHERE r.recipe_id = p_recipe_id
1563: AND r.formula_id = f.formula_id;
1564:
1565: l_form_rec Cur_get_tot_qty%ROWTYPE;