APPS.GMD_FORMULA_DETAIL_PUB dependencies on IC_ITEM_MST

Line 1560: l_item_id ic_item_mst.item_id%TYPE := 0;

1556: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_FORMULADETAIL';
1557: l_api_version CONSTANT NUMBER := 1.1;
1558: l_user_id fnd_user.user_id%TYPE := 0;
1559: l_return_val NUMBER := 0;
1560: l_item_id ic_item_mst.item_id%TYPE := 0;
1561: l_inv_uom ic_item_mst.item_um%TYPE := NULL;
1562: l_fm_matl_dtl_rec fm_matl_dtl%ROWTYPE;
1563: p_formula_detail_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
1564: l_count NUMBER := 0;

Line 1561: l_inv_uom ic_item_mst.item_um%TYPE := NULL;

1557: l_api_version CONSTANT NUMBER := 1.1;
1558: l_user_id fnd_user.user_id%TYPE := 0;
1559: l_return_val NUMBER := 0;
1560: l_item_id ic_item_mst.item_id%TYPE := 0;
1561: l_inv_uom ic_item_mst.item_um%TYPE := NULL;
1562: l_fm_matl_dtl_rec fm_matl_dtl%ROWTYPE;
1563: p_formula_detail_rec GMD_FORMULA_COMMON_PUB.formula_update_rec_type;
1564: l_count NUMBER := 0;
1565:

Line 1586: ic_item_mst it

1582: CURSOR check_validity_rules(pformula_id number, pitem_no varchar2 ) IS
1583: SELECT 1
1584: FROM gmd_recipes_b rcp,
1585: gmd_recipe_validity_rules vr,
1586: ic_item_mst it
1587: WHERE vr.delete_mark = 0
1588: AND vr.validity_rule_status < 1000
1589: AND (vr.end_date IS NULL OR vr.end_date >= SYSDATE)
1590: AND it.item_no = pitem_no