APPS.GMD_FORMULA_DETAIL_PUB dependencies on MTL_SYSTEM_ITEMS

Line 78: l_item_id mtl_system_items.inventory_item_id%TYPE := 0;

74: l_api_name CONSTANT VARCHAR2(30) := 'INSERT_FORMULADETAIL';
75: l_api_version CONSTANT NUMBER := 1.0;
76: l_user_id fnd_user.user_id%TYPE := 0;
77: l_return_val NUMBER := 0;
78: l_item_id mtl_system_items.inventory_item_id%TYPE := 0;
79: l_inv_uom mtl_system_items.primary_uom_code%TYPE := NULL;
80: l_formula_id fm_matl_dtl.formula_id%TYPE := 0;
81: l_surrogate fm_matl_dtl.formulaline_id%TYPE := 0;
82:

Line 79: l_inv_uom mtl_system_items.primary_uom_code%TYPE := NULL;

75: l_api_version CONSTANT NUMBER := 1.0;
76: l_user_id fnd_user.user_id%TYPE := 0;
77: l_return_val NUMBER := 0;
78: l_item_id mtl_system_items.inventory_item_id%TYPE := 0;
79: l_inv_uom mtl_system_items.primary_uom_code%TYPE := NULL;
80: l_formula_id fm_matl_dtl.formula_id%TYPE := 0;
81: l_surrogate fm_matl_dtl.formulaline_id%TYPE := 0;
82:
83: /* Record type definition */

Line 235: FROM mtl_system_items_b

231: /* Bug No.6799624 - Start */
232:
233: BEGIN
234: SELECT segment1,recipe_enabled_flag INTO v_item_no, v_recipe_enabled
235: FROM mtl_system_items_b
236: WHERE inventory_item_id = p_formula_detail_rec.inventory_item_id AND
237: organization_id = p_formula_detail_rec.owner_organization_id;
238: EXCEPTION
239: WHEN others THEN

Line 582: l_item_id mtl_system_items.inventory_item_id%TYPE := 0;

578: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_FORMULADETAIL';
579: l_api_version CONSTANT NUMBER := 2.0;
580: l_user_id fnd_user.user_id%TYPE := 0;
581: l_return_val NUMBER := 0;
582: l_item_id mtl_system_items.inventory_item_id%TYPE := 0;
583: l_inv_uom mtl_system_items.primary_uom_code%TYPE := NULL;
584: l_formula_id fm_matl_dtl.formula_id%TYPE := 0;
585: l_fm_matl_dtl_rec fm_matl_dtl%ROWTYPE;
586: p_formula_detail_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;

Line 583: l_inv_uom mtl_system_items.primary_uom_code%TYPE := NULL;

579: l_api_version CONSTANT NUMBER := 2.0;
580: l_user_id fnd_user.user_id%TYPE := 0;
581: l_return_val NUMBER := 0;
582: l_item_id mtl_system_items.inventory_item_id%TYPE := 0;
583: l_inv_uom mtl_system_items.primary_uom_code%TYPE := NULL;
584: l_formula_id fm_matl_dtl.formula_id%TYPE := 0;
585: l_fm_matl_dtl_rec fm_matl_dtl%ROWTYPE;
586: p_formula_detail_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
587: X_formula_detail_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;

Line 657: FROM mtl_system_items_kfv

653: WHERE formulaline_id = V_formulaline_id;
654:
655: CURSOR C_get_item_no (V_item_id NUMBER) IS
656: SELECT concatenated_segments
657: FROM mtl_system_items_kfv
658: WHERE inventory_item_id = V_item_id;
659: l_item_no VARCHAR2(2000);
660:
661: -- Kapil ME Auto-Prod :Bug#5716318