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 190: FROM gmd_recipes_b

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

Line 212: FROM gmd_recipes_b

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

Line 1497: FROM gmd_recipes_b r, fm_matl_dtl d

1493: x_scale_factor OUT NOCOPY NUMBER,
1494: x_return_status OUT NOCOPY VARCHAR2) IS
1495: CURSOR Cur_get_product_lines IS
1496: SELECT qty, detail_uom
1497: FROM gmd_recipes_b r, fm_matl_dtl d
1498: WHERE r.recipe_id = p_recipe_id
1499: AND r.formula_id = d.formula_id
1500: AND d.line_type = 1
1501: AND d.inventory_item_id = p_item_id;

Line 1583: FROM fm_form_mst_b f, gmd_recipes_b r

1579: x_scale_factor OUT NOCOPY NUMBER,
1580: x_return_status OUT NOCOPY VARCHAR2) IS
1581: CURSOR Cur_get_tot_qty IS
1582: SELECT f.formula_id, total_output_qty, yield_uom
1583: FROM fm_form_mst_b f, gmd_recipes_b r
1584: WHERE r.recipe_id = p_recipe_id
1585: AND r.formula_id = f.formula_id;
1586:
1587: l_form_rec Cur_get_tot_qty%ROWTYPE;