APPS.GMD_COMMON_VAL dependencies on GMD_RECIPE_VALIDITY_RULES

Line 609: FROM gmd_recipes_b r, gmd_recipe_validity_rules v

605:
606: -- NPD Conv.
607: CURSOR Get_validity_cur (vValidity_Rule_Id NUMBER) IS
608: SELECT r.recipe_id, formula_id, routing_id, v.std_qty, v.organization_id, v.inventory_item_id, v.detail_uom
609: FROM gmd_recipes_b r, gmd_recipe_validity_rules v
610: WHERE r.recipe_id = v.recipe_id
611: AND v.recipe_validity_rule_id = vValidity_Rule_Id;
612:
613: CURSOR Get_recipe_orgn_loss (vRecipe_id NUMBER, vOrgn_code_id VARCHAR2) IS

Line 1815: FROM gmd_recipe_validity_rules

1811: WHERE oprn_id = Entity_id;
1812: ELSIF (Entity = 'VALIDITY') THEN
1813: SELECT delete_mark, validity_rule_status
1814: INTO l_delete_mark, l_status_code
1815: FROM gmd_recipe_validity_rules
1816: WHERE recipe_validity_rule_id = Entity_id;
1817: END IF;
1818:
1819: Get_Status

Line 2112: TYPE VRtbl IS TABLE OF GMD_RECIPE_VALIDITY_RULES.Recipe_Validity_Rule_Id%TYPE;

2108: l_period_cnt NUMBER;
2109: l_cost_type NUMBER;
2110:
2111:
2112: TYPE VRtbl IS TABLE OF GMD_RECIPE_VALIDITY_RULES.Recipe_Validity_Rule_Id%TYPE;
2113: VRList VRtbl;
2114:
2115: CURSOR FROZEN_EFF_CUR IS
2116: SELECT distinct(fmeff_id) fmeff_id from cm_cmpt_dtl

Line 2133: SELECT recipe_id from gmd_recipe_validity_rules

2129: SELECT cost_type from cm_mthd_mst
2130: WHERE cost_mthd_code = pCost_mthd_code;
2131:
2132: CURSOR Get_Recipe_id(vValidity_Rule_id NUMBER) IS
2133: SELECT recipe_id from gmd_recipe_validity_rules
2134: WHERE recipe_validity_rule_id = vValidity_Rule_id;
2135:
2136: CURSOR Get_FmRout_id(vRecipe_id NUMBER) IS
2137: SELECT formula_id, routing_id From gmd_recipes_b

Line 2171: Update gmd_recipe_validity_rules

2167:
2168: FOR i IN 1 .. VRList.count LOOP
2169:
2170: /* Update the VR - status field */
2171: Update gmd_recipe_validity_rules
2172: SET validity_rule_status = '900'
2173: WHERE recipe_validity_rule_id = VRList(i)
2174: AND to_number(validity_rule_status) < 800;
2175:

Line 2373: from gmd_recipe_validity_rules rvr, gmd_recipes_b r, mtl_parameters o

2369:
2370: -- Cursor to get the validity rules for the recipes
2371: CURSOR Cur_recipe_validity(p_formula_id number,p_inventory_item_id number) IS
2372: select o.organization_code,r.recipe_no, r.recipe_version
2373: from gmd_recipe_validity_rules rvr, gmd_recipes_b r, mtl_parameters o
2374: where r.recipe_id = rvr.recipe_id
2375: and r.formula_id = p_formula_id
2376: and o.organization_id = rvr.organization_id
2377: AND rvr.organization_id <> r.owner_organization_id

Line 2388: from gmd_recipe_validity_rules rvr, gmd_recipes_b r, mtl_parameters o

2384: AND m.organization_id = rvr.organization_id);
2385: -- Bug 5237351 added
2386: CURSOR Cur_recipe_validity_revision(p_formula_id number,p_inventory_item_id number,p_revision VARCHAR2) IS
2387: select o.organization_code,r.recipe_no, r.recipe_version
2388: from gmd_recipe_validity_rules rvr, gmd_recipes_b r, mtl_parameters o
2389: where r.recipe_id = rvr.recipe_id
2390: and r.formula_id = p_formula_id
2391: and o.organization_id = rvr.organization_id
2392: AND r.recipe_status < 1000

Line 2934: TYPE VRtbl IS TABLE OF GMD_RECIPE_VALIDITY_RULES.Recipe_Validity_Rule_Id%TYPE;

2930: l_cost_type NUMBER;
2931: l_period_id NUMBER;
2932:
2933:
2934: TYPE VRtbl IS TABLE OF GMD_RECIPE_VALIDITY_RULES.Recipe_Validity_Rule_Id%TYPE;
2935: VRList VRtbl;
2936:
2937: CURSOR Get_period_id IS
2938: SELECT period_id from gmf_period_statuses

Line 2960: SELECT recipe_id from gmd_recipe_validity_rules

2956: SELECT cost_type from cm_mthd_mst
2957: WHERE cost_type_id = pCost_type_id;
2958:
2959: CURSOR Get_Recipe_id(vValidity_Rule_id NUMBER) IS
2960: SELECT recipe_id from gmd_recipe_validity_rules
2961: WHERE recipe_validity_rule_id = vValidity_Rule_id;
2962:
2963: CURSOR Get_FmRout_id(vRecipe_id NUMBER) IS
2964: SELECT formula_id, routing_id From gmd_recipes_b

Line 3007: Update gmd_recipe_validity_rules

3003:
3004: FOR i IN 1 .. VRList.count LOOP
3005:
3006: /* Update the VR - status field */
3007: Update gmd_recipe_validity_rules
3008: SET validity_rule_status = '900'
3009: WHERE recipe_validity_rule_id = VRList(i)
3010: AND to_number(validity_rule_status) < 800;
3011: