APPS.GMD_VALIDITY_RULES_PVT dependencies on GMD_RECIPES_B

Line 34: From gmd_recipes_b rc

30: FUNCTION Determine_Product(pRecipe_id NUMBER, pItem_id NUMBER) RETURN BOOLEAN IS
31: CURSOR product_cur(vRecipe_id NUMBER, vItem_id NUMBER) IS
32: Select 1 from fm_matl_dtl fm
33: Where exists (Select 1
34: From gmd_recipes_b rc
35: Where fm.formula_id = rc.formula_id
36: And fm.line_type IN (1,2)
37: And fm.inventory_item_id = vItem_id -- NPD Conv.
38: And rc.recipe_id = vRecipe_id);

Line 498: From gmd_routings_b rt, gmd_recipes_b rc,

494: CURSOR Get_Routing_Details(vValidity_rule_id
495: gmd_recipe_validity_rules.recipe_validity_rule_id%TYPE) IS
496: Select rt.Effective_Start_Date,
497: rt.Effective_End_Date
498: From gmd_routings_b rt, gmd_recipes_b rc,
499: gmd_recipe_validity_rules vr
500: Where vr.recipe_id = rc.recipe_id AND
501: rc.routing_id = rt.routing_id AND
502: vr.recipe_validity_rule_id = vValidity_rule_id AND

Line 505: CURSOR check_fmdtl_fixed_scale(vRecipe_id gmd_recipes_b.recipe_id%TYPE

501: rc.routing_id = rt.routing_id AND
502: vr.recipe_validity_rule_id = vValidity_rule_id AND
503: rt.delete_mark = 0;
504:
505: CURSOR check_fmdtl_fixed_scale(vRecipe_id gmd_recipes_b.recipe_id%TYPE
506: ,vItem_id ic_item_mst_b.item_id%TYPE) IS
507: SELECT 1
508: FROM sys.dual
509: WHERE EXISTS (Select d.formula_id

Line 510: From fm_matl_dtl d, gmd_recipes_b r

506: ,vItem_id ic_item_mst_b.item_id%TYPE) IS
507: SELECT 1
508: FROM sys.dual
509: WHERE EXISTS (Select d.formula_id
510: From fm_matl_dtl d, gmd_recipes_b r
511: WHERE r.formula_id = d.formula_id AND
512: r.recipe_id = vRecipe_id AND
513: d.line_type = 1 AND
514: d.inventory_item_id = vItem_id AND -- NPD Conv.

Line 517: CURSOR check_fmhdr_fixed_scale(vRecipe_id gmd_recipes_b.recipe_id%TYPE) IS

513: d.line_type = 1 AND
514: d.inventory_item_id = vItem_id AND -- NPD Conv.
515: d.scale_type = 0);
516:
517: CURSOR check_fmhdr_fixed_scale(vRecipe_id gmd_recipes_b.recipe_id%TYPE) IS
518: SELECT 1
519: FROM sys.dual
520: WHERE EXISTS (Select h.formula_id
521: From fm_form_mst h, gmd_recipes_b r

Line 521: From fm_form_mst h, gmd_recipes_b r

517: CURSOR check_fmhdr_fixed_scale(vRecipe_id gmd_recipes_b.recipe_id%TYPE) IS
518: SELECT 1
519: FROM sys.dual
520: WHERE EXISTS (Select h.formula_id
521: From fm_form_mst h, gmd_recipes_b r
522: WHERE r.formula_id = h.formula_id AND
523: r.recipe_id = vRecipe_id AND
524: h.scale_type = 0);
525:

Line 529: FROM gmd_recipes_b r, gmd_recipe_validity_rules v

525:
526: -- Cursor to fetch recipe use and formula id of the VR
527: CURSOR get_recp_dets IS
528: SELECT r.formula_id, v.recipe_use
529: FROM gmd_recipes_b r, gmd_recipe_validity_rules v
530: WHERE v.recipe_validity_rule_id = p_validity_rule_id
531: AND v.recipe_id = r.recipe_id;
532:
533: BEGIN