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_RECIPES

Line 577: From gmd_recipes

573: l_validity_um VARCHAR2(4);
574:
575: CURSOR Get_recipe_cur(vRecipe_id NUMBER) IS
576: Select formula_id, routing_id, planned_process_loss
577: From gmd_recipes
578: Where recipe_id = vRecipe_id;
579:
580: Cursor Rout_hdr_cur(vRouting_id NUMBER) IS
581: Select Routing_class, Routing_qty, Process_loss, routing_uom

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 976: ( formula_id IN GMD_RECIPES.Formula_id%TYPE ,

972: /* The uom is that of FM_YIELD_TYPE UOM */
973: /* */
974: /* ====================================================================== */
975: PROCEDURE Calculate_Total_Qty
976: ( formula_id IN GMD_RECIPES.Formula_id%TYPE ,
977: x_product_qty OUT NOCOPY NUMBER ,
978: x_ingredient_qty OUT NOCOPY NUMBER ,
979: x_uom IN OUT NOCOPY VARCHAR2 ,
980: x_return_status OUT NOCOPY VARCHAR2 ,

Line 1195: FROM gmd_recipes_b

1191: x_Routing_Scale_factor NUMBER := 1 ;
1192:
1193: CURSOR Cur_get_recipe IS
1194: SELECT formula_id, routing_id, calculate_step_quantity
1195: FROM gmd_recipes_b
1196: WHERE recipe_id = vRecipe_Id;
1197:
1198: Cursor get_routrecipe_qty(pFormula_Id NUMBER, pRouting_Id NUMBER) IS
1199: Select rout.routing_qty rout_qty,

Line 1714: l_owner_orgn_id GMD_RECIPES_B.owner_organization_id%TYPE;

1710: l_status_code GMD_STATUS.Status_Code%TYPE;
1711: l_delete_mark NUMBER := 0;
1712:
1713: l_resp_id NUMBER(15) DEFAULT FND_PROFILE.VALUE('RESP_ID');
1714: l_owner_orgn_id GMD_RECIPES_B.owner_organization_id%TYPE;
1715: l_dummy NUMBER := 0;
1716:
1717: Cursor Check_recipe_orgn_access(vresp_id NUMBER, vOwner_orgn_id NUMBER) IS
1718: SELECT 1

Line 1738: FROM gmd_recipes_b

1734: ELSIF (Entity = 'RECIPE') THEN
1735:
1736: SELECT delete_mark, recipe_status, owner_organization_id
1737: INTO l_delete_mark, l_status_code, l_owner_orgn_id
1738: FROM gmd_recipes_b
1739: WHERE recipe_id = Entity_id;
1740:
1741: /* Check if user has access to this Recipe orgn */
1742: OPEN Check_recipe_orgn_access(l_resp_id, l_Owner_orgn_id);

Line 1809: FROM gmd_recipes_b

1805: FROM fm_form_mst_b
1806: WHERE formula_id = vformula_id;
1807: CURSOR get_recipe_owner_orgn_id(vrecipe_id NUMBER) IS
1808: SELECT owner_organization_id
1809: FROM gmd_recipes_b
1810: WHERE recipe_id = vrecipe_id;
1811: CURSOR get_routing_owner_orgn_id(vrouting_id NUMBER) IS
1812: SELECT owner_organization_id
1813: FROM gmd_routings_b

Line 1863: From gmd_recipes r, gmd_status s

1859: FETCH get_recipe_owner_orgn_id INTO l_orgn_id;
1860: CLOSE get_recipe_owner_orgn_id;
1861: OPEN Status_cur FOR
1862: Select r.recipe_status, s.version_enabled
1863: From gmd_recipes r, gmd_status s
1864: Where r.recipe_id = Entity_id
1865: And r.recipe_status = s.status_code;
1866: FETCH Status_cur INTO l_status, l_version_enabled;
1867: ClOSE Status_cur;

Line 2079: SELECT formula_id, routing_id From gmd_recipes_b

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
2080: WHERE recipe_id = vRecipe_id;
2081:
2082: Standard_costing_exception EXCEPTION;
2083: Period_status_exception EXCEPTION;

Line 2123: UPDATE gmd_recipes_b

2119: FETCH Get_Recipe_id INTO l_Recipe_id;
2120: CLOSE Get_Recipe_id;
2121:
2122: /* Update the Recipe - status field */
2123: UPDATE gmd_recipes_b
2124: SET recipe_status = '900'
2125: WHERE recipe_id = l_Recipe_Id
2126: AND to_number(recipe_status) < 800;
2127:

Line 2253: FROM gmd_recipes_b r, mtl_parameters o

2249: -- Lists the organization id for the recipe which are not owned
2250: -- By the owner organization id of formula
2251: CURSOR Cur_recipe_own (p_formula_id NUMBER, p_inventory_item_id NUMBER) IS
2252: SELECT recipe_no, recipe_version, organization_code
2253: FROM gmd_recipes_b r, mtl_parameters o
2254: WHERE formula_id = p_formula_id
2255: AND r.owner_organization_id = o.organization_id
2256: AND recipe_status < 1000
2257: AND NOT EXISTS (SELECT 1

Line 2265: FROM gmd_recipes_b r, mtl_parameters o

2261: AND m.organization_id = r.owner_organization_id);
2262: -- Bug 5237351 added
2263: CURSOR Cur_recipe_own_revision (p_formula_id NUMBER, p_inventory_item_id NUMBER,p_revision VARCHAR2) IS
2264: SELECT recipe_no, recipe_version, organization_code
2265: FROM gmd_recipes_b r, mtl_parameters o
2266: WHERE formula_id = p_formula_id
2267: AND r.owner_organization_id = o.organization_id
2268: AND recipe_status < 1000
2269: AND NOT EXISTS (SELECT 1

Line 2282: from gmd_recipe_process_loss rpl, gmd_recipes_b r, mtl_parameters o

2278:
2279: -- Cursors to get the recipe over rides for a recipe id
2280: CURSOR Cur_recipe_override(p_formula_id number, p_inventory_item_id number) IS
2281: select r.recipe_no, r.recipe_version, o.organization_code
2282: from gmd_recipe_process_loss rpl, gmd_recipes_b r, mtl_parameters o
2283: where r.recipe_id = rpl.recipe_id
2284: AND r.formula_id = p_formula_id
2285: AND r.owner_organization_id <> rpl.organization_id
2286: AND rpl.organization_id = o.organization_id

Line 2297: from gmd_recipe_process_loss rpl, gmd_recipes_b r, mtl_parameters o

2293:
2294: -- Bug 5237351 added
2295: CURSOR Cur_recipe_override_revision(p_formula_id number, p_inventory_item_id number,p_revision VARCHAR2) IS
2296: select r.recipe_no, r.recipe_version, o.organization_code
2297: from gmd_recipe_process_loss rpl, gmd_recipes_b r, mtl_parameters o
2298: where r.recipe_id = rpl.recipe_id
2299: AND r.formula_id = p_formula_id
2300: AND r.owner_organization_id <> rpl.organization_id
2301: AND rpl.organization_id = o.organization_id

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

Line 2537: PROCEDURE Calculate_Total_Product_Qty ( p_formula_id IN gmd_recipes.formula_id%TYPE,

2533: |
2534: +=============================================================================
2535: Api end of comments
2536: */
2537: PROCEDURE Calculate_Total_Product_Qty ( p_formula_id IN gmd_recipes.formula_id%TYPE,
2538: x_return_status OUT NOCOPY VARCHAR2,
2539: x_msg_count OUT NOCOPY NUMBER,
2540: x_msg_data OUT NOCOPY VARCHAR2) IS
2541: