APPS.GMD_NPD_MIGRATE dependencies on MTL_PARAMETERS

Line 1050: Mtl_parameters org

1046: FROM gmd_recipes_b chld,
1047: (SELECT recipe_id, owner_organization_id, recipe_no, formula_id, routing_id
1048: FROM gmd_recipes_b
1049: WHERE recipe_type = 0 ) mst,
1050: Mtl_parameters org
1051: WHERE org.master_organization_id = mst.owner_organization_id
1052: AND chld.owner_organization_id = org.organization_id
1053: AND mst.recipe_no = chld.recipe_no
1054: AND mst.formula_id = chld.formula_id

Line 1087: FROM mtl_parameters o

1083: WHERE recipe_type IS NULL
1084: AND owner_organization_id IN ( SELECT DISTINCT owner_organization_id
1085: FROM gmd_recipes_b r
1086: WHERE EXISTS (SELECT 1
1087: FROM mtl_parameters o
1088: WHERE o.master_organization_id = r.owner_organization_id));
1089:
1090: /* Now lets update the rest of the recipe types as "Site" */
1091: UPDATE gmd_recipes_b