APPS.EAM_WL_UTIL_PKG dependencies on MTL_PARAMETERS

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 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 131: FROM csi_item_instances cii, mtl_parameters mp

127: FUNCTION get_serial_description( p_serial_number VARCHAR2, p_item_id NUMBER, p_organization_id NUMBER) RETURN VARCHAR2
128: IS
129: CURSOR get_value IS
130: SELECT cii.instance_description
131: FROM csi_item_instances cii, mtl_parameters mp
132: WHERE cii.serial_number = p_serial_number
133: AND cii.inventory_item_id = p_item_id
134: AND cii.last_vld_organization_id = mp.organization_id
135: AND mp.maint_organization_id = p_organization_id;