xmltype data retrieval.
I have data in xmltype column as shown below.
<?xml version="1.0" encoding="UTF-8"?>
<FndFilter xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="http://www.oracle.com/apps/fnd/applcore/filter/FndFilter.xsd">
<KeyFlexFilter>
<keyFlexfieldCode>GL#</keyFlexfieldCode>
<structureInstanceCode>OCD_Corporate_COA</structureInstanceCode>
<applicationShortName>GL</applicationShortName>
<filterCriteriaRow>
<filterCriteriaItem>
<attributeName>ocdLocation</attributeName>
<columnName>SEGMENT5</columnName>
<operator>EQUALTO</operator>
<conjunction>AND</conjunction>
<valueDataType>STRING</valueDataType>
<value>1350</value>
</filterCriteriaItem>
<filterCriteriaItem>
<attributeName>ocdLocation</attributeName>
<columnName>SEGMENT5</columnName>
<operator>EQUALTO</operator>
<conjunction>OR</conjunction>
<valueDataType>STRING</valueDataType>
<value>4000</value>
</filterCriteriaItem>
<conjunction>AND</conjunction>
</filterCriteriaRow>
</KeyFlexFilter>
</FndFilter>
Result should be
ocdLocation Equals to 1350 OR ocdLocation Equals to 4000 (values from attributeName operator value).