eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_RECIPE_MIGRATION dependencies on GMD_RECIPES

Line 80: FROM gmd_recipes

76: AND NOT EXISTS ( SELECT 1
77: FROM gmd_recipe_step_materials
78: WHERE formulaline_id = rm.formulaline_id
79: AND EXISTS ( SELECT recipe_id
80: FROM gmd_recipes
81: WHERE formula_id = rm.formula_id
82: AND routing_id = rm.routing_id ))
83: GROUP BY rm.routingstep_no,
84: rm.formulaline_id,

Line 177: l_recipe_id gmd_recipes.recipe_id%TYPE := 0;

173: FROM cm_cmpt_dtl
174: WHERE fmeff_id = pfmeff_id;
175:
176: /* Defining all local variables */
177: l_recipe_id gmd_recipes.recipe_id%TYPE := 0;
178: l_routingstep_id NUMBER := 0;
179: l_recipe_no gmd_recipes.recipe_no%TYPE := NULL;
180: l_recipe_version gmd_recipes.recipe_version%TYPE := 0;
181: l_recipe_status gmd_recipes.recipe_status%TYPE := '700';

Line 179: l_recipe_no gmd_recipes.recipe_no%TYPE := NULL;

175:
176: /* Defining all local variables */
177: l_recipe_id gmd_recipes.recipe_id%TYPE := 0;
178: l_routingstep_id NUMBER := 0;
179: l_recipe_no gmd_recipes.recipe_no%TYPE := NULL;
180: l_recipe_version gmd_recipes.recipe_version%TYPE := 0;
181: l_recipe_status gmd_recipes.recipe_status%TYPE := '700';
182: l_counter NUMBER := 0;
183: l_cm_counter NUMBER := 0;

Line 180: l_recipe_version gmd_recipes.recipe_version%TYPE := 0;

176: /* Defining all local variables */
177: l_recipe_id gmd_recipes.recipe_id%TYPE := 0;
178: l_routingstep_id NUMBER := 0;
179: l_recipe_no gmd_recipes.recipe_no%TYPE := NULL;
180: l_recipe_version gmd_recipes.recipe_version%TYPE := 0;
181: l_recipe_status gmd_recipes.recipe_status%TYPE := '700';
182: l_counter NUMBER := 0;
183: l_cm_counter NUMBER := 0;
184: l_recipe_vr_id NUMBER := 0;

Line 181: l_recipe_status gmd_recipes.recipe_status%TYPE := '700';

177: l_recipe_id gmd_recipes.recipe_id%TYPE := 0;
178: l_routingstep_id NUMBER := 0;
179: l_recipe_no gmd_recipes.recipe_no%TYPE := NULL;
180: l_recipe_version gmd_recipes.recipe_version%TYPE := 0;
181: l_recipe_status gmd_recipes.recipe_status%TYPE := '700';
182: l_counter NUMBER := 0;
183: l_cm_counter NUMBER := 0;
184: l_recipe_vr_id NUMBER := 0;
185: l_return_val NUMBER := 0;

Line 265: ,p_target_table => 'GMD_RECIPES'

261: THEN
262: x_return_status := fnd_api.g_ret_sts_error;
263: /* Thomas - Bug 2562007, Added the following loggin of message */
264: insert_message (p_source_table => 'FM_FORM_MST'
265: ,p_target_table => 'GMD_RECIPES'
266: ,p_source_id => l_recipe_no
267: ,p_target_id => l_recipe_version
268: ,p_message => 'Recipe:'||l_recipe_no||' Version:'||l_recipe_version||' already exists.'
269: ,p_error_type => 'U');

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 337: INSERT INTO gmd_recipes_tl (recipe_id, recipe_description, source_lang, created_by, creation_date,

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,
335: l_delete_mark, l_creation_date, l_created_by, l_last_update_date, l_last_updated_by, l_last_update_login);
336:
337: INSERT INTO gmd_recipes_tl (recipe_id, recipe_description, source_lang, created_by, creation_date,
338: last_updated_by, last_update_date, last_update_login, language
339: )
340: SELECT l_recipe_id, formula_rec.formula_desc1, userenv('lang'), l_created_by, l_creation_date,
341: l_last_updated_by, l_last_update_date, l_last_update_login, l.language_code

Line 345: FROM gmd_recipes_tl t

341: l_last_updated_by, l_last_update_date, l_last_update_login, l.language_code
342: FROM fnd_languages l
343: WHERE l.installed_flag in ('I', 'B')
344: AND NOT EXISTS (SELECT null
345: FROM gmd_recipes_tl t
346: WHERE t.recipe_id = l_recipe_id
347: AND t.language = l.language_code);
348: END IF;
349:

Line 355: ,p_target_table => 'GMD_RECIPES'

351: WHEN OTHERS
352: THEN
353: error_msg := SQLERRM;
354: insert_message (p_source_table => 'FM_FORM_EFF'
355: ,p_target_table => 'GMD_RECIPES'
356: ,p_source_id => formula_rec.formula_id
357: ,p_target_id => l_recipe_id
358: ,p_message => error_msg
359: ,p_error_type => 'U');

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 473: INSERT INTO gmd_recipes_tl (recipe_id, recipe_description, source_lang, created_by, creation_date,

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,
471: l_delete_mark, l_creation_date, l_created_by, l_last_update_date, l_last_updated_by, l_last_update_login);
472:
473: INSERT INTO gmd_recipes_tl (recipe_id, recipe_description, source_lang, created_by, creation_date,
474: last_updated_by, last_update_date, last_update_login, language
475: )
476: SELECT l_recipe_id, product_rec.item_desc1, userenv('lang'), l_created_by, l_creation_date,
477: l_last_updated_by, l_last_update_date, l_last_update_login, l.language_code

Line 481: FROM gmd_recipes_tl t

477: l_last_updated_by, l_last_update_date, l_last_update_login, l.language_code
478: FROM fnd_languages l
479: WHERE l.installed_flag in ('I', 'B')
480: AND NOT EXISTS (SELECT null
481: FROM gmd_recipes_tl t
482: WHERE t.recipe_id = l_recipe_id
483: AND t.language = l.language_code);
484:
485: END IF;

Line 491: ,p_target_table => 'GMD_RECIPES'

487: WHEN OTHERS
488: THEN
489: error_msg := SQLERRM;
490: insert_message (p_source_table => 'FM_FORM_EFF'
491: ,p_target_table => 'GMD_RECIPES'
492: ,p_source_id => product_rec.item_no
493: ,p_target_id => l_recipe_id
494: ,p_message => error_msg
495: ,p_error_type => 'U');

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