Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

with XML_TABLE as (
select xmltype(
q'[<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ReceiptDesc xmlns="http //www.w3.org/2000/svg">
    <appt_nbr>0</appt_nbr>
    <Receipt>
        <dc_dest_id>ST</dc_dest_id>
        <po_nbr>1232</po_nbr>
        <document_type>T</document_type>
        <asn_nbr>0033</asn_nbr>
        <ReceiptDtl>
            <item_id>100233127</item_id>
            <unit_qty>0.0000</unit_qty>
            <user_id>EXTERNAL</user_id>
            <shipped_qty>6.0000</shipped_qty>
        </ReceiptDtl>
        <from_loc>WH</from_loc>
        <from_loc_type>W</from_loc_type>
    </Receipt>
    <Receipt>
        <dc_dest_id>ST</dc_dest_id>
        <po_nbr>1233</po_nbr>
        <document_type>T</document_type>
        <asn_nbr>0033</asn_nbr>
        <ReceiptDtl>
            <item_id>355532244</item_id>
            <unit_qty>2.0000</unit_qty>
            <user_id>EXTERNAL</user_id>
            <shipped_qty>2.0000</shipped_qty>
        </ReceiptDtl>
        <from_loc>WH</from_loc>
        <from_loc_type>W</from_loc_type>
    </Receipt>
    <Receipt>
        <dc_dest_id>ST</dc_dest_id>
        <po_nbr>1234</po_nbr>
        <document_type>T</document_type>
        <asn_nbr>0033</asn_nbr>
        <ReceiptDtl>
            <item_id>54480</item_id>
            <unit_qty>0.0000</unit_qty>
            <user_id>EXTERNAL</user_id>
            <shipped_qty>6.0000</shipped_qty>
        </ReceiptDtl>
        <from_loc>WH</from_loc>
        <from_loc_type>W</from_loc_type>
    </Receipt>
    <Receipt>
        <dc_dest_id>ST</dc_dest_id>
        <po_nbr>1235</po_nbr>
        <document_type>T</document_type>
        <asn_nbr>0033</asn_nbr>
        <ReceiptDtl>
            <item_id>38760</item_id>
            <unit_qty>8.0000</unit_qty>
            <user_id>EXTERNAL</user_id>
            <shipped_qty>8.0000</shipped_qty>
        </ReceiptDtl>
        <from_loc>WH</from_loc>
        <from_loc_type>W</from_loc_type>
    </Receipt>
</ReceiptDesc>
]') XML_COLUMN
from dual
)
select
  x.XML_COLUMN as original
  ,XMLQuery(
    'copy $NEWXML := $XML
       modify (
         delete nodes $NEWXML/*:ReceiptDesc/*:Receipt[./*:ReceiptDtl/*:unit_qty/text() = $NAME]
       )
     return $NEWXML'
     passing XML_COLUMN as "XML",
             '0.0000' as "NAME"
     returning CONTENT
   ) xml_fixed   
from XML_TABLE x

ORIGINAL	XML_FIXED
<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <ReceiptDesc xmlns="http //www.w3.org/2000/svg"> <appt_nbr>0</appt_nbr> <Receipt> <dc_dest_id>ST</dc_dest_id> <po_nbr>1232</po_nbr> <document_type>T</document_type> <asn_nbr>0033</asn_nbr> <ReceiptDtl> <item_id>100233127</item_id> <unit_qty>0.0000</unit_qty> <user_id>EXTERNAL</user_id> <shipped_qty>6.0000</shipped_qty> </ReceiptDtl> <from_loc>WH</from_loc> <from_loc_type>W</from_loc_type> </Receipt> <Receipt> <dc_dest_id>ST</dc_dest_id> <po_nbr>1233</po_nbr> <document_type>T</document_type> <asn_nbr>0033</asn_nbr> <ReceiptDtl> <item_id>355532244</item_id> <unit_qty>2.0000</unit_qty> <user_id>EXTERNAL</user_id> <shipped_qty>2.0000</shipped_qty> </ReceiptDtl> <from_loc>WH</from_loc> <from_loc_type>W</from_loc_type> </Receipt> <Receipt> <dc_dest_id>ST</dc_dest_id> <po_nbr>1234</po_nbr> <document_type>T</document_type> <asn_nbr>0033</asn_nbr> <ReceiptDtl> <item_id>54480</item_id> <unit_qty>0.0000</unit_qty> <user_id>EXTERNAL</user_id> <shipped_qty>6.0000</shipped_qty> </ReceiptDtl> <from_loc>WH</from_loc> <from_loc_type>W</from_loc_type> </Receipt> <Receipt> <dc_dest_id>ST</dc_dest_id> <po_nbr>1235</po_nbr> <document_type>T</document_type> <asn_nbr>0033</asn_nbr> <ReceiptDtl> <item_id>38760</item_id> <unit_qty>8.0000</unit_qty> <user_id>EXTERNAL</user_id> <shipped_qty>8.0000</shipped_qty> </ReceiptDtl> <from_loc>WH</from_loc> <from_loc_type>W</from_loc_type> </Receipt> </ReceiptDesc>	<?xml version="1.0" encoding="UTF-8" standalone='yes'?><ReceiptDesc xmlns="http //www.w3.org/2000/svg"><appt_nbr>0</appt_nbr><Receipt><dc_dest_id>ST</dc_dest_id><po_nbr>1233</po_nbr><document_type>T</document_type><asn_nbr>0033</asn_nbr><ReceiptDtl><item_id>355532244</item_id><unit_qty>2.0000</unit_qty><user_id>EXTERNAL</user_id><shipped_qty>2.0000</shipped_qty></ReceiptDtl><from_loc>WH</from_loc><from_loc_type>W</from_loc_type></Receipt><Receipt><dc_dest_id>ST</dc_dest_id><po_nbr>1235</po_nbr><document_type>T</document_type><asn_nbr>0033</asn_nbr><ReceiptDtl><item_id>38760</item_id><unit_qty>8.0000</unit_qty><user_id>EXTERNAL</user_id><shipped_qty>8.0000</shipped_qty></ReceiptDtl><from_loc>WH</from_loc><from_loc_type>W</from_loc_type></Receipt></ReceiptDesc>

ORIGINAL

XML_FIXED

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ReceiptDesc xmlns="http //www.w3.org/2000/svg">
<appt_nbr>0</appt_nbr>
<Receipt>
<dc_dest_id>ST</dc_dest_id>
<po_nbr>1232</po_nbr>
<document_type>T</document_type>
<asn_nbr>0033</asn_nbr>
<ReceiptDtl>
<item_id>100233127</item_id>
<unit_qty>0.0000</unit_qty>
<user_id>EXTERNAL</user_id>
<shipped_qty>6.0000</shipped_qty>
</ReceiptDtl>
<from_loc>WH</from_loc>
<from_loc_type>W</from_loc_type>
</Receipt>
<Receipt>
<dc_dest_id>ST</dc_dest_id>
<po_nbr>1233</po_nbr>
<document_type>T</document_type>
<asn_nbr>0033</asn_nbr>
<ReceiptDtl>
<item_id>355532244</item_id>
<unit_qty>2.0000</unit_qty>
<user_id>EXTERNAL</user_id>
<shipped_qty>2.0000</shipped_qty>
</ReceiptDtl>
<from_loc>WH</from_loc>
<from_loc_type>W</from_loc_type>
</Receipt>
<Receipt>
<dc_dest_id>ST</dc_dest_id>
<po_nbr>1234</po_nbr>
<document_type>T</document_type>
<asn_nbr>0033</asn_nbr>
<ReceiptDtl>
<item_id>54480</item_id>
<unit_qty>0.0000</unit_qty>
<user_id>EXTERNAL</user_id>
<shipped_qty>6.0000</shipped_qty>
</ReceiptDtl>
<from_loc>WH</from_loc>
<from_loc_type>W</from_loc_type>
</Receipt>
<Receipt>
<dc_dest_id>ST</dc_dest_id>
<po_nbr>1235</po_nbr>
<document_type>T</document_type>
<asn_nbr>0033</asn_nbr>
<ReceiptDtl>
<item_id>38760</item_id>
<unit_qty>8.0000</unit_qty>
<user_id>EXTERNAL</user_id>
<shipped_qty>8.0000</shipped_qty>
</ReceiptDtl>
<from_loc>WH</from_loc>
<from_loc_type>W</from_loc_type>
</Receipt>
</ReceiptDesc>

<?xml version="1.0" encoding="UTF-8" standalone='yes'?><ReceiptDesc xmlns="http //www.w3.org/2000/svg"><appt_nbr>0</appt_nbr><Receipt><dc_dest_id>ST</dc_dest_id><po_nbr>1233</po_nbr><document_type>T</document_type><asn_nbr>0033</asn_nbr><ReceiptDtl><item_id>355532244</item_id><unit_qty>2.0000</unit_qty><user_id>EXTERNAL</user_id><shipped_qty>2.0000</shipped_qty></ReceiptDtl><from_loc>WH</from_loc><from_loc_type>W</from_loc_type></Receipt><Receipt><dc_dest_id>ST</dc_dest_id><po_nbr>1235</po_nbr><document_type>T</document_type><asn_nbr>0033</asn_nbr><ReceiptDtl><item_id>38760</item_id><unit_qty>8.0000</unit_qty><user_id>EXTERNAL</user_id><shipped_qty>8.0000</shipped_qty></ReceiptDtl><from_loc>WH</from_loc><from_loc_type>W</from_loc_type></Receipt></ReceiptDesc>

with XML_TABLE as (
select xmltype(
q'[<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<ReceiptDesc xmlns="http //www.w3.org/2000/svg">
    <appt_nbr>0</appt_nbr>
    <Receipt>
        <dc_dest_id>ST</dc_dest_id>
        <po_nbr>1232</po_nbr>
        <document_type>T</document_type>
        <asn_nbr>0033</asn_nbr>
        <ReceiptDtl>
            <item_id>100233127</item_id>
            <unit_qty>0.0000</unit_qty>
            <user_id>EXTERNAL</user_id>
            <shipped_qty>6.0000</shipped_qty>
        </ReceiptDtl>
        <from_loc>WH</from_loc>
        <from_loc_type>W</from_loc_type>
    </Receipt>
    <Receipt>
        <dc_dest_id>ST</dc_dest_id>
        <po_nbr>1233</po_nbr>
        <document_type>T</document_type>
        <asn_nbr>0033</asn_nbr>
        <ReceiptDtl>
            <item_id>355532244</item_id>
            <unit_qty>2.0000</unit_qty>
            <user_id>EXTERNAL</user_id>
            <shipped_qty>2.0000</shipped_qty>
        </ReceiptDtl>
        <from_loc>WH</from_loc>
        <from_loc_type>W</from_loc_type>
    </Receipt>
    <Receipt>
        <dc_dest_id>ST</dc_dest_id>
        <po_nbr>1234</po_nbr>
        <document_type>T</document_type>
        <asn_nbr>0033</asn_nbr>
        <ReceiptDtl>
            <item_id>54480</item_id>
            <unit_qty>0.0000</unit_qty>
            <user_id>EXTERNAL</user_id>
            <shipped_qty>6.0000</shipped_qty>
        </ReceiptDtl>
        <from_loc>WH</from_loc>
        <from_loc_type>W</from_loc_type>
    </Receipt>
    <Receipt>
        <dc_dest_id>ST</dc_dest_id>
        <po_nbr>1235</po_nbr>
        <document_type>T</document_type>
        <asn_nbr>0033</asn_nbr>
        <ReceiptDtl>
            <item_id>38760</item_id>
            <unit_qty>8.0000</unit_qty>
            <user_id>EXTERNAL</user_id>
            <shipped_qty>8.0000</shipped_qty>
        </ReceiptDtl>
        <from_loc>WH</from_loc>
        <from_loc_type>W</from_loc_type>
    </Receipt>
</ReceiptDesc>
]') XML_COLUMN
from dual
)
select
  x.XML_COLUMN as original
  ,xmlserialize(content 
     XMLQuery(
      'copy $NEWXML := $XML
         modify (
           delete nodes $NEWXML/*:ReceiptDesc/*:Receipt[./*:ReceiptDtl/*:unit_qty/text() = $NAME]
         )
       return $NEWXML'
       passing XML_COLUMN as "XML",
               '0.0000' as "NAME"
       returning CONTENT
     ) 
   indent size=4)
   xml_fixed   
from XML_TABLE x

ORIGINAL	XML_FIXED
<?xml version="1.0" encoding="UTF-8" standalone="yes"?> <ReceiptDesc xmlns="http //www.w3.org/2000/svg"> <appt_nbr>0</appt_nbr> <Receipt> <dc_dest_id>ST</dc_dest_id> <po_nbr>1232</po_nbr> <document_type>T</document_type> <asn_nbr>0033</asn_nbr> <ReceiptDtl> <item_id>100233127</item_id> <unit_qty>0.0000</unit_qty> <user_id>EXTERNAL</user_id> <shipped_qty>6.0000</shipped_qty> </ReceiptDtl> <from_loc>WH</from_loc> <from_loc_type>W</from_loc_type> </Receipt> <Receipt> <dc_dest_id>ST</dc_dest_id> <po_nbr>1233</po_nbr> <document_type>T</document_type> <asn_nbr>0033</asn_nbr> <ReceiptDtl> <item_id>355532244</item_id> <unit_qty>2.0000</unit_qty> <user_id>EXTERNAL</user_id> <shipped_qty>2.0000</shipped_qty> </ReceiptDtl> <from_loc>WH</from_loc> <from_loc_type>W</from_loc_type> </Receipt> <Receipt> <dc_dest_id>ST</dc_dest_id> <po_nbr>1234</po_nbr> <document_type>T</document_type> <asn_nbr>0033</asn_nbr> <ReceiptDtl> <item_id>54480</item_id> <unit_qty>0.0000</unit_qty> <user_id>EXTERNAL</user_id> <shipped_qty>6.0000</shipped_qty> </ReceiptDtl> <from_loc>WH</from_loc> <from_loc_type>W</from_loc_type> </Receipt> <Receipt> <dc_dest_id>ST</dc_dest_id> <po_nbr>1235</po_nbr> <document_type>T</document_type> <asn_nbr>0033</asn_nbr> <ReceiptDtl> <item_id>38760</item_id> <unit_qty>8.0000</unit_qty> <user_id>EXTERNAL</user_id> <shipped_qty>8.0000</shipped_qty> </ReceiptDtl> <from_loc>WH</from_loc> <from_loc_type>W</from_loc_type> </Receipt> </ReceiptDesc>	<?xml version="1.0" encoding="UTF-8" standalone='yes'?> <ReceiptDesc xmlns="http //www.w3.org/2000/svg"> <appt_nbr>0</appt_nbr> <Receipt> <dc_dest_id>ST</dc_dest_id> <po_nbr>1233</po_nbr> <document_type>T</document_type> <asn_nbr>0033</asn_nbr> <ReceiptDtl> <item_id>355532244</item_id> <unit_qty>2.0000</unit_qty> <user_id>EXTERNAL</user_id> <shipped_qty>2.0000</shipped_qty> </ReceiptDtl> <from_loc>WH</from_loc> <from_loc_type>W</from_loc_type> </Receipt> <Receipt> <dc_dest_id>ST</dc_dest_id> <po_nbr>1235</po_nbr> <document_type>T</document_type> <asn_nbr>0033</asn_nbr> <ReceiptDtl> <item_id>38760</item_id> <unit_qty>8.0000</unit_qty> <user_id>EXTERNAL</user_id> <shipped_qty>8.0000</shipped_qty> </ReceiptDtl> <from_loc>WH</from_loc> <from_loc_type>W</from_loc_type> </Receipt> </ReceiptDesc>

ORIGINAL

XML_FIXED

<?xml version="1.0" encoding="UTF-8" standalone='yes'?>
<ReceiptDesc xmlns="http //www.w3.org/2000/svg">
<appt_nbr>0</appt_nbr>
<Receipt>
<dc_dest_id>ST</dc_dest_id>
<po_nbr>1233</po_nbr>
<document_type>T</document_type>
<asn_nbr>0033</asn_nbr>
<ReceiptDtl>
<item_id>355532244</item_id>
<unit_qty>2.0000</unit_qty>
<user_id>EXTERNAL</user_id>
<shipped_qty>2.0000</shipped_qty>
</ReceiptDtl>
<from_loc>WH</from_loc>
<from_loc_type>W</from_loc_type>
</Receipt>
<Receipt>
<dc_dest_id>ST</dc_dest_id>
<po_nbr>1235</po_nbr>
<document_type>T</document_type>
<asn_nbr>0033</asn_nbr>
<ReceiptDtl>
<item_id>38760</item_id>
<unit_qty>8.0000</unit_qty>
<user_id>EXTERNAL</user_id>
<shipped_qty>8.0000</shipped_qty>
</ReceiptDtl>
<from_loc>WH</from_loc>
<from_loc_type>W</from_loc_type>
</Receipt>
</ReceiptDesc>