APPS.GMD_VALIDITY_RULES_PVT dependencies on GMD_RECIPES

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 501: From gmd_routings_b rt, gmd_recipes_b rc,

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

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

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

Line 513: From fm_matl_dtl d, gmd_recipes_b r

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

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

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

Line 524: From fm_form_mst h, gmd_recipes_b r

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

Line 532: FROM gmd_recipes_b r, gmd_recipe_validity_rules v

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

Line 887: FROM GMD_RECIPES

883:
884: IF l_old_vr_rec.organization_id is NULL then
885: SELECT owner_organization_id
886: INTO l_organization_id
887: FROM GMD_RECIPES
888: WHERE RECIPE_ID = l_old_vr_rec.RECIPE_ID;
889:
890: END IF; -- IF l_old_vr_rec.organization_id is NULL then
891: SELECT UNIQUE primary_uom_code