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
52: -- and m.rowid = p_rowid