APPS.BOM_RTG_EXP_UTIL dependencies on MTL_SYSTEM_ITEMS_KFV

Line 24: l_item_name mtl_system_items_kfv.concatenated_segments%TYPE;

20: -- 06-OCT-02 M V M P Tilak Initial Creation
21: ***************************************************************************/
22:
23: FUNCTION Get_Item_Name(P_inventory_item_id IN NUMBER) RETURN VARCHAR2 IS
24: l_item_name mtl_system_items_kfv.concatenated_segments%TYPE;
25: BEGIN
26: SELECT concatenated_segments
27: INTO l_item_name
28: FROM mtl_system_items_kfv

Line 28: FROM mtl_system_items_kfv

24: l_item_name mtl_system_items_kfv.concatenated_segments%TYPE;
25: BEGIN
26: SELECT concatenated_segments
27: INTO l_item_name
28: FROM mtl_system_items_kfv
29: WHERE inventory_item_id = P_inventory_item_id
30: AND rownum = 1;
31: RETURN l_item_name;
32: EXCEPTION

Line 42: FROM mtl_system_items_kfv

38: l_item_id NUMBER;
39: BEGIN
40: SELECT inventory_item_id
41: INTO l_item_id
42: FROM mtl_system_items_kfv
43: WHERE concatenated_segments = P_item_name
44: AND rownum = 1;
45: RETURN l_item_id;
46: EXCEPTION