I can’t see your attachment on my phone, but I’d point out your mixed use of ‘xpaths’ vs ‘selects’ between the two queries.
You’ll likely need something like
node values of child nodes of xpaths "..." rather than
(it as text) of xpaths "...".
Xpath returns a node, you need to either get its node value or its child node’s node value.
I’d start from the top, retrieving
(node name of it | "no name", node value of it | "no value") of (it, child nodes of it) of xpaths "INVENTORY" of xml document of file “C:\Program Files (x86)\Oracle\Inventory\ContentsXML\inventory.xml”
That will help illustrate where you are in the tree, and as you get a result you can further build the xpath value to drill down to the node you want.