APPS.GMD_RECIPE_MIGRATION dependencies on FM_FORM_EFF_BAK

Line 21: FROM fm_form_eff_bak e,

17: h.formula_vers,
18: e.routing_id,
19: e.formula_id,
20: h.formula_desc1
21: FROM fm_form_eff_bak e,
22: fm_form_mst_b h
23: WHERE NOT EXISTS ( SELECT 1
24: FROM gmd_recipe_eff_assoc
25: WHERE fmeff_id = e.fmeff_id )

Line 44: fm_form_eff_bak e,

40: e.formula_id,
41: e.routing_id,
42: i.item_desc1
43: FROM fm_form_mst_b h,
44: fm_form_eff_bak e,
45: fm_matl_dtl m,
46: ic_item_mst i
47: WHERE NOT EXISTS ( SELECT 1
48: FROM gmd_recipe_eff_assoc

Line 298: FROM fm_form_eff_bak

294: to derive delete mark and Who columns
295: */
296: SELECT Min(delete_mark)
297: INTO l_delete_mark
298: FROM fm_form_eff_bak
299: WHERE formula_id = formula_rec.formula_id
300: AND NVL ( routing_id, -999 ) =
301: NVL ( formula_rec.routing_id, -999 );
302:

Line 315: FROM fm_form_eff_bak

311: l_last_updated_by,
312: l_last_update_date,
313: l_last_update_login,
314: l_owner_id
315: FROM fm_form_eff_bak
316: WHERE formula_id = formula_rec.formula_id
317: AND NVL ( routing_id, -999 ) =
318: NVL ( formula_rec.routing_id, -999 )
319: AND ROWNUM = 1;

Line 431: FROM fm_form_eff_bak

427: to derive delete mark and Who columns
428: */
429: SELECT Min(delete_mark)
430: INTO l_delete_mark
431: FROM fm_form_eff_bak
432: WHERE formula_id = product_rec.formula_id
433: AND NVL ( routing_id, -999 ) =
434: NVL ( product_rec.routing_id, -999 );
435:

Line 448: FROM fm_form_eff_bak

444: l_last_updated_by,
445: l_last_update_date,
446: l_last_update_login,
447: l_owner_id
448: FROM fm_form_eff_bak
449: WHERE formula_id = product_rec.formula_id
450: AND NVL ( routing_id, -999 ) =
451: NVL ( product_rec.routing_id, -999 )
452: AND ROWNUM = 1;

Line 564: FROM fm_form_eff_bak eff,

560: eff.text_code,
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 )

Line 775: FROM fm_form_eff_bak

771: l_dup_counter := 0;
772: /* changed fm_form_eff to _bak as it was deleting new recipes */
773: FOR update_eff_rec IN
774: (SELECT fmeff_id
775: FROM fm_form_eff_bak
776: WHERE NVL(orgn_code,fnd_api.g_miss_char) =
777: NVL(get_dup_eff_rec.orgn_code,
778: fnd_api.g_miss_char )
779: AND item_id = get_dup_eff_rec.item_id