APPS.EAM_WL_UTIL_PKG dependencies on MTL_SYSTEM_ITEMS_KFV

Line 26: FROM mtl_system_items_kfv msi, mtl_parameters mp

22: FUNCTION get_concatenated_segments( p_item_id NUMBER, p_organization_id NUMBER) RETURN VARCHAR2
23: IS
24: CURSOR get_value IS
25: SELECT msi.concatenated_segments
26: FROM mtl_system_items_kfv msi, mtl_parameters mp
27: WHERE msi.inventory_item_id = p_item_id
28: AND msi.organization_id = mp.organization_id
29: AND mp.maint_organization_id = p_organization_id ;
30:

Line 31: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;

27: WHERE msi.inventory_item_id = p_item_id
28: AND msi.organization_id = mp.organization_id
29: AND mp.maint_organization_id = p_organization_id ;
30:
31: l_concatenated_segments mtl_system_items_kfv.concatenated_segments%TYPE;
32: BEGIN
33: OPEN get_value;
34: FETCH get_value INTO l_concatenated_segments;
35: CLOSE get_value;