title: How to omit aliased used in XMLForest function in oracle XML
body: <p>pl SQL code segment
  <code>SELECT Xmlserialize(DOCUMENT<br>
                       XMLELEMENT("intrastat",
                       XMLAGG(
                              Xmlforest(ENVELOPE_ID AS "envID",
                              XMLFOREST(DATE_ AS "date",TIME_ AS "Time")AS "Date 
                                   time", PARTY_ID AS "pid",PARTY_NAME AS "pname", 
                                   XMLFOREST(Xmlelement("RC",REGION_CODE) AS RC,Xmlelement("TCPCODE",MODE_OF_TRANSPORT_CODE) AS TCPCODE) AS "item") 
  )))
  FROM INTRASTAT_XML_TEMPLATE_LINE_TMP</code></p>
  
  <p>part of actual output that make the trouble 
  <code>&lt;item&gt;&lt;RC&gt;&lt;RC&gt;as&lt;/RC&gt;&lt;/RC&gt;&lt;TCPCODE&gt;&lt;TCPCODE&gt;22&lt;/TCPCODE&gt;&lt;/TCPCODE&gt;&lt;/item&gt;</code> </p>
  
  <p>what i want to get
  <code>&lt;item&gt;&lt;RC&gt;ads&lt;/RC&gt;&lt;TCPCODE&gt;22&lt;/TCPCODE&gt;&lt;/item&gt;</code>  </p>