In table how to fetch XML cachedata of screen entry value in Transaction table

For Pending Transaction, we are not able to get the accurate element entry value from XML data cache element entry rows data , we are only fetching values if they have in element entries table. We want to fetch screen entry value for each Input Value in each row. But we ae getting all the values in a row without any space.

select txnh.XML_DATA_CACHE.extract('/TRANSACTION/BUSINESSDATA/AM/TXN/EO/ElementEntryDEORow/CEO/EO/ElementEntryValueDEORow/ScreenEntryValue/DATA/text()').getStringVal() amount
from hrc_txn_header txnh
where txnh.TRANSACTION_ID = 300001980083109