APPS.GMD_RECIPE_DETAIL dependencies on GMD_RECIPES_B

Line 559: FROM fm_matl_dtl f, gmd_recipes_b r

555: /* Get the matl dtl for the main product */
556: Cursor get_certain_VR_defaults(vRecipe_id NUMBER) IS
557: -- NPD Conv.
558: SELECT inventory_item_id, qty, detail_uom
559: FROM fm_matl_dtl f, gmd_recipes_b r
560: WHERE f.formula_id = r.formula_id
561: AND r.recipe_id = vRecipe_id
562: AND f.line_type = 1
563: AND f.line_no = 1;

Line 568: FROM fm_matl_dtl f, gmd_recipes_b r

564:
565: /* get the matl details for the item passed in */
566: Cursor get_specific_VR_details(vRecipe_id NUMBER, vItem_id NUMBER) IS
567: SELECT qty, detail_uom
568: FROM fm_matl_dtl f, gmd_recipes_b r
569: WHERE f.formula_id = r.formula_id
570: AND r.recipe_id = vRecipe_id
571: AND f.line_type IN (1,2)
572: AND f.inventory_item_id = vItem_id

Line 586: FROM gmd_routings_b rt, gmd_recipes_b rc

582: /* Chcek VR dates against Routing dates */
583: CURSOR Get_Routing_Details(vRecipe_id NUMBER) IS
584: SELECT rt.Effective_Start_Date,
585: rt.Effective_End_Date
586: FROM gmd_routings_b rt, gmd_recipes_b rc
587: WHERE rc.routing_id = rt.routing_id AND
588: rc.recipe_id = vRecipe_id AND
589: rt.delete_mark = 0;
590:

Line 595: From fm_form_mst h, gmd_recipes_b r

591: CURSOR check_fmhdr_fixed_scale(vRecipe_id NUMBER) IS
592: SELECT 1
593: FROM sys.dual
594: WHERE EXISTS (Select h.formula_id
595: From fm_form_mst h, gmd_recipes_b r
596: WHERE r.formula_id = h.formula_id AND
597: r.recipe_id = vRecipe_id AND
598: h.scale_type = 0);
599: