APPS.INVPULI4 dependencies on MTL_ITEM_STATUS

Line 22: g_item_status_code mtl_item_status.inventory_item_status_code%TYPE;

18: **status ctrl
19: */
20:
21: -- bug 7137702 : new variables for caching purpose
22: g_item_status_code mtl_item_status.inventory_item_status_code%TYPE;
23: g_attribute_names dbms_sql.varchar2s;
24: g_attribute_values dbms_sql.varchar2s;
25: g_status_control_codes dbms_sql.number_table;
26: g_control_levels dbms_sql.number_table;

Line 47: from mtl_item_status s,

43: select v.attribute_name,
44: v.attribute_value,
45: a.status_control_code,
46: a.control_level
47: from mtl_item_status s,
48: mtl_status_attribute_values v,
49: mtl_item_attributes a
50: -- mtl_system_items_interface m
51: -- where s.inventory_item_status_code = m.inventory_item_status_code