APPS.GMD_RECIPE_MIGRATION dependencies on GMD_RECIPE_EFF_ASSOC

Line 24: FROM gmd_recipe_eff_assoc

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 )
26: AND e.formula_id = h.formula_id
27: GROUP BY h.formula_no,
28: h.formula_vers,

Line 48: FROM gmd_recipe_eff_assoc

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
49: WHERE fmeff_id = e.fmeff_id )
50: AND e.formula_id = m.formula_id
51: AND e.formula_id = h.formula_id
52: AND m.item_id = i.item_id

Line 508: /* We need to use an association table GMD_RECIPE_EFF_ASSOC that relates fmeff_id */

504: /* Step 2: Create an association table */
505: /* Loop thro every fmeff_id in the fm_form_eff table */
506: /* Based on the formula and routing id we could derive the recipe_id from recipe_header. */
507:
508: /* We need to use an association table GMD_RECIPE_EFF_ASSOC that relates fmeff_id */
509: /* to the recipe_id and validity rule id */
510:
511: INSERT INTO gmd_recipe_eff_assoc
512: ( fmeff_id,

Line 511: INSERT INTO gmd_recipe_eff_assoc

507:
508: /* We need to use an association table GMD_RECIPE_EFF_ASSOC that relates fmeff_id */
509: /* to the recipe_id and validity rule id */
510:
511: INSERT INTO gmd_recipe_eff_assoc
512: ( fmeff_id,
513: recipe_id,
514: orgn_code,
515: item_id,

Line 567: FROM gmd_recipe_eff_assoc

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
570: AND NVL ( rec.routing_id, -111 ) = NVL ( eff.routing_id, -111 );
571:

Line 582: FROM gmd_recipe_eff_assoc a

578: a.last_updated_by,
579: a.last_update_login,
580: a.text_code,
581: a.last_update_date
582: FROM gmd_recipe_eff_assoc a
583: WHERE NOT EXISTS ( SELECT 1
584: FROM gmd_recipe_customers
585: WHERE recipe_id = a.recipe_id
586: AND customer_id = a.cust_id )

Line 671: FROM gmd_recipe_eff_assoc

667: last_update_date,
668: last_update_login,
669: delete_mark,
670: gmdfmval_pub.gmd_effectivity_locked_status ( fmeff_id )
671: FROM gmd_recipe_eff_assoc
672: WHERE NOT EXISTS ( SELECT 1
673: FROM gmd_recipe_validity_rules
674: WHERE recipe_validity_rule_id = fmeff_id );
675:

Line 868: insert_message (p_source_table => 'GMD_RECIPE_EFF_ASSOC'

864: EXCEPTION
865: WHEN OTHERS
866: THEN
867: error_msg := SQLERRM;
868: insert_message (p_source_table => 'GMD_RECIPE_EFF_ASSOC'
869: ,p_target_table => 'PM_BTCH_HDR - CM_CMPT_DTL - GL_ITEM_CST - GMP_FORM_EFF'
870: ,p_source_id => l_fmeff_id
871: ,p_target_id => update_eff_rec.fmeff_id
872: ,p_message => error_msg