[Home] [Help]
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) )
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
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
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
1294: AND (p_revision IS NULL OR (p_revision IS NOT NULL AND v.revision = p_revision))