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 229: l_new_ingredient FM_MATL_DTL.inventory_item_id%TYPE;

225: l_status_type GMD_STATUS_B.status_type%TYPE;
226:
227: l_item_no VARCHAR2(2000);
228: l_formula_class FM_FORM_MST_B.formula_class%TYPE;
229: l_new_ingredient FM_MATL_DTL.inventory_item_id%TYPE;
230: l_old_ingredient FM_MATL_DTL.inventory_item_id%TYPE;
231: l_owner_id FM_FORM_MST_B.owner_id%TYPE;
232: l_formula_id FM_FORM_MST_B.formula_id%TYPE;
233: l_form_id FM_FORM_MST_B.formula_id%TYPE;

Line 230: l_old_ingredient FM_MATL_DTL.inventory_item_id%TYPE;

226:
227: l_item_no VARCHAR2(2000);
228: l_formula_class FM_FORM_MST_B.formula_class%TYPE;
229: l_new_ingredient FM_MATL_DTL.inventory_item_id%TYPE;
230: l_old_ingredient FM_MATL_DTL.inventory_item_id%TYPE;
231: l_owner_id FM_FORM_MST_B.owner_id%TYPE;
232: l_formula_id FM_FORM_MST_B.formula_id%TYPE;
233: l_form_id FM_FORM_MST_B.formula_id%TYPE;
234: l_scale_factor NUMBER;

Line 821: UPDATE fm_matl_dtl

817: IF l_return_status <> 'S' THEN
818: RAISE NO_UPDATE_EXCEPTION;
819: END IF;
820:
821: UPDATE fm_matl_dtl
822: SET inventory_item_id = get_object_rec.new_name,
823: revision = get_object_rec.new_version,
824: qty = qty * l_scale_factor,
825: ingredient_end_date = Null, --bug 4479101

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

2053: ELSE
2054: fnd_dsql.add_text( ' And '||l_replace_type||' IN (');
2055:
2056: IF (pReplace_type = 'INGREDIENT') THEN
2057: fnd_dsql.add_text(' SELECT FORMULA_ID FROM FM_MATL_DTL
2058: WHERE LINE_TYPE = -1
2059: AND INVENTORY_ITEM_ID = ');
2060: fnd_dsql.add_bind(pOld_name);
2061: fnd_dsql.add_text(' ))');