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

1251:
1252: --Cursor to get data based on recipe ID
1253: CURSOR Get_val_recipe IS
1254: SELECT v.*
1255: FROM Gmd_recipe_validity_rules V, Gmd_recipes R, Gmd_status S
1256: WHERE V.Recipe_id = R.Recipe_id
1257: AND V.Validity_rule_status = S.Status_code
1258: AND V.Recipe_id = NVL (P_recipe_id, V.Recipe_id)
1259: AND v.delete_mark = 0

Line 1267: Gmd_recipes R,

1263:
1264: CURSOR Get_val_item IS
1265: SELECT V.*
1266: FROM Gmd_recipe_validity_rules V,
1267: Gmd_recipes R,
1268: Gmd_status S
1269: WHERE V.Recipe_id = R.Recipe_id
1270: AND V.Validity_rule_status = S.Status_code
1271: AND V.inventory_item_id = P_item_id

Line 1282: FROM gmd_recipes rcp, fm_matl_dtl d

1278: FROM GMD_VAL_RULE_GTMP;
1279:
1280: CURSOR Cur_get_form_id (v_recipe_id NUMBER, V_inventory_item_id NUMBER) IS
1281: SELECT rcp.formula_id, SUM(qty), MAX(detail_uom)
1282: FROM gmd_recipes rcp, fm_matl_dtl d
1283: WHERE rcp.recipe_id = v_recipe_id
1284: AND rcp.formula_id = d.formula_id
1285: AND d.line_type = 1
1286: AND d.inventory_item_id = V_inventory_item_id;

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;