Solved

select xml data as column

Posted on 2013-11-11
21
529 Views
Last Modified: 2013-12-02
I have a file

/home/oracle/output.xml


i inserted file data into table using

INSERT INTO xml_table VALUES (XMLType(bfilename('XMLDIR', 'output.xml'), nls_charset_id('AL32UTF8')));

INSERT INTO table_with_xml_column (filename, xml_document)
  VALUES ('output.xml',
          XMLType(bfilename('XMLDIR', 'output.xml'),
          nls_charset_id('AL32UTF8')));
commit;          

Open in new window

         
                 
I can select the xml in the table with
SELECT x.OBJECT_VALUE.getCLOBVal() FROM xml_table x;

Open in new window



Now i want to select the xml as columns.

Can someone poing me in the right direction?

This is the accompanying XSD for the xml data which i also have created in XML Schemas


<?xml version="1.0" encoding="WINDOWS-1252"?>
<!-- Created with Liquid XML 2013 Designer Edition (Trial) 11.1.0.4725 (http://www.liquid-technologies.com) -->
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:oraxdb="http://xmlns.oracle.com/xdb" oraxdb:storeVarrayAsTable="true" oraxdb:flags="2105639" oraxdb:schemaURL="XML_SCHEMA" oraxdb:schemaOwner="REPERMS" oraxdb:numProps="330">
  <xs:element name="response" oraxdb:propNumber="4289" oraxdb:global="true" oraxdb:SQLName="response" oraxdb:SQLType="response621_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:defaultTable="response729_TAB" oraxdb:defaultTableSchema="REPERMS">
    <xs:complexType oraxdb:SQLType="response621_T" oraxdb:SQLSchema="REPERMS">
      <xs:sequence>
        <xs:element minOccurs="0" name="objects" oraxdb:propNumber="4277" oraxdb:global="false" oraxdb:SQLName="objects" oraxdb:SQLType="objects622_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
          <xs:complexType oraxdb:SQLType="objects622_T" oraxdb:SQLSchema="REPERMS">
            <xs:sequence>
              <xs:element minOccurs="0" maxOccurs="unbounded" name="object" oraxdb:propNumber="4276" oraxdb:global="false" oraxdb:SQLName="object" oraxdb:SQLType="object623_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false" oraxdb:SQLCollType="object723_COLL" oraxdb:SQLCollSchema="REPERMS">
                <xs:complexType oraxdb:SQLType="object623_T" oraxdb:SQLSchema="REPERMS">
                  <xs:sequence>
                    <xs:element minOccurs="0" name="otherVersions" oraxdb:propNumber="3963" oraxdb:global="false" oraxdb:SQLName="otherVersions" oraxdb:SQLType="otherVersions624_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                      <xs:complexType oraxdb:SQLType="otherVersions624_T" oraxdb:SQLSchema="REPERMS">
                        <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="3962" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                      </xs:complexType>
                    </xs:element>
                    <xs:element minOccurs="0" name="percentDiscount" oraxdb:propNumber="3965" oraxdb:global="false" oraxdb:SQLName="percentDiscount" oraxdb:SQLType="percentDiscount625_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                      <xs:complexType oraxdb:SQLType="percentDiscount625_T" oraxdb:SQLSchema="REPERMS">
                        <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="3964" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                      </xs:complexType>
                    </xs:element>
                    <xs:element minOccurs="0" name="entityType" type="xs:string" oraxdb:propNumber="3966" oraxdb:global="false" oraxdb:SQLName="entityType" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                    <xs:element minOccurs="0" name="ownerName" type="xs:string" oraxdb:propNumber="3967" oraxdb:global="false" oraxdb:SQLName="ownerName" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                    <xs:element minOccurs="0" name="mtime" type="xs:dateTime" oraxdb:propNumber="3968" oraxdb:global="false" oraxdb:SQLName="mtime" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                    <xs:element minOccurs="0" name="owner" type="xs:string" oraxdb:propNumber="3969" oraxdb:global="false" oraxdb:SQLName="owner" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                    <xs:element minOccurs="0" name="shippingMethod" type="xs:string" oraxdb:propNumber="3970" oraxdb:global="false" oraxdb:SQLName="shippingMethod" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                    <xs:element minOccurs="0" name="id" type="xs:string" oraxdb:propNumber="3971" oraxdb:global="false" oraxdb:SQLName="id" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                    <xs:element minOccurs="0" name="category" type="xs:string" oraxdb:propNumber="3972" oraxdb:global="false" oraxdb:SQLName="category" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                    <xs:element minOccurs="0" name="billTo" oraxdb:propNumber="4010" oraxdb:global="false" oraxdb:SQLName="billTo" oraxdb:SQLType="billTo626_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                      <xs:complexType oraxdb:SQLType="billTo626_T" oraxdb:SQLSchema="REPERMS">
                        <xs:sequence>
                          <xs:element minOccurs="0" name="btCustomer" type="xs:string" oraxdb:propNumber="3974" oraxdb:global="false" oraxdb:SQLName="btCustomer" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                          <xs:element minOccurs="0" name="entityType" type="xs:string" oraxdb:propNumber="3975" oraxdb:global="false" oraxdb:SQLName="entityType" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                          <xs:element minOccurs="0" name="street" oraxdb:propNumber="3977" oraxdb:global="false" oraxdb:SQLName="street" oraxdb:SQLType="street627_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                            <xs:complexType oraxdb:SQLType="street627_T" oraxdb:SQLSchema="REPERMS">
                              <xs:simpleContent>
                                <xs:extension base="xs:string">
                                  <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="3976" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                </xs:extension>
                              </xs:simpleContent>
                            </xs:complexType>
                          </xs:element>
                          <xs:element minOccurs="0" name="postcode" oraxdb:propNumber="3979" oraxdb:global="false" oraxdb:SQLName="postcode" oraxdb:SQLType="postcode628_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                            <xs:complexType oraxdb:SQLType="postcode628_T" oraxdb:SQLSchema="REPERMS">
                              <xs:simpleContent>
                                <xs:extension base="xs:string">
                                  <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="3978" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                </xs:extension>
                              </xs:simpleContent>
                            </xs:complexType>
                          </xs:element>
                          <xs:element minOccurs="0" name="mtime" type="xs:dateTime" oraxdb:propNumber="3980" oraxdb:global="false" oraxdb:SQLName="mtime" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                          <xs:element minOccurs="0" name="owner" type="xs:string" oraxdb:propNumber="3981" oraxdb:global="false" oraxdb:SQLName="owner" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                          <xs:element minOccurs="0" name="id" oraxdb:propNumber="3983" oraxdb:global="false" oraxdb:SQLName="id" oraxdb:SQLType="id629_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                            <xs:complexType oraxdb:SQLType="id629_T" oraxdb:SQLSchema="REPERMS">
                              <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="3982" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                            </xs:complexType>
                          </xs:element>
                          <xs:element minOccurs="0" name="city" oraxdb:propNumber="3985" oraxdb:global="false" oraxdb:SQLName="city" oraxdb:SQLType="city630_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                            <xs:complexType oraxdb:SQLType="city630_T" oraxdb:SQLSchema="REPERMS">
                              <xs:simpleContent>
                                <xs:extension base="xs:string">
                                  <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="3984" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                </xs:extension>
                              </xs:simpleContent>
                            </xs:complexType>
                          </xs:element>
                          <xs:element minOccurs="0" name="uuid" type="xs:string" oraxdb:propNumber="3986" oraxdb:global="false" oraxdb:SQLName="uuid" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                          <xs:element minOccurs="0" name="ctimeOnServer" type="xs:dateTime" oraxdb:propNumber="3987" oraxdb:global="false" oraxdb:SQLName="ctimeOnServer" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                          <xs:element minOccurs="0" name="mtimeOnServer" type="xs:dateTime" oraxdb:propNumber="3988" oraxdb:global="false" oraxdb:SQLName="mtimeOnServer" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                          <xs:element minOccurs="0" name="state" oraxdb:propNumber="3990" oraxdb:global="false" oraxdb:SQLName="state" oraxdb:SQLType="state631_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                            <xs:complexType oraxdb:SQLType="state631_T" oraxdb:SQLSchema="REPERMS">
                              <xs:simpleContent>
                                <xs:extension base="xs:string">
                                  <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="3989" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                </xs:extension>
                              </xs:simpleContent>
                            </xs:complexType>
                          </xs:element>
                          <xs:element minOccurs="0" name="fax" oraxdb:propNumber="3992" oraxdb:global="false" oraxdb:SQLName="fax" oraxdb:SQLType="fax632_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                            <xs:complexType oraxdb:SQLType="fax632_T" oraxdb:SQLSchema="REPERMS">
                              <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="3991" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                            </xs:complexType>
                          </xs:element>
                          <xs:element minOccurs="0" name="isDefaultShipTo" oraxdb:propNumber="3994" oraxdb:global="false" oraxdb:SQLName="isDefaultShipTo" oraxdb:SQLType="isDefaultShipTo633_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                            <xs:complexType oraxdb:SQLType="isDefaultShipTo633_T" oraxdb:SQLSchema="REPERMS">
                              <xs:simpleContent>
                                <xs:extension base="xs:string">
                                  <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="3993" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                </xs:extension>
                              </xs:simpleContent>
                            </xs:complexType>
                          </xs:element>
                          <xs:element minOccurs="0" name="street2" oraxdb:propNumber="3996" oraxdb:global="false" oraxdb:SQLName="street2" oraxdb:SQLType="street2634_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                            <xs:complexType oraxdb:SQLType="street2634_T" oraxdb:SQLSchema="REPERMS">
                              <xs:simpleContent>
                                <xs:extension base="xs:string">
                                  <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="3995" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                </xs:extension>
                              </xs:simpleContent>
                            </xs:complexType>
                          </xs:element>
                          <xs:element minOccurs="0" name="stCustomer" oraxdb:propNumber="3998" oraxdb:global="false" oraxdb:SQLName="stCustomer" oraxdb:SQLType="stCustomer635_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                            <xs:complexType oraxdb:SQLType="stCustomer635_T" oraxdb:SQLSchema="REPERMS">
                              <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="3997" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                            </xs:complexType>
                          </xs:element>
                          <xs:element minOccurs="0" name="phone" oraxdb:propNumber="4000" oraxdb:global="false" oraxdb:SQLName="phone" oraxdb:SQLType="phone636_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                            <xs:complexType oraxdb:SQLType="phone636_T" oraxdb:SQLSchema="REPERMS">
                              <xs:simpleContent>
                                <xs:extension base="xs:string">
                                  <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="3999" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                </xs:extension>
                              </xs:simpleContent>
                            </xs:complexType>
                          </xs:element>
                          <xs:element minOccurs="0" name="cdate" type="xs:date" oraxdb:propNumber="4001" oraxdb:global="false" oraxdb:SQLName="cdate" oraxdb:SQLType="DATE" oraxdb:memType="12" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                          <xs:element minOccurs="0" name="ctime" type="xs:dateTime" oraxdb:propNumber="4002" oraxdb:global="false" oraxdb:SQLName="ctime" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                          <xs:element minOccurs="0" name="name" oraxdb:propNumber="4004" oraxdb:global="false" oraxdb:SQLName="name" oraxdb:SQLType="name637_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                            <xs:complexType oraxdb:SQLType="name637_T" oraxdb:SQLSchema="REPERMS">
                              <xs:simpleContent>
                                <xs:extension base="xs:string">
                                  <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4003" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                </xs:extension>
                              </xs:simpleContent>
                            </xs:complexType>
                          </xs:element>
                          <xs:element minOccurs="0" name="country" oraxdb:propNumber="4006" oraxdb:global="false" oraxdb:SQLName="country" oraxdb:SQLType="country638_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                            <xs:complexType oraxdb:SQLType="country638_T" oraxdb:SQLSchema="REPERMS">
                              <xs:simpleContent>
                                <xs:extension base="xs:string">
                                  <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4005" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                </xs:extension>
                              </xs:simpleContent>
                            </xs:complexType>
                          </xs:element>
                          <xs:element minOccurs="0" name="objID" oraxdb:propNumber="4008" oraxdb:global="false" oraxdb:SQLName="objID" oraxdb:SQLType="objID639_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                            <xs:complexType oraxdb:SQLType="objID639_T" oraxdb:SQLSchema="REPERMS">
                              <xs:simpleContent>
                                <xs:extension base="xs:unsignedInt">
                                  <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4007" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                </xs:extension>
                              </xs:simpleContent>
                            </xs:complexType>
                          </xs:element>
                          <xs:element minOccurs="0" name="resource_uri" type="xs:string" oraxdb:propNumber="4009" oraxdb:global="false" oraxdb:SQLName="resource_uri" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                        </xs:sequence>
                        <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="3973" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                      </xs:complexType>
                    </xs:element>
                    <xs:element minOccurs="0" name="paymentTerms" type="xs:string" oraxdb:propNumber="4011" oraxdb:global="false" oraxdb:SQLName="paymentTerms" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                    <xs:element minOccurs="0" name="uuid" type="xs:string" oraxdb:propNumber="4012" oraxdb:global="false" oraxdb:SQLName="uuid" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                    <xs:element minOccurs="0" name="ctimeOnServer" type="xs:dateTime" oraxdb:propNumber="4013" oraxdb:global="false" oraxdb:SQLName="ctimeOnServer" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                    <xs:element minOccurs="0" name="freeShipping" oraxdb:propNumber="4015" oraxdb:global="false" oraxdb:SQLName="freeShipping" oraxdb:SQLType="freeShipping640_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                      <xs:complexType oraxdb:SQLType="freeShipping640_T" oraxdb:SQLSchema="REPERMS">
                        <xs:simpleContent>
                          <xs:extension base="xs:string">
                            <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4014" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                          </xs:extension>
                        </xs:simpleContent>
                      </xs:complexType>
                    </xs:element>
                    <xs:element minOccurs="0" name="startShipDate" oraxdb:propNumber="4017" oraxdb:global="false" oraxdb:SQLName="startShipDate" oraxdb:SQLType="startShipDate641_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                      <xs:complexType oraxdb:SQLType="startShipDate641_T" oraxdb:SQLSchema="REPERMS">
                        <xs:simpleContent>
                          <xs:extension base="xs:string">
                            <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4016" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                          </xs:extension>
                        </xs:simpleContent>
                      </xs:complexType>
                    </xs:element>
                    <xs:element minOccurs="0" name="mtimeOnServer" type="xs:dateTime" oraxdb:propNumber="4018" oraxdb:global="false" oraxdb:SQLName="mtimeOnServer" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                    <xs:element minOccurs="0" name="shipPartial" oraxdb:propNumber="4020" oraxdb:global="false" oraxdb:SQLName="shipPartial" oraxdb:SQLType="shipPartial642_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                      <xs:complexType oraxdb:SQLType="shipPartial642_T" oraxdb:SQLSchema="REPERMS">
                        <xs:simpleContent>
                          <xs:extension base="xs:string">
                            <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4019" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                          </xs:extension>
                        </xs:simpleContent>
                      </xs:complexType>
                    </xs:element>
                    <xs:element minOccurs="0" name="userGroup" type="xs:string" oraxdb:propNumber="4021" oraxdb:global="false" oraxdb:SQLName="userGroup" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                    <xs:element minOccurs="0" name="status" type="xs:string" oraxdb:propNumber="4022" oraxdb:global="false" oraxdb:SQLName="status" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                    <xs:element minOccurs="0" name="customer" oraxdb:propNumber="4169" oraxdb:global="false" oraxdb:SQLName="customer" oraxdb:SQLType="customer643_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                      <xs:complexType oraxdb:SQLType="customer643_T" oraxdb:SQLSchema="REPERMS">
                        <xs:sequence>
                          <xs:element minOccurs="0" name="locale" type="xs:string" oraxdb:propNumber="4024" oraxdb:global="false" oraxdb:SQLName="locale" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                          <xs:element minOccurs="0" name="percentDiscount" oraxdb:propNumber="4026" oraxdb:global="false" oraxdb:SQLName="percentDiscount" oraxdb:SQLType="percentDiscount644_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                            <xs:complexType oraxdb:SQLType="percentDiscount644_T" oraxdb:SQLSchema="REPERMS">
                              <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4025" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                            </xs:complexType>
                          </xs:element>
                          <xs:element minOccurs="0" name="entityType" type="xs:string" oraxdb:propNumber="4027" oraxdb:global="false" oraxdb:SQLName="entityType" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                          <xs:element minOccurs="0" name="currency" type="xs:string" oraxdb:propNumber="4028" oraxdb:global="false" oraxdb:SQLName="currency" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                          <xs:element minOccurs="0" name="ownerName" type="xs:string" oraxdb:propNumber="4029" oraxdb:global="false" oraxdb:SQLName="ownerName" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                          <xs:element minOccurs="0" name="mtime" type="xs:dateTime" oraxdb:propNumber="4030" oraxdb:global="false" oraxdb:SQLName="mtime" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                          <xs:element minOccurs="0" name="owner" type="xs:string" oraxdb:propNumber="4031" oraxdb:global="false" oraxdb:SQLName="owner" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                          <xs:element minOccurs="0" name="shippingMethod" type="xs:string" oraxdb:propNumber="4032" oraxdb:global="false" oraxdb:SQLName="shippingMethod" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                          <xs:element minOccurs="0" name="id" type="xs:string" oraxdb:propNumber="4033" oraxdb:global="false" oraxdb:SQLName="id" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                          <xs:element minOccurs="0" name="billTo" oraxdb:propNumber="4071" oraxdb:global="false" oraxdb:SQLName="billTo" oraxdb:SQLType="billTo645_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                            <xs:complexType oraxdb:SQLType="billTo645_T" oraxdb:SQLSchema="REPERMS">
                              <xs:sequence>
                                <xs:element minOccurs="0" name="btCustomer" type="xs:string" oraxdb:propNumber="4035" oraxdb:global="false" oraxdb:SQLName="btCustomer" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="entityType" type="xs:string" oraxdb:propNumber="4036" oraxdb:global="false" oraxdb:SQLName="entityType" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="street" oraxdb:propNumber="4038" oraxdb:global="false" oraxdb:SQLName="street" oraxdb:SQLType="street646_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                  <xs:complexType oraxdb:SQLType="street646_T" oraxdb:SQLSchema="REPERMS">
                                    <xs:simpleContent>
                                      <xs:extension base="xs:string">
                                        <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4037" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                      </xs:extension>
                                    </xs:simpleContent>
                                  </xs:complexType>
                                </xs:element>
                                <xs:element minOccurs="0" name="postcode" oraxdb:propNumber="4040" oraxdb:global="false" oraxdb:SQLName="postcode" oraxdb:SQLType="postcode647_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                  <xs:complexType oraxdb:SQLType="postcode647_T" oraxdb:SQLSchema="REPERMS">
                                    <xs:simpleContent>
                                      <xs:extension base="xs:string">
                                        <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4039" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                      </xs:extension>
                                    </xs:simpleContent>
                                  </xs:complexType>
                                </xs:element>
                                <xs:element minOccurs="0" name="mtime" type="xs:dateTime" oraxdb:propNumber="4041" oraxdb:global="false" oraxdb:SQLName="mtime" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="owner" type="xs:string" oraxdb:propNumber="4042" oraxdb:global="false" oraxdb:SQLName="owner" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="id" oraxdb:propNumber="4044" oraxdb:global="false" oraxdb:SQLName="id" oraxdb:SQLType="id648_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                  <xs:complexType oraxdb:SQLType="id648_T" oraxdb:SQLSchema="REPERMS">
                                    <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4043" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                  </xs:complexType>
                                </xs:element>
                                <xs:element minOccurs="0" name="city" oraxdb:propNumber="4046" oraxdb:global="false" oraxdb:SQLName="city" oraxdb:SQLType="city649_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                  <xs:complexType oraxdb:SQLType="city649_T" oraxdb:SQLSchema="REPERMS">
                                    <xs:simpleContent>
                                      <xs:extension base="xs:string">
                                        <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4045" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                      </xs:extension>
                                    </xs:simpleContent>
                                  </xs:complexType>
                                </xs:element>
                                <xs:element minOccurs="0" name="uuid" type="xs:string" oraxdb:propNumber="4047" oraxdb:global="false" oraxdb:SQLName="uuid" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="ctimeOnServer" type="xs:dateTime" oraxdb:propNumber="4048" oraxdb:global="false" oraxdb:SQLName="ctimeOnServer" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="mtimeOnServer" type="xs:dateTime" oraxdb:propNumber="4049" oraxdb:global="false" oraxdb:SQLName="mtimeOnServer" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="state" oraxdb:propNumber="4051" oraxdb:global="false" oraxdb:SQLName="state" oraxdb:SQLType="state650_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                  <xs:complexType oraxdb:SQLType="state650_T" oraxdb:SQLSchema="REPERMS">
                                    <xs:simpleContent>
                                      <xs:extension base="xs:string">
                                        <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4050" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                      </xs:extension>
                                    </xs:simpleContent>
                                  </xs:complexType>
                                </xs:element>
                                <xs:element minOccurs="0" name="fax" oraxdb:propNumber="4053" oraxdb:global="false" oraxdb:SQLName="fax" oraxdb:SQLType="fax651_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                  <xs:complexType oraxdb:SQLType="fax651_T" oraxdb:SQLSchema="REPERMS">
                                    <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4052" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                  </xs:complexType>
                                </xs:element>
                                <xs:element minOccurs="0" name="isDefaultShipTo" oraxdb:propNumber="4055" oraxdb:global="false" oraxdb:SQLName="isDefaultShipTo" oraxdb:SQLType="isDefaultShipTo652_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                  <xs:complexType oraxdb:SQLType="isDefaultShipTo652_T" oraxdb:SQLSchema="REPERMS">
                                    <xs:simpleContent>
                                      <xs:extension base="xs:string">
                                        <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4054" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                      </xs:extension>
                                    </xs:simpleContent>
                                  </xs:complexType>
                                </xs:element>
                                <xs:element minOccurs="0" name="street2" oraxdb:propNumber="4057" oraxdb:global="false" oraxdb:SQLName="street2" oraxdb:SQLType="street2653_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                  <xs:complexType oraxdb:SQLType="street2653_T" oraxdb:SQLSchema="REPERMS">
                                    <xs:simpleContent>
                                      <xs:extension base="xs:string">
                                        <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4056" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                      </xs:extension>
                                    </xs:simpleContent>
                                  </xs:complexType>
                                </xs:element>
                                <xs:element minOccurs="0" name="stCustomer" oraxdb:propNumber="4059" oraxdb:global="false" oraxdb:SQLName="stCustomer" oraxdb:SQLType="stCustomer654_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                  <xs:complexType oraxdb:SQLType="stCustomer654_T" oraxdb:SQLSchema="REPERMS">
                                    <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4058" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                  </xs:complexType>
                                </xs:element>
                                <xs:element minOccurs="0" name="phone" oraxdb:propNumber="4061" oraxdb:global="false" oraxdb:SQLName="phone" oraxdb:SQLType="phone655_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                  <xs:complexType oraxdb:SQLType="phone655_T" oraxdb:SQLSchema="REPERMS">
                                    <xs:simpleContent>
                                      <xs:extension base="xs:string">
                                        <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4060" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                      </xs:extension>
                                    </xs:simpleContent>
                                  </xs:complexType>
                                </xs:element>
                                <xs:element minOccurs="0" name="cdate" type="xs:date" oraxdb:propNumber="4062" oraxdb:global="false" oraxdb:SQLName="cdate" oraxdb:SQLType="DATE" oraxdb:memType="12" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="ctime" type="xs:dateTime" oraxdb:propNumber="4063" oraxdb:global="false" oraxdb:SQLName="ctime" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="name" oraxdb:propNumber="4065" oraxdb:global="false" oraxdb:SQLName="name" oraxdb:SQLType="name656_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                  <xs:complexType oraxdb:SQLType="name656_T" oraxdb:SQLSchema="REPERMS">
                                    <xs:simpleContent>
                                      <xs:extension base="xs:string">
                                        <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4064" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                      </xs:extension>
                                    </xs:simpleContent>
                                  </xs:complexType>
                                </xs:element>
                                <xs:element minOccurs="0" name="country" oraxdb:propNumber="4067" oraxdb:global="false" oraxdb:SQLName="country" oraxdb:SQLType="country657_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                  <xs:complexType oraxdb:SQLType="country657_T" oraxdb:SQLSchema="REPERMS">
                                    <xs:simpleContent>
                                      <xs:extension base="xs:string">
                                        <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4066" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                      </xs:extension>
                                    </xs:simpleContent>
                                  </xs:complexType>
                                </xs:element>
                                <xs:element minOccurs="0" name="objID" oraxdb:propNumber="4069" oraxdb:global="false" oraxdb:SQLName="objID" oraxdb:SQLType="objID658_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                  <xs:complexType oraxdb:SQLType="objID658_T" oraxdb:SQLSchema="REPERMS">
                                    <xs:simpleContent>
                                      <xs:extension base="xs:unsignedInt">
                                        <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4068" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                      </xs:extension>
                                    </xs:simpleContent>
                                  </xs:complexType>
                                </xs:element>
                                <xs:element minOccurs="0" name="resource_uri" type="xs:string" oraxdb:propNumber="4070" oraxdb:global="false" oraxdb:SQLName="resource_uri" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                              </xs:sequence>
                              <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4034" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                            </xs:complexType>
                          </xs:element>
                          <xs:element minOccurs="0" name="paymentTerms" type="xs:string" oraxdb:propNumber="4072" oraxdb:global="false" oraxdb:SQLName="paymentTerms" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                          <xs:element minOccurs="0" name="customerGroup" oraxdb:propNumber="4090" oraxdb:global="false" oraxdb:SQLName="customerGroup" oraxdb:SQLType="customerGroup659_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                            <xs:complexType oraxdb:SQLType="customerGroup659_T" oraxdb:SQLSchema="REPERMS">
                              <xs:sequence>
                                <xs:element minOccurs="0" name="uuid" type="xs:string" oraxdb:propNumber="4074" oraxdb:global="false" oraxdb:SQLName="uuid" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="ctimeOnServer" type="xs:dateTime" oraxdb:propNumber="4075" oraxdb:global="false" oraxdb:SQLName="ctimeOnServer" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="currencyCode" type="xs:string" oraxdb:propNumber="4076" oraxdb:global="false" oraxdb:SQLName="currencyCode" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="entityType" type="xs:string" oraxdb:propNumber="4077" oraxdb:global="false" oraxdb:SQLName="entityType" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="name" type="xs:string" oraxdb:propNumber="4078" oraxdb:global="false" oraxdb:SQLName="name" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="mtimeOnServer" type="xs:dateTime" oraxdb:propNumber="4079" oraxdb:global="false" oraxdb:SQLName="mtimeOnServer" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="cdate" type="xs:date" oraxdb:propNumber="4080" oraxdb:global="false" oraxdb:SQLName="cdate" oraxdb:SQLType="DATE" oraxdb:memType="12" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="objID" oraxdb:propNumber="4082" oraxdb:global="false" oraxdb:SQLName="objID" oraxdb:SQLType="objID660_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                  <xs:complexType oraxdb:SQLType="objID660_T" oraxdb:SQLSchema="REPERMS">
                                    <xs:simpleContent>
                                      <xs:extension base="xs:unsignedShort">
                                        <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4081" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                      </xs:extension>
                                    </xs:simpleContent>
                                  </xs:complexType>
                                </xs:element>
                                <xs:element minOccurs="0" name="mtime" type="xs:dateTime" oraxdb:propNumber="4083" oraxdb:global="false" oraxdb:SQLName="mtime" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="owner" type="xs:string" oraxdb:propNumber="4084" oraxdb:global="false" oraxdb:SQLName="owner" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="resource_uri" type="xs:string" oraxdb:propNumber="4085" oraxdb:global="false" oraxdb:SQLName="resource_uri" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="id" type="xs:unsignedByte" oraxdb:propNumber="4086" oraxdb:global="false" oraxdb:SQLName="id" oraxdb:SQLType="NUMBER" oraxdb:memType="68" oraxdb:memByteLength="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="isDefault" oraxdb:propNumber="4088" oraxdb:global="false" oraxdb:SQLName="isDefault" oraxdb:SQLType="isDefault661_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                  <xs:complexType oraxdb:SQLType="isDefault661_T" oraxdb:SQLSchema="REPERMS">
                                    <xs:simpleContent>
                                      <xs:extension base="xs:string">
                                        <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4087" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                      </xs:extension>
                                    </xs:simpleContent>
                                  </xs:complexType>
                                </xs:element>
                                <xs:element minOccurs="0" name="ctime" type="xs:dateTime" oraxdb:propNumber="4089" oraxdb:global="false" oraxdb:SQLName="ctime" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                              </xs:sequence>
                              <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4073" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                            </xs:complexType>
                          </xs:element>
                          <xs:element minOccurs="0" name="uuid" type="xs:string" oraxdb:propNumber="4091" oraxdb:global="false" oraxdb:SQLName="uuid" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                          <xs:element minOccurs="0" name="ctimeOnServer" type="xs:dateTime" oraxdb:propNumber="4092" oraxdb:global="false" oraxdb:SQLName="ctimeOnServer" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                          <xs:element minOccurs="0" name="taxID" type="xs:string" oraxdb:propNumber="4093" oraxdb:global="false" oraxdb:SQLName="taxID" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                          <xs:element minOccurs="0" name="mtimeOnServer" type="xs:dateTime" oraxdb:propNumber="4094" oraxdb:global="false" oraxdb:SQLName="mtimeOnServer" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                          <xs:element minOccurs="0" name="userGroup" oraxdb:propNumber="4114" oraxdb:global="false" oraxdb:SQLName="userGroup" oraxdb:SQLType="userGroup662_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                            <xs:complexType oraxdb:SQLType="userGroup662_T" oraxdb:SQLSchema="REPERMS">
                              <xs:sequence>
                                <xs:element minOccurs="0" name="isMaster" oraxdb:propNumber="4097" oraxdb:global="false" oraxdb:SQLName="isMaster" oraxdb:SQLType="isMaster663_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                  <xs:complexType oraxdb:SQLType="isMaster663_T" oraxdb:SQLSchema="REPERMS">
                                    <xs:simpleContent>
                                      <xs:extension base="xs:string">
                                        <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4096" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                      </xs:extension>
                                    </xs:simpleContent>
                                  </xs:complexType>
                                </xs:element>
                                <xs:element minOccurs="0" name="subcategories" oraxdb:propNumber="4099" oraxdb:global="false" oraxdb:SQLName="subcategories" oraxdb:SQLType="subcategories664_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                  <xs:complexType oraxdb:SQLType="subcategories664_T" oraxdb:SQLSchema="REPERMS">
                                    <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4098" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                  </xs:complexType>
                                </xs:element>
                                <xs:element minOccurs="0" name="ctime" type="xs:dateTime" oraxdb:propNumber="4100" oraxdb:global="false" oraxdb:SQLName="ctime" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="parent" type="xs:string" oraxdb:propNumber="4101" oraxdb:global="false" oraxdb:SQLName="parent" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="ctimeOnServer" type="xs:dateTime" oraxdb:propNumber="4102" oraxdb:global="false" oraxdb:SQLName="ctimeOnServer" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="entityType" type="xs:string" oraxdb:propNumber="4103" oraxdb:global="false" oraxdb:SQLName="entityType" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="name" type="xs:string" oraxdb:propNumber="4104" oraxdb:global="false" oraxdb:SQLName="name" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="mtimeOnServer" type="xs:dateTime" oraxdb:propNumber="4105" oraxdb:global="false" oraxdb:SQLName="mtimeOnServer" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="cdate" type="xs:date" oraxdb:propNumber="4106" oraxdb:global="false" oraxdb:SQLName="cdate" oraxdb:SQLType="DATE" oraxdb:memType="12" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="objID" oraxdb:propNumber="4108" oraxdb:global="false" oraxdb:SQLName="objID" oraxdb:SQLType="objID665_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                  <xs:complexType oraxdb:SQLType="objID665_T" oraxdb:SQLSchema="REPERMS">
                                    <xs:simpleContent>
                                      <xs:extension base="xs:unsignedShort">
                                        <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4107" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                      </xs:extension>
                                    </xs:simpleContent>
                                  </xs:complexType>
                                </xs:element>
                                <xs:element minOccurs="0" name="mtime" type="xs:dateTime" oraxdb:propNumber="4109" oraxdb:global="false" oraxdb:SQLName="mtime" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="owner" type="xs:string" oraxdb:propNumber="4110" oraxdb:global="false" oraxdb:SQLName="owner" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="resource_uri" type="xs:string" oraxdb:propNumber="4111" oraxdb:global="false" oraxdb:SQLName="resource_uri" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="id" type="xs:string" oraxdb:propNumber="4112" oraxdb:global="false" oraxdb:SQLName="id" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="uuid" type="xs:string" oraxdb:propNumber="4113" oraxdb:global="false" oraxdb:SQLName="uuid" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                              </xs:sequence>
                              <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4095" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                            </xs:complexType>
                          </xs:element>
                          <xs:element minOccurs="0" name="defaultShipTo" type="xs:string" oraxdb:propNumber="4115" oraxdb:global="false" oraxdb:SQLName="defaultShipTo" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                          <xs:element minOccurs="0" name="email" oraxdb:propNumber="4117" oraxdb:global="false" oraxdb:SQLName="email" oraxdb:SQLType="email666_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                            <xs:complexType oraxdb:SQLType="email666_T" oraxdb:SQLSchema="REPERMS">
                              <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4116" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                            </xs:complexType>
                          </xs:element>
                          <xs:element minOccurs="0" name="defaultWarehouse" oraxdb:propNumber="4119" oraxdb:global="false" oraxdb:SQLName="defaultWarehouse" oraxdb:SQLType="defaultWarehouse667_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                            <xs:complexType oraxdb:SQLType="defaultWarehouse667_T" oraxdb:SQLSchema="REPERMS">
                              <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4118" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                            </xs:complexType>
                          </xs:element>
                          <xs:element minOccurs="0" name="cdate" type="xs:date" oraxdb:propNumber="4120" oraxdb:global="false" oraxdb:SQLName="cdate" oraxdb:SQLType="DATE" oraxdb:memType="12" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                          <xs:element minOccurs="0" name="name" type="xs:string" oraxdb:propNumber="4121" oraxdb:global="false" oraxdb:SQLName="name" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                          <xs:element minOccurs="0" name="ctime" type="xs:dateTime" oraxdb:propNumber="4122" oraxdb:global="false" oraxdb:SQLName="ctime" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                          <xs:element minOccurs="0" name="contact" oraxdb:propNumber="4124" oraxdb:global="false" oraxdb:SQLName="contact" oraxdb:SQLType="contact668_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                            <xs:complexType oraxdb:SQLType="contact668_T" oraxdb:SQLSchema="REPERMS">
                              <xs:simpleContent>
                                <xs:extension base="xs:string">
                                  <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4123" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                </xs:extension>
                              </xs:simpleContent>
                            </xs:complexType>
                          </xs:element>
                          <xs:element minOccurs="0" name="objID" oraxdb:propNumber="4126" oraxdb:global="false" oraxdb:SQLName="objID" oraxdb:SQLType="objID669_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                            <xs:complexType oraxdb:SQLType="objID669_T" oraxdb:SQLSchema="REPERMS">
                              <xs:simpleContent>
                                <xs:extension base="xs:unsignedInt">
                                  <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4125" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                </xs:extension>
                              </xs:simpleContent>
                            </xs:complexType>
                          </xs:element>
                          <xs:element minOccurs="0" name="creditCards" oraxdb:propNumber="4128" oraxdb:global="false" oraxdb:SQLName="creditCards" oraxdb:SQLType="creditCards670_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                            <xs:complexType oraxdb:SQLType="creditCards670_T" oraxdb:SQLSchema="REPERMS">
                              <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4127" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                            </xs:complexType>
                          </xs:element>
                          <xs:element minOccurs="0" name="shipTos" oraxdb:propNumber="4167" oraxdb:global="false" oraxdb:SQLName="shipTos" oraxdb:SQLType="shipTos671_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                            <xs:complexType oraxdb:SQLType="shipTos671_T" oraxdb:SQLSchema="REPERMS">
                              <xs:sequence>
                                <xs:element minOccurs="0" name="object" oraxdb:propNumber="4166" oraxdb:global="false" oraxdb:SQLName="object" oraxdb:SQLType="object672_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                  <xs:complexType oraxdb:SQLType="object672_T" oraxdb:SQLSchema="REPERMS">
                                    <xs:sequence>
                                      <xs:element minOccurs="0" name="btCustomer" oraxdb:propNumber="4132" oraxdb:global="false" oraxdb:SQLName="btCustomer" oraxdb:SQLType="btCustomer673_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                        <xs:complexType oraxdb:SQLType="btCustomer673_T" oraxdb:SQLSchema="REPERMS">
                                          <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4131" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                        </xs:complexType>
                                      </xs:element>
                                      <xs:element minOccurs="0" name="entityType" type="xs:string" oraxdb:propNumber="4133" oraxdb:global="false" oraxdb:SQLName="entityType" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                      <xs:element minOccurs="0" name="street" type="xs:unsignedByte" oraxdb:propNumber="4134" oraxdb:global="false" oraxdb:SQLName="street" oraxdb:SQLType="NUMBER" oraxdb:memType="68" oraxdb:memByteLength="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                      <xs:element minOccurs="0" name="postcode" oraxdb:propNumber="4136" oraxdb:global="false" oraxdb:SQLName="postcode" oraxdb:SQLType="postcode674_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                        <xs:complexType oraxdb:SQLType="postcode674_T" oraxdb:SQLSchema="REPERMS">
                                          <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4135" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                        </xs:complexType>
                                      </xs:element>
                                      <xs:element minOccurs="0" name="mtime" type="xs:dateTime" oraxdb:propNumber="4137" oraxdb:global="false" oraxdb:SQLName="mtime" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                      <xs:element minOccurs="0" name="owner" type="xs:string" oraxdb:propNumber="4138" oraxdb:global="false" oraxdb:SQLName="owner" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                      <xs:element minOccurs="0" name="id" oraxdb:propNumber="4140" oraxdb:global="false" oraxdb:SQLName="id" oraxdb:SQLType="id675_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                        <xs:complexType oraxdb:SQLType="id675_T" oraxdb:SQLSchema="REPERMS">
                                          <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4139" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                        </xs:complexType>
                                      </xs:element>
                                      <xs:element minOccurs="0" name="city" oraxdb:propNumber="4142" oraxdb:global="false" oraxdb:SQLName="city" oraxdb:SQLType="city676_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                        <xs:complexType oraxdb:SQLType="city676_T" oraxdb:SQLSchema="REPERMS">
                                          <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4141" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                        </xs:complexType>
                                      </xs:element>
                                      <xs:element minOccurs="0" name="uuid" type="xs:string" oraxdb:propNumber="4143" oraxdb:global="false" oraxdb:SQLName="uuid" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                      <xs:element minOccurs="0" name="ctimeOnServer" type="xs:dateTime" oraxdb:propNumber="4144" oraxdb:global="false" oraxdb:SQLName="ctimeOnServer" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                      <xs:element minOccurs="0" name="mtimeOnServer" type="xs:dateTime" oraxdb:propNumber="4145" oraxdb:global="false" oraxdb:SQLName="mtimeOnServer" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                      <xs:element minOccurs="0" name="state" oraxdb:propNumber="4147" oraxdb:global="false" oraxdb:SQLName="state" oraxdb:SQLType="state677_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                        <xs:complexType oraxdb:SQLType="state677_T" oraxdb:SQLSchema="REPERMS">
                                          <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4146" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                        </xs:complexType>
                                      </xs:element>
                                      <xs:element minOccurs="0" name="fax" oraxdb:propNumber="4149" oraxdb:global="false" oraxdb:SQLName="fax" oraxdb:SQLType="fax678_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                        <xs:complexType oraxdb:SQLType="fax678_T" oraxdb:SQLSchema="REPERMS">
                                          <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4148" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                        </xs:complexType>
                                      </xs:element>
                                      <xs:element minOccurs="0" name="isDefaultShipTo" oraxdb:propNumber="4151" oraxdb:global="false" oraxdb:SQLName="isDefaultShipTo" oraxdb:SQLType="isDefaultShipTo679_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                        <xs:complexType oraxdb:SQLType="isDefaultShipTo679_T" oraxdb:SQLSchema="REPERMS">
                                          <xs:simpleContent>
                                            <xs:extension base="xs:string">
                                              <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4150" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                            </xs:extension>
                                          </xs:simpleContent>
                                        </xs:complexType>
                                      </xs:element>
                                      <xs:element minOccurs="0" name="street2" oraxdb:propNumber="4153" oraxdb:global="false" oraxdb:SQLName="street2" oraxdb:SQLType="street2680_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                        <xs:complexType oraxdb:SQLType="street2680_T" oraxdb:SQLSchema="REPERMS">
                                          <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4152" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                        </xs:complexType>
                                      </xs:element>
                                      <xs:element minOccurs="0" name="stCustomer" type="xs:string" oraxdb:propNumber="4154" oraxdb:global="false" oraxdb:SQLName="stCustomer" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                      <xs:element minOccurs="0" name="phone" oraxdb:propNumber="4156" oraxdb:global="false" oraxdb:SQLName="phone" oraxdb:SQLType="phone681_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                        <xs:complexType oraxdb:SQLType="phone681_T" oraxdb:SQLSchema="REPERMS">
                                          <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4155" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                        </xs:complexType>
                                      </xs:element>
                                      <xs:element minOccurs="0" name="cdate" type="xs:date" oraxdb:propNumber="4157" oraxdb:global="false" oraxdb:SQLName="cdate" oraxdb:SQLType="DATE" oraxdb:memType="12" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                      <xs:element minOccurs="0" name="ctime" type="xs:dateTime" oraxdb:propNumber="4158" oraxdb:global="false" oraxdb:SQLName="ctime" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                      <xs:element minOccurs="0" name="name" oraxdb:propNumber="4160" oraxdb:global="false" oraxdb:SQLName="name" oraxdb:SQLType="name682_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                        <xs:complexType oraxdb:SQLType="name682_T" oraxdb:SQLSchema="REPERMS">
                                          <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4159" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                        </xs:complexType>
                                      </xs:element>
                                      <xs:element minOccurs="0" name="country" oraxdb:propNumber="4162" oraxdb:global="false" oraxdb:SQLName="country" oraxdb:SQLType="country683_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                        <xs:complexType oraxdb:SQLType="country683_T" oraxdb:SQLSchema="REPERMS">
                                          <xs:simpleContent>
                                            <xs:extension base="xs:string">
                                              <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4161" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                            </xs:extension>
                                          </xs:simpleContent>
                                        </xs:complexType>
                                      </xs:element>
                                      <xs:element minOccurs="0" name="objID" oraxdb:propNumber="4164" oraxdb:global="false" oraxdb:SQLName="objID" oraxdb:SQLType="objID684_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                        <xs:complexType oraxdb:SQLType="objID684_T" oraxdb:SQLSchema="REPERMS">
                                          <xs:simpleContent>
                                            <xs:extension base="xs:unsignedInt">
                                              <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4163" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                            </xs:extension>
                                          </xs:simpleContent>
                                        </xs:complexType>
                                      </xs:element>
                                      <xs:element minOccurs="0" name="resource_uri" type="xs:string" oraxdb:propNumber="4165" oraxdb:global="false" oraxdb:SQLName="resource_uri" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                    </xs:sequence>
                                    <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4130" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                  </xs:complexType>
                                </xs:element>
                              </xs:sequence>
                              <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4129" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                            </xs:complexType>
                          </xs:element>
                          <xs:element minOccurs="0" name="resource_uri" type="xs:string" oraxdb:propNumber="4168" oraxdb:global="false" oraxdb:SQLName="resource_uri" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                        </xs:sequence>
                        <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4023" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                      </xs:complexType>
                    </xs:element>
                    <xs:element minOccurs="0" name="versionInfo" oraxdb:propNumber="4171" oraxdb:global="false" oraxdb:SQLName="versionInfo" oraxdb:SQLType="versionInfo685_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                      <xs:complexType oraxdb:SQLType="versionInfo685_T" oraxdb:SQLSchema="REPERMS">
                        <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4170" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                      </xs:complexType>
                    </xs:element>
                    <xs:element minOccurs="0" name="shipTo" oraxdb:propNumber="4209" oraxdb:global="false" oraxdb:SQLName="shipTo" oraxdb:SQLType="shipTo686_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                      <xs:complexType oraxdb:SQLType="shipTo686_T" oraxdb:SQLSchema="REPERMS">
                        <xs:sequence>
                          <xs:element minOccurs="0" name="btCustomer" oraxdb:propNumber="4174" oraxdb:global="false" oraxdb:SQLName="btCustomer" oraxdb:SQLType="btCustomer687_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                            <xs:complexType oraxdb:SQLType="btCustomer687_T" oraxdb:SQLSchema="REPERMS">
                              <xs:simpleContent>
                                <xs:extension base="xs:string">
                                  <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4173" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                </xs:extension>
                              </xs:simpleContent>
                            </xs:complexType>
                          </xs:element>
                          <xs:element minOccurs="0" name="entityType" type="xs:string" oraxdb:propNumber="4175" oraxdb:global="false" oraxdb:SQLName="entityType" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                          <xs:element minOccurs="0" name="street" type="xs:string" oraxdb:propNumber="4176" oraxdb:global="false" oraxdb:SQLName="street" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                          <xs:element minOccurs="0" name="postcode" oraxdb:propNumber="4178" oraxdb:global="false" oraxdb:SQLName="postcode" oraxdb:SQLType="postcode688_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                            <xs:complexType oraxdb:SQLType="postcode688_T" oraxdb:SQLSchema="REPERMS">
                              <xs:simpleContent>
                                <xs:extension base="xs:string">
                                  <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4177" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                </xs:extension>
                              </xs:simpleContent>
                            </xs:complexType>
                          </xs:element>
                          <xs:element minOccurs="0" name="mtime" type="xs:dateTime" oraxdb:propNumber="4179" oraxdb:global="false" oraxdb:SQLName="mtime" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                          <xs:element minOccurs="0" name="owner" type="xs:string" oraxdb:propNumber="4180" oraxdb:global="false" oraxdb:SQLName="owner" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                          <xs:element minOccurs="0" name="id" oraxdb:propNumber="4182" oraxdb:global="false" oraxdb:SQLName="id" oraxdb:SQLType="id689_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                            <xs:complexType oraxdb:SQLType="id689_T" oraxdb:SQLSchema="REPERMS">
                              <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4181" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                            </xs:complexType>
                          </xs:element>
                          <xs:element minOccurs="0" name="city" oraxdb:propNumber="4184" oraxdb:global="false" oraxdb:SQLName="city" oraxdb:SQLType="city690_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                            <xs:complexType oraxdb:SQLType="city690_T" oraxdb:SQLSchema="REPERMS">
                              <xs:simpleContent>
                                <xs:extension base="xs:string">
                                  <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4183" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                </xs:extension>
                              </xs:simpleContent>
                            </xs:complexType>
                          </xs:element>
                          <xs:element minOccurs="0" name="uuid" type="xs:string" oraxdb:propNumber="4185" oraxdb:global="false" oraxdb:SQLName="uuid" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                          <xs:element minOccurs="0" name="ctimeOnServer" type="xs:dateTime" oraxdb:propNumber="4186" oraxdb:global="false" oraxdb:SQLName="ctimeOnServer" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                          <xs:element minOccurs="0" name="mtimeOnServer" type="xs:dateTime" oraxdb:propNumber="4187" oraxdb:global="false" oraxdb:SQLName="mtimeOnServer" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                          <xs:element minOccurs="0" name="state" oraxdb:propNumber="4189" oraxdb:global="false" oraxdb:SQLName="state" oraxdb:SQLType="state691_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                            <xs:complexType oraxdb:SQLType="state691_T" oraxdb:SQLSchema="REPERMS">
                              <xs:simpleContent>
                                <xs:extension base="xs:string">
                                  <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4188" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                </xs:extension>
                              </xs:simpleContent>
                            </xs:complexType>
                          </xs:element>
                          <xs:element minOccurs="0" name="fax" oraxdb:propNumber="4191" oraxdb:global="false" oraxdb:SQLName="fax" oraxdb:SQLType="fax692_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                            <xs:complexType oraxdb:SQLType="fax692_T" oraxdb:SQLSchema="REPERMS">
                              <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4190" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                            </xs:complexType>
                          </xs:element>
                          <xs:element minOccurs="0" name="isDefaultShipTo" oraxdb:propNumber="4193" oraxdb:global="false" oraxdb:SQLName="isDefaultShipTo" oraxdb:SQLType="isDefaultShipTo693_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                            <xs:complexType oraxdb:SQLType="isDefaultShipTo693_T" oraxdb:SQLSchema="REPERMS">
                              <xs:simpleContent>
                                <xs:extension base="xs:string">
                                  <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4192" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                </xs:extension>
                              </xs:simpleContent>
                            </xs:complexType>
                          </xs:element>
                          <xs:element minOccurs="0" name="street2" oraxdb:propNumber="4195" oraxdb:global="false" oraxdb:SQLName="street2" oraxdb:SQLType="street2694_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                            <xs:complexType oraxdb:SQLType="street2694_T" oraxdb:SQLSchema="REPERMS">
                              <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4194" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                            </xs:complexType>
                          </xs:element>
                          <xs:element minOccurs="0" name="stCustomer" oraxdb:propNumber="4197" oraxdb:global="false" oraxdb:SQLName="stCustomer" oraxdb:SQLType="stCustomer695_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                            <xs:complexType oraxdb:SQLType="stCustomer695_T" oraxdb:SQLSchema="REPERMS">
                              <xs:simpleContent>
                                <xs:extension base="xs:string">
                                  <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4196" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                </xs:extension>
                              </xs:simpleContent>
                            </xs:complexType>
                          </xs:element>
                          <xs:element minOccurs="0" name="phone" oraxdb:propNumber="4199" oraxdb:global="false" oraxdb:SQLName="phone" oraxdb:SQLType="phone696_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                            <xs:complexType oraxdb:SQLType="phone696_T" oraxdb:SQLSchema="REPERMS">
                              <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4198" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                            </xs:complexType>
                          </xs:element>
                          <xs:element minOccurs="0" name="cdate" type="xs:date" oraxdb:propNumber="4200" oraxdb:global="false" oraxdb:SQLName="cdate" oraxdb:SQLType="DATE" oraxdb:memType="12" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                          <xs:element minOccurs="0" name="ctime" type="xs:dateTime" oraxdb:propNumber="4201" oraxdb:global="false" oraxdb:SQLName="ctime" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                          <xs:element minOccurs="0" name="name" oraxdb:propNumber="4203" oraxdb:global="false" oraxdb:SQLName="name" oraxdb:SQLType="name697_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                            <xs:complexType oraxdb:SQLType="name697_T" oraxdb:SQLSchema="REPERMS">
                              <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4202" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                            </xs:complexType>
                          </xs:element>
                          <xs:element minOccurs="0" name="country" oraxdb:propNumber="4205" oraxdb:global="false" oraxdb:SQLName="country" oraxdb:SQLType="country698_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                            <xs:complexType oraxdb:SQLType="country698_T" oraxdb:SQLSchema="REPERMS">
                              <xs:simpleContent>
                                <xs:extension base="xs:string">
                                  <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4204" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                </xs:extension>
                              </xs:simpleContent>
                            </xs:complexType>
                          </xs:element>
                          <xs:element minOccurs="0" name="objID" oraxdb:propNumber="4207" oraxdb:global="false" oraxdb:SQLName="objID" oraxdb:SQLType="objID699_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                            <xs:complexType oraxdb:SQLType="objID699_T" oraxdb:SQLSchema="REPERMS">
                              <xs:simpleContent>
                                <xs:extension base="xs:unsignedInt">
                                  <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4206" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                </xs:extension>
                              </xs:simpleContent>
                            </xs:complexType>
                          </xs:element>
                          <xs:element minOccurs="0" name="resource_uri" type="xs:string" oraxdb:propNumber="4208" oraxdb:global="false" oraxdb:SQLName="resource_uri" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                        </xs:sequence>
                        <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4172" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                      </xs:complexType>
                    </xs:element>
                    <xs:element minOccurs="0" name="defaultWarehouse" oraxdb:propNumber="4211" oraxdb:global="false" oraxdb:SQLName="defaultWarehouse" oraxdb:SQLType="defaultWarehouse700_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                      <xs:complexType oraxdb:SQLType="defaultWarehouse700_T" oraxdb:SQLSchema="REPERMS">
                        <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4210" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                      </xs:complexType>
                    </xs:element>
                    <xs:element minOccurs="0" name="customerPO" oraxdb:propNumber="4213" oraxdb:global="false" oraxdb:SQLName="customerPO" oraxdb:SQLType="customerPO701_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                      <xs:complexType oraxdb:SQLType="customerPO701_T" oraxdb:SQLSchema="REPERMS">
                        <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4212" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                      </xs:complexType>
                    </xs:element>
                    <xs:element minOccurs="0" name="lastEdited" type="xs:dateTime" oraxdb:propNumber="4214" oraxdb:global="false" oraxdb:SQLName="lastEdited" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                    <xs:element minOccurs="0" name="creditCard" oraxdb:propNumber="4216" oraxdb:global="false" oraxdb:SQLName="creditCard" oraxdb:SQLType="creditCard702_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                      <xs:complexType oraxdb:SQLType="creditCard702_T" oraxdb:SQLSchema="REPERMS">
                        <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4215" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                      </xs:complexType>
                    </xs:element>
                    <xs:element minOccurs="0" name="lastExported" oraxdb:propNumber="4218" oraxdb:global="false" oraxdb:SQLName="lastExported" oraxdb:SQLType="lastExported703_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                      <xs:complexType oraxdb:SQLType="lastExported703_T" oraxdb:SQLSchema="REPERMS">
                        <xs:simpleContent>
                          <xs:extension base="xs:string">
                            <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4217" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                          </xs:extension>
                        </xs:simpleContent>
                      </xs:complexType>
                    </xs:element>
                    <xs:element minOccurs="0" name="cdate" type="xs:date" oraxdb:propNumber="4219" oraxdb:global="false" oraxdb:SQLName="cdate" oraxdb:SQLType="DATE" oraxdb:memType="12" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                    <xs:element minOccurs="0" name="versionType" oraxdb:propNumber="4221" oraxdb:global="false" oraxdb:SQLName="versionType" oraxdb:SQLType="versionType704_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                      <xs:complexType oraxdb:SQLType="versionType704_T" oraxdb:SQLSchema="REPERMS">
                        <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4220" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                      </xs:complexType>
                    </xs:element>
                    <xs:element minOccurs="0" name="realVersion" oraxdb:propNumber="4223" oraxdb:global="false" oraxdb:SQLName="realVersion" oraxdb:SQLType="realVersion705_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                      <xs:complexType oraxdb:SQLType="realVersion705_T" oraxdb:SQLSchema="REPERMS">
                        <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4222" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                      </xs:complexType>
                    </xs:element>
                    <xs:element minOccurs="0" name="signatureURL" oraxdb:propNumber="4225" oraxdb:global="false" oraxdb:SQLName="signatureURL" oraxdb:SQLType="signatureURL706_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                      <xs:complexType oraxdb:SQLType="signatureURL706_T" oraxdb:SQLSchema="REPERMS">
                        <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4224" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                      </xs:complexType>
                    </xs:element>
                    <xs:element minOccurs="0" name="shippedStatus" type="xs:string" oraxdb:propNumber="4226" oraxdb:global="false" oraxdb:SQLName="shippedStatus" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                    <xs:element minOccurs="0" name="totalOffDiscount" oraxdb:propNumber="4228" oraxdb:global="false" oraxdb:SQLName="totalOffDiscount" oraxdb:SQLType="totalOffDiscount707_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                      <xs:complexType oraxdb:SQLType="totalOffDiscount707_T" oraxdb:SQLSchema="REPERMS">
                        <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4227" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                      </xs:complexType>
                    </xs:element>
                    <xs:element minOccurs="0" name="ctime" type="xs:dateTime" oraxdb:propNumber="4229" oraxdb:global="false" oraxdb:SQLName="ctime" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                    <xs:element minOccurs="0" name="photoURLs" oraxdb:propNumber="4231" oraxdb:global="false" oraxdb:SQLName="photoURLs" oraxdb:SQLType="photoURLs708_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                      <xs:complexType oraxdb:SQLType="photoURLs708_T" oraxdb:SQLSchema="REPERMS">
                        <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4230" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                      </xs:complexType>
                    </xs:element>
                    <xs:element minOccurs="0" name="lines" oraxdb:propNumber="4269" oraxdb:global="false" oraxdb:SQLName="lines" oraxdb:SQLType="lines709_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                      <xs:complexType oraxdb:SQLType="lines709_T" oraxdb:SQLSchema="REPERMS">
                        <xs:sequence minOccurs="0">
                          <xs:element minOccurs="0" maxOccurs="unbounded" name="object" oraxdb:propNumber="4268" oraxdb:global="false" oraxdb:SQLName="object" oraxdb:SQLType="object710_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false" oraxdb:SQLCollType="object720_COLL" oraxdb:SQLCollSchema="REPERMS">
                            <xs:complexType oraxdb:SQLType="object710_T" oraxdb:SQLSchema="REPERMS">
                              <xs:sequence>
                                <xs:element minOccurs="0" name="barcode" oraxdb:propNumber="4235" oraxdb:global="false" oraxdb:SQLName="barcode" oraxdb:SQLType="barcode711_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                  <xs:complexType oraxdb:SQLType="barcode711_T" oraxdb:SQLSchema="REPERMS">
                                    <xs:simpleContent>
                                      <xs:extension base="xs:string">
                                        <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4234" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                      </xs:extension>
                                    </xs:simpleContent>
                                  </xs:complexType>
                                </xs:element>
                                <xs:element minOccurs="0" name="description" type="xs:string" oraxdb:propNumber="4236" oraxdb:global="false" oraxdb:SQLName="description" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="item" oraxdb:propNumber="4238" oraxdb:global="false" oraxdb:SQLName="item" oraxdb:SQLType="item712_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                  <xs:complexType oraxdb:SQLType="item712_T" oraxdb:SQLSchema="REPERMS">
                                    <xs:simpleContent>
                                      <xs:extension base="xs:string">
                                        <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4237" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                      </xs:extension>
                                    </xs:simpleContent>
                                  </xs:complexType>
                                </xs:element>
                                <xs:element minOccurs="0" name="entityType" type="xs:string" oraxdb:propNumber="4239" oraxdb:global="false" oraxdb:SQLName="entityType" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="ctime" type="xs:dateTime" oraxdb:propNumber="4240" oraxdb:global="false" oraxdb:SQLName="ctime" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="qty" oraxdb:propNumber="4242" oraxdb:global="false" oraxdb:SQLName="qty" oraxdb:SQLType="qty713_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                  <xs:complexType oraxdb:SQLType="qty713_T" oraxdb:SQLSchema="REPERMS">
                                    <xs:simpleContent>
                                      <xs:extension base="xs:unsignedByte">
                                        <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4241" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                      </xs:extension>
                                    </xs:simpleContent>
                                  </xs:complexType>
                                </xs:element>
                                <xs:element minOccurs="0" name="dimensions" oraxdb:propNumber="4244" oraxdb:global="false" oraxdb:SQLName="dimensions" oraxdb:SQLType="dimensions714_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                  <xs:complexType oraxdb:SQLType="dimensions714_T" oraxdb:SQLSchema="REPERMS">
                                    <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4243" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                  </xs:complexType>
                                </xs:element>
                                <xs:element minOccurs="0" name="cdate" type="xs:date" oraxdb:propNumber="4245" oraxdb:global="false" oraxdb:SQLName="cdate" oraxdb:SQLType="DATE" oraxdb:memType="12" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="mtime" type="xs:dateTime" oraxdb:propNumber="4246" oraxdb:global="false" oraxdb:SQLName="mtime" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="owner" type="xs:string" oraxdb:propNumber="4247" oraxdb:global="false" oraxdb:SQLName="owner" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="total" type="xs:decimal" oraxdb:propNumber="4248" oraxdb:global="false" oraxdb:SQLName="total" oraxdb:SQLType="NUMBER" oraxdb:memType="2" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="unitPrice" type="xs:decimal" oraxdb:propNumber="4249" oraxdb:global="false" oraxdb:SQLName="unitPrice" oraxdb:SQLType="NUMBER" oraxdb:memType="2" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="manufacturer" oraxdb:propNumber="4251" oraxdb:global="false" oraxdb:SQLName="manufacturer" oraxdb:SQLType="manufacturer715_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                  <xs:complexType oraxdb:SQLType="manufacturer715_T" oraxdb:SQLSchema="REPERMS">
                                    <xs:simpleContent>
                                      <xs:extension base="xs:string">
                                        <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4250" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                      </xs:extension>
                                    </xs:simpleContent>
                                  </xs:complexType>
                                </xs:element>
                                <xs:element minOccurs="0" name="sku" type="xs:unsignedInt" oraxdb:propNumber="4252" oraxdb:global="false" oraxdb:SQLName="sku" oraxdb:SQLType="NUMBER" oraxdb:memType="68" oraxdb:memByteLength="4" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="uuid" type="xs:string" oraxdb:propNumber="4253" oraxdb:global="false" oraxdb:SQLName="uuid" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="mtimeOnServer" type="xs:dateTime" oraxdb:propNumber="4254" oraxdb:global="false" oraxdb:SQLName="mtimeOnServer" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="isku" type="xs:unsignedInt" oraxdb:propNumber="4255" oraxdb:global="false" oraxdb:SQLName="isku" oraxdb:SQLType="NUMBER" oraxdb:memType="68" oraxdb:memByteLength="4" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="qtyFree" oraxdb:propNumber="4257" oraxdb:global="false" oraxdb:SQLName="qtyFree" oraxdb:SQLType="qtyFree716_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                  <xs:complexType oraxdb:SQLType="qtyFree716_T" oraxdb:SQLSchema="REPERMS">
                                    <xs:simpleContent>
                                      <xs:extension base="xs:unsignedByte">
                                        <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4256" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                      </xs:extension>
                                    </xs:simpleContent>
                                  </xs:complexType>
                                </xs:element>
                                <xs:element minOccurs="0" name="notes" oraxdb:propNumber="4258" oraxdb:global="false" oraxdb:SQLName="notes" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false"/>
                                <xs:element minOccurs="0" name="ctimeOnServer" type="xs:dateTime" oraxdb:propNumber="4259" oraxdb:global="false" oraxdb:SQLName="ctimeOnServer" oraxdb:SQLType="TIMESTAMP" oraxdb:memType="180" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="qtyShipped" oraxdb:propNumber="4261" oraxdb:global="false" oraxdb:SQLName="qtyShipped" oraxdb:SQLType="qtyShipped717_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                  <xs:complexType oraxdb:SQLType="qtyShipped717_T" oraxdb:SQLSchema="REPERMS">
                                    <xs:simpleContent>
                                      <xs:extension base="xs:unsignedByte">
                                        <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4260" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                      </xs:extension>
                                    </xs:simpleContent>
                                  </xs:complexType>
                                </xs:element>
                                <xs:element minOccurs="0" name="objID" oraxdb:propNumber="4263" oraxdb:global="false" oraxdb:SQLName="objID" oraxdb:SQLType="objID718_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                  <xs:complexType oraxdb:SQLType="objID718_T" oraxdb:SQLSchema="REPERMS">
                                    <xs:simpleContent>
                                      <xs:extension base="xs:unsignedInt">
                                        <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4262" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                      </xs:extension>
                                    </xs:simpleContent>
                                  </xs:complexType>
                                </xs:element>
                                <xs:element minOccurs="0" name="vsku" oraxdb:propNumber="4265" oraxdb:global="false" oraxdb:SQLName="vsku" oraxdb:SQLType="vsku719_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                                  <xs:complexType oraxdb:SQLType="vsku719_T" oraxdb:SQLSchema="REPERMS">
                                    <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4264" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                                  </xs:complexType>
                                </xs:element>
                                <xs:element minOccurs="0" name="order" type="xs:string" oraxdb:propNumber="4266" oraxdb:global="false" oraxdb:SQLName="order" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                                <xs:element minOccurs="0" name="resource_uri" type="xs:string" oraxdb:propNumber="4267" oraxdb:global="false" oraxdb:SQLName="resource_uri" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                              </xs:sequence>
                              <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4233" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                            </xs:complexType>
                          </xs:element>
                        </xs:sequence>
                        <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4232" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                      </xs:complexType>
                    </xs:element>
                    <xs:element minOccurs="0" name="cancelDate" oraxdb:propNumber="4271" oraxdb:global="false" oraxdb:SQLName="cancelDate" oraxdb:SQLType="cancelDate721_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                      <xs:complexType oraxdb:SQLType="cancelDate721_T" oraxdb:SQLSchema="REPERMS">
                        <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4270" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                      </xs:complexType>
                    </xs:element>
                    <xs:element minOccurs="0" name="objID" oraxdb:propNumber="4273" oraxdb:global="false" oraxdb:SQLName="objID" oraxdb:SQLType="objID722_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                      <xs:complexType oraxdb:SQLType="objID722_T" oraxdb:SQLSchema="REPERMS">
                        <xs:simpleContent>
                          <xs:extension base="xs:unsignedInt">
                            <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4272" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                          </xs:extension>
                        </xs:simpleContent>
                      </xs:complexType>
                    </xs:element>
                    <xs:element minOccurs="0" name="notes" type="xs:string" oraxdb:propNumber="4274" oraxdb:global="false" oraxdb:SQLName="notes" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                    <xs:element minOccurs="0" name="resource_uri" type="xs:string" oraxdb:propNumber="4275" oraxdb:global="false" oraxdb:SQLName="resource_uri" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
                  </xs:sequence>
                  <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="3961" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                </xs:complexType>
              </xs:element>
            </xs:sequence>
            <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="3960" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
          </xs:complexType>
        </xs:element>
        <xs:element minOccurs="0" name="meta" oraxdb:propNumber="4288" oraxdb:global="false" oraxdb:SQLName="meta" oraxdb:SQLType="meta724_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
          <xs:complexType oraxdb:SQLType="meta724_T" oraxdb:SQLSchema="REPERMS">
            <xs:sequence>
              <xs:element minOccurs="0" name="next" type="xs:string" oraxdb:propNumber="4279" oraxdb:global="false" oraxdb:SQLName="next" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1" oraxdb:MemInline="true" oraxdb:SQLInline="true" oraxdb:JavaInline="true"/>
              <xs:element minOccurs="0" name="total_count" oraxdb:propNumber="4281" oraxdb:global="false" oraxdb:SQLName="total_count" oraxdb:SQLType="total_count725_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                <xs:complexType oraxdb:SQLType="total_count725_T" oraxdb:SQLSchema="REPERMS">
                  <xs:simpleContent>
                    <xs:extension base="xs:unsignedShort">
                      <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4280" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <xs:element minOccurs="0" name="previous" oraxdb:propNumber="4283" oraxdb:global="false" oraxdb:SQLName="previous" oraxdb:SQLType="previous726_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                <xs:complexType oraxdb:SQLType="previous726_T" oraxdb:SQLSchema="REPERMS">
                  <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4282" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                </xs:complexType>
              </xs:element>
              <xs:element minOccurs="0" name="limit" oraxdb:propNumber="4285" oraxdb:global="false" oraxdb:SQLName="limit" oraxdb:SQLType="limit727_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                <xs:complexType oraxdb:SQLType="limit727_T" oraxdb:SQLSchema="REPERMS">
                  <xs:simpleContent>
                    <xs:extension base="xs:unsignedByte">
                      <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4284" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
              <xs:element minOccurs="0" name="offset" oraxdb:propNumber="4287" oraxdb:global="false" oraxdb:SQLName="offset" oraxdb:SQLType="offset728_T" oraxdb:SQLSchema="REPERMS" oraxdb:memType="258" oraxdb:MemInline="false" oraxdb:SQLInline="true" oraxdb:JavaInline="false">
                <xs:complexType oraxdb:SQLType="offset728_T" oraxdb:SQLSchema="REPERMS">
                  <xs:simpleContent>
                    <xs:extension base="xs:unsignedByte">
                      <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4286" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
                    </xs:extension>
                  </xs:simpleContent>
                </xs:complexType>
              </xs:element>
            </xs:sequence>
            <xs:attribute name="type" type="xs:string" use="optional" oraxdb:propNumber="4278" oraxdb:global="false" oraxdb:SQLName="type" oraxdb:SQLType="VARCHAR2" oraxdb:memType="1"/>
          </xs:complexType>
        </xs:element>
      </xs:sequence>
    </xs:complexType>
  </xs:element>
</xs:schema>

Open in new window

0
Comment
Question by:FutureDBA-
  • 11
  • 10
21 Comments
 

Author Comment

by:FutureDBA-
ID: 39639342
this is sample XML data from the file.


the fields i really need to pull are

OWNER
CTIME
SKU
taxid
ID
QTY

This XML file does not appear to have any style information associated with it. The document tree is shown below.
<object type="hash">
<otherVersions type="list"/>
<percentDiscount type="null"/>
<entityType>SalesOrder</entityType>
<ownerName>John Doe</ownerName>
<mtime>2013-11-11T17:28:40Z</mtime>
<owner>johnd@nowhere.com</owner>
<shippingMethod>FEDEX</shippingMethod>
<id>#331450</id>
<category>/api/v2/order_categories/4960</category>
<billTo type="hash">
<btCustomer>/api/v2/customers/154678</btCustomer>
<entityType>Address</entityType>
<street>661 NOWHERE AVE 92ND ST</street>
<postcode>10025</postcode>
<mtime>2013-11-11T17:27:36Z</mtime>
<owner>system</owner>
<id type="null"/>
<city>NEW YORK</city>
<uuid>16124759-5fd1-4fb1-ae13-993a6bf1ecb7</uuid>
<ctimeOnServer>2013-10-04T16:34:17Z</ctimeOnServer>
<mtimeOnServer>2013-11-11T17:28:40Z</mtimeOnServer>
<state>NY</state>
<fax type="null"/>
<isDefaultShipTo type="boolean">False</isDefaultShipTo>
<street2/>
<stCustomer type="null"/>
<phone>212 222 6332</phone>
<cdate>2013-10-04</cdate>
<ctime>2013-10-04T16:34:17Z</ctime>
<name type="null"/>
<country type="null"/>
<objID type="integer">154679</objID>
<resource_uri>/api/v2/addresses/154679</resource_uri>
</billTo>
<paymentTerms>PREPAID</paymentTerms>
<uuid>da4ed66f-6051-441b-9a2b-18bc7779ff52</uuid>
<ctimeOnServer>2013-11-11T17:28:40Z</ctimeOnServer>
<freeShipping type="boolean">False</freeShipping>
<startShipDate>2013-11-12</startShipDate>
<mtimeOnServer>2013-11-11T17:28:40Z</mtimeOnServer>
<shipPartial type="boolean">True</shipPartial>
<userGroup>/api/v2/user_groups/20747</userGroup>
<status>Open</status>
<customer type="hash">
<locale>en_US</locale>
<percentDiscount type="null"/>
<entityType>Customer</entityType>
<currency>USD</currency>
<ownerName>system</ownerName>
<mtime>2013-11-11T17:27:36Z</mtime>
<owner>system</owner>
<shippingMethod>FEDEX</shippingMethod>
<id>24233</id>
<billTo type="hash">
<btCustomer>/api/v2/customers/154678</btCustomer>
<entityType>Address</entityType>
<street>661 NOWHERE AVE 92ND ST</street>
<postcode>10025</postcode>
<mtime>2013-11-11T17:27:36Z</mtime>
<owner>system</owner>
<id type="null"/>
<city>NEW YORK</city>
<uuid>16124759-5fd1-4fb1-ae13-993a6bf1ecb7</uuid>
<ctimeOnServer>2013-10-04T16:34:17Z</ctimeOnServer>
<mtimeOnServer>2013-11-11T17:28:40Z</mtimeOnServer>
<state>NY</state>
<fax type="null"/>
<isDefaultShipTo type="boolean">False</isDefaultShipTo>
<street2/>
<stCustomer type="null"/>
<phone>212 222 6332</phone>
<cdate>2013-10-04</cdate>
<ctime>2013-10-04T16:34:17Z</ctime>
<name type="null"/>
<country type="null"/>
<objID type="integer">154679</objID>
<resource_uri>/api/v2/addresses/154679</resource_uri>
</billTo>
<paymentTerms>PREPAID</paymentTerms>
<customerGroup type="hash">
<uuid>1e1cbc21-13f8-457a-81e0-8b0380dbf838</uuid>
<ctimeOnServer>2013-09-12T18:13:56Z</ctimeOnServer>
<currencyCode>USD</currencyCode>
<entityType>CustomerGroup</entityType>
<name>John Doe</name>
<mtimeOnServer>2013-09-12T18:34:22Z</mtimeOnServer>
<cdate>2013-09-12</cdate>
<objID type="integer">20653</objID>
<mtime>2013-09-12T18:34:22Z</mtime>
<owner>johnt@dorasnaturals.com</owner>
<resource_uri>/api/v2/customer_groups/20653</resource_uri>
<id>2</id>
<isDefault type="boolean">False</isDefault>
<ctime>2013-09-12T18:13:56Z</ctime>
</customerGroup>
<uuid>f6342929-7751-4ab8-91f6-7d0b3adab562</uuid>
<ctimeOnServer>2013-10-04T16:34:17Z</ctimeOnServer>
<taxID>0</taxID>
<mtimeOnServer>2013-11-11T17:28:40Z</mtimeOnServer>
<userGroup type="hash">
<isMaster type="boolean">False</isMaster>
<subcategories type="list"/>
<ctime>2013-09-12T19:45:06Z</ctime>
<parent>/api/v2/user_groups/2</parent>
<ctimeOnServer>2013-09-12T19:45:06Z</ctimeOnServer>
<entityType>UserGroup</entityType>
<name>John Doe</name>
<mtimeOnServer>2013-09-12T19:45:06Z</mtimeOnServer>
<cdate>2013-09-12</cdate>
<objID type="integer">20747</objID>
<mtime>2013-09-12T19:45:06Z</mtime>
<owner>johnt@dorasnaturals.com</owner>
<resource_uri>/api/v2/user_groups/20747</resource_uri>
<id>John Doe</id>
<uuid>6e637aea-7190-461e-a5d7-f6d8230c7599</uuid>
</userGroup>
<defaultShipTo>/api/v2/addresses/154682</defaultShipTo>
<email type="null"/>
<defaultWarehouse type="null"/>
<cdate>2013-10-04</cdate>
<name>SUPERSOL SUPERMARKETS (24233)</name>
<ctime>2013-10-04T16:34:17Z</ctime>
<contact type="null"/>
<objID type="integer">154678</objID>
<creditCards type="list"/>
<shipTos type="list">
<object type="hash">
<btCustomer type="null"/>
<entityType>Address</entityType>
<street>20</street>
<postcode type="null"/>
<mtime>2013-11-11T17:27:36Z</mtime>
<owner>system</owner>
<id type="null"/>
<city type="null"/>
<uuid>bb719d15-a661-4c0d-9736-d943158dbd89</uuid>
<ctimeOnServer>2013-10-04T16:34:17Z</ctimeOnServer>
<mtimeOnServer>2013-11-11T17:28:40Z</mtimeOnServer>
<state type="null"/>
<fax type="null"/>
<isDefaultShipTo type="boolean">True</isDefaultShipTo>
<street2 type="null"/>
<stCustomer>/api/v2/customers/154678</stCustomer>
<phone type="null"/>
<cdate>2013-10-04</cdate>
<ctime>2013-10-04T16:34:17Z</ctime>
<name type="null"/>
<country type="null"/>
<objID type="integer">154682</objID>
<resource_uri>/api/v2/addresses/154682</resource_uri>
</object>
</shipTos>
<resource_uri>/api/v2/customers/154678</resource_uri>
</customer>
<versionInfo type="null"/>
<shipTo type="hash">
<btCustomer type="null"/>
<entityType>Address</entityType>
<street>20</street>
<postcode type="null"/>
<mtime>2013-11-11T17:27:36Z</mtime>
<owner>system</owner>
<id type="null"/>
<city type="null"/>
<uuid>bb719d15-a661-4c0d-9736-d943158dbd89</uuid>
<ctimeOnServer>2013-10-04T16:34:17Z</ctimeOnServer>
<mtimeOnServer>2013-11-11T17:28:40Z</mtimeOnServer>
<state type="null"/>
<fax type="null"/>
<isDefaultShipTo type="boolean">True</isDefaultShipTo>
<street2 type="null"/>
<stCustomer>/api/v2/customers/154678</stCustomer>
<phone type="null"/>
<cdate>2013-10-04</cdate>
<ctime>2013-10-04T16:34:17Z</ctime>
<name type="null"/>
<country type="null"/>
<objID type="integer">154682</objID>
<resource_uri>/api/v2/addresses/154682</resource_uri>
</shipTo>
<defaultWarehouse type="null"/>
<customerPO type="null"/>
<lastEdited>2013-11-11T17:28:40Z</lastEdited>
<creditCard type="null"/>
<lastExported type="null"/>
<cdate>2013-11-11</cdate>
<versionType type="null"/>
<realVersion type="null"/>
<signatureURL type="null"/>
<shippedStatus>Not Shipped</shippedStatus>
<totalOffDiscount type="null"/>
<ctime>2013-11-11T17:27:35Z</ctime>
<photoURLs type="list"/>
<lines type="list">
<object type="hash">
<barcode>8-95267-00203-0</barcode>
<description>Premium Water - 1 LITER</description>
<item>/api/v2/items/157219</item>
<entityType>SalesOrderLine</entityType>
<ctime>2013-11-11T17:28:12Z</ctime>
<qty type="integer">12</qty>
<dimensions type="null"/>
<cdate>2013-11-11</cdate>
<mtime>2013-11-11T17:28:40Z</mtime>
<owner>johnd@nowhere.com</owner>
<total>0.00</total>
<unitPrice>0.00</unitPrice>
<manufacturer>/api/v2/manufacturers/3</manufacturer>
<sku>746</sku>
<uuid>86d9b689-f355-470a-ad81-003352039bd3</uuid>
<mtimeOnServer>2013-11-11T17:28:40Z</mtimeOnServer>
<isku>746</isku>
<qtyFree type="integer">0</qtyFree>
<notes/>
<ctimeOnServer>2013-11-11T17:28:40Z</ctimeOnServer>
<qtyShipped type="integer">0</qtyShipped>
<objID type="integer">331458</objID>
<vsku type="null"/>
<order>/api/v2/orders/331450</order>
<resource_uri>/api/v2/order_lines/331458</resource_uri>
</object>
<object type="hash">
<barcode>8-95267-00200-9</barcode>
<description>Premium Water - 20 OZ</description>
<item>/api/v2/items/157221</item>
<entityType>SalesOrderLine</entityType>
<ctime>2013-11-11T17:28:12Z</ctime>
<qty type="integer">24</qty>
<dimensions type="null"/>
<cdate>2013-11-11</cdate>
<mtime>2013-11-11T17:28:40Z</mtime>
<owner>johnd@nowhere.com</owner>
<total>0.00</total>
<unitPrice>0.00</unitPrice>
<manufacturer>/api/v2/manufacturers/3</manufacturer>
<sku>748</sku>
<uuid>58787f95-867b-4ef9-9c01-bdbc4434563f</uuid>
<mtimeOnServer>2013-11-11T17:28:40Z</mtimeOnServer>
<isku>748</isku>
<qtyFree type="integer">0</qtyFree>
<notes/>
<ctimeOnServer>2013-11-11T17:28:40Z</ctimeOnServer>
<qtyShipped type="integer">0</qtyShipped>
<objID type="integer">331459</objID>
<vsku type="null"/>
<order>/api/v2/orders/331450</order>
<resource_uri>/api/v2/order_lines/331459</resource_uri>
</object>
<object type="hash">
<barcode>0-93966-51400-1</barcode>
<description>Lowfat 1% Milk Half Gallon - 64 OZ</description>
<item>/api/v2/items/157348</item>
<entityType>SalesOrderLine</entityType>
<ctime>2013-11-11T17:27:45Z</ctime>
<qty type="integer">12</qty>
<dimensions type="null"/>
<cdate>2013-11-11</cdate>
<mtime>2013-11-11T17:28:40Z</mtime>
<owner>johnd@nowhere.com</owner>
<total>0.00</total>
<unitPrice>0.00</unitPrice>
<manufacturer>/api/v2/manufacturers/3</manufacturer>
<sku>2152</sku>
<uuid>c51a2130-c19e-475a-96ce-0a580d791aa1</uuid>
<mtimeOnServer>2013-11-11T17:28:40Z</mtimeOnServer>
<isku>2152</isku>
<qtyFree type="integer">0</qtyFree>
<notes/>
<ctimeOnServer>2013-11-11T17:28:40Z</ctimeOnServer>
<qtyShipped type="integer">0</qtyShipped>
<objID type="integer">331451</objID>
<vsku type="null"/>
<order>/api/v2/orders/331450</order>
<resource_uri>/api/v2/order_lines/331451</resource_uri>
</object>
<object type="hash">
<barcode>0-93966-51600-5</barcode>
<description>Nonfat Skim Milk Half Gallon - 64 OZ</description>
<item>/api/v2/items/157349</item>
<entityType>SalesOrderLine</entityType>
<ctime>2013-11-11T17:27:46Z</ctime>
<qty type="integer">12</qty>
<dimensions type="null"/>
<cdate>2013-11-11</cdate>
<mtime>2013-11-11T17:28:40Z</mtime>
<owner>johnd@nowhere.com</owner>
<total>0.00</total>
<unitPrice>0.00</unitPrice>
<manufacturer>/api/v2/manufacturers/3</manufacturer>
<sku>2153</sku>
<uuid>cde8a71b-684e-40f4-895a-81333e183d5c</uuid>
<mtimeOnServer>2013-11-11T17:28:40Z</mtimeOnServer>
<isku>2153</isku>
<qtyFree type="integer">0</qtyFree>
<notes/>
<ctimeOnServer>2013-11-11T17:28:40Z</ctimeOnServer>
<qtyShipped type="integer">0</qtyShipped>
<objID type="integer">331452</objID>
<vsku type="null"/>
<order>/api/v2/orders/331450</order>
<resource_uri>/api/v2/order_lines/331452</resource_uri>
</object>
<object type="hash">
<barcode>0-93966-51052-2</barcode>
<description>Half and Half Pint - 16 OZ</description>
<item>/api/v2/items/157369</item>
<entityType>SalesOrderLine</entityType>
<ctime>2013-11-11T17:27:53Z</ctime>
<qty type="integer">24</qty>
<dimensions type="null"/>
<cdate>2013-11-11</cdate>
<mtime>2013-11-11T17:28:40Z</mtime>
<owner>johnd@nowhere.com</owner>
<total>0.00</total>
<unitPrice>0.00</unitPrice>
<manufacturer>/api/v2/manufacturers/3</manufacturer>
<sku>2361</sku>
<uuid>2b76b1ce-2990-4858-8a7b-1f440c0db25d</uuid>
<mtimeOnServer>2013-11-11T17:28:40Z</mtimeOnServer>
<isku>2361</isku>
<qtyFree type="integer">0</qtyFree>
<notes/>
<ctimeOnServer>2013-11-11T17:28:40Z</ctimeOnServer>
<qtyShipped type="integer">0</qtyShipped>
<objID type="integer">331453</objID>
<vsku type="null"/>
<order>/api/v2/orders/331450</order>
<resource_uri>/api/v2/order_lines/331453</resource_uri>
</object>
<object type="hash">
<barcode>0-72050-10101-3</barcode>
<description>Organic Plain Soy Drink - 64 OZ</description>
<item>/api/v2/items/157533</item>
<entityType>SalesOrderLine</entityType>
<ctime>2013-11-11T17:28:00Z</ctime>
<qty type="integer">6</qty>
<dimensions type="null"/>
<cdate>2013-11-11</cdate>
<mtime>2013-11-11T17:28:40Z</mtime>
<owner>johnd@nowhere.com</owner>
<total>0.00</total>
<unitPrice>0.00</unitPrice>
<manufacturer>/api/v2/manufacturers/3</manufacturer>
<sku>10101</sku>
<uuid>29a8b016-db53-4912-99bb-9272c32c4a87</uuid>
<mtimeOnServer>2013-11-11T17:28:40Z</mtimeOnServer>
<isku>10101</isku>
<qtyFree type="integer">0</qtyFree>
<notes/>
<ctimeOnServer>2013-11-11T17:28:40Z</ctimeOnServer>
<qtyShipped type="integer">0</qtyShipped>
<objID type="integer">331454</objID>
<vsku type="null"/>
<order>/api/v2/orders/331450</order>
<resource_uri>/api/v2/order_lines/331454</resource_uri>
</object>
<object type="hash">
<barcode>0-72050-10102-0</barcode>
<description>Organic Vanilla Soy Drink - 64 OZ</description>
<item>/api/v2/items/157535</item>
<entityType>SalesOrderLine</entityType>
<ctime>2013-11-11T17:28:01Z</ctime>
<qty type="integer">6</qty>
<dimensions type="null"/>
<cdate>2013-11-11</cdate>
<mtime>2013-11-11T17:28:40Z</mtime>
<owner>johnd@nowhere.com</owner>
<total>0.00</total>
<unitPrice>0.00</unitPrice>
<manufacturer>/api/v2/manufacturers/3</manufacturer>
<sku>10102</sku>
<uuid>f64b8499-c3df-410c-a38d-6d630a96e9f7</uuid>
<mtimeOnServer>2013-11-11T17:28:40Z</mtimeOnServer>
<isku>10102</isku>
<qtyFree type="integer">0</qtyFree>
<notes/>
<ctimeOnServer>2013-11-11T17:28:40Z</ctimeOnServer>
<qtyShipped type="integer">0</qtyShipped>
<objID type="integer">331455</objID>
<vsku type="null"/>
<order>/api/v2/orders/331450</order>
<resource_uri>/api/v2/order_lines/331455</resource_uri>
</object>
<object type="hash">
<barcode>0-72050-10103-7</barcode>
<description>Organic Chocolate Soy Drink - 64 OZ</description>
<item>/api/v2/items/157536</item>
<entityType>SalesOrderLine</entityType>
<ctime>2013-11-11T17:28:01Z</ctime>
<qty type="integer">6</qty>
<dimensions type="null"/>
<cdate>2013-11-11</cdate>
<mtime>2013-11-11T17:28:40Z</mtime>
<owner>johnd@nowhere.com</owner>
<total>0.00</total>
<unitPrice>0.00</unitPrice>
<manufacturer>/api/v2/manufacturers/3</manufacturer>
<sku>10103</sku>
<uuid>2d6b6a72-50dc-4b09-9657-147fba5b9cd9</uuid>
<mtimeOnServer>2013-11-11T17:28:40Z</mtimeOnServer>
<isku>10103</isku>
<qtyFree type="integer">0</qtyFree>
<notes/>
<ctimeOnServer>2013-11-11T17:28:40Z</ctimeOnServer>
<qtyShipped type="integer">0</qtyShipped>
<objID type="integer">331456</objID>
<vsku type="null"/>
<order>/api/v2/orders/331450</order>
<resource_uri>/api/v2/order_lines/331456</resource_uri>
</object>
<object type="hash">
<barcode>0-72050-11010-7</barcode>
<description>Chocolate Almond Beverage Pudding - 4 X 3.8OZ</description>
<item>/api/v2/items/157545</item>
<entityType>SalesOrderLine</entityType>
<ctime>2013-11-11T17:28:02Z</ctime>
<qty type="integer">12</qty>
<dimensions type="null"/>
<cdate>2013-11-11</cdate>
<mtime>2013-11-11T17:28:40Z</mtime>
<owner>johnd@nowhere.com</owner>
<total>0.00</total>
<unitPrice>0.00</unitPrice>
<manufacturer>/api/v2/manufacturers/3</manufacturer>
<sku>11010</sku>
<uuid>71003eb8-ff5e-41cc-9e62-3d6420777e94</uuid>
<mtimeOnServer>2013-11-11T17:28:40Z</mtimeOnServer>
<isku>11010</isku>
<qtyFree type="integer">0</qtyFree>
<notes/>
<ctimeOnServer>2013-11-11T17:28:40Z</ctimeOnServer>
<qtyShipped type="integer">0</qtyShipped>
<objID type="integer">331457</objID>
<vsku type="null"/>
<order>/api/v2/orders/331450</order>
<resource_uri>/api/v2/order_lines/331457</resource_uri>
</object>
<object type="hash">
<barcode type="null"/>
<description>NY2O 20OZ PREMIUM WATER - 20 OZ</description>
<item>/api/v2/items/157702</item>
<entityType>SalesOrderLine</entityType>
<ctime>2013-11-11T17:28:24Z</ctime>
<qty type="integer">24</qty>
<dimensions type="null"/>
<cdate>2013-11-11</cdate>
<mtime>2013-11-11T17:28:40Z</mtime>
<owner>johnd@nowhere.com</owner>
<total>0.00</total>
<unitPrice>0.00</unitPrice>
<manufacturer>/api/v2/manufacturers/3</manufacturer>
<sku>700748</sku>
<uuid>1bf3d2af-fe1e-45b1-9f5d-94a209c079a8</uuid>
<mtimeOnServer>2013-11-11T17:28:40Z</mtimeOnServer>
<isku>700748</isku>
<qtyFree type="integer">0</qtyFree>
<notes/>
<ctimeOnServer>2013-11-11T17:28:40Z</ctimeOnServer>
<qtyShipped type="integer">0</qtyShipped>
<objID type="integer">331460</objID>
<vsku type="null"/>
<order>/api/v2/orders/331450</order>
<resource_uri>/api/v2/order_lines/331460</resource_uri>
</object>
<object type="hash">
<barcode type="null"/>
<description>Delivery Charge -</description>
<item>/api/v2/items/157776</item>
<entityType>SalesOrderLine</entityType>
<ctime>2013-11-11T17:28:34Z</ctime>
<qty type="integer">1</qty>
<dimensions type="null"/>
<cdate>2013-11-11</cdate>
<mtime>2013-11-11T17:28:40Z</mtime>
<owner>johnd@nowhere.com</owner>
<total>0.00</total>
<unitPrice>0.00</unitPrice>
<manufacturer>/api/v2/manufacturers/3</manufacturer>
<sku>994</sku>
<uuid>4403b3b5-9098-4589-8641-2939552e34d4</uuid>
<mtimeOnServer>2013-11-11T17:28:40Z</mtimeOnServer>
<isku>994</isku>
<qtyFree type="integer">0</qtyFree>
<notes/>
<ctimeOnServer>2013-11-11T17:28:40Z</ctimeOnServer>
<qtyShipped type="integer">0</qtyShipped>
<objID type="integer">331461</objID>
<vsku type="null"/>
<order>/api/v2/orders/331450</order>
<resource_uri>/api/v2/order_lines/331461</resource_uri>
</object>
</lines>
<cancelDate type="null"/>
<objID type="integer">331450</objID>
<notes/>
<resource_uri>/api/v2/orders/331450</resource_uri>
</object>

Open in new window

0
 
LVL 73

Expert Comment

by:sdstuber
ID: 39639419
how do you want them extracted?

are you expecting a single table? multiple tables?
single row? multiple rows?


Given the xml above, what is the expected result?
please provide rows/columns of data.  That's what I'll use to confirm my test results
0
 

Author Comment

by:FutureDBA-
ID: 39639467
in a perfect world. from the last xml sample i uploaded to this thread. i would get these results

owner	taxid	mtime			owner			sku	qty
24233	0	2013-11-11T17:27:36Z	johnd@nowhere.com	746	12
24233	0	2013-11-11T17:27:36Z	johnd@nowhere.com	748	24
24233	0	2013-11-11T17:27:36Z	johnd@nowhere.com	2152	12
24233	0	2013-11-11T17:27:36Z	johnd@nowhere.com	2153	12
24233	0	2013-11-11T17:27:36Z	johnd@nowhere.com	2361	24
24233	0	2013-11-11T17:27:36Z	johnd@nowhere.com	10101	6
24233	0	2013-11-11T17:27:36Z	johnd@nowhere.com	10102	6
24233	0	2013-11-11T17:27:36Z	johnd@nowhere.com	10103	6
24233	0	2013-11-11T17:27:36Z	johnd@nowhere.com	11010	12
24233	0	2013-11-11T17:27:36Z	johnd@nowhere.com	700748	24
24233	0	2013-11-11T17:27:36Z	johnd@nowhere.com	994	1

Open in new window

0
 
LVL 73

Expert Comment

by:sdstuber
ID: 39639519
SELECT EXTRACTVALUE(t.xml_document, '//customer/id') id,
       EXTRACTVALUE(t.xml_document, '//customer/taxID') taxid,
       x.*
  FROM table_with_xml_column t,
       XMLTABLE(
           '//lines/object'
           PASSING t.xml_document
           COLUMNS mtime VARCHAR2(50) PATH '/object/mtime',
                   owner VARCHAR2(50) PATH '/object/owner',
                   sku NUMBER PATH '/object/sku',
                   qty NUMBER PATH '/object/qty'
       ) x
 WHERE filename = 'output.xml'
0
 

Author Comment

by:FutureDBA-
ID: 39639533
ORA-19025: EXTRACTVALUE returns value of only one node
19025. 00000 -  "EXTRACTVALUE returns value of only one node"
*Cause:    Given XPath points to more than one node.
*Action:   Rewrite the query so that exactly one node is returned.

Open in new window

0
 
LVL 73

Expert Comment

by:sdstuber
ID: 39639534
alternate version using xmltable for both the customer portion and the lines


SELECT c.*, l.*
  FROM table_with_xml_column t,
       XMLTABLE(
           '//customer'
           PASSING t.xml_document
           COLUMNS id NUMBER PATH '/customer/id', taxid NUMBER PATH '/customer/taxID'
       ) c,
       XMLTABLE(
           '//lines/object'
           PASSING t.xml_document
           COLUMNS mtime VARCHAR2(50) PATH '/object/mtime',
                   owner VARCHAR2(50) PATH '/object/owner',
                   sku NUMBER PATH '/object/sku',
                   qty NUMBER PATH '/object/qty'
       ) l
 WHERE filename = 'output.xml'
0
 
LVL 73

Expert Comment

by:sdstuber
ID: 39639537
using the xml provided above,  I get the the requested results.

if you're getting

ORA-19025: EXTRACTVALUE returns value of only one node

are you sure your input XML is the same as what you have posted above?
The xmltable version I posted will allow you to pull multiple customers out of a single xml, but there is nothing in the sample above to correlate a particular customer to a particular set of lines
0
 

Author Comment

by:FutureDBA-
ID: 39639701
using the below code, i cant select anything in the xml file that has a recent data.

the last select-able date is 20131004.

Also, when i run this, i get a query with 130K rows.

would it help if i uploaded an XML file that had multiple orders ?


WITH Q AS (SELECT c.*, l.*
  FROM table_with_xml_column t,
       XMLTABLE(
           '//customer'
           PASSING t.xml_document
           COLUMNS id VARCHAR2(10) PATH '/customer/id'
       ) c,
       XMLTABLE(
           '//lines/object'
           PASSING t.xml_document
           COLUMNS mtime VARCHAR2(50) PATH '/object/mtime',
                   owner VARCHAR2(50) PATH '/object/owner',
                   sku VARCHAR2(10) PATH '/object/sku',
                   qty VARCHAR2(10) PATH '/object/qty'
       ) l
 WHERE filename = 'output.xml')
 
 
 select * from (
 select 
    id,
    to_char(to_date(substr(mtime,1,10),'YYYY-MM-DD'),'yyyymmdd') xdate,
    owner,
    sku,
    qty from Q) where xdate = 20131107;
    
    

Open in new window

0
 

Author Comment

by:FutureDBA-
ID: 39639709
i just checked the xml file manually. mtime does has a 2013-11-07 order
0
 
LVL 73

Expert Comment

by:sdstuber
ID: 39639740
The file above doesn't have any data for 2013-11-07.

We need to use the same data with the same expected results.

If you're trying to do something different than what you've posted above, it doesn't surprise me that it might fail or produce different results.

What do you get when you run either of the queries I posted using the file you posted above?


If you post a new file, then include the expected results for that file.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

Author Comment

by:FutureDBA-
ID: 39639762
Im going to post a new file that has 5 orders.

i will also post expected results. gimme 10 mins to prepare
0
 

Author Comment

by:FutureDBA-
ID: 39639882
I think the problem is that different sections have different mtimes, the one i am looking for is the one under billto
0
 

Author Comment

by:FutureDBA-
ID: 39639889
<object type="hash">
<otherVersions type="list"/>
<percentDiscount type="null"/>
<entityType>SalesOrder</entityType>
<ownerName>Somefirstname Somelastname</ownerName>
<mtime>2013-10-12T20:17:05Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<shippingMethod>FEDEX</shippingMethod>
<id>#81331</id>
<category>/api/v2/order_categories/4960</category>
<billTo type="hash">
<btCustomer>/api/v2/customers/98969</btCustomer>
<entityType>Address</entityType>
<street type="null"/>
<postcode type="null"/>
<mtime>2013-11-08T16:43:43Z</mtime>
<owner>system</owner>
<id type="null"/>
<city type="null"/>
<uuid>a3e9b1d3-6247-4a21-8283-69d473d37824</uuid>
<ctimeOnServer>2013-10-04T16:31:19Z</ctimeOnServer>
<mtimeOnServer>2013-11-08T17:29:39Z</mtimeOnServer>
<state type="null"/>
<fax type="null"/>
<isDefaultShipTo type="boolean">False</isDefaultShipTo>
<street2 type="null"/>
<stCustomer type="null"/>
<phone type="null"/>
<cdate>2013-10-04</cdate>
<ctime>2013-10-04T16:31:19Z</ctime>
<name type="null"/>
<country type="null"/>
<objID type="integer">98970</objID>
<resource_uri>/api/v2/addresses/98970</resource_uri>
</billTo>
<paymentTerms>PREPAID</paymentTerms>
<uuid>b0454240-fd38-4363-997e-518e6a7086d7</uuid>
<ctimeOnServer>2013-10-04T17:43:59Z</ctimeOnServer>
<freeShipping type="boolean">False</freeShipping>
<startShipDate>2013-10-05</startShipDate>
<mtimeOnServer>2013-10-12T20:17:06Z</mtimeOnServer>
<shipPartial type="boolean">True</shipPartial>
<userGroup>/api/v2/user_groups/20743</userGroup>
<status>Confirmed</status>
<customer type="hash">
<locale>en_US</locale>
<percentDiscount type="null"/>
<entityType>Customer</entityType>
<currency>USD</currency>
<ownerName>system</ownerName>
<mtime>2013-11-08T16:43:43Z</mtime>
<owner>system</owner>
<shippingMethod>FEDEX</shippingMethod>
<id>26483</id>
<billTo type="hash">
<btCustomer>/api/v2/customers/98969</btCustomer>
<entityType>Address</entityType>
<street type="null"/>
<postcode type="null"/>
<mtime>2013-11-08T16:43:43Z</mtime>
<owner>system</owner>
<id type="null"/>
<city type="null"/>
<uuid>a3e9b1d3-6247-4a21-8283-69d473d37824</uuid>
<ctimeOnServer>2013-10-04T16:31:19Z</ctimeOnServer>
<mtimeOnServer>2013-11-08T17:29:39Z</mtimeOnServer>
<state type="null"/>
<fax type="null"/>
<isDefaultShipTo type="boolean">False</isDefaultShipTo>
<street2 type="null"/>
<stCustomer type="null"/>
<phone type="null"/>
<cdate>2013-10-04</cdate>
<ctime>2013-10-04T16:31:19Z</ctime>
<name type="null"/>
<country type="null"/>
<objID type="integer">98970</objID>
<resource_uri>/api/v2/addresses/98970</resource_uri>
</billTo>
<paymentTerms>PREPAID</paymentTerms>
<customerGroup type="hash">
<uuid>5e0ccb0b-d2d6-496f-8c0c-0fbfba0d5807</uuid>
<ctimeOnServer>2013-09-12T18:33:09Z</ctimeOnServer>
<currencyCode>USD</currencyCode>
<entityType>CustomerGroup</entityType>
<name>Somefirstname Somelastname</name>
<mtimeOnServer>2013-09-12T18:34:22Z</mtimeOnServer>
<cdate>2013-09-12</cdate>
<objID type="integer">20659</objID>
<mtime>2013-09-12T18:34:22Z</mtime>
<owner>johnt@somedomain</owner>
<resource_uri>/api/v2/customer_groups/20659</resource_uri>
<id>9</id>
<isDefault type="boolean">False</isDefault>
<ctime>2013-09-12T18:33:09Z</ctime>
</customerGroup>
<uuid>95619422-11fd-49d1-87e5-18e1d0bd005f</uuid>
<ctimeOnServer>2013-10-04T16:31:19Z</ctimeOnServer>
<taxID>0</taxID>
<mtimeOnServer>2013-11-08T17:29:39Z</mtimeOnServer>
<userGroup type="hash">
<isMaster type="boolean">False</isMaster>
<subcategories type="list"/>
<ctime>2013-09-12T18:59:19Z</ctime>
<parent>/api/v2/user_groups/2</parent>
<ctimeOnServer>2013-09-12T18:59:19Z</ctimeOnServer>
<entityType>UserGroup</entityType>
<name>Somefirstname Somelastname</name>
<mtimeOnServer>2013-09-12T18:59:19Z</mtimeOnServer>
<cdate>2013-09-12</cdate>
<objID type="integer">20743</objID>
<mtime>2013-09-12T18:59:19Z</mtime>
<owner>johnt@somedomain</owner>
<resource_uri>/api/v2/user_groups/20743</resource_uri>
<id>Somefirstname Somelastname</id>
<uuid>0af1dc20-2567-4f7d-96d4-20e80a28d6a4</uuid>
</userGroup>
<defaultShipTo>/api/v2/addresses/156711</defaultShipTo>
<email type="null"/>
<defaultWarehouse type="null"/>
<cdate>2013-10-04</cdate>
<name>Healthways (26483)</name>
<ctime>2013-10-04T16:31:19Z</ctime>
<contact>Khalid</contact>
<objID type="integer">98969</objID>
<creditCards type="list"/>
<shipTos type="list">
<object type="hash">
<btCustomer type="null"/>
<entityType>Address</entityType>
<street>90</street>
<postcode/>
<mtime>2013-11-08T16:43:43Z</mtime>
<owner>johnt@somedomain</owner>
<id type="null"/>
<city/>
<uuid>5605c073-7db1-4fe9-9285-ff70cdd2cac6</uuid>
<ctimeOnServer>2013-10-04T19:30:00Z</ctimeOnServer>
<mtimeOnServer>2013-11-08T17:29:39Z</mtimeOnServer>
<state/>
<fax/>
<isDefaultShipTo type="boolean">True</isDefaultShipTo>
<street2/>
<stCustomer>/api/v2/customers/98969</stCustomer>
<phone/>
<cdate>2013-10-04</cdate>
<ctime>2013-10-04T19:30:00Z</ctime>
<name/>
<country/>
<objID type="integer">156711</objID>
<resource_uri>/api/v2/addresses/156711</resource_uri>
</object>
</shipTos>
<resource_uri>/api/v2/customers/98969</resource_uri>
</customer>
<versionInfo type="null"/>
<shipTo type="hash">
<btCustomer type="null"/>
<entityType>Address</entityType>
<street>90</street>
<postcode/>
<mtime>2013-11-08T16:43:43Z</mtime>
<owner>johnt@somedomain</owner>
<id type="null"/>
<city/>
<uuid>5605c073-7db1-4fe9-9285-ff70cdd2cac6</uuid>
<ctimeOnServer>2013-10-04T19:30:00Z</ctimeOnServer>
<mtimeOnServer>2013-11-08T17:29:39Z</mtimeOnServer>
<state/>
<fax/>
<isDefaultShipTo type="boolean">True</isDefaultShipTo>
<street2/>
<stCustomer>/api/v2/customers/98969</stCustomer>
<phone/>
<cdate>2013-10-04</cdate>
<ctime>2013-10-04T19:30:00Z</ctime>
<name/>
<country/>
<objID type="integer">156711</objID>
<resource_uri>/api/v2/addresses/156711</resource_uri>
</shipTo>
<defaultWarehouse type="null"/>
<customerPO type="null"/>
<lastEdited>2013-11-08T16:43:43Z</lastEdited>
<creditCard type="null"/>
<lastExported>2013-10-10T20:29:29Z</lastExported>
<cdate>2013-10-04</cdate>
<versionType type="null"/>
<realVersion type="null"/>
<signatureURL type="null"/>
<shippedStatus>Not Shipped</shippedStatus>
<totalOffDiscount type="null"/>
<ctime>2013-10-04T14:24:38Z</ctime>
<photoURLs type="list"/>
<lines type="list">
<object type="hash">
<barcode>7-22430-11016-5</barcode>
<description>Synergy, Trilogy - 16 OZ</description>
<item>/api/v2/items/156998</item>
<entityType>SalesOrderLine</entityType>
<ctime>2013-10-04T14:24:48Z</ctime>
<qty type="integer">12</qty>
<dimensions type="null"/>
<cdate>2013-10-04</cdate>
<mtime>2013-10-06T21:06:11Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<total>0.00</total>
<unitPrice>0.00</unitPrice>
<manufacturer>/api/v2/manufacturers/3</manufacturer>
<sku>402</sku>
<uuid>bb85e14d-c500-4395-8e1e-a4c041fc3c23</uuid>
<mtimeOnServer>2013-10-06T21:06:11Z</mtimeOnServer>
<isku>402</isku>
<qtyFree type="integer">0</qtyFree>
<notes/>
<ctimeOnServer>2013-10-04T17:43:59Z</ctimeOnServer>
<qtyShipped type="integer">0</qtyShipped>
<objID type="integer">81332</objID>
<vsku type="null"/>
<order>/api/v2/orders/81331</order>
<resource_uri>/api/v2/order_lines/81332</resource_uri>
</object>
<object type="hash">
<barcode>7-22430-60016-1</barcode>
<description>Synergy, Gingerberry - 16 OZ</description>
<item>/api/v2/items/157001</item>
<entityType>SalesOrderLine</entityType>
<ctime>2013-10-04T14:24:51Z</ctime>
<qty type="integer">12</qty>
<dimensions type="null"/>
<cdate>2013-10-04</cdate>
<mtime>2013-10-06T21:06:11Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<total>0.00</total>
<unitPrice>0.00</unitPrice>
<manufacturer>/api/v2/manufacturers/3</manufacturer>
<sku>406</sku>
<uuid>521cf305-8826-4f4b-9dd2-e83f4673c948</uuid>
<mtimeOnServer>2013-10-06T21:06:11Z</mtimeOnServer>
<isku>406</isku>
<qtyFree type="integer">0</qtyFree>
<notes/>
<ctimeOnServer>2013-10-04T17:43:59Z</ctimeOnServer>
<qtyShipped type="integer">0</qtyShipped>
<objID type="integer">81333</objID>
<vsku type="null"/>
<order>/api/v2/orders/81331</order>
<resource_uri>/api/v2/order_lines/81333</resource_uri>
</object>
<object type="hash">
<barcode>7-22430-10016-6</barcode>
<description>GT's, Citrus - 16 OZ</description>
<item>/api/v2/items/157009</item>
<entityType>SalesOrderLine</entityType>
<ctime>2013-10-04T14:24:54Z</ctime>
<qty type="integer">12</qty>
<dimensions type="null"/>
<cdate>2013-10-04</cdate>
<mtime>2013-10-06T21:06:11Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<total>0.00</total>
<unitPrice>0.00</unitPrice>
<manufacturer>/api/v2/manufacturers/3</manufacturer>
<sku>415</sku>
<uuid>cada83c4-b159-4873-8290-e9939b0e20f5</uuid>
<mtimeOnServer>2013-10-06T21:06:11Z</mtimeOnServer>
<isku>415</isku>
<qtyFree type="integer">0</qtyFree>
<notes/>
<ctimeOnServer>2013-10-04T17:43:59Z</ctimeOnServer>
<qtyShipped type="integer">0</qtyShipped>
<objID type="integer">81334</objID>
<vsku type="null"/>
<order>/api/v2/orders/81331</order>
<resource_uri>/api/v2/order_lines/81334</resource_uri>
</object>
<object type="hash">
<barcode>8-59078-00209-2</barcode>
<description>100% Raw Coconut Water - 8 OZ</description>
<item>/api/v2/items/157055</item>
<entityType>SalesOrderLine</entityType>
<ctime>2013-10-04T14:28:29Z</ctime>
<qty type="integer">24</qty>
<dimensions type="null"/>
<cdate>2013-10-04</cdate>
<mtime>2013-10-06T21:06:12Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<total>0.00</total>
<unitPrice>0.00</unitPrice>
<manufacturer>/api/v2/manufacturers/3</manufacturer>
<sku>470</sku>
<uuid>8e82528a-709b-427e-afe9-453d879417d2</uuid>
<mtimeOnServer>2013-10-06T21:06:12Z</mtimeOnServer>
<isku>470</isku>
<qtyFree type="integer">0</qtyFree>
<notes/>
<ctimeOnServer>2013-10-04T17:43:59Z</ctimeOnServer>
<qtyShipped type="integer">0</qtyShipped>
<objID type="integer">81335</objID>
<vsku type="null"/>
<order>/api/v2/orders/81331</order>
<resource_uri>/api/v2/order_lines/81335</resource_uri>
</object>
<object type="hash">
<barcode>8-59078-00215-3</barcode>
<description>100% Raw Coconut Water - 16 OZ</description>
<item>/api/v2/items/157057</item>
<entityType>SalesOrderLine</entityType>
<ctime>2013-10-04T14:28:30Z</ctime>
<qty type="integer">36</qty>
<dimensions type="null"/>
<cdate>2013-10-04</cdate>
<mtime>2013-10-06T21:06:13Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<total>0.00</total>
<unitPrice>0.00</unitPrice>
<manufacturer>/api/v2/manufacturers/3</manufacturer>
<sku>471</sku>
<uuid>98852331-0a45-443e-b8d3-0943183b89f5</uuid>
<mtimeOnServer>2013-10-06T21:06:13Z</mtimeOnServer>
<isku>471</isku>
<qtyFree type="integer">0</qtyFree>
<notes/>
<ctimeOnServer>2013-10-04T17:43:59Z</ctimeOnServer>
<qtyShipped type="integer">0</qtyShipped>
<objID type="integer">81336</objID>
<vsku type="null"/>
<order>/api/v2/orders/81331</order>
<resource_uri>/api/v2/order_lines/81336</resource_uri>
</object>
</lines>
<cancelDate type="null"/>
<objID type="integer">81331</objID>
<notes>
WARNING: The customer for this order was deleted by John Terrero. You will need to recreate this customer record manually and then tap the top row in the 'Summary' view to re-link this order to the new customer record. The old customer was: Healthways (Contact: Khalid) Email: Phone: None
</notes>
<resource_uri>/api/v2/orders/81331</resource_uri>
</object>
<object type="hash">
<otherVersions type="list"/>
<percentDiscount type="null"/>
<entityType>SalesOrder</entityType>
<ownerName>Somefirstname Somelastname</ownerName>
<mtime>2013-10-12T20:17:20Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<shippingMethod>FEDEX</shippingMethod>
<id>#81341</id>
<category>/api/v2/order_categories/4960</category>
<billTo type="hash">
<btCustomer>/api/v2/customers/81337</btCustomer>
<entityType>Address</entityType>
<street>78 West Pleasant Ave</street>
<postcode>07601</postcode>
<mtime>2013-10-22T21:14:46Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<id type="null"/>
<city>Maywood</city>
<uuid>2efc8147-42ad-43be-a4a2-9864ca27b390</uuid>
<ctimeOnServer>2013-10-04T17:48:37Z</ctimeOnServer>
<mtimeOnServer>2013-10-23T11:40:33Z</mtimeOnServer>
<state>NJ</state>
<fax type="null"/>
<isDefaultShipTo type="boolean">False</isDefaultShipTo>
<street2/>
<stCustomer type="null"/>
<phone/>
<cdate>2013-10-04</cdate>
<ctime>2013-10-04T17:44:01Z</ctime>
<name>West side Market Dba May wood Market</name>
<country>US</country>
<objID type="integer">81338</objID>
<resource_uri>/api/v2/addresses/81338</resource_uri>
</billTo>
<paymentTerms>PREPAID</paymentTerms>
<uuid>3b644adc-7071-4e52-9760-f02bc52ba52a</uuid>
<ctimeOnServer>2013-10-04T17:48:37Z</ctimeOnServer>
<freeShipping type="boolean">False</freeShipping>
<startShipDate type="null"/>
<mtimeOnServer>2013-10-13T20:01:37Z</mtimeOnServer>
<shipPartial type="boolean">True</shipPartial>
<userGroup>/api/v2/user_groups/20743</userGroup>
<status>Confirmed</status>
<customer type="hash">
<locale>en_US</locale>
<percentDiscount type="null"/>
<entityType>Customer</entityType>
<currency>USD</currency>
<ownerName>Somefirstname Somelastname</ownerName>
<mtime>2013-10-22T21:14:46Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<shippingMethod>FEDEX</shippingMethod>
<id>23075</id>
<billTo type="hash">
<btCustomer>/api/v2/customers/81337</btCustomer>
<entityType>Address</entityType>
<street>78 West Pleasant Ave</street>
<postcode>07601</postcode>
<mtime>2013-10-22T21:14:46Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<id type="null"/>
<city>Maywood</city>
<uuid>2efc8147-42ad-43be-a4a2-9864ca27b390</uuid>
<ctimeOnServer>2013-10-04T17:48:37Z</ctimeOnServer>
<mtimeOnServer>2013-10-23T11:40:33Z</mtimeOnServer>
<state>NJ</state>
<fax type="null"/>
<isDefaultShipTo type="boolean">False</isDefaultShipTo>
<street2/>
<stCustomer type="null"/>
<phone/>
<cdate>2013-10-04</cdate>
<ctime>2013-10-04T17:44:01Z</ctime>
<name>West side Market Dba May wood Market</name>
<country>US</country>
<objID type="integer">81338</objID>
<resource_uri>/api/v2/addresses/81338</resource_uri>
</billTo>
<paymentTerms>PREPAID</paymentTerms>
<customerGroup type="hash">
<uuid>5e0ccb0b-d2d6-496f-8c0c-0fbfba0d5807</uuid>
<ctimeOnServer>2013-09-12T18:33:09Z</ctimeOnServer>
<currencyCode>USD</currencyCode>
<entityType>CustomerGroup</entityType>
<name>Somefirstname Somelastname</name>
<mtimeOnServer>2013-09-12T18:34:22Z</mtimeOnServer>
<cdate>2013-09-12</cdate>
<objID type="integer">20659</objID>
<mtime>2013-09-12T18:34:22Z</mtime>
<owner>johnt@somedomain</owner>
<resource_uri>/api/v2/customer_groups/20659</resource_uri>
<id>9</id>
<isDefault type="boolean">False</isDefault>
<ctime>2013-09-12T18:33:09Z</ctime>
</customerGroup>
<uuid>e52cd757-5127-4c62-9eb3-6bb3eea9de8d</uuid>
<ctimeOnServer>2013-10-04T17:48:37Z</ctimeOnServer>
<taxID>0</taxID>
<mtimeOnServer>2013-10-23T11:40:33Z</mtimeOnServer>
<userGroup type="hash">
<isMaster type="boolean">False</isMaster>
<subcategories type="list"/>
<ctime>2013-09-12T18:59:19Z</ctime>
<parent>/api/v2/user_groups/2</parent>
<ctimeOnServer>2013-09-12T18:59:19Z</ctimeOnServer>
<entityType>UserGroup</entityType>
<name>Somefirstname Somelastname</name>
<mtimeOnServer>2013-09-12T18:59:19Z</mtimeOnServer>
<cdate>2013-09-12</cdate>
<objID type="integer">20743</objID>
<mtime>2013-09-12T18:59:19Z</mtime>
<owner>johnt@somedomain</owner>
<resource_uri>/api/v2/user_groups/20743</resource_uri>
<id>Somefirstname Somelastname</id>
<uuid>0af1dc20-2567-4f7d-96d4-20e80a28d6a4</uuid>
</userGroup>
<defaultShipTo>/api/v2/addresses/81340</defaultShipTo>
<email/>
<defaultWarehouse type="null"/>
<cdate>2013-10-04</cdate>
<name>Maywood Market</name>
<ctime>2013-10-04T17:44:01Z</ctime>
<contact>Kosta</contact>
<objID type="integer">81337</objID>
<creditCards type="list"/>
<shipTos type="list">
<object type="hash">
<btCustomer type="null"/>
<entityType>Address</entityType>
<street>90</street>
<postcode type="null"/>
<mtime>2013-10-22T21:14:46Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<id type="null"/>
<city type="null"/>
<uuid>dfa31602-ae56-4ed7-8dad-3fb8164feb83</uuid>
<ctimeOnServer>2013-10-04T17:48:37Z</ctimeOnServer>
<mtimeOnServer>2013-10-23T11:40:33Z</mtimeOnServer>
<state type="null"/>
<fax type="null"/>
<isDefaultShipTo type="boolean">True</isDefaultShipTo>
<street2 type="null"/>
<stCustomer>/api/v2/customers/81337</stCustomer>
<phone type="null"/>
<cdate>2013-10-04</cdate>
<ctime>2013-10-04T17:45:21Z</ctime>
<name type="null"/>
<country>US</country>
<objID type="integer">81340</objID>
<resource_uri>/api/v2/addresses/81340</resource_uri>
</object>
</shipTos>
<resource_uri>/api/v2/customers/81337</resource_uri>
</customer>
<versionInfo type="null"/>
<shipTo type="hash">
<btCustomer type="null"/>
<entityType>Address</entityType>
<street>90</street>
<postcode type="null"/>
<mtime>2013-10-22T21:14:46Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<id type="null"/>
<city type="null"/>
<uuid>dfa31602-ae56-4ed7-8dad-3fb8164feb83</uuid>
<ctimeOnServer>2013-10-04T17:48:37Z</ctimeOnServer>
<mtimeOnServer>2013-10-23T11:40:33Z</mtimeOnServer>
<state type="null"/>
<fax type="null"/>
<isDefaultShipTo type="boolean">True</isDefaultShipTo>
<street2 type="null"/>
<stCustomer>/api/v2/customers/81337</stCustomer>
<phone type="null"/>
<cdate>2013-10-04</cdate>
<ctime>2013-10-04T17:45:21Z</ctime>
<name type="null"/>
<country>US</country>
<objID type="integer">81340</objID>
<resource_uri>/api/v2/addresses/81340</resource_uri>
</shipTo>
<defaultWarehouse type="null"/>
<customerPO type="null"/>
<lastEdited>2013-10-22T21:14:46Z</lastEdited>
<creditCard type="null"/>
<lastExported>2013-10-10T20:29:29Z</lastExported>
<cdate>2013-10-04</cdate>
<versionType type="null"/>
<realVersion type="null"/>
<signatureURL type="null"/>
<shippedStatus>Not Shipped</shippedStatus>
<totalOffDiscount type="null"/>
<ctime>2013-10-04T17:47:48Z</ctime>
<photoURLs type="list"/>
<lines type="list">
<object type="hash">
<barcode>7-22430-20016-3</barcode>
<description>GT's, Gingerade - 16 OZ</description>
<item>/api/v2/items/156995</item>
<entityType>SalesOrderLine</entityType>
<ctime>2013-10-04T17:48:19Z</ctime>
<qty type="integer">12</qty>
<dimensions type="null"/>
<cdate>2013-10-04</cdate>
<mtime>2013-10-06T21:06:11Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<total>0.00</total>
<unitPrice>0.00</unitPrice>
<manufacturer>/api/v2/manufacturers/3</manufacturer>
<sku>400</sku>
<uuid>2d026d00-89b6-4381-89b9-54569546b8ae</uuid>
<mtimeOnServer>2013-10-06T21:06:11Z</mtimeOnServer>
<isku>400</isku>
<qtyFree type="integer">0</qtyFree>
<notes/>
<ctimeOnServer>2013-10-04T17:48:37Z</ctimeOnServer>
<qtyShipped type="integer">0</qtyShipped>
<objID type="integer">81345</objID>
<vsku type="null"/>
<order>/api/v2/orders/81341</order>
<resource_uri>/api/v2/order_lines/81345</resource_uri>
</object>
<object type="hash">
<barcode>7-22430-14016-2</barcode>
<description>GT's, Multi-green - 16 OZ</description>
<item>/api/v2/items/156997</item>
<entityType>SalesOrderLine</entityType>
<ctime>2013-10-04T17:48:20Z</ctime>
<qty type="integer">12</qty>
<dimensions type="null"/>
<cdate>2013-10-04</cdate>
<mtime>2013-10-06T21:06:11Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<total>0.00</total>
<unitPrice>0.00</unitPrice>
<manufacturer>/api/v2/manufacturers/3</manufacturer>
<sku>401</sku>
<uuid>84264055-738c-4958-a6b8-4c2cb2025806</uuid>
<mtimeOnServer>2013-10-06T21:06:11Z</mtimeOnServer>
<isku>401</isku>
<qtyFree type="integer">0</qtyFree>
<notes/>
<ctimeOnServer>2013-10-04T17:48:37Z</ctimeOnServer>
<qtyShipped type="integer">0</qtyShipped>
<objID type="integer">81346</objID>
<vsku type="null"/>
<order>/api/v2/orders/81341</order>
<resource_uri>/api/v2/order_lines/81346</resource_uri>
</object>
<object type="hash">
<barcode>7-22430-11016-5</barcode>
<description>Synergy, Trilogy - 16 OZ</description>
<item>/api/v2/items/156998</item>
<entityType>SalesOrderLine</entityType>
<ctime>2013-10-04T17:48:20Z</ctime>
<qty type="integer">12</qty>
<dimensions type="null"/>
<cdate>2013-10-04</cdate>
<mtime>2013-10-06T21:06:11Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<total>0.00</total>
<unitPrice>0.00</unitPrice>
<manufacturer>/api/v2/manufacturers/3</manufacturer>
<sku>402</sku>
<uuid>9e3a7b9f-c573-49d4-ab69-0e7cd13a73b3</uuid>
<mtimeOnServer>2013-10-06T21:06:11Z</mtimeOnServer>
<isku>402</isku>
<qtyFree type="integer">0</qtyFree>
<notes/>
<ctimeOnServer>2013-10-04T17:48:37Z</ctimeOnServer>
<qtyShipped type="integer">0</qtyShipped>
<objID type="integer">81347</objID>
<vsku type="null"/>
<order>/api/v2/orders/81341</order>
<resource_uri>/api/v2/order_lines/81347</resource_uri>
</object>
<object type="hash">
<barcode>7-22430-60016-1</barcode>
<description>Synergy, Gingerberry - 16 OZ</description>
<item>/api/v2/items/157001</item>
<entityType>SalesOrderLine</entityType>
<ctime>2013-10-04T17:48:22Z</ctime>
<qty type="integer">12</qty>
<dimensions type="null"/>
<cdate>2013-10-04</cdate>
<mtime>2013-10-06T21:06:11Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<total>0.00</total>
<unitPrice>0.00</unitPrice>
<manufacturer>/api/v2/manufacturers/3</manufacturer>
<sku>406</sku>
<uuid>06945e84-56f1-40bb-9f7b-14e87df39bbc</uuid>
<mtimeOnServer>2013-10-06T21:06:11Z</mtimeOnServer>
<isku>406</isku>
<qtyFree type="integer">0</qtyFree>
<notes/>
<ctimeOnServer>2013-10-04T17:48:37Z</ctimeOnServer>
<qtyShipped type="integer">0</qtyShipped>
<objID type="integer">81348</objID>
<vsku type="null"/>
<order>/api/v2/orders/81341</order>
<resource_uri>/api/v2/order_lines/81348</resource_uri>
</object>
<object type="hash">
<barcode>7-22430-00016-9</barcode>
<description>GT's, Original Raw - 16 OZ</description>
<item>/api/v2/items/157002</item>
<entityType>SalesOrderLine</entityType>
<ctime>2013-10-04T17:48:24Z</ctime>
<qty type="integer">12</qty>
<dimensions type="null"/>
<cdate>2013-10-04</cdate>
<mtime>2013-10-06T21:06:11Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<total>0.00</total>
<unitPrice>0.00</unitPrice>
<manufacturer>/api/v2/manufacturers/3</manufacturer>
<sku>407</sku>
<uuid>92520a73-613c-425c-be19-e8f0d4a27985</uuid>
<mtimeOnServer>2013-10-06T21:06:11Z</mtimeOnServer>
<isku>407</isku>
<qtyFree type="integer">0</qtyFree>
<notes/>
<ctimeOnServer>2013-10-04T17:48:37Z</ctimeOnServer>
<qtyShipped type="integer">0</qtyShipped>
<objID type="integer">81349</objID>
<vsku type="null"/>
<order>/api/v2/orders/81341</order>
<resource_uri>/api/v2/order_lines/81349</resource_uri>
</object>
<object type="hash">
<barcode>0-72050-30070-6</barcode>
<description>Eggs, Cage Free Omega 3 - 1 DOZEN</description>
<item>/api/v2/items/157189</item>
<entityType>SalesOrderLine</entityType>
<ctime>2013-10-04T17:48:05Z</ctime>
<qty type="integer">15</qty>
<dimensions type="null"/>
<cdate>2013-10-04</cdate>
<mtime>2013-10-06T21:06:15Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<total>0.00</total>
<unitPrice>0.00</unitPrice>
<manufacturer>/api/v2/manufacturers/3</manufacturer>
<sku>29332</sku>
<uuid>cbc4da0a-5f10-4a51-a28f-ac2c141e817c</uuid>
<mtimeOnServer>2013-10-06T21:06:15Z</mtimeOnServer>
<isku>29332</isku>
<qtyFree type="integer">0</qtyFree>
<notes/>
<ctimeOnServer>2013-10-04T17:48:37Z</ctimeOnServer>
<qtyShipped type="integer">0</qtyShipped>
<objID type="integer">81342</objID>
<vsku type="null"/>
<order>/api/v2/orders/81341</order>
<resource_uri>/api/v2/order_lines/81342</resource_uri>
</object>
<object type="hash">
<barcode>0-72050-30080-5</barcode>
<description>Eggs, Cage Free Vitamin D - 1 DOZEN</description>
<item>/api/v2/items/157190</item>
<entityType>SalesOrderLine</entityType>
<ctime>2013-10-04T17:48:06Z</ctime>
<qty type="integer">15</qty>
<dimensions type="null"/>
<cdate>2013-10-04</cdate>
<mtime>2013-10-06T21:06:15Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<total>0.00</total>
<unitPrice>0.00</unitPrice>
<manufacturer>/api/v2/manufacturers/3</manufacturer>
<sku>29333</sku>
<uuid>e69347d7-ff2a-4912-aad1-9d09639a646b</uuid>
<mtimeOnServer>2013-10-06T21:06:15Z</mtimeOnServer>
<isku>29333</isku>
<qtyFree type="integer">0</qtyFree>
<notes/>
<ctimeOnServer>2013-10-04T17:48:37Z</ctimeOnServer>
<qtyShipped type="integer">0</qtyShipped>
<objID type="integer">81343</objID>
<vsku type="null"/>
<order>/api/v2/orders/81341</order>
<resource_uri>/api/v2/order_lines/81343</resource_uri>
</object>
<object type="hash">
<barcode>0-72050-30090-4</barcode>
<description>Eggs, Cage Free Natural - 1 DOZEN</description>
<item>/api/v2/items/157191</item>
<entityType>SalesOrderLine</entityType>
<ctime>2013-10-04T17:48:07Z</ctime>
<qty type="integer">15</qty>
<dimensions type="null"/>
<cdate>2013-10-04</cdate>
<mtime>2013-10-06T21:06:15Z</mtime>
<owner>Somefirstnamek@somedomain</owner>
<total>0.00</total>
<unitPrice>0.00</unitPrice>
<manufacturer>/api/v2/manufacturers/3</manufacturer>
<sku>29335</sku>
<uuid>ac8279ab-fdbd-44af-9421-0a591ecf593d</uuid>
<mtimeOnServer>2013-10-06T21:06:15Z</mtimeOnServer>
<isku>29335</isku>
<qtyFree type="integer">0</qtyFree>
<notes/>
<ctimeOnServer>2013-10-04T17:48:37Z</ctimeOnServer>
<qtyShipped type="integer">0</qtyShipped>
<objID type="integer">81344</objID>
<vsku type="null"/>
<order>/api/v2/orders/81341</order>
<resource_uri>/api/v2/order_lines/81344</resource_uri>
</object>
</lines>
<cancelDate type="null"/>
<objID type="integer">81341</objID>
<notes/>
<resource_uri>/api/v2/orders/81341</resource_uri>
</object>

Open in new window

0
 

Author Comment

by:FutureDBA-
ID: 39639980
correct, the mtime i need to grab is the one within

<billTo type="hash">
<btCustomer>/api/v2/customers/98969</btCustomer>
<entityType>Address</entityType>
<street type="null"/>
<postcode type="null"/>
<mtime>2013-11-08T16:43:43Z</mtime>
<owner>system</owner>
<id type="null"/>
<city type="null"/>
<uuid>a3e9b1d3-6247-4a21-8283-69d473d37824</uuid>
<ctimeOnServer>2013-10-04T16:31:19Z</ctimeOnServer>
<mtimeOnServer>2013-11-08T17:29:39Z</mtimeOnServer>
<state type="null"/>
<fax type="null"/>
<isDefaultShipTo type="boolean">False</isDefaultShipTo>
<street2 type="null"/>
<stCustomer type="null"/>
<phone type="null"/>
<cdate>2013-10-04</cdate>
<ctime>2013-10-04T16:31:19Z</ctime>
<name type="null"/>
<country type="null"/>
<objID type="integer">98970</objID>
<resource_uri>/api/v2/addresses/98970</resource_uri>
</billTo>
0
 
LVL 73

Expert Comment

by:sdstuber
ID: 39640006
how do you tie an mtime from billTo to an object in lines?

also, what are the results you get for original file?

If you don't get the expected results posted above then there's no sense pursuing another file.
Both queries work for me.  If they don't work for you, please describe exactly what is different between what you're doing and what you posted above.

If you do get the expected results for the original input file, great.
Post similar results for the new file
0
 

Author Comment

by:FutureDBA-
ID: 39640500
sdstuber, sorry I didnt post the file. I am going to upload the main xml file to a remote directory so that you can access it, I will delete it once solution has been solved.

What i originally posted was one portion of the file for one order. that entire file has about 100 - 150 orders per day over the last 2 months.

right now we have to download the file in CSV format from 3rd party, import to oracle, export CSV file in new format so that we can import into our ERP, if i can get this done from within oracle via XML, i can eliminate that step and completely automate this process.

What I really need from this is each order giving me the data in this format for each order.
owner	taxid	mtime			owner			sku	qty
24233	0	2013-11-11T17:27:36Z	johnd@nowhere.com	746	12
24233	0	2013-11-11T17:27:36Z	johnd@nowhere.com	748	24
24233	0	2013-11-11T17:27:36Z	johnd@nowhere.com	2152	12
24233	0	2013-11-11T17:27:36Z	johnd@nowhere.com	2153	12
24233	0	2013-11-11T17:27:36Z	johnd@nowhere.com	2361	24
24233	0	2013-11-11T17:27:36Z	johnd@nowhere.com	10101	6
24233	0	2013-11-11T17:27:36Z	johnd@nowhere.com	10102	6
24233	0	2013-11-11T17:27:36Z	johnd@nowhere.com	10103	6
24233	0	2013-11-11T17:27:36Z	johnd@nowhere.com	11010	12
24233	0	2013-11-11T17:27:36Z	johnd@nowhere.com	700748	24
24233	0	2013-11-11T17:27:36Z	johnd@nowhere.com	994	1

Open in new window


actual XML file is here

http://199.237.198.11/EE/output.xml

also. right now i am running curl, with my api key to download it to the server where Oracle sits on.

would it be better to run this directly from a URL? or as a local file like i am currently doing.

Additionally, There is various parts that are called mtime on the XML file. the time I am actually looking for, is the order create day.  the other mtimes are the create time for the resource (which i do not need in my final output)

from what I understand, the correct time would be the time under
the bill to section

eg

<billTo type="hash">
<btCustomer>/api/v2/customers/99233</btCustomer>
<entityType>Address</entityType>
<street>77 HUSDON ST</street>
<postcode>07302</postcode>
<mtime>2013-11-07T16:58:10Z</mtime>
<owner>system</owner>
<id type="null"/>
<city>JERSEY CITY</city>
<uuid>2de1c96f-c9b3-44bd-a99c-2aaf9a98d3e5</uuid>
<ctimeOnServer>2013-10-04T16:31:25Z</ctimeOnServer>
<mtimeOnServer>2013-11-07T17:53:56Z</mtimeOnServer>

Open in new window



Thanks for all the help
0
 
LVL 73

Expert Comment

by:sdstuber
ID: 39640588
>>  I will delete it once solution has been solved.


All communication for the question should occur within EE itself.
If the link you've provided isn't going to be reliable going forward then it shouldn't be used.

If you can't post a full real file here, that's ok.  We don't need the real file.   We just need a consistent set of input and output.


>>> What i originally posted was one portion of the file for one order.

That's fine.  Did the queries work for you with that file?  They did for me. If not, what did you get?
0
 
LVL 73

Expert Comment

by:sdstuber
ID: 39641840
on second thought, let's simplify.   You have lots of nodes you're not interested in, so don't post those.
Just construct an example manually that has what you want and leave out the rest.

I think, based on your previous comments and posts that this is what you want for a single customer with multiple lines

<object type="hash"> 
  <customer type="hash">
    <id>24233</id>
    <taxID>0</taxID>
    <billTo type="hash">
      <mtime>2013-11-11T17:27:36Z</mtime>
    </billTo>
  </customer>
  <lines type="list">
    <object type="hash">
      <qty type="integer">12</qty>
      <owner>johnd@nowhere.com</owner>
      <sku>746</sku>
    </object>
    <object type="hash">
      <qty type="integer">24</qty>
      <owner>johnd@nowhere.com</owner>
      <sku>748</sku>
    </object>
  </lines>
</object>

Open in new window


If that is not correct, please adjust.

Let's do ONE, then you can expand that example for 2 customers.
If there is a connection between customers and their lines, please explain what that connection is.

If it's simply order within the xml document I can work with that too
0
 
LVL 73

Accepted Solution

by:
sdstuber earned 500 total points
ID: 39642379
Here's an example of what I think you want to read for multiple customers

<object type="hash"> 
  <customer type="hash">
    <id>24233</id>
    <taxID>0</taxID>
    <billTo type="hash">
      <mtime>2013-11-11T17:27:36Z</mtime>
    </billTo>
  </customer>
  <lines type="list">
    <object type="hash">
      <qty type="integer">12</qty>
      <owner>johnd@nowhere.com</owner>
      <sku>746</sku>
    </object>
    <object type="hash">
      <qty type="integer">24</qty>
      <owner>johnd@nowhere.com</owner>
      <sku>748</sku>
    </object>
  </lines>
  <customer type="hash">
    <id>9876</id>
    <taxID>1</taxID>
    <billTo type="hash">
      <mtime>2001-11-11T17:27:36Z</mtime>
    </billTo>
  </customer>
  <lines type="list">
    <object type="hash">
      <qty type="integer">19.234</qty>
      <owner>janed@nowhere.com</owner>
      <sku>456</sku>
    </object>
    <object type="hash">
      <qty type="integer">24.56</qty>
      <owner>janed@nowhere.com</owner>
      <sku>123</sku>
    </object>
  </lines>
</object>

Open in new window


With the assumption that the first customer node synchs with the first lines node,  the second customer node synchs with the second lines node and so on.


Again, if it's not correct, please adjust and explain.
These are easy to parse to get the results you want, I just need clarification as to what you really want it to do.


Assuming all of my guesses are right, then you could use something like this...

SELECT c.id,
       c.taxid,
       c.mtime,
       o.owner,
       o.sku,
       o.qty
  FROM table_with_xml_column t,
       XMLTABLE(
           '//customer'
           PASSING t.xml_document
           COLUMNS cust_seq FOR ORDINALITY,
                   id NUMBER PATH '/customer/id',
                   taxid NUMBER PATH '/customer/taxID',
                   mtime VARCHAR2(50) PATH '/customer/billTo/mtime'
       ) c,
       XMLTABLE(
           '//lines'
           PASSING t.xml_document
           COLUMNS line_seq FOR ORDINALITY, node XMLTYPE PATH '.'
       ) l,
       XMLTABLE(
           '//object'
           PASSING l.node
           COLUMNS owner VARCHAR2(50) PATH '/object/owner',
                   sku NUMBER PATH '/object/sku',
                   qty NUMBER PATH '/object/qty'
       ) o
 WHERE filename = 'output.xml' AND l.line_seq = c.cust_seq

Open in new window


This query with the this data produces these results

24233	0	2013-11-11T17:27:36Z	johnd@nowhere.com	746	12
24233	0	2013-11-11T17:27:36Z	johnd@nowhere.com	748	24
9876	1	2001-11-11T17:27:36Z	janed@nowhere.com	456	19.234
9876	1	2001-11-11T17:27:36Z	janed@nowhere.com	123	24.56

Open in new window

0
 
LVL 73

Expert Comment

by:sdstuber
ID: 39689096
A "B" grade is not appropriate
0
 

Author Comment

by:FutureDBA-
ID: 39689992
that my friend, was a mistake.  I always give you an A
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Create index on View 27 52
Single ERP VS muttiple Application or Systems 6 40
Clone Oracle 12c Database 5 27
sql query 9 22
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now