APPS.GMD_RECIPE_MIGRATION dependencies on GMD_RECIPES_B

Line 330: INSERT INTO gmd_recipes_b (recipe_id, recipe_no, recipe_version, owner_orgn_code, creation_orgn_code,

326: l_owner_orgn_code :=
327: TRIM (fnd_profile.value_specific ('GEMMS_DEFAULT_ORGN' ,
328: l_owner_id ));
329:
330: INSERT INTO gmd_recipes_b (recipe_id, recipe_no, recipe_version, owner_orgn_code, creation_orgn_code,
331: formula_id, routing_id, recipe_status, calculate_step_quantity, owner_id,
332: delete_mark, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
333: VALUES (l_recipe_id, l_recipe_no, l_recipe_version, l_owner_orgn_code, l_creation_orgn_code,
334: formula_rec.formula_id, formula_rec.routing_id, l_recipe_status, 0, l_owner_id,

Line 466: INSERT INTO gmd_recipes_b (recipe_id, recipe_no, recipe_version, owner_orgn_code, creation_orgn_code,

462:
463: /* Insert into the recipe header table */
464: IF ( x_return_status = 'S' )
465: THEN
466: INSERT INTO gmd_recipes_b (recipe_id, recipe_no, recipe_version, owner_orgn_code, creation_orgn_code,
467: formula_id, routing_id, recipe_status, calculate_step_quantity, owner_id,
468: delete_mark, creation_date, created_by, last_update_date, last_updated_by, last_update_login)
469: VALUES (l_recipe_id, l_recipe_no, l_recipe_version, l_owner_orgn_code, l_creation_orgn_code,
470: product_rec.formula_id, product_rec.routing_id, l_recipe_status, 0, l_owner_id,

Line 565: gmd_recipes_b rec

561: eff.trans_cnt,
562: eff.last_update_login,
563: eff.fmeff_id vr_id
564: FROM fm_form_eff_bak eff,
565: gmd_recipes_b rec
566: WHERE NOT EXISTS ( SELECT 1
567: FROM gmd_recipe_eff_assoc
568: WHERE fmeff_id = eff.fmeff_id )
569: AND rec.formula_id = eff.formula_id

Line 686: FROM gmd_recipes_b

682: IF ( recipe_material_rec.routing_id IS NOT NULL )
683: THEN
684: SELECT recipe_id
685: INTO l_recipe_id
686: FROM gmd_recipes_b
687: WHERE formula_id = recipe_material_rec.formula_id
688: AND routing_id = recipe_material_rec.routing_id
689: AND ROWNUM = 1;
690: ELSE

Line 693: FROM gmd_recipes_b

689: AND ROWNUM = 1;
690: ELSE
691: SELECT DISTINCT recipe_id
692: INTO l_recipe_id
693: FROM gmd_recipes_b
694: WHERE formula_id = recipe_material_rec.formula_id
695: AND routing_id IS NULL
696: AND ROWNUM = 1;
697: END IF;

Line 751: UPDATE gmd_recipes_b

747:
748: /* Step 6: Obsolete VRs and recipes that are based on Obsolted formulas
749: During formula migartion we had obsoleted formulas whose items
750: are inactive. Recipes and VRs that use this formula are also obsoleted */
751: UPDATE gmd_recipes_b
752: SET recipe_status = '1000'
753: WHERE formula_id IN (SELECT formula_id
754: FROM fm_form_mst_b
755: WHERE formula_Status = '1000');

Line 761: FROM gmd_recipes_b

757: /* Obsolete Vrs that are based on obsoleted Recipes */
758: UPDATE gmd_recipe_validity_rules
759: SET validity_rule_status = '1000'
760: WHERE recipe_id IN (SELECT recipe_id
761: FROM gmd_recipes_b
762: WHERE recipe_Status = '1000');
763:
764: /* Step 7: Update all tables that use fmeff_id - with VR id */
765: /* Validate duplicate effectivity customers */

Line 932: gmd_recipes_b gr,

928: SELECT grv.item_id, fmd.qty,fmd.item_um base_um, grv.std_qty, grv.item_um conv_um,
929: recipe_validity_rule_id rule_id, grv.min_qty, grv.max_qty
930: FROM fm_form_mst_b ffm,
931: fm_matl_dtl fmd,
932: gmd_recipes_b gr,
933: gmd_recipe_validity_rules grv
934: WHERE ffm.formula_id = fmd.formula_id
935: AND ffm.formula_id = gr.formula_id
936: AND grv.orgn_code = ffm.orgn_code