eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 1764: FROM gmd_recipe_validity_rules

1760: WHERE oprn_id = Entity_id;
1761: ELSIF (Entity = 'VALIDITY') THEN
1762: SELECT delete_mark, validity_rule_status
1763: INTO l_delete_mark, l_status_code
1764: FROM gmd_recipe_validity_rules
1765: WHERE recipe_validity_rule_id = Entity_id;
1766: END IF;
1767:
1768: Get_Status

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

2050: l_period_cnt NUMBER;
2051: l_cost_type NUMBER;
2052:
2053:
2054: TYPE VRtbl IS TABLE OF GMD_RECIPE_VALIDITY_RULES.Recipe_Validity_Rule_Id%TYPE;
2055: VRList VRtbl;
2056:
2057: CURSOR FROZEN_EFF_CUR IS
2058: SELECT distinct(fmeff_id) fmeff_id from cm_cmpt_dtl

Line 2075: SELECT recipe_id from gmd_recipe_validity_rules

2071: SELECT cost_type from cm_mthd_mst
2072: WHERE cost_mthd_code = pCost_mthd_code;
2073:
2074: CURSOR Get_Recipe_id(vValidity_Rule_id NUMBER) IS
2075: SELECT recipe_id from gmd_recipe_validity_rules
2076: WHERE recipe_validity_rule_id = vValidity_Rule_id;
2077:
2078: CURSOR Get_FmRout_id(vRecipe_id NUMBER) IS
2079: SELECT formula_id, routing_id From gmd_recipes_b

Line 2113: Update gmd_recipe_validity_rules

2109:
2110: FOR i IN 1 .. VRList.count LOOP
2111:
2112: /* Update the VR - status field */
2113: Update gmd_recipe_validity_rules
2114: SET validity_rule_status = '900'
2115: WHERE recipe_validity_rule_id = VRList(i)
2116: AND to_number(validity_rule_status) < 800;
2117:

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

2311:
2312: -- Cursor to get the validity rules for the recipes
2313: CURSOR Cur_recipe_validity(p_formula_id number,p_inventory_item_id number) IS
2314: select o.organization_code,r.recipe_no, r.recipe_version
2315: from gmd_recipe_validity_rules rvr, gmd_recipes_b r, mtl_parameters o
2316: where r.recipe_id = rvr.recipe_id
2317: and r.formula_id = p_formula_id
2318: and o.organization_id = rvr.organization_id
2319: AND rvr.organization_id <> r.owner_organization_id

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

2326: AND m.organization_id = rvr.organization_id);
2327: -- Bug 5237351 added
2328: CURSOR Cur_recipe_validity_revision(p_formula_id number,p_inventory_item_id number,p_revision VARCHAR2) IS
2329: select o.organization_code,r.recipe_no, r.recipe_version
2330: from gmd_recipe_validity_rules rvr, gmd_recipes_b r, mtl_parameters o
2331: where r.recipe_id = rvr.recipe_id
2332: and r.formula_id = p_formula_id
2333: and o.organization_id = rvr.organization_id
2334: AND r.recipe_status < 1000