APPS.EAM_WL_UTIL_PKG dependencies on MTL_SYSTEM_ITEMS

Line 7: l_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE ;

3:
4:
5: FUNCTION get_item_description( p_item_id NUMBER, p_organization_id NUMBER)
6: return VARCHAR2 IS
7: l_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE ;
8: CURSOR get_description IS
9: SELECT msi.description
10: FROM mtl_system_items msi, mtl_parameters mp
11: WHERE msi.inventory_item_id = p_item_id

Line 10: FROM mtl_system_items msi, mtl_parameters mp

6: return VARCHAR2 IS
7: l_description MTL_SYSTEM_ITEMS.DESCRIPTION%TYPE ;
8: CURSOR get_description IS
9: SELECT msi.description
10: FROM mtl_system_items msi, mtl_parameters mp
11: WHERE msi.inventory_item_id = p_item_id
12: AND msi.organization_id = mp.organization_id
13: AND mp.maint_organization_id = p_organization_id ;
14: BEGIN

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;

Line 110: FROM mtl_system_items msi, mtl_parameters mp

106: FUNCTION Is_Stock_Enable( p_inventory_item_id NUMBER, p_organization_id NUMBER) RETURN VARCHAR2
107: IS
108: CURSOR get_value IS
109: SELECT NVL(stock_enabled_flag,'N')
110: FROM mtl_system_items msi, mtl_parameters mp
111: WHERE msi.inventory_item_id = p_inventory_item_id
112: AND msi.organization_id = mp.organization_id
113: AND mp.maint_organization_id = p_organization_id ;
114:

Line 115: l_flag mtl_system_items.stock_enabled_flag%TYPE;

111: WHERE msi.inventory_item_id = p_inventory_item_id
112: AND msi.organization_id = mp.organization_id
113: AND mp.maint_organization_id = p_organization_id ;
114:
115: l_flag mtl_system_items.stock_enabled_flag%TYPE;
116: BEGIN
117: OPEN get_value;
118: FETCH get_value INTO l_flag;
119: CLOSE get_value;