select * from
innovator.PART where keyed_name='P00001'
-- Get ID from above results and use in the below query...
select * from
innovator.PART_ITEM_CHARACTERISTIC_VALUE where
SOURCE_ID='36A093C8325A44698684354FAF6E3425'
--Above query will give all item characteristic values of P00001. This result will have "Display_Value" and "Text_value"