APPS.GMD_CONC_REPLACE_PKG dependencies on FM_MATL_DTL

Line 39: inventory_item_id NOT IN (SELECT inventory_item_id FROM fm_matl_dtl

35: /* Bug 3037410 Appended the where clause to check for the
36: validity rule's Product */
37: DELETE FROM gmd_recipe_validity_rules
38: WHERE recipe_id = precipe_id AND
39: inventory_item_id NOT IN (SELECT inventory_item_id FROM fm_matl_dtl
40: WHERE formula_id = (SELECT formula_id FROM gmd_recipes_b
41: WHERE recipe_id = precipe_id)
42: AND line_type = 1);
43:

Line 364: l_new_ingredient FM_MATL_DTL.inventory_item_id%TYPE;

360: l_status_type GMD_STATUS_B.status_type%TYPE;
361:
362: l_item_no VARCHAR2(2000);
363: l_formula_class FM_FORM_MST_B.formula_class%TYPE;
364: l_new_ingredient FM_MATL_DTL.inventory_item_id%TYPE;
365: l_old_ingredient FM_MATL_DTL.inventory_item_id%TYPE;
366: l_owner_id FM_FORM_MST_B.owner_id%TYPE;
367: l_formula_id FM_FORM_MST_B.formula_id%TYPE;
368: l_form_id FM_FORM_MST_B.formula_id%TYPE;

Line 365: l_old_ingredient FM_MATL_DTL.inventory_item_id%TYPE;

361:
362: l_item_no VARCHAR2(2000);
363: l_formula_class FM_FORM_MST_B.formula_class%TYPE;
364: l_new_ingredient FM_MATL_DTL.inventory_item_id%TYPE;
365: l_old_ingredient FM_MATL_DTL.inventory_item_id%TYPE;
366: l_owner_id FM_FORM_MST_B.owner_id%TYPE;
367: l_formula_id FM_FORM_MST_B.formula_id%TYPE;
368: l_form_id FM_FORM_MST_B.formula_id%TYPE;
369: l_scale_factor NUMBER;

Line 974: UPDATE fm_matl_dtl

970: IF l_return_status <> 'S' THEN
971: RAISE NO_UPDATE_EXCEPTION;
972: END IF;
973:
974: UPDATE fm_matl_dtl
975: SET inventory_item_id = get_object_rec.new_name,
976: revision = get_object_rec.new_version,
977: qty = qty * l_scale_factor,
978: ingredient_end_date = Null, --bug 4479101

Line 2243: fnd_dsql.add_text(' SELECT FORMULA_ID FROM FM_MATL_DTL

2239: ELSE
2240: fnd_dsql.add_text( ' And '||l_replace_type||' IN (');
2241:
2242: IF (pReplace_type = 'INGREDIENT') THEN
2243: fnd_dsql.add_text(' SELECT FORMULA_ID FROM FM_MATL_DTL
2244: WHERE LINE_TYPE = -1
2245: AND INVENTORY_ITEM_ID = ');
2246: fnd_dsql.add_bind(pOld_name);
2247: fnd_dsql.add_text(' ))');