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 587: l_item_id mtl_system_items.inventory_item_id%TYPE := 0;

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

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

584: l_api_version CONSTANT NUMBER := 2.0;
585: l_user_id fnd_user.user_id%TYPE := 0;
586: l_return_val NUMBER := 0;
587: l_item_id mtl_system_items.inventory_item_id%TYPE := 0;
588: l_inv_uom mtl_system_items.primary_uom_code%TYPE := NULL;
589: l_formula_id fm_matl_dtl.formula_id%TYPE := 0;
590: l_fm_matl_dtl_rec fm_matl_dtl%ROWTYPE;
591: p_formula_detail_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
592: X_formula_detail_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;

Line 662: FROM mtl_system_items_kfv

658: WHERE formulaline_id = V_formulaline_id;
659:
660: CURSOR C_get_item_no (V_item_id NUMBER) IS
661: SELECT concatenated_segments
662: FROM mtl_system_items_kfv
663: WHERE inventory_item_id = V_item_id;
664: l_item_no VARCHAR2(2000);
665:
666: -- Kapil ME Auto-Prod :Bug#5716318

Line 1605: mtl_system_items_vl it

1601: CURSOR check_validity_rules(pformula_id number, pitem_no varchar2 ) IS
1602: SELECT 1
1603: FROM gmd_recipes_b rcp,
1604: gmd_recipe_validity_rules vr,
1605: mtl_system_items_vl it
1606: WHERE vr.delete_mark = 0
1607: AND vr.validity_rule_status < 1000
1608: AND (vr.end_date IS NULL OR vr.end_date >= SYSDATE)
1609: AND it.concatenated_segments = pitem_no