se/SE/schema/ant-object/default_db.InvestArrangements/InvestArrangements/InvestArrangements.xsd

<?xml version="1.0" encoding="UTF-8"?>
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema"
           xmlns:gml="http://www.opengis.net/gml/3.2"
           xmlns:Types__x3A__default_Default="https://biuro.biall-net.pl/wfs/default_db/Types/Default.xsd"
           xmlns:default_db__x3A__IN7_DZIENNIK_KORESP="https://biuro.biall-net.pl/wfs/default_db/table/IN7_DZIENNIK_KORESP.xsd"
           xmlns:hfp="http://www.w3.org/2001/XMLSchema-hasFacetAndProperty"
           xmlns:default_db__x3A__ADMIN_USERS="https://biuro.biall-net.pl/wfs/default_db/table/ADMIN_USERS.xsd"
           xmlns:default_db__x3A__IN7_MK_BAZA_DYSTRYBUCJI="https://biuro.biall-net.pl/wfs/default_db/table/IN7_MK_BAZA_DYSTRYBUCJI.xsd"
           xmlns:SystemObjects__x3A__AccessGroup="https://biuro.biall-net.pl/wfs/default_db/SystemObjects/AccessGroup.xsd"
           xmlns:SystemObjects__x3A__AccessOwner="https://biuro.biall-net.pl/wfs/default_db/SystemObjects/AccessOwner.xsd"
           xmlns:default_db__x3A__InvestArrangements="https://biuro.biall-net.pl/wfs/default_db/table/InvestArrangements.xsd"
           xmlns:default_db__x3A__Rozdzielcza_Dzialki="https://biuro.biall-net.pl/wfs/default_db/table/Rozdzielcza_Dzialki.xsd"
           xmlns:default_db__x3A__Rozdzielcza_rurociagi_obce_wsg84="https://biuro.biall-net.pl/wfs/default_db/table/Rozdzielcza_rurociagi_obce_wsg84.xsd"
           xmlns:default_db__x3A__CRM_LISTA_ZASOBOW_OFFERS="https://biuro.biall-net.pl/wfs/default_db/table/CRM_LISTA_ZASOBOW_OFFERS.xsd"
           xmlns:default_db__x3A__Dzialki="https://biuro.biall-net.pl/wfs/default_db/table/Dzialki.xsd"
           xmlns:default_db__x3A__rurociagi_obce_wsg84="https://biuro.biall-net.pl/wfs/default_db/table/rurociagi_obce_wsg84.xsd"
           xmlns:default_db__x3A__BUILDINGS="https://biuro.biall-net.pl/wfs/default_db/table/BUILDINGS.xsd"
           xmlns:fix_se_defaultdb_schema="http://biuro.biall-net.pl/xmlschema_procesy5/WPS_Functions/fix_se_defaultdb_schema/fix_se_defaultdb_schema.xsd"
           xmlns:p5Type="http://biuro.biall-net.pl/p5/schema/types"
           xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
           xmlns:p5_tr_map="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/procesy5_translate_map.xsd"
           xmlns:vc="http://www.w3.org/2007/XMLSchema-versioning"
           xmlns:system_cache__resources_tree_generate_xsl_required_occurs_raport="http://biuro.biall-net.pl/xmlschema_procesy5/system_cache/resources_tree_generate_xsl_require_occurs_raport"
           xmlns:system_cache__appinfo="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/appinfo.xsd"
           xmlns:p5opr="http://biuro.biall-net.pl/xmlschema_procesy5/system_cache/object_parent_relations/object_parent_relations.xsd"
           xmlns:p5_simpleSchema_map="http://biuro.biall-net.pl/xmlschema_procesy5/default_db_xml_cache/p5_simpleSchema_map.xsd"
           xmlns:ant-object="http://biuro.biall-net.pl/xmlschema_procesy5/ant-object/ant-object.xsd"
           xmlns:p5ant-interface="http://biuro.biall-net.pl/xmlschema_procesy5/WPS_Functions/ant_interface/ant_interface.xsd"
           targetNamespace="https://biuro.biall-net.pl/wfs/default_db/table/InvestArrangements.xsd"
           vc:minVersion="1.1">
   <xs:import namespace="http://biuro.biall-net.pl/p5/schema/types"
              schemaLocation="../../../types.xsd"/>
   <xs:import namespace="http://www.opengis.net/gml/3.2"
              schemaLocation="http://www.opengis.net/gml/3.2"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/Dzialki.xsd"
              schemaLocation="../../default_db.Dzialki/Dzialki/Dzialki.xsd"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/IN7_DZIENNIK_KORESP.xsd"
              schemaLocation="../../default_db.IN7_DZIENNIK_KORESP/IN7_DZIENNIK_KORESP/IN7_DZIENNIK_KORESP.xsd"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/CRM_LISTA_ZASOBOW_OFFERS.xsd"
              schemaLocation="../../default_db.CRM_LISTA_ZASOBOW_OFFERS/CRM_LISTA_ZASOBOW_OFFERS/CRM_LISTA_ZASOBOW_OFFERS.xsd"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/rurociagi_obce_wsg84.xsd"
              schemaLocation="../../default_db.rurociagi_obce_wsg84/rurociagi_obce_wsg84/rurociagi_obce_wsg84.xsd"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/BUILDINGS.xsd"
              schemaLocation="../../default_db.BUILDINGS/BUILDINGS/BUILDINGS.xsd"/>
   <xs:import namespace="https://biuro.biall-net.pl/wfs/default_db/table/ADMIN_USERS.xsd"
              schemaLocation="../../default_db.ADMIN_USERS/ADMIN_USERS/ADMIN_USERS.xsd"/>
   <xs:simpleType name="A_STATUS_Type" id="rrangements___d4e7067-1_A_STATUS_T">
      <xs:restriction base="xs:string"/>
   </xs:simpleType>
   <xs:complexType name="InvestArrangements" id="rrangements___d4e7069-1_InvestArra"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
      <xs:annotation>
         <xs:documentation>Instancyjny - Protopyowy obiekt, który powinien mieć typy konkretnych
            rodzaji dla różnych technologii. Podzielony z uwagi na stany projektowania oraz
            realizacji. </xs:documentation>
         <xs:appinfo>
            <system_cache__appinfo:heritage>
               <system_cache__appinfo:inherit system_cache__appinfo:inherit_ref="default_db:InvestArrangements"
                                              system_cache__appinfo:heritage_acl="true">
                  <system_cache__appinfo:acl_rule_inherit_to_all_same_name_elements_and_refs/>
                  <acl_rule_inherit_to_all_refs_by_primary/>
                  <acl_rule_inherit_to_all_refs_by_local_element system_cache__appinfo:acl_rule_inherit_local_element_name="A_ADM_COMPANY"/>
               </system_cache__appinfo:inherit>
               <system_cache__appinfo:exherit_all system_cache__appinfo:heritage_acl="true"
                                                  system_cache__appinfo:heritage_sort="true"/>
            </system_cache__appinfo:heritage>
         </xs:appinfo>
      </xs:annotation>
      <xs:sequence id="rrangements___d4e7073-1">
         <xs:element minOccurs="0"
                     maxOccurs="1"
                     name="ID"
                     type="xs:int"
                     id="rrangements___d4e7074-1_ID"/>
         <xs:element name="A_STATUS"
                     type="default_db__x3A__InvestArrangements:A_STATUS_Type"
                     id="rrangements___d4e7075-1_A_STATUS"
                     minOccurs="0"/>
         <xs:element name="A_STATUS_INFO"
                     type="xs:string"
                     id="rrangements___d4e7076-1_A_STATUS_I"
                     minOccurs="0"/>
         <xs:element minOccurs="0"
                     name="L_APPOITMENT_USER"
                     type="xs:string"
                     id="rrangements___d4e7077-1_L_APPOITME"/>
         <xs:element ref="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER"
                     minOccurs="0"
                     id="rrangements___d18e36580-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                   system_cache__appinfo:name="L_APPOITMENT_USER"
                                                   system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER/ADM_ACCOUNT"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
               <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #166
                </xs:documentation>
            </xs:annotation>
         </xs:element>
         <!--<xs:element ref="SystemObjects__x3A__AccessOwner:AccessOwner"
                     id="rrangements___d4e7078-1">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="L_APPOITMENT_USER"
                                                   system_cache__appinfo:ref_engine="view"
                                                   system_cache__appinfo:xpath="SystemObjects__x3A__AccessOwner:AccessOwner/name"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>-->
         <xs:element minOccurs="0"
                     name="A_CLASSIFIED"
                     type="xs:string"
                     id="rrangements___d4e7083-1_A_CLASSIFI"/>
         <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupRead"
                     id="rrangements___d4e7084-1">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="A_CLASSIFIED"
                                                   system_cache__appinfo:ref_engine="view"
                                                   system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupRead/name"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>-->
         <xs:element minOccurs="0"
                     name="A_ADM_COMPANY"
                     type="xs:string"
                     id="rrangements___d4e7089-1_A_ADM_COMP"/>
         <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupWrite"
                     id="rrangements___d4e7090-1">
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="A_ADM_COMPANY"
                                                   system_cache__appinfo:ref_engine="view"
                                                   system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupWrite/name"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>-->
         <xs:element minOccurs="0"
                     name="ID_OFFER"
                     type="xs:int"
                     id="rrangements___d4e7099-1_ID_OFFER"/>
         <xs:element ref="default_db__x3A__CRM_LISTA_ZASOBOW_OFFERS:CRM_LISTA_ZASOBOW_OFFERS"
                     minOccurs="0"
                     id="rrangements___d4e7100-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="ID_OFFER"
                                                   system_cache__appinfo:ref_engine="view"
                                                   system_cache__appinfo:xpath="default_db__x3A__CRM_LISTA_ZASOBOW_OFFERS:CRM_LISTA_ZASOBOW_OFFERS/ID"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
               <xs:documentation>Oznaczenie elementu oferty w ramach ktorej wystepuje dane
                  uzgodnienie/kolizja/przeciecie</xs:documentation>
            </xs:annotation>
         </xs:element>
         <xs:element minOccurs="0"
                     name="ID_KORESP_INVEST_ARRANGEMENT_DEAL"
                     type="xs:int"
                     id="rrangements___d4e7107-1_ID_KORESP_"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
            <xs:annotation>
               <xs:documentation>Powiazany natywny numer korespondencji</xs:documentation>
            </xs:annotation>
         </xs:element>
         <xs:element ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_INVEST_ARRANGEMENT_DEAL"
                     minOccurs="0"
                     id="rrangements___d18e36605-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache system_cache__appinfo:backref_evaluate="true">
                     <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                   system_cache__appinfo:name="ID_KORESP_INVEST_ARRANGEMENT_DEAL"
                                                   system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_INVEST_ARRANGEMENT_DEAL"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
               <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #245 !!!
                </xs:documentation>
            </xs:annotation>
         </xs:element>
         <xs:element minOccurs="0"
                     name="ID_BUILDINGS"
                     type="xs:int"
                     id="rrangements___d4e7108-1_ID_BUILDIN"/>
         <xs:element ref="default_db__x3A__BUILDINGS:BUILDINGS"
                     minOccurs="0"
                     id="rrangements___d4e7109-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="ID_BUILDINGS"
                                                   system_cache__appinfo:ref_engine="view"
                                                   system_cache__appinfo:xpath="default_db__x3A__BUILDINGS:BUILDINGS/ID"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
               <xs:documentation>Obiekt dzialki, z ktorym jest kolizja -
                  uzgodnienie</xs:documentation>
            </xs:annotation>
         </xs:element>
         <xs:element minOccurs="0"
                     name="ID_Dzialki"
                     type="xs:int"
                     id="rrangements___d4e7116-1_ID_Dzialki"/>
         <xs:element ref="default_db__x3A__Dzialki:Dzialki_Known"
                     minOccurs="0"
                     id="rrangements___d4e7117-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
            <xs:annotation>
               <xs:documentation>Obiekt dzialki, z ktorym jest kolizja -
                  uzgodnienie</xs:documentation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="ID_Dzialki"
                                                   system_cache__appinfo:ref_engine="view"
                                                   system_cache__appinfo:xpath="default_db__x3A__Dzialki:Dzialki_Known/ID"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
            </xs:annotation>
         </xs:element>
         <xs:element minOccurs="0"
                     name="ID_rurociagi_obce_wsg84_Known"
                     type="xs:int"
                     id="rrangements___d4e7124-1_ID_rurocia"/>
         <xs:element ref="default_db__x3A__rurociagi_obce_wsg84:rurociagi_obce_wsg84_Known"
                     minOccurs="0"
                     id="rrangements___d4e7125-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
            <xs:annotation>
               <xs:appinfo>
                  <system_cache__appinfo:flat_relation_cache>
                     <system_cache__appinfo:source system_cache__appinfo:name="ID_rurociagi_obce_wsg84_Known"
                                                   system_cache__appinfo:ref_engine="view"
                                                   system_cache__appinfo:xpath="default_db__x3A__rurociagi_obce_wsg84:rurociagi_obce_wsg84_Known/ID"/>
                  </system_cache__appinfo:flat_relation_cache>
               </xs:appinfo>
               <xs:documentation>Obiekt dzialki, z ktorym jest kolizja -
                  uzgodnienie</xs:documentation>
            </xs:annotation>
         </xs:element>
         <xs:element minOccurs="0"
                     name="CoverArea"
                     type="xs:double"
                     id="rrangements___d4e7132-1_CoverArea"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
            <xs:annotation>
               <xs:documentation>W przypadku powierzchni zajecia - jest to wartosc odpowiadajaca tej
                  powierzchni</xs:documentation>
            </xs:annotation>
         </xs:element>
         <xs:element minOccurs="0"
                     name="CoverLength"
                     type="xs:double"
                     id="rrangements___d4e7136-1_CoverLengt"/>
         <xs:element minOccurs="0"
                     name="CloseupDistance"
                     type="xs:double"
                     id="rrangements___d4e7138-1_CloseupDis"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
            <xs:annotation>
               <xs:documentation>Wyliczona odleglosc do zblizenia</xs:documentation>
            </xs:annotation>
         </xs:element>
         <xs:element minOccurs="0"
                     name="INWDZ__ustalono_odszkodowanie"
                     type="xs:double"
                     id="rrangements___d18e36646-1_INWDZ__ust"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
            <xs:annotation>
               <xs:documentation>TODO pole cache z kwota z oferty - dziedziczone do kontroli spraw</xs:documentation>
            </xs:annotation>
         </xs:element>
         <xs:element minOccurs="0"
                     name="INWDZ__max_odszkodowanie"
                     type="xs:double"
                     id="rrangements___d18e36650-1_INWDZ__max"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
            <xs:annotation>
               <xs:documentation>TODO pole cache z kwota z oferty - dziedziczone do kontroli spraw</xs:documentation>
            </xs:annotation>
         </xs:element>
      </xs:sequence>
   </xs:complexType>
   <xs:element name="InvestArrangements"
               type="default_db__x3A__InvestArrangements:InvestArrangements"
               id="rrangements___d4e7142-1_InvestArra"/>
   <xs:complexType name="InvestArrangements_Network_Crossings"
                   id="rrangements___d4e7144-1_InvestArra">
      <xs:complexContent id="rrangements___d4e7145-1">
         <xs:restriction base="default_db__x3A__InvestArrangements:InvestArrangements">
            <xs:sequence id="rrangements___d4e7147-1">
               <xs:element minOccurs="0"
                           maxOccurs="1"
                           name="ID"
                           type="xs:int"
                           id="rrangements___d4e7148-1_ID"/>
               <xs:element minOccurs="0"
                           name="A_STATUS"
                           type="default_db__x3A__InvestArrangements:A_STATUS_Type"
                           id="rrangements___d4e7149-1_A_STATUS"/>
               <xs:element minOccurs="0"
                           name="A_STATUS_INFO"
                           type="xs:string"
                           id="rrangements___d4e7150-1_A_STATUS_I"/>
               <xs:element minOccurs="0"
                           name="L_APPOITMENT_USER"
                           type="xs:string"
                           id="rrangements___d4e7151-1_L_APPOITME"/>
               <xs:element ref="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER"
                           id="rrangements___d18e36664-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="L_APPOITMENT_USER"
                                                         system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER/ADM_ACCOUNT"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #166
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <!--<xs:element ref="SystemObjects__x3A__AccessOwner:AccessOwner"
                  id="rrangements___d4e7152-1">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="L_APPOITMENT_USER" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="SystemObjects__x3A__AccessOwner:AccessOwner/name"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>-->
               <xs:element minOccurs="0"
                           name="A_CLASSIFIED"
                           type="xs:string"
                           id="rrangements___d4e7157-1_A_CLASSIFI"/>
               <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupRead"
                  id="rrangements___d4e7158-1">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="A_CLASSIFIED" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupRead/name"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>-->
               <xs:element minOccurs="0"
                           name="A_ADM_COMPANY"
                           type="xs:string"
                           id="rrangements___d4e7163-1_A_ADM_COMP"/>
               <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupWrite"
                  id="rrangements___d4e7164-1">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="A_ADM_COMPANY" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupWrite/name"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>-->
               <xs:element minOccurs="0"
                           name="ID_OFFER"
                           type="xs:int"
                           id="rrangements___d4e7172-1_ID_OFFER"/>
               <xs:element ref="default_db__x3A__CRM_LISTA_ZASOBOW_OFFERS:CRM_LISTA_ZASOBOW_OFFERS"
                           minOccurs="0"
                           id="rrangements___d4e7173-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="ID_OFFER"
                                                         system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:xpath="default_db__x3A__CRM_LISTA_ZASOBOW_OFFERS:CRM_LISTA_ZASOBOW_OFFERS/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>Oznaczenie elementu oferty w ramach ktorej wystepuje dane
                        uzgodnienie/kolizja/przeciecie</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="ID_KORESP_INVEST_ARRANGEMENT_DEAL"
                           type="xs:int"
                           id="rrangements___d4e7180-1_ID_KORESP_"/>
               <xs:element ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_INVEST_ARRANGEMENT_DEAL"
                           id="rrangements___d18e36686-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache system_cache__appinfo:backref_evaluate="true">
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="ID_KORESP_INVEST_ARRANGEMENT_DEAL"
                                                         system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_INVEST_ARRANGEMENT_DEAL"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #245 !!!
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="ID_BUILDINGS"
                           type="xs:int"
                           id="rrangements___d4e7181-1_ID_BUILDIN"/>
               <xs:element ref="default_db__x3A__BUILDINGS:BUILDINGS"
                           minOccurs="0"
                           maxOccurs="0"
                           id="rrangements___d4e7182-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="ID_BUILDINGS"
                                                         system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:xpath="default_db__x3A__BUILDINGS:BUILDINGS/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="ID_Dzialki"
                           type="xs:int"
                           id="rrangements___d4e7187-1_ID_Dzialki"/>
               <xs:element ref="default_db__x3A__Dzialki:Dzialki_Known"
                           minOccurs="0"
                           maxOccurs="0"
                           id="rrangements___d4e7188-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="ID_Dzialki"
                                                         system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:xpath="default_db__x3A__Dzialki:Dzialki_Known/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>Obiekt dzialki, z ktorym jest kolizja -
                        uzgodnienie</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="ID_rurociagi_obce_wsg84_Known"
                           type="xs:int"
                           id="rrangements___d4e7195-1_ID_rurocia"/>
               <xs:element ref="default_db__x3A__rurociagi_obce_wsg84:rurociagi_obce_wsg84_Known"
                           minOccurs="1"
                           id="rrangements___d4e7196-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="ID_rurociagi_obce_wsg84_Known"
                                                         system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:xpath="default_db__x3A__rurociagi_obce_wsg84:rurociagi_obce_wsg84_Known/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>Obiekt dzialki, z ktorym jest kolizja -
                        uzgodnienie</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="CoverArea"
                           type="xs:double"
                           id="rrangements___d4e7203-1_CoverArea"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:documentation>W przypadku powierzchni zajecia - jest to wartosc
                        odpowiadajaca tej powierzchni</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="CoverLength"
                           type="xs:double"
                           id="rrangements___d4e7207-1_CoverLengt"/>
               <xs:element minOccurs="0"
                           name="CloseupDistance"
                           type="xs:double"
                           id="rrangements___d4e7209-1_CloseupDis"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:documentation>Wyliczona odleglosc do zblizenia</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="INWDZ__ustalono_odszkodowanie"
                           type="xs:double"
                           id="rrangements___d18e36725-1_INWDZ__ust"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:documentation>TODO pole cache z kwota z oferty - dziedziczone do kontroli spraw</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="INWDZ__max_odszkodowanie"
                           type="xs:double"
                           id="rrangements___d18e36729-1_INWDZ__max"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:documentation>TODO pole cache z kwota z oferty - dziedziczone do kontroli spraw</xs:documentation>
                  </xs:annotation>
               </xs:element>
            </xs:sequence>
         </xs:restriction>
      </xs:complexContent>
   </xs:complexType>
   <xs:element name="InvestArrangements_Network_Crossings"
               type="default_db__x3A__InvestArrangements:InvestArrangements_Network_Crossings"
               id="rrangements___d4e7213-1_InvestArra"/>
   <xs:complexType name="InvestArrangements_Infrastructure_Placement_Ground"
                   id="rrangements___d4e7214-1_InvestArra"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
      <xs:annotation>
         <xs:documentation>Relacja tylko do dzialki</xs:documentation>
      </xs:annotation>
      <xs:complexContent id="rrangements___d4e7218-1">
         <xs:restriction base="default_db__x3A__InvestArrangements:InvestArrangements">
            <xs:sequence id="rrangements___d4e7220-1">
               <xs:element minOccurs="0"
                           maxOccurs="1"
                           name="ID"
                           type="xs:int"
                           id="rrangements___d4e7221-1_ID"/>
               <xs:element minOccurs="0"
                           name="A_STATUS"
                           type="default_db__x3A__InvestArrangements:A_STATUS_Type"
                           id="rrangements___d4e7222-1_A_STATUS"/>
               <xs:element minOccurs="0"
                           name="A_STATUS_INFO"
                           type="xs:string"
                           id="rrangements___d4e7223-1_A_STATUS_I"/>
               <xs:element minOccurs="0"
                           name="L_APPOITMENT_USER"
                           type="xs:string"
                           id="rrangements___d4e7224-1_L_APPOITME"/>
               <xs:element ref="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER"
                           id="rrangements___d18e36745-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="L_APPOITMENT_USER"
                                                         system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER/ADM_ACCOUNT"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #166
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <!--<xs:element ref="SystemObjects__x3A__AccessOwner:AccessOwner"
                  id="rrangements___d4e7225-1">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="L_APPOITMENT_USER" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="SystemObjects__x3A__AccessOwner:AccessOwner/name"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>-->
               <xs:element minOccurs="0"
                           name="A_CLASSIFIED"
                           type="xs:string"
                           id="rrangements___d4e7230-1_A_CLASSIFI"/>
               <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupRead"
                  id="rrangements___d4e7231-1">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="A_CLASSIFIED" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupRead/name"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>-->
               <xs:element minOccurs="0"
                           name="A_ADM_COMPANY"
                           type="xs:string"
                           id="rrangements___d4e7236-1_A_ADM_COMP"/>
               <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupWrite"
                  id="rrangements___d4e7237-1">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="A_ADM_COMPANY" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupWrite/name"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>-->
               <xs:element minOccurs="0"
                           name="ID_OFFER"
                           type="xs:int"
                           id="rrangements___d4e7246-1_ID_OFFER"/>
               <xs:element ref="default_db__x3A__CRM_LISTA_ZASOBOW_OFFERS:CRM_LISTA_ZASOBOW_OFFERS"
                           minOccurs="0"
                           id="rrangements___d4e7247-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="ID_OFFER"
                                                         system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:xpath="default_db__x3A__CRM_LISTA_ZASOBOW_OFFERS:CRM_LISTA_ZASOBOW_OFFERS/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>Oznaczenie elementu oferty w ramach ktorej wystepuje dane
                        uzgodnienie/kolizja/przeciecie</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="ID_KORESP_INVEST_ARRANGEMENT_DEAL"
                           type="xs:int"
                           id="rrangements___d4e7254-1_ID_KORESP_"/>
               <xs:element ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_INVEST_ARRANGEMENT_DEAL"
                           id="rrangements___d18e36767-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache system_cache__appinfo:backref_evaluate="true">
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="ID_KORESP_INVEST_ARRANGEMENT_DEAL"
                                                         system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_INVEST_ARRANGEMENT_DEAL"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #245 !!!
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="ID_BUILDINGS"
                           type="xs:int"
                           id="rrangements___d4e7255-1_ID_BUILDIN"/>
               <xs:element ref="default_db__x3A__BUILDINGS:BUILDINGS"
                           minOccurs="0"
                           maxOccurs="0"
                           id="rrangements___d4e7256-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="ID_BUILDINGS"
                                                         system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:xpath="default_db__x3A__BUILDINGS:BUILDINGS/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>Oznaczenie elementu oferty w ramach ktorej wystepuje dane
                        uzgodnienie/kolizja/przeciecie</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="ID_Dzialki"
                           type="xs:int"
                           id="rrangements___d4e7263-1_ID_Dzialki"/>
               <xs:element ref="default_db__x3A__Dzialki:Dzialki_Known"
                           minOccurs="1"
                           id="rrangements___d4e7264-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:documentation>Obiekt dzialki, z ktorym jest kolizja -
                        uzgodnienie</xs:documentation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="ID_Dzialki"
                                                         system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:xpath="default_db__x3A__Dzialki:Dzialki_Known/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="ID_rurociagi_obce_wsg84_Known"
                           type="xs:int"
                           id="rrangements___d4e7271-1_ID_rurocia"/>
               <xs:element ref="default_db__x3A__rurociagi_obce_wsg84:rurociagi_obce_wsg84_Known"
                           minOccurs="0"
                           maxOccurs="0"
                           id="rrangements___d4e7272-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="ID_rurociagi_obce_wsg84_Known"
                                                         system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:xpath="default_db__x3A__rurociagi_obce_wsg84:rurociagi_obce_wsg84_Known/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>Obiekt dzialki, z ktorym jest kolizja -
                        uzgodnienie</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="CoverArea"
                           type="xs:double"
                           id="rrangements___d4e7279-1_CoverArea"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:documentation>W przypadku powierzchni zajecia - jest to wartosc
                        odpowiadajaca tej powierzchni</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="CoverLength"
                           type="xs:double"
                           id="rrangements___d4e7283-1_CoverLengt"/>
               <xs:element minOccurs="0"
                           name="CloseupDistance"
                           type="xs:double"
                           id="rrangements___d4e7285-1_CloseupDis"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:documentation>Wyliczona odleglosc do zblizenia</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="INWDZ__ustalono_odszkodowanie"
                           type="xs:double"
                           id="rrangements___d18e36808-1_INWDZ__ust"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:documentation>TODO pole cache z kwota z oferty - dziedziczone do kontroli spraw</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="INWDZ__max_odszkodowanie"
                           type="xs:double"
                           id="rrangements___d18e36812-1_INWDZ__max"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:documentation>TODO pole cache z kwota z oferty - dziedziczone do kontroli spraw</xs:documentation>
                  </xs:annotation>
               </xs:element>
            </xs:sequence>
         </xs:restriction>
      </xs:complexContent>
   </xs:complexType>
   <xs:element name="InvestArrangements_Infrastructure_Placement_Ground"
               type="default_db__x3A__InvestArrangements:InvestArrangements_Infrastructure_Placement_Ground"
               id="rrangements___d4e7289-1_InvestArra"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
      <xs:annotation>
         <xs:documentation>W relacji od KORESP - DEAL arrang....</xs:documentation>
      </xs:annotation>
   </xs:element>
   <xs:complexType name="InvestArrangements_Infrastructure_Placement_Buildings"
                   id="rrangements___d4e7293-1_InvestArra"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
      <xs:annotation>
         <xs:documentation>tylko relacja do budynkow</xs:documentation>
      </xs:annotation>
      <xs:complexContent id="rrangements___d4e7297-1">
         <xs:restriction base="default_db__x3A__InvestArrangements:InvestArrangements">
            <xs:sequence id="rrangements___d4e7299-1">
               <xs:element minOccurs="0"
                           maxOccurs="1"
                           name="ID"
                           type="xs:int"
                           id="rrangements___d4e7300-1_ID"/>
               <xs:element minOccurs="0"
                           name="A_STATUS"
                           type="default_db__x3A__InvestArrangements:A_STATUS_Type"
                           id="rrangements___d4e7301-1_A_STATUS"/>
               <xs:element minOccurs="0"
                           name="A_STATUS_INFO"
                           type="xs:string"
                           id="rrangements___d4e7302-1_A_STATUS_I"/>
               <xs:element minOccurs="0"
                           name="L_APPOITMENT_USER"
                           type="xs:string"
                           id="rrangements___d4e7303-1_L_APPOITME"/>
               <xs:element ref="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER"
                           id="rrangements___d18e36831-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="L_APPOITMENT_USER"
                                                         system_cache__appinfo:xpath="default_db__x3A__ADMIN_USERS:L_APPOITMENT_USER/ADM_ACCOUNT"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #166
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <!--<xs:element ref="SystemObjects__x3A__AccessOwner:AccessOwner"
                  id="rrangements___d4e7304-1">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="L_APPOITMENT_USER" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="SystemObjects__x3A__AccessOwner:AccessOwner/name"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>-->
               <xs:element minOccurs="0"
                           name="A_CLASSIFIED"
                           type="xs:string"
                           id="rrangements___d4e7309-1_A_CLASSIFI"/>
               <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupRead"
                  id="rrangements___d4e7310-1">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="A_CLASSIFIED" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupRead/name"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>-->
               <xs:element minOccurs="0"
                           name="A_ADM_COMPANY"
                           type="xs:string"
                           id="rrangements___d4e7315-1_A_ADM_COMP"/>
               <!--<xs:element ref="SystemObjects__x3A__AccessGroup:AccessGroupWrite"
                  id="rrangements___d4e7316-1">
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="A_ADM_COMPANY" system_cache__appinfo:ref_engine="view" system_cache__appinfo:xpath="SystemObjects__x3A__AccessGroup:AccessGroupWrite/name"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                  </xs:annotation>
               </xs:element>-->
               <xs:element minOccurs="0"
                           name="ID_OFFER"
                           type="xs:int"
                           id="rrangements___d4e7325-1_ID_OFFER"/>
               <xs:element ref="default_db__x3A__CRM_LISTA_ZASOBOW_OFFERS:CRM_LISTA_ZASOBOW_OFFERS"
                           minOccurs="0"
                           id="rrangements___d4e7326-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="ID_OFFER"
                                                         system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:xpath="default_db__x3A__CRM_LISTA_ZASOBOW_OFFERS:CRM_LISTA_ZASOBOW_OFFERS/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>Oznaczenie elementu oferty w ramach ktorej wystepuje dane
                        uzgodnienie/kolizja/przeciecie</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="ID_KORESP_INVEST_ARRANGEMENT_DEAL"
                           type="xs:int"
                           id="rrangements___d4e7333-1_ID_KORESP_"/>
               <xs:element ref="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_INVEST_ARRANGEMENT_DEAL"
                           id="rrangements___d18e36853-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache system_cache__appinfo:backref_evaluate="true">
                           <system_cache__appinfo:source system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:name="ID_KORESP_INVEST_ARRANGEMENT_DEAL"
                                                         system_cache__appinfo:xpath="default_db__x3A__IN7_DZIENNIK_KORESP:ID_KORESP_INVEST_ARRANGEMENT_DEAL"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>
                    TODO CHECK IF THIS IS CORRECT FLAT RELATION! WAS GENERATED #245 !!!
                </xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="ID_BUILDINGS"
                           type="xs:int"
                           id="rrangements___d4e7334-1_ID_BUILDIN"/>
               <xs:element ref="default_db__x3A__BUILDINGS:BUILDINGS"
                           minOccurs="1"
                           id="rrangements___d4e7335-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="ID_BUILDINGS"
                                                         system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:xpath="default_db__x3A__BUILDINGS:BUILDINGS/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>Oznaczenie elementu oferty w ramach ktorej wystepuje dane
                        uzgodnienie/kolizja/przeciecie</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="ID_Dzialki"
                           type="xs:int"
                           id="rrangements___d4e7336-1_ID_Dzialki"/>
               <xs:element ref="default_db__x3A__Dzialki:Dzialki_Known"
                           minOccurs="0"
                           maxOccurs="0"
                           id="rrangements___d4e7337-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="ID_Dzialki"
                                                         system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:xpath="default_db__x3A__Dzialki:Dzialki_Known/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>Obiekt dzialki, z ktorym jest kolizja -
                        uzgodnienie</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="ID_rurociagi_obce_wsg84_Known"
                           type="xs:int"
                           id="rrangements___d4e7341-1_ID_rurocia"/>
               <xs:element ref="default_db__x3A__rurociagi_obce_wsg84:rurociagi_obce_wsg84_Known"
                           minOccurs="0"
                           maxOccurs="0"
                           id="rrangements___d4e7342-1"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:appinfo>
                        <system_cache__appinfo:flat_relation_cache>
                           <system_cache__appinfo:source system_cache__appinfo:name="ID_rurociagi_obce_wsg84_Known"
                                                         system_cache__appinfo:ref_engine="view"
                                                         system_cache__appinfo:xpath="default_db__x3A__rurociagi_obce_wsg84:rurociagi_obce_wsg84_Known/ID"/>
                        </system_cache__appinfo:flat_relation_cache>
                     </xs:appinfo>
                     <xs:documentation>Obiekt dzialki, z ktorym jest kolizja -
                        uzgodnienie</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="CoverArea"
                           type="xs:double"
                           id="rrangements___d4e7349-1_CoverArea"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:documentation>W przypadku powierzchni zajecia - jest to wartosc
                        odpowiadajaca tej powierzchni</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="CoverLength"
                           type="xs:double"
                           id="rrangements___d4e7353-1_CoverLengt"/>
               <xs:element minOccurs="0"
                           name="CloseupDistance"
                           type="xs:double"
                           id="rrangements___d4e7355-1_CloseupDis"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:documentation>Wyliczona odleglosc do zblizenia</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="INWDZ__ustalono_odszkodowanie"
                           type="xs:double"
                           id="rrangements___d18e36894-1_INWDZ__ust"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:documentation>TODO pole cache z kwota z oferty - dziedziczone do kontroli spraw</xs:documentation>
                  </xs:annotation>
               </xs:element>
               <xs:element minOccurs="0"
                           name="INWDZ__max_odszkodowanie"
                           type="xs:double"
                           id="rrangements___d18e36898-1_INWDZ__max"><!--#375 match annotation with (prefix:xs);(root/schema/@xmlns=())-->
                  <xs:annotation>
                     <xs:documentation>TODO pole cache z kwota z oferty - dziedziczone do kontroli spraw</xs:documentation>
                  </xs:annotation>
               </xs:element>
            </xs:sequence>
         </xs:restriction>
      </xs:complexContent>
   </xs:complexType>
   <xs:element name="InvestArrangements_Infrastructure_Placement_Buildings"
               type="default_db__x3A__InvestArrangements:InvestArrangements_Infrastructure_Placement_Buildings"
               id="rrangements___d4e7359-1_InvestArra"/>
</xs:schema>