APPS.GMD_VALIDITY_RULES dependencies on GMD_RECIPES

Line 92: FROM gmd_recipe_validity_rules v, gmd_recipes r, gmd_status s

88:
89: /* Cursor to get data based on recipe ID and input and output qty. */
90: CURSOR get_val IS
91: SELECT v.*
92: FROM gmd_recipe_validity_rules v, gmd_recipes r, gmd_status s
93: WHERE v.recipe_id = r.recipe_id
94: AND v.validity_rule_status = s.status_code
95: AND v.recipe_id = NVL(P_RECIPE_ID, v.recipe_id)
96: AND ( r.recipe_no = NVL(p_recipe_no, r.recipe_no) AND r.recipe_version = nvl(p_recipe_version, r.recipe_version) )

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 1277: FROM Gmd_recipe_validity_rules V, Gmd_recipes R, Gmd_status S

1273:
1274: --Cursor to get data based on recipe ID
1275: CURSOR Get_val_recipe IS
1276: SELECT v.*
1277: FROM Gmd_recipe_validity_rules V, Gmd_recipes R, Gmd_status S
1278: WHERE V.Recipe_id = R.Recipe_id
1279: AND V.Validity_rule_status = S.Status_code
1280: AND V.Recipe_id = NVL (P_recipe_id, V.Recipe_id)
1281: AND v.delete_mark = 0

Line 1289: Gmd_recipes R,

1285:
1286: CURSOR Get_val_item IS
1287: SELECT V.*
1288: FROM Gmd_recipe_validity_rules V,
1289: Gmd_recipes R,
1290: Gmd_status S
1291: WHERE V.Recipe_id = R.Recipe_id
1292: AND V.Validity_rule_status = S.Status_code
1293: AND V.inventory_item_id = P_item_id

Line 1304: FROM gmd_recipes rcp, fm_matl_dtl d

1300: FROM GMD_VAL_RULE_GTMP;
1301:
1302: CURSOR Cur_get_form_id (v_recipe_id NUMBER, V_inventory_item_id NUMBER) IS
1303: SELECT rcp.formula_id, SUM(qty), MAX(detail_uom)
1304: FROM gmd_recipes rcp, fm_matl_dtl d
1305: WHERE rcp.recipe_id = v_recipe_id
1306: AND rcp.formula_id = d.formula_id
1307: AND d.line_type = 1
1308: AND d.inventory_item_id = V_inventory_item_id;

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;