sql
<?xml version="1.0" encoding="utf-8" ?>
<root>
<!--【说明1】：提取登记簿数据源配置，不依赖任何后台代码逻辑，完全靠配置去实现，配置项中格式如"{***}的代表特殊的变量，现已用到的变量有：业务号{YWH}；不动产单元号{BDCDYH}；登记簿权利标识码{QLBSM}；登记库权利标识码{DJQLBSM}；区县代码{QXDM}；服务器编码{FWQBM}；登记簿权利表名{QLBM}；特殊语句{ESPECIALSQL}。"-->
<!--【说明2】：变量除特殊语句取值来源于TableRuleMapJRBH.xml配置文件中的especialsql属性外。-->
<!--【说明3】：关于 CaseWhen 标签的用法，由于不同的权利注销所取的表字段有差异，为了更灵活的配置，自定义 CaseWhen 语法结构,返回符合第一个匹配项所设定的语句，相同的When条件可以用字符"$"隔开。目前可以Case的变量只限定于说明1中提到的变量。 -->
<Table No="表1" Name="YSDM" tablemark="" mustfillfield="" description="此配置项是个虚拟配置，作为表序号占位项，与部里接入文档中的表序列保持一致。"></Table>
<!--FDCQ1,FDCQ2,TDSYQ,JSYDSY,LQ,NYDSYQ,ZLSYQ 获取宗地基本信息-->
<Table No="表2" Name="ZDJBXX" tablemark="ZDJBXX_QL" mustfillfield="" description="宗地基本信息表(房地产权业务，纯地业务)。">
<![CDATA[ SELECT * FROM BDCDJB.ZDJBXX D WHERE EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.ZDJBXXBSM=D.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}') ]]>
</Table>
<!--FDCQ1，FDCQ2 首次登记+ FDCQ3 获取宗地基本信息-->
<Table No="表2" Name="ZDJBXX" tablemark="ZDJBXX_FDCQ_YZGY" mustfillfield="" description="宗地基本信息表(房地产权首次业务+ 业主共用部分)。">
<![CDATA[SELECT * FROM BDCDJB.ZDJBXX D WHERE D.BSM IN ( SELECT Q.ZDJBXXBSM FROM BDCDJB.{QLBM} Q WHERE Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}'
UNION SELECT Q.ZDJBXXBSM FROM BDCDJB.FDCQ3 Q WHERE Q.YWH='{YWH}')]]>
</Table>
<Table No="表2" Name="ZDJBXX" tablemark="ZDJBXX_QL_ZX" mustfillfield="" description="宗地基本信息表((房地产权业务，纯地业务)的注销业务)。">
<![CDATA[ SELECT * FROM BDCDJB.ZDJBXX D WHERE EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.ZDJBXXBSM=D.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}') ]]>
</Table>
<!--GJZWSYQ 获取宗地基本信息(已做配置暂无该业务使用)-->
<Table No="表2" Name="ZDJBXX" tablemark="ZDJBXX_GZW" mustfillfield="" description="宗地基本信息表(构建筑物所有权)。">
<![CDATA[ SELECT * FROM BDCDJB.ZDJBXX Z WHERE EXISTS (SELECT 1 FROM BDCDJB.GZW D WHERE D.ZDZHBSM=Z.BSM AND EXISTS (SELECT 1 FROM BDCDJB.GJZWSYQ Q WHERE Q.GZWBSM=D.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}'))]]>
</Table>
<Table No="表2" Name="ZDJBXX" tablemark="ZDJBXX_GZW_ZX" mustfillfield="" description="宗地基本信息表(构建筑物所有权的注销业务)。">
<![CDATA[ SELECT * FROM BDCDJB.ZDJBXX Z WHERE EXISTS (SELECT 1 FROM BDCDJB.GZW D WHERE D.ZDZHBSM=Z.BSM AND EXISTS (SELECT 1 FROM BDCDJB.GJZWSYQ Q WHERE Q.GZWBSM=D.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')) ]]>
</Table>
<!--纯宗地的他项权，即纯地的抵押、查封、预告、异议、地役获取对应宗地基本信息-->
<Table No="表2" Name="ZDJBXX" tablemark="ZDJBXX_QL_TXQ" mustfillfield="" description="宗地基本信息表(异议登记)。">
<![CDATA[ SELECT * FROM BDCDJB.ZDJBXX D WHERE EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBSM=D.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}') ]]>
</Table>
<Table No="表2" Name="ZDJBXX" tablemark="ZDJBXX_DYAQ_ZX" mustfillfield="" description="宗地基本信息表(抵押权注销业务)。">
<![CDATA[ SELECT * FROM BDCDJB.ZDJBXX D WHERE EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBSM=D.BSM AND Q.DYBM='ZDJBXX' AND Q.ZXDYYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}') ]]>
</Table>
<Table No="表2" Name="ZDJBXX" tablemark="ZDJBXX_ZLSYQ_ZX" mustfillfield="" description="宗地基本信息表(租赁使用权注销业务)。">
<![CDATA[ SELECT * FROM BDCDJB.ZDJBXX D WHERE EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.ZDJBXXBSM=D.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}') ]]>
</Table>
<Table No="表2" Name="ZDJBXX" tablemark="ZDJBXX_JUZQ_ZX" mustfillfield="" description="宗地基本信息表(居住权注销业务)。">
<![CDATA[ SELECT * FROM BDCDJB.ZDJBXX D WHERE D.BSM IN (SELECT D.ZDJBXXBSM FROM BDCDJB.H D WHERE EXISTS (SELECT 1 FROM BDCDJB.JUZQ Q WHERE Q.DYBSM=D.BSM AND Q.DYBM='H' AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}')) ]]>
</Table>
<Table No="表2" Name="ZDJBXX" tablemark="ZDJBXX_CFDJ_ZX" mustfillfield="" description="宗地基本信息表(查封登记注销业务)。">
<![CDATA[ SELECT * FROM BDCDJB.ZDJBXX D WHERE EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBSM=D.BSM AND Q.DYBM='ZDJBXX' AND Q.JFYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}') ]]>
</Table>
<Table No="表2" Name="ZDJBXX" tablemark="ZDJBXX_YGDJ_ZX" mustfillfield="" description="宗地基本信息表(预告登记注销业务)。">
<![CDATA[ SELECT * FROM BDCDJB.ZDJBXX D WHERE EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBSM=D.BSM AND Q.DYBM='ZDJBXX' AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}') ]]>
</Table>
<Table No="表2" Name="ZDJBXX" tablemark="ZDJBXX_YYDJ_ZX" mustfillfield="" description="宗地基本信息表(异议登记注销业务)。">
<![CDATA[ SELECT * FROM BDCDJB.ZDJBXX D WHERE EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBSM=D.BSM AND Q.DYBM='ZDJBXX' AND Q.ZXYYYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}') ]]>
</Table>
<Table No="表2" Name="ZDJBXX" tablemark="ZDJBXX_DYIQ_ZX" mustfillfield="" description="宗地基本信息表(地役权登记注销业务)。">
<![CDATA[ SELECT * FROM BDCDJB.ZDJBXX D WHERE EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBSM=D.BSM AND Q.DYBM='ZDJBXX' AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}') ]]>
</Table>
<!--如果他项权的对应的单元为户（H）,则根据户关联获取宗地基本信息-->
<Table No="表2" Name="ZDJBXX" tablemark="ZDJBXX_H_TXQ" mustfillfield="" description="宗地基本信息表(他项权对应的户的宗地基本信息)。">
<![CDATA[ SELECT * FROM BDCDJB.ZDJBXX D WHERE EXISTS (SELECT 1 FROM BDCDJB.H H WHERE H.ZDJBXXBSM=D.BSM AND EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBM='H' AND Q.DYBSM=H.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')) ]]>
</Table>
<Table No="表3" Name="ZDJBXX_BHGX" tablemark="ZDJBXX_H_TXQ" mustfillfield="" description="宗地变化情况表（他项权对应的户的宗地基本信息）。">
<![CDATA[ SELECT B.BSM,B.YWH,B.YDYBSM,B.XDYBSM,B.BHSJ,B.QXDM,B.DJBSM,X.DJBSM AS XDYDJBSM,X.BBH AS XDYBBH,Y.DJBSM AS YDYDJBSM,Y.BBH AS YDYBBH FROM BDCDJB.ZDJBXX_BHGX B,BDCDJB.ZDJBXX X,BDCDJB.ZDJBXX Y WHERE B.XDYBSM=X.BSM AND B.YDYBSM=Y.BSM AND EXISTS (SELECT 1 FROM BDCDJB.ZDJBXX D WHERE D.BSM=B.XDYBSM AND EXISTS (SELECT 1 FROM BDCDJB.H H WHERE H.ZDJBXXBSM=D.BSM AND EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBM='H' AND Q.DYBSM=H.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}'))) ]]>
</Table>
<!--FDCQ1,FDCQ2,TDSYQ,JSYDSY,LQ,NYDSYQ,ZLSYQ 获取宗地变化情况信息-->
<Table No="表3" Name="ZDJBXX_BHGX" tablemark="ZDJBXX_QL" mustfillfield="" description="宗地变化情况表。">
<![CDATA[ SELECT B.BSM,B.YWH,B.YDYBSM,B.XDYBSM,B.BHSJ,B.QXDM,B.DJBSM,X.DJBSM AS XDYDJBSM,X.BBH AS XDYBBH,Y.DJBSM AS YDYDJBSM,Y.BBH AS YDYBBH FROM BDCDJB.ZDJBXX_BHGX B,BDCDJB.ZDJBXX X,BDCDJB.ZDJBXX Y WHERE B.XDYBSM=X.BSM AND B.YDYBSM=Y.BSM AND EXISTS (SELECT 1 FROM BDCDJB.ZDJBXX D WHERE D.BSM =B.XDYBSM AND EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.ZDJBXXBSM=D.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')) ]]>
</Table>
<!--FDCQ1，FDCQ2 首次登记+ FDCQ3 获取宗地变化情况信息-->
<Table No="表3" Name="ZDJBXX_BHGX" tablemark="ZDJBXX_FDCQ_YZGY" mustfillfield="" description="宗地变化情况表(业主共有部分)。">
<![CDATA[ SELECT B.BSM,B.YWH,B.YDYBSM,B.XDYBSM,B.BHSJ,B.QXDM,B.DJBSM,X.DJBSM AS XDYDJBSM,X.BBH AS XDYBBH,Y.DJBSM AS YDYDJBSM,Y.BBH AS YDYBBH FROM BDCDJB.ZDJBXX_BHGX B,BDCDJB.ZDJBXX X,BDCDJB.ZDJBXX Y WHERE B.XDYBSM=X.BSM AND B.YDYBSM=Y.BSM AND EXISTS (SELECT 1 FROM BDCDJB.ZDJBXX D WHERE D.BSM =B.XDYBSM AND D.BSM IN ( SELECT Q.ZDJBXXBSM FROM BDCDJB.{QLBM} Q WHERE Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}'
UNION SELECT Q.ZDJBXXBSM FROM BDCDJB.FDCQ3 Q WHERE Q.YWH='{YWH}')) ]]>
</Table>
<Table No="表3" Name="ZDJBXX_BHGX" tablemark="ZDJBXX_QL_TXQ" mustfillfield="" description="宗地变化情况表(针对异议登记)。">
<![CDATA[ SELECT B.BSM,B.YWH,B.YDYBSM,B.XDYBSM,B.BHSJ,B.QXDM,B.DJBSM,X.DJBSM AS XDYDJBSM,X.BBH AS XDYBBH,Y.DJBSM AS YDYDJBSM,Y.BBH AS YDYBBH FROM BDCDJB.ZDJBXX_BHGX B,BDCDJB.ZDJBXX X,BDCDJB.ZDJBXX Y WHERE B.XDYBSM=X.BSM AND B.YDYBSM=Y.BSM AND EXISTS (SELECT 1 FROM BDCDJB.ZDJBXX D WHERE D.BSM =B.XDYBSM AND EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBSM=D.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')) ]]>
</Table>
<!--GJZWSYQ 获取宗地基本信息变化关系(已做配置暂无该业务使用)-->
<Table No="表3" Name="ZDJBXX_BHGX" tablemark="ZDJBXX_GZW" mustfillfield="" description="宗地基本信息表(构建筑物所有权)。">
<![CDATA[ SELECT B.BSM,B.YWH,B.YDYBSM,B.XDYBSM,B.BHSJ,B.QXDM,B.DJBSM,X.DJBSM AS XDYDJBSM,X.BBH AS XDYBBH,Y.DJBSM AS YDYDJBSM,Y.BBH AS YDYBBH FROM BDCDJB.ZDJBXX_BHGX B,BDCDJB.ZDJBXX X,BDCDJB.ZDJBXX Y WHERE B.XDYBSM=X.BSM AND B.YDYBSM=Y.BSM AND EXISTS (SELECT 1 FROM BDCDJB.ZDJBXX Z WHERE Z.BSM=B.XDYBSM AND EXISTS (SELECT 1 FROM BDCDJB.GZW D WHERE D.ZDZHBSM=Z.BSM AND EXISTS (SELECT 1 FROM BDCDJB.GJZWSYQ Q WHERE Q.GZWBSM=D.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}'))) ]]>
</Table>
<Table No="表3" Name="ZDJBXX_BHGX" tablemark="ZDJBXX_GZW_ZX" mustfillfield="" description="宗地基本信息表(构建筑物所有权的注销业务)。">
<![CDATA[ SELECT B.BSM,B.YWH,B.YDYBSM,B.XDYBSM,B.BHSJ,B.QXDM,B.DJBSM,X.DJBSM AS XDYDJBSM,X.BBH AS XDYBBH,Y.DJBSM AS YDYDJBSM,Y.BBH AS YDYBBH FROM BDCDJB.ZDJBXX_BHGX B,BDCDJB.ZDJBXX X,BDCDJB.ZDJBXX Y WHERE B.XDYBSM=X.BSM AND B.YDYBSM=Y.BSM AND EXISTS (SELECT 1 FROM BDCDJB.ZDJBXX Z WHERE Z.BSM=B.XDYBSM AND EXISTS (SELECT 1 FROM BDCDJB.GZW D WHERE D.ZDZHBSM=Z.BSM AND EXISTS (SELECT 1 FROM BDCDJB.GJZWSYQ Q WHERE Q.GZWBSM=D.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}'))) ]]>
</Table>
<!--获取海域使用权对应的宗海基本信息-->
<Table No="表4" Name="ZHJBXX" tablemark="ZHJBXX_QL" mustfillfield="" description="宗海基本信息(海域使用权)。">
<![CDATA[ SELECT * FROM BDCDJB.ZHJBXX D WHERE EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.ZHJBXXBSM=D.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}') ]]>
</Table>
<Table No="表4" Name="ZHJBXX" tablemark="ZHJBXX_QL_ZX" mustfillfield="" description="宗海基本信息(海域使用权注销)。">
<![CDATA[ SELECT * FROM BDCDJB.ZHJBXX D WHERE EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.ZHJBXXBSM=D.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}') ]]>
</Table>
<!--GJZWSYQ 获取构建筑物关联的宗海基本信息-->
<Table No="表4" Name="ZHJBXX" tablemark="ZHJBXX_GZW" mustfillfield="" description="构建筑物关联的宗海基本信息(构建筑物所有权)。">
<![CDATA[ SELECT * FROM BDCDJB.ZHJBXX Z WHERE EXISTS (SELECT 1 FROM BDCDJB.GZW D WHERE D.ZDZHBSM=Z.BSM AND EXISTS (SELECT 1 FROM BDCDJB.GJZWSYQ Q WHERE Q.GZWBSM=D.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}'))]]>
</Table>
<Table No="表4" Name="ZHJBXX" tablemark="ZHJBXX_GZW_ZX" mustfillfield="" description="构建筑物关联的宗海基本信息(构建筑物所有权的注销业务)。">
<![CDATA[ SELECT * FROM BDCDJB.ZHJBXX Z WHERE EXISTS (SELECT 1 FROM BDCDJB.GZW D WHERE D.ZDZHBSM=Z.BSM AND EXISTS (SELECT 1 FROM BDCDJB.GJZWSYQ Q WHERE Q.GZWBSM=D.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')) ]]>
</Table>
<!--宗海的他项权及其注销业务，即海域的抵押、查封、预告、异议、地役获取对应宗地基本信息-->
<Table No="表4" Name="ZHJBXX" tablemark="ZHJBXX_QL_TXQ" mustfillfield="" description="宗海基本信息(海域使用权)。">
<![CDATA[ SELECT * FROM BDCDJB.ZHJBXX D WHERE EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBSM=D.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}') ]]>
</Table>
<Table No="表4" Name="ZHJBXX" tablemark="ZHJBXX_DYAQ_ZX" mustfillfield="" description="宗海基本信息（(海域使用权抵押注销)）。">
<![CDATA[ SELECT * FROM BDCDJB.ZHJBXX D WHERE EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBSM=D.BSM AND Q.DYBM='ZHJBXX' AND Q.ZXDYYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}') ]]>
</Table>
<Table No="表4" Name="ZHJBXX" tablemark="ZHJBXX_ZLSYQ_ZX" mustfillfield="" description="宗海基本信息（(海域租赁使用权注销,此处是预留配置，没有该业务）。">
<![CDATA[ SELECT * FROM BDCDJB.ZHJBXX D WHERE EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.ZDJBXXBSM=D.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}') ]]>
</Table>
<Table No="表4" Name="ZHJBXX" tablemark="ZHJBXX_CFDJ_ZX" mustfillfield="" description="宗海基本信息（(海域使用权查封注销)）。">
<![CDATA[ SELECT * FROM BDCDJB.ZHJBXX D WHERE EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBSM=D.BSM AND Q.DYBM='ZHJBXX' AND Q.JFYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}') ]]>
</Table>
<Table No="表4" Name="ZHJBXX" tablemark="ZHJBXX_YGDJ_ZX" mustfillfield="" description="宗海基本信息（(海域使用权预告登记注销)）。">
<![CDATA[ SELECT * FROM BDCDJB.ZHJBXX D WHERE EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBSM=D.BSM AND Q.DYBM='ZHJBXX' AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}') ]]>
</Table>
<Table No="表4" Name="ZHJBXX" tablemark="ZHJBXX_YYDJ_ZX" mustfillfield="" description="宗海基本信息（(海域使用权异议登记注销)）。">
<![CDATA[ SELECT * FROM BDCDJB.ZHJBXX D WHERE EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBSM=D.BSM AND Q.DYBM='ZHJBXX' AND Q.ZXYYYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}') ]]>
</Table>
<Table No="表4" Name="ZHJBXX" tablemark="ZHJBXX_DYIQ_ZX" mustfillfield="" description="宗海基本信息（(海域使用权地役权登记注销)）。">
<![CDATA[ SELECT * FROM BDCDJB.ZHJBXX D WHERE EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBSM=D.BSM AND Q.DYBM='ZHJBXX' AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}') ]]>
</Table>
<Table No="表5" Name="ZHJBXX_BHGX" tablemark="ZHJBXX_QL" mustfillfield="" description="宗海基本信息变化情况。">
<![CDATA[ SELECT B.BSM,B.YWH,B.YDYBSM,B.XDYBSM,B.BHSJ,B.QXDM,B.DJBSM,X.DJBSM AS XDYDJBSM,X.BBH AS XDYBBH,Y.DJBSM AS YDYDJBSM,Y.BBH AS YDYBBH FROM BDCDJB.ZHJBXX_BHGX B,BDCDJB.ZHJBXX X,BDCDJB.ZHJBXX Y WHERE B.XDYBSM=X.BSM AND B.YDYBSM=Y.BSM AND EXISTS (SELECT 1 FROM BDCDJB.ZHJBXX D WHERE D.BSM =B.XDYBSM AND EXISTS (SELECT 1 FROM BDCDJB.ZHJBXX D WHERE D.BSM =B.XDYBSM AND EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.ZHJBXXBSM=D.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')))]]>
</Table>
<Table No="表5" Name="ZHJBXX_BHGX" tablemark="ZHJBXX_QL_TXQ" mustfillfield="" description="宗海基本信息变化情况(针对异议登记)。">
<![CDATA[ SELECT B.BSM,B.YWH,B.YDYBSM,B.XDYBSM,B.BHSJ,B.QXDM,B.DJBSM,X.DJBSM AS XDYDJBSM,X.BBH AS XDYBBH,Y.DJBSM AS YDYDJBSM,Y.BBH AS YDYBBH FROM BDCDJB.ZHJBXX_BHGX B,BDCDJB.ZHJBXX X,BDCDJB.ZHJBXX Y WHERE B.XDYBSM=X.BSM AND B.YDYBSM=Y.BSM AND EXISTS (SELECT 1 FROM BDCDJB.ZHJBXX D WHERE D.BSM =B.XDYBSM AND EXISTS (SELECT 1 FROM BDCDJB.ZHJBXX D WHERE D.BSM =B.XDYBSM AND EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBSM=D.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')))]]>
</Table>
<!--GJZWSYQ 获取构建筑物关联的宗海基本信息的变化关系-->
<Table No="表5" Name="ZHJBXX_BHGX" tablemark="ZHJBXX_GZW" mustfillfield="" description="关联的宗海基本信息的变化关系(构建筑物所有权)。">
<![CDATA[ SELECT B.BSM,B.YWH,B.YDYBSM,B.XDYBSM,B.BHSJ,B.QXDM,B.DJBSM,X.DJBSM AS XDYDJBSM,X.BBH AS XDYBBH,Y.DJBSM AS YDYDJBSM,Y.BBH AS YDYBBH FROM BDCDJB.ZHJBXX_BHGX B,BDCDJB.ZHJBXX X,BDCDJB.ZHJBXX Y WHERE B.XDYBSM=X.BSM AND B.YDYBSM=Y.BSM AND EXISTS (SELECT 1 FROM BDCDJB.ZHJBXX Z WHERE Z.BSM=B.XDYBSM AND EXISTS (SELECT 1 FROM BDCDJB.GZW D WHERE D.ZDZHBSM=Z.BSM AND EXISTS (SELECT 1 FROM BDCDJB.GJZWSYQ Q WHERE Q.GZWBSM=D.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}'))) ]]>
</Table>
<Table No="表5" Name="ZHJBXX_BHGX" tablemark="ZHJBXX_GZW_ZX" mustfillfield="" description="关联的宗海基本信息的变化关系(构建筑物所有权的注销业务)。">
<![CDATA[ SELECT B.BSM,B.YWH,B.YDYBSM,B.XDYBSM,B.BHSJ,B.QXDM,B.DJBSM,X.DJBSM AS XDYDJBSM,X.BBH AS XDYBBH,Y.DJBSM AS YDYDJBSM,Y.BBH AS YDYBBH FROM BDCDJB.ZHJBXX_BHGX B,BDCDJB.ZHJBXX X,BDCDJB.ZHJBXX Y WHERE B.XDYBSM=X.BSM AND B.YDYBSM=Y.BSM AND EXISTS (SELECT 1 FROM BDCDJB.ZHJBXX Z WHERE Z.BSM=B.XDYBSM AND EXISTS (SELECT 1 FROM BDCDJB.GZW D WHERE D.ZDZHBSM=Z.BSM AND EXISTS (SELECT 1 FROM BDCDJB.GJZWSYQ Q WHERE Q.GZWBSM=D.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}'))) ]]>
</Table>
<!--获取自然幢信息(包括ZLSYQ)-->
<Table No="表6" Name="ZRZ" tablemark="H_FDCQ" mustfillfield="" description="自然幢表信息。">
<![CDATA[ SELECT * FROM BDCDJB.ZRZ Z WHERE EXISTS (SELECT 1 FROM BDCDJB.H D WHERE D.ZRZBSM=Z.BSM AND EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.HBSM=D.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')) ]]>
</Table>
<!--FDCQ1，FDCQ2 首次登记+ FDCQ3 获取自然幢表信息(包含业主共用部分)-->
<Table No="表6" Name="ZRZ" tablemark="H_FDCQ_YZGY" mustfillfield="" description="自然幢表信息(包含业主共用部分)。">
<![CDATA[ SELECT * FROM BDCDJB.ZRZ Z WHERE EXISTS (SELECT 1 FROM BDCDJB.H D WHERE D.ZRZBSM=Z.BSM AND D.BSM IN ( SELECT Q.HBSM FROM BDCDJB.{QLBM} Q WHERE Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' UNION SELECT Q.HBSM FROM BDCDJB.FDCQ3 Q WHERE Q.YWH='{YWH}')) ]]>
</Table>
<Table No="表6" Name="ZRZ" tablemark="H_FDCQ_ZX" mustfillfield="" description="自然幢表信息。">
<![CDATA[ SELECT * FROM BDCDJB.ZRZ Z WHERE EXISTS (SELECT 1 FROM BDCDJB.H D WHERE D.ZRZBSM=Z.BSM AND EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.HBSM=D.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')) ]]>
</Table>
<Table No="表6" Name="ZRZ" tablemark="H_TXQ" mustfillfield="" description="自然幢表信息。">
<![CDATA[ SELECT * FROM BDCDJB.ZRZ Z WHERE EXISTS (SELECT 1 FROM BDCDJB.H D WHERE D.ZRZBSM=Z.BSM AND EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBM='H' AND Q.DYBSM=D.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')) ]]>
</Table>
<Table No="表6" Name="ZRZ" tablemark="H_DYAQ_ZX" mustfillfield="" description="自然幢表信息。">
<![CDATA[ SELECT * FROM BDCDJB.ZRZ Z WHERE EXISTS (SELECT 1 FROM BDCDJB.H D WHERE D.ZRZBSM=Z.BSM AND EXISTS (SELECT 1 FROM BDCDJB.DYAQ Q WHERE Q.DYBM='H' AND Q.DYBSM=D.BSM AND Q.ZXDYYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}')) ]]>
</Table>
<Table No="表6" Name="ZRZ" tablemark="H_ZLSYQ_ZX" mustfillfield="" description="自然幢表信息。">
<![CDATA[ SELECT * FROM BDCDJB.ZRZ Z WHERE EXISTS (SELECT 1 FROM BDCDJB.H D WHERE D.ZRZBSM=Z.BSM AND EXISTS (SELECT 1 FROM BDCDJB.ZLSYQ Q WHERE Q.HBSM=D.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}')) ]]>
</Table>
<Table No="表6" Name="ZRZ" tablemark="H_JUZQ_ZX" mustfillfield="" description="自然幢表信息。">
<![CDATA[ SELECT * FROM BDCDJB.ZRZ Z WHERE EXISTS (SELECT 1 FROM BDCDJB.H D WHERE D.ZRZBSM=Z.BSM AND EXISTS (SELECT 1 FROM BDCDJB.JUZQ Q WHERE Q.DYBM='H' AND Q.DYBSM=D.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}')) ]]>
</Table>
<Table No="表6" Name="ZRZ" tablemark="H_YGDJ_ZX" mustfillfield="" description="自然幢表信息。">
<![CDATA[ SELECT * FROM BDCDJB.ZRZ Z WHERE EXISTS (SELECT 1 FROM BDCDJB.H D WHERE D.ZRZBSM=Z.BSM AND EXISTS (SELECT 1 FROM BDCDJB.YGDJ Q WHERE Q.DYBM='H' AND Q.DYBSM=D.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')) ]]>
</Table>
<Table No="表6" Name="ZRZ" tablemark="H_CFDJ_ZX" mustfillfield="" description="自然幢表信息。">
<![CDATA[ SELECT * FROM BDCDJB.ZRZ Z WHERE EXISTS (SELECT 1 FROM BDCDJB.H D WHERE D.ZRZBSM=Z.BSM AND EXISTS (SELECT 1 FROM BDCDJB.CFDJ Q WHERE Q.DYBM='H' AND Q.DYBSM=D.BSM AND Q.JFYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}')) ]]>
</Table>
<Table No="表6" Name="ZRZ" tablemark="H_YYDJ_ZX" mustfillfield="" description="自然幢表信息。">
<![CDATA[ SELECT * FROM BDCDJB.ZRZ Z WHERE EXISTS (SELECT 1 FROM BDCDJB.H D WHERE D.ZRZBSM=Z.BSM AND EXISTS (SELECT 1 FROM BDCDJB.YYDJ Q WHERE Q.DYBM='H' AND Q.DYBSM=D.BSM AND Q.ZXYYYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}')) ]]>
</Table>
<Table No="表6" Name="ZRZ" tablemark="H_DYIQ_ZX" mustfillfield="" description="自然幢表信息。">
<![CDATA[ SELECT * FROM BDCDJB.ZRZ Z WHERE EXISTS (SELECT 1 FROM BDCDJB.H D WHERE D.ZRZBSM=Z.BSM AND EXISTS (SELECT 1 FROM BDCDJB.DYIQ Q WHERE Q.DYBM='H' AND Q.DYBSM=D.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')) ]]>
</Table>
<!--FDCQ1,FDCQ2,TDSYQ,JSYDSY,LQ,NYDSYQ,ZLSYQ 获取宗地对应的界址线信息-->
<Table No="表7" Name="JZX" tablemark="JZX_ZD" mustfillfield="" description="界址线（提取宗地界址线数据，包括房地产权，纯地业务对应的宗地界址线数据）。">
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZXCD,J.JZXLB,J.JZXWZ,J.JXXZ,J.QSJXXYSBH,J.QSZYYYSBH,J.QXDM,J.BSM AS DJBBSM
FROM BDCDJB.JZX J WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZDJBXX D WHERE D.ZDDM=J.ZDZHDM AND
EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.ZDJBXXBSM=D.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')) ]]>
</Table>
<!--FDCQ1，FDCQ2 首次登记+ FDCQ3 获取界址线信息(包含业主共用部分)-->
<Table No="表7" Name="JZX" tablemark="JZX_ZD_YZGY" mustfillfield="" description="界址线（提取宗地界址线数据，包括房地产权首次和业主共用部分对应的宗地界址线数据）。">
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZXCD,J.JZXLB,J.JZXWZ,J.JXXZ,J.QSJXXYSBH,J.QSZYYYSBH,J.QXDM,J.BSM AS DJBBSM
FROM BDCDJB.JZX J WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZDJBXX D WHERE D.ZDDM=J.ZDZHDM AND
D.BSM IN ( SELECT Q.ZDJBXXBSM FROM BDCDJB.{QLBM} Q WHERE Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}'
UNION SELECT Q.ZDJBXXBSM FROM BDCDJB.FDCQ3 Q WHERE Q.YWH='{YWH}' )) ]]>
</Table>
<Table No="表7" Name="JZX" tablemark="JZX_ZD_ZX" mustfillfield="" description="界址线（提取宗地界址线数据，包括房地产权，纯地业务注销业务对应的宗地界址线数据）。">
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZXCD,J.JZXLB,J.JZXWZ,J.JXXZ,J.QSJXXYSBH,J.QSZYYYSBH,J.QXDM,J.BSM AS DJBBSM
FROM BDCDJB.JZX J WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZDJBXX D WHERE D.ZDDM=J.ZDZHDM AND
EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.ZDJBXXBSM=D.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')) ]]>
</Table>
<!--GJZWSYQ 获取宗地基本信息(已做配置暂无该业务使用)-->
<Table No="表7" Name="JZX" tablemark="JZX_ZD_GZW" mustfillfield="" description="宗地基本信息表(构建筑物所有权)。">
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZXCD,J.JZXLB,J.JZXWZ,J.JXXZ,J.QSJXXYSBH,J.QSZYYYSBH,J.QXDM,J.BSM AS DJBBSM FROM BDCDJB.JZX J
WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZDJBXX Z WHERE Z.ZDDM=J.ZDZHDM AND EXISTS (SELECT 1 FROM BDCDJB.GZW D WHERE D.ZDZHBSM=Z.BSM
AND EXISTS (SELECT 1 FROM BDCDJB.GJZWSYQ Q WHERE Q.GZWBSM=D.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')))]]>
</Table>
<Table No="表7" Name="JZX" tablemark="JZX_ZD_GZW_ZX" mustfillfield="" description="宗地基本信息表(构建筑物所有权的注销业务)。">
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZXCD,J.JZXLB,J.JZXWZ,J.JXXZ,J.QSJXXYSBH,J.QSZYYYSBH,J.QXDM,J.BSM AS DJBBSM FROM BDCDJB.JZX J
WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZDJBXX Z WHERE Z.ZDDM=J.ZDZHDM AND EXISTS (SELECT 1 FROM BDCDJB.GZW D WHERE D.ZDZHBSM=Z.BSM
AND EXISTS (SELECT 1 FROM BDCDJB.GJZWSYQ Q WHERE Q.GZWBSM=D.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}'))) ]]>
</Table>
<!--GJZWSYQ 获取关联的宗海基本信息的界址线信息-->
<Table No="表7" Name="JZX" tablemark="JZX_ZH_GZW" mustfillfield="" description="关联的宗海基本信息的界址线信息(构建筑物所有权)。">
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZXCD,J.JZXLB,J.JZXWZ,J.JXXZ,J.QSJXXYSBH,J.QSZYYYSBH,J.QXDM,J.BSM AS DJBBSM FROM BDCDJB.JZX J
WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZHJBXX Z WHERE Z.ZHDM=J.ZDZHDM AND EXISTS (SELECT 1 FROM BDCDJB.GZW D WHERE D.ZDZHBSM=Z.BSM
AND EXISTS (SELECT 1 FROM BDCDJB.GJZWSYQ Q WHERE Q.GZWBSM=D.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')))]]>
</Table>
<Table No="表7" Name="JZX" tablemark="JZX_ZH_GZW_ZX" mustfillfield="" description="关联的宗海基本信息的界址线信息(构建筑物所有权的注销业务)。">
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZXCD,J.JZXLB,J.JZXWZ,J.JXXZ,J.QSJXXYSBH,J.QSZYYYSBH,J.QXDM,J.BSM AS DJBBSM FROM BDCDJB.JZX J
WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZHJBXX Z WHERE Z.ZHDM=J.ZDZHDM AND EXISTS (SELECT 1 FROM BDCDJB.GZW D WHERE D.ZDZHBSM=Z.BSM
AND EXISTS (SELECT 1 FROM BDCDJB.GJZWSYQ Q WHERE Q.GZWBSM=D.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}'))) ]]>
</Table>
<!--纯宗地的他项权及其注销业务，即纯地的抵押、查封、预告、异议、地役获取对应宗地界址线信息-->
<Table No="表7" Name="JZX" tablemark="JZX_ZD_TXQ" mustfillfield="" description="界址线（提取宗地界址线数据，包括抵押、查封、预告、地役权，异议对应的宗地界址线数据）。">
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZXCD,J.JZXLB,J.JZXWZ,J.JXXZ,J.QSJXXYSBH,J.QSZYYYSBH,J.QXDM,J.BSM AS DJBBSM
FROM BDCDJB.JZX J WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZDJBXX D WHERE D.ZDDM=J.ZDZHDM AND
EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBSM=D.BSM AND Q.DYBM='ZDJBXX' AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')) ]]>
</Table>
<Table No="表7" Name="JZX" tablemark="JZX_ZD_DYAQ_ZX" mustfillfield="" description="界址线（提取宗地界址线数据，主要针对抵押权注销业务对应的宗地界址线数据）。">
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZXCD,J.JZXLB,J.JZXWZ,J.JXXZ,J.QSJXXYSBH,J.QSZYYYSBH,J.QXDM,J.BSM AS DJBBSM
FROM BDCDJB.JZX J WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZDJBXX D WHERE D.ZDDM=J.ZDZHDM AND
EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBSM=D.BSM AND Q.ZXDYYWH='{YWH}' AND Q.DYBM='ZDJBXX' AND Q.DJBSM='{ZXDJBSM}') ]]>
</Table>
<Table No="表7" Name="JZX" tablemark="JZX_ZD_CFDJ_ZX" mustfillfield="" description="界址线（提取宗地界址线数据，主要针对查封登记注销业务对应的宗地界址线数据）。">
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZXCD,J.JZXLB,J.JZXWZ,J.JXXZ,J.QSJXXYSBH,J.QSZYYYSBH,J.QXDM,J.BSM AS DJBBSM
FROM BDCDJB.JZX J WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZDJBXX D WHERE D.ZDDM=J.ZDZHDM AND
EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBSM=D.BSM AND Q.JFYWH='{YWH}' AND Q.DYBM='ZDJBXX' AND Q.DJBSM='{ZXDJBSM}')) ]]>
</Table>
<Table No="表7" Name="JZX" tablemark="JZX_ZD_YGDJ_ZX" mustfillfield="" description="界址线（提取宗地界址线数据，主要针对预告登记注销业务对应的宗地界址线数据）。">
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZXCD,J.JZXLB,J.JZXWZ,J.JXXZ,J.QSJXXYSBH,J.QSZYYYSBH,J.QXDM,J.BSM AS DJBBSM
FROM BDCDJB.JZX J WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZDJBXX D WHERE D.ZDDM=J.ZDZHDM AND
EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBSM=D.BSM AND Q.ZXYWH='{YWH}' AND Q.DYBM='ZDJBXX' AND Q.DJBSM='{DJQLBSM}' )) ]]>
</Table>
<Table No="表7" Name="JZX" tablemark="JZX_ZD_DYIQ_ZX" mustfillfield="" description="界址线（提取宗地界址线数据，主要针对地役权登记注销业务对应的宗地界址线数据）。">
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZXCD,J.JZXLB,J.JZXWZ,J.JXXZ,J.QSJXXYSBH,J.QSZYYYSBH,J.QXDM,J.BSM AS DJBBSM
FROM BDCDJB.JZX J WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZDJBXX D WHERE D.ZDDM=J.ZDZHDM AND
EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBSM=D.BSM AND Q.ZXYYYWH='{YWH}' AND Q.DYBM='ZDJBXX' AND Q.DJBSM='{DJQLBSM}')) ]]>
</Table>
<Table No="表7" Name="JZX" tablemark="JZX_ZD_YYDJ_ZX" mustfillfield="" description="界址线（提取宗地界址线数据，主要针对异议登记注销业务对应的宗地界址线数据）。">
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZXCD,J.JZXLB,J.JZXWZ,J.JXXZ,J.QSJXXYSBH,J.QSZYYYSBH,J.QXDM,J.BSM AS DJBBSM
FROM BDCDJB.JZX J WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZDJBXX D WHERE D.ZDDM=J.ZDZHDM AND
EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBSM=D.BSM AND Q.ZXYYYWH='{YWH}' AND Q.DYBM='ZDJBXX' AND Q.DJBSM='{ZXDJBSM}')) ]]>
</Table>
<!--如果他项权的对应的单元为户（H）,则根据户关联获取宗地对应的界址线信息-->
<Table No="表7" Name="JZX" tablemark="JZX_ZD_H_TXQ" mustfillfield="" description="界址线（他项权根据户关联获取宗地对应的界址线信息）。">
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZXCD,J.JZXLB,J.JZXWZ,J.JXXZ,J.QSJXXYSBH,J.QSZYYYSBH,J.QXDM,J.BSM AS DJBBSM
FROM BDCDJB.JZX J WHERE EXISTS (SELECT 1 FROM BDCDJB.ZDJBXX D WHERE D.ZDDM=J.ZDZHDM AND EXISTS (SELECT 1 FROM BDCDJB.H H WHERE H.ZDJBXXBSM=D.BSM
AND EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBM='H' AND Q.DYBSM=H.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')) ) ]]>
</Table>
<!--获取海域使用权对应的宗海基本信息的界址线信息-->
<Table No="表7" Name="JZX" tablemark="JZX_ZH" mustfillfield="" description="界址线(提取宗海界址线数据,主要针对HYSYQ业务)。">
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZXCD,J.JZXLB,J.JZXWZ,J.JXXZ,J.QSJXXYSBH,J.QSZYYYSBH,J.QXDM,J.BSM AS DJBBSM
FROM BDCDJB.JZX J WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZHJBXX D WHERE D.ZHDM=J.ZDZHDM AND
EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.ZHJBXXBSM=D.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')) ]]>
</Table>
<Table No="表7" Name="JZX" tablemark="JZX_ZH_ZX" mustfillfield="" description="界址线(提取宗海界址线数据,主要针对HYSYQ注销业务)。">
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZXCD,J.JZXLB,J.JZXWZ,J.JXXZ,J.QSJXXYSBH,J.QSZYYYSBH,J.QXDM,J.BSM AS DJBBSM
FROM BDCDJB.JZX J WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZHJBXX D WHERE D.ZHDM=J.ZDZHDM AND
EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.ZHJBXXBSM=D.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')) ]]>
</Table>
<!--宗海的他项权及其注销业务，即海域的抵押、查封、预告、异议、地役获取对应宗地基本信息-->
<Table No="表7" Name="JZX" tablemark="JZX_ZH_TXQ" mustfillfield="" description="界址线(提取宗海界址线数据,主要针对HYSYQ的抵押，查封，预告，地役权，异议登记业务)。">
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZXCD,J.JZXLB,J.JZXWZ,J.JXXZ,J.QSJXXYSBH,J.QSZYYYSBH,J.QXDM,J.BSM AS DJBBSM
FROM BDCDJB.JZX J WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZHJBXX D WHERE D.ZHDM=J.ZDZHDM AND
EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBSM=D.BSM AND Q.DYBM='ZHJBXX' AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')) ]]>
</Table>
<Table No="表7" Name="JZX" tablemark="JZX_ZH_DYAQ_ZX" mustfillfield="" description="界址线(提取宗海界址线数据,主要针对HYSYQ抵押权注销业务)。">
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZXCD,J.JZXLB,J.JZXWZ,J.JXXZ,J.QSJXXYSBH,J.QSZYYYSBH,J.QXDM,J.BSM AS DJBBSM
FROM BDCDJB.JZX J WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZHJBXX D WHERE D.ZHDM=J.ZDZHDM AND
EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBSM=D.BSM AND Q.ZXDYYWH='{YWH}' AND Q.DYBM='ZHJBXX' AND Q.DJBSM='{ZXDJBSM}')) ]]>
</Table>
<Table No="表7" Name="JZX" tablemark="JZX_ZH_CFDJ_ZX" mustfillfield="" description="界址线(提取宗海界址线数据,主要针对HYSYQ查封登记注销业务)。">
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZXCD,J.JZXLB,J.JZXWZ,J.JXXZ,J.QSJXXYSBH,J.QSZYYYSBH,J.QXDM,J.BSM AS DJBBSM
FROM BDCDJB.JZX J WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZHJBXX D WHERE D.ZHDM=J.ZDZHDM AND
EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBSM=D.BSM AND Q.JFYWH='{YWH}' AND Q.DYBM='ZHJBXX' AND Q.DJBSM='{ZXDJBSM}')) ]]>
</Table>
<Table No="表7" Name="JZX" tablemark="JZX_ZH_YGDJ_ZX" mustfillfield="" description="界址线(提取宗海界址线数据,主要针对HYSYQ预告登记注销业务)。">
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZXCD,J.JZXLB,J.JZXWZ,J.JXXZ,J.QSJXXYSBH,J.QSZYYYSBH,J.QXDM,J.BSM AS DJBBSM
FROM BDCDJB.JZX J WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZHJBXX D WHERE D.ZHDM=J.ZDZHDM AND
EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBSM=D.BSM AND Q.ZXYWH='{YWH}' AND Q.DYBM='ZHJBXX' AND Q.DJBSM='{DJQLBSM}')) ]]>
</Table>
<Table No="表7" Name="JZX" tablemark="JZX_ZH_DYIQ_ZX" mustfillfield="" description="界址线(提取宗海界址线数据,主要针对HYSYQ地役权登记注销业务)。">
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZXCD,J.JZXLB,J.JZXWZ,J.JXXZ,J.QSJXXYSBH,J.QSZYYYSBH,J.QXDM,J.BSM AS DJBBSM
FROM BDCDJB.JZX J WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZHJBXX D WHERE D.ZHDM=J.ZDZHDM AND
EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBSM=D.BSM AND Q.ZXYWH='{YWH}' AND Q.DYBM='ZHJBXX' AND Q.DJBSM='{DJQLBSM}')) ]]>
</Table>
<Table No="表7" Name="JZX" tablemark="JZX_ZH_DYIQ_ZX" mustfillfield="" description="界址线(提取宗海界址线数据,主要针对HYSYQ异议登记注销业务)。">
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZXCD,J.JZXLB,J.JZXWZ,J.JXXZ,J.QSJXXYSBH,J.QSZYYYSBH,J.QXDM,J.BSM AS DJBBSM
FROM BDCDJB.JZX J WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZHJBXX D WHERE D.ZHDM=J.ZDZHDM AND
EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBSM=D.BSM AND Q.ZXYYYWH='{YWH}' AND Q.DYBM='ZHJBXX' AND Q.DJBSM='{DJQLBSM}')) ]]>
</Table>
<!--FDCQ1,FDCQ2,TDSYQ,JSYDSY,LQ,NYDSYQ,ZLSYQ 获取宗地对应的界址点信息-->
<Table No="表8" Name="JZD" tablemark="JZD_ZD" mustfillfield="" description="界址点（提取宗地界址点数据包括房地产权，纯地业务对应的宗地界址点数据）。" >
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZDH,J.SXH,J.JBLX,J.JZDLX,J.XZBZ,J.YZBZ,J.QXDM,J.BSM AS DJBBSM
FROM BDCDJB.JZD J WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZDJBXX D WHERE D.ZDDM=J.ZDZHDM AND
EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.ZDJBXXBSM=D.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')) ]]>
</Table>
<!--FDCQ1，FDCQ2 首次登记+ FDCQ3 获取界址点信息(包含业主共用部分)-->
<Table No="表8" Name="JZD" tablemark="JZD_ZD_YZGY" mustfillfield="" description="界址点（提取宗地界址点数据包括房地产权首次和业主共用部分对应的宗地界址线数据）。" >
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZDH,J.SXH,J.JBLX,J.JZDLX,J.XZBZ,J.YZBZ,J.QXDM,J.BSM AS DJBBSM
FROM BDCDJB.JZD J WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZDJBXX D WHERE D.ZDDM=J.ZDZHDM AND
D.BSM IN ( SELECT Q.ZDJBXXBSM FROM BDCDJB.{QLBM} Q WHERE Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}'
UNION SELECT Q.ZDJBXXBSM FROM BDCDJB.FDCQ3 Q WHERE Q.YWH='{YWH}' ))]]>
</Table>
<Table No="表8" Name="JZD" tablemark="JZD_ZD_ZX" mustfillfield="" description="界址点（提取宗地界址点数据，包括房地产权，纯地业务注销业务对应的宗地界址点数据）。" >
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZDH,J.SXH,J.JBLX,J.JZDLX,J.XZBZ,J.YZBZ,J.QXDM,J.BSM AS DJBBSM
FROM BDCDJB.JZD J WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZDJBXX D WHERE D.ZDDM=J.ZDZHDM AND
EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.ZDJBXXBSM=D.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')) ]]>
</Table>
<!--GJZWSYQ 获取宗地基本信息(已做配置暂无该业务使用)-->
<Table No="表8" Name="JZD" tablemark="JZD_ZD_GZW" mustfillfield="" description="宗地基本信息表(构建筑物所有权)。">
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZDH,J.SXH,J.JBLX,J.JZDLX,J.XZBZ,J.YZBZ,J.QXDM,J.BSM AS DJBBSM FROM BDCDJB.JZD J
WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZDJBXX Z WHERE Z.ZDDM=J.ZDZHDM AND EXISTS (SELECT 1 FROM BDCDJB.GZW D WHERE D.ZDZHBSM=Z.BSM
AND EXISTS (SELECT 1 FROM BDCDJB.GJZWSYQ Q WHERE Q.GZWBSM=D.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')))]]>
</Table>
<Table No="表8" Name="JZD" tablemark="JZD_ZD_GZW_ZX" mustfillfield="" description="宗地基本信息表(构建筑物所有权的注销业务)。">
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZDH,J.SXH,J.JBLX,J.JZDLX,J.XZBZ,J.YZBZ,J.QXDM,J.BSM AS DJBBSM FROM BDCDJB.JZD J
WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZDJBXX Z WHERE Z.ZDDM=J.ZDZHDM AND EXISTS (SELECT 1 FROM BDCDJB.GZW D WHERE D.ZDZHBSM=Z.BSM
AND EXISTS (SELECT 1 FROM BDCDJB.GJZWSYQ Q WHERE Q.GZWBSM=D.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}'))) ]]>
</Table>
<!--GJZWSYQ 获取关联的宗海基本信息的界址点信息-->
<Table No="表8" Name="JZD" tablemark="JZD_ZH_GZW" mustfillfield="" description="关联的宗海基本信息的界址点信息(构建筑物所有权)。">
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZDH,J.SXH,J.JBLX,J.JZDLX,J.XZBZ,J.YZBZ,J.QXDM,J.BSM AS DJBBSM FROM BDCDJB.JZD J
WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZHJBXX Z WHERE Z.ZHDM=J.ZDZHDM AND EXISTS (SELECT 1 FROM BDCDJB.GZW D WHERE D.ZDZHBSM=Z.BSM
AND EXISTS (SELECT 1 FROM BDCDJB.GJZWSYQ Q WHERE Q.GZWBSM=D.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')))]]>
</Table>
<Table No="表8" Name="JZD" tablemark="JZD_ZH_GZW_ZX" mustfillfield="" description="关联的宗海基本信息的界址点信息(构建筑物所有权的注销业务)。">
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZDH,J.SXH,J.JBLX,J.JZDLX,J.XZBZ,J.YZBZ,J.QXDM,J.BSM AS DJBBSM FROM BDCDJB.JZD J
WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZHJBXX Z WHERE Z.ZHDM=J.ZDZHDM AND EXISTS (SELECT 1 FROM BDCDJB.GZW D WHERE D.ZDZHBSM=Z.BSM
AND EXISTS (SELECT 1 FROM BDCDJB.GJZWSYQ Q WHERE Q.GZWBSM=D.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}'))) ]]>
</Table>
<!--纯宗地的他项权及其注销业务，即纯地的抵押、查封、预告、异议、地役获取对应宗地界址点信息-->
<Table No="表8" Name="JZD" tablemark="JZD_ZD_TXQ" mustfillfield="" description="界址点（提取宗地界址点数据包括抵押、查封、预告、地役权、异议对应的宗地界址点数据）。" >
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZDH,J.SXH,J.JBLX,J.JZDLX,J.XZBZ,J.YZBZ,J.QXDM,J.BSM AS DJBBSM
FROM BDCDJB.JZD J WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZDJBXX D WHERE D.ZDDM=J.ZDZHDM AND
EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBSM=D.BSM AND Q.DYBM='ZDJBXX' AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' )) ]]>
</Table>
<Table No="表8" Name="JZD" tablemark="JZD_ZD_DYAQ_ZX" mustfillfield="" description="界址点（提取宗地界址点数据，主要针对抵押权注销业务对应的宗地界址点数据）。" >
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZDH,J.SXH,J.JBLX,J.JZDLX,J.XZBZ,J.YZBZ,J.QXDM,J.BSM AS DJBBSM
FROM BDCDJB.JZD J WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZDJBXX D WHERE D.ZDDM=J.ZDZHDM AND
EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBSM=D.BSM AND Q.DYBM='ZDJBXX' AND Q.ZXDYYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}')) ]]>
</Table>
<Table No="表8" Name="JZD" tablemark="JZD_ZD_CFDJ_ZX" mustfillfield="" description="界址点（提取宗地界址点数据，主要针对查封登记注销业务对应的宗地界址点数据）。" >
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZDH,J.SXH,J.JBLX,J.JZDLX,J.XZBZ,J.YZBZ,J.QXDM,J.BSM AS DJBBSM
FROM BDCDJB.JZD J WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZDJBXX D WHERE D.ZDDM=J.ZDZHDM AND
EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBSM=D.BSM AND Q.DYBM='ZDJBXX' AND Q.JFYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}')) ]]>
</Table>
<Table No="表8" Name="JZD" tablemark="JZD_ZD_YGDJ_ZX" mustfillfield="" description="界址点（提取宗地界址点数据，主要针对预告登记注销业务对应的宗地界址点数据）。" >
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZDH,J.SXH,J.JBLX,J.JZDLX,J.XZBZ,J.YZBZ,J.QXDM,J.BSM AS DJBBSM
FROM BDCDJB.JZD J WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZDJBXX D WHERE D.ZDDM=J.ZDZHDM AND
EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBSM=D.BSM AND Q.DYBM='ZDJBXX' AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')) ]]>
</Table>
<Table No="表8" Name="JZD" tablemark="JZD_ZD_DYIQ_ZX" mustfillfield="" description="界址点（提取宗地界址点数据，主要针对地役权登记注销业务对应的宗地界址点数据）。" >
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZDH,J.SXH,J.JBLX,J.JZDLX,J.XZBZ,J.YZBZ,J.QXDM,J.BSM AS DJBBSM
FROM BDCDJB.JZD J WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZDJBXX D WHERE D.ZDDM=J.ZDZHDM AND
EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBSM=D.BSM AND Q.DYBM='ZDJBXX' AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')) ]]>
</Table>
<Table No="表8" Name="JZD" tablemark="JZD_ZD_YYDJ_ZX" mustfillfield="" description="界址点（提取宗地界址点数据，主要针对地异议登记登记注销业务对应的宗地界址点数据）。" >
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZDH,J.SXH,J.JBLX,J.JZDLX,J.XZBZ,J.YZBZ,J.QXDM,J.BSM AS DJBBSM
FROM BDCDJB.JZD J WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZDJBXX D WHERE D.ZDDM=J.ZDZHDM AND
EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBSM=D.BSM AND Q.DYBM='ZDJBXX' AND Q.ZXYYYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}')) ]]>
</Table>
<!--如果他项权的对应的单元为户（H）,则根据户关联获取宗地对应的界址点信息-->
<Table No="表8" Name="JZD" tablemark="JZD_ZD_H_TXQ" mustfillfield="" description="界址点（提取宗地界址点数据，主要针对地异议登记登记注销业务对应的宗地界址点数据）。" >
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZDH,J.SXH,J.JBLX,J.JZDLX,J.XZBZ,J.YZBZ,J.QXDM,J.BSM AS DJBBSM
FROM BDCDJB.JZD J WHERE EXISTS (SELECT 1 FROM BDCDJB.ZDJBXX D WHERE D.ZDDM=J.ZDZHDM AND EXISTS (SELECT 1 FROM BDCDJB.H H WHERE H.ZDJBXXBSM=D.BSM
AND EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBM='H' AND Q.DYBSM=H.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')) ) ]]>
</Table>
<!--获取海域使用权对应的宗海基本信息的界址点信息-->
<Table No="表8" Name="JZD" tablemark="JZD_ZH" mustfillfield="" description="界址点（提取宗海界址点数据,主要针对HYSYQ的登记业务对应的界址点数据）。" >
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZDH,J.SXH,J.JBLX,J.JZDLX,J.XZBZ,J.YZBZ,J.QXDM,J.BSM AS DJBBSM
FROM BDCDJB.JZD J WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZHJBXX D WHERE D.ZHDM=J.ZDZHDM AND
EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.ZHJBXXBSM=D.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')) ]]>
</Table>
<Table No="表8" Name="JZD" tablemark="JZD_ZH_ZX" mustfillfield="" description="界址点（提取宗海界址点数据,主要针对HYSYQ的注销登记业务对应的界址点数据）。" >
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZDH,J.SXH,J.JBLX,J.JZDLX,J.XZBZ,J.YZBZ,J.QXDM,J.BSM AS DJBBSM
FROM BDCDJB.JZD J WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZHJBXX D WHERE D.ZHDM=J.ZDZHDM AND
EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.ZHJBXXBSM=D.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')) ]]>
</Table>
<Table No="表8" Name="JZD" tablemark="JZD_ZH_TXQ" mustfillfield="" description="界址点（提取宗海界址点数据,主要针对HYSYQ的抵押，查封，预告，地役权，异议对应的界址点数据）。" >
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZDH,J.SXH,J.JBLX,J.JZDLX,J.XZBZ,J.YZBZ,J.QXDM,J.BSM AS DJBBSM
FROM BDCDJB.JZD J WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZHJBXX D WHERE D.ZHDM=J.ZDZHDM AND
EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBSM=D.BSM AND Q.DYBM='ZHJBXX' AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')) ]]>
</Table>
<Table No="表8" Name="JZD" tablemark="JZD_ZH_DYAQ_ZX" mustfillfield="" description="界址点（提取宗海界址点数据,主要针对HYSYQ的抵押权注销对应的界址点数据）。" >
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZDH,J.SXH,J.JBLX,J.JZDLX,J.XZBZ,J.YZBZ,J.QXDM,J.BSM AS DJBBSM
FROM BDCDJB.JZD J WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZHJBXX D WHERE D.ZHDM=J.ZDZHDM AND
EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBSM=D.BSM AND Q.DYBM='ZHJBXX' AND Q.ZXDYYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}')) ]]>
</Table>
<Table No="表8" Name="JZD" tablemark="JZD_ZH_CFDJ_ZX" mustfillfield="" description="界址点（提取宗海界址点数据,主要针对HYSYQ的查封登记注销对应的界址点数据）。" >
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZDH,J.SXH,J.JBLX,J.JZDLX,J.XZBZ,J.YZBZ,J.QXDM,J.BSM AS DJBBSM
FROM BDCDJB.JZD J WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZHJBXX D WHERE D.ZHDM=J.ZDZHDM AND
EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBSM=D.BSM AND Q.DYBM='ZHJBXX' AND Q.JFYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}')) ]]>
</Table>
<Table No="表8" Name="JZD" tablemark="JZD_ZH_YGDJ_ZX" mustfillfield="" description="界址点（提取宗海界址点数据,主要针对HYSYQ的预告登记注销对应的界址点数据）。" >
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZDH,J.SXH,J.JBLX,J.JZDLX,J.XZBZ,J.YZBZ,J.QXDM,J.BSM AS DJBBSM
FROM BDCDJB.JZD J WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZHJBXX D WHERE D.ZHDM=J.ZDZHDM AND
EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBSM=D.BSM AND Q.DYBM='ZHJBXX' AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')) ]]>
</Table>
<Table No="表8" Name="JZD" tablemark="JZD_ZH_DYIQ_ZX" mustfillfield="" description="界址点（提取宗海界址点数据,主要针对HYSYQ的地役权登记注销对应的界址点数据）。" >
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZDH,J.SXH,J.JBLX,J.JZDLX,J.XZBZ,J.YZBZ,J.QXDM,J.BSM AS DJBBSM
FROM BDCDJB.JZD J WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZHJBXX D WHERE D.ZHDM=J.ZDZHDM AND
EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBSM=D.BSM AND Q.DYBM='ZHJBXX' AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')) ]]>
</Table>
<Table No="表8" Name="JZD" tablemark="JZD_ZH_YYDJ_ZX" mustfillfield="" description="界址点（提取宗海界址点数据,主要针对HYSYQ的异议登记注销对应的界址点数据）。" >
<![CDATA[ SELECT J.BSM,J.ZDZHDM,J.YSDM,J.JZDH,J.SXH,J.JBLX,J.JZDLX,J.XZBZ,J.YZBZ,J.QXDM,J.BSM AS DJBBSM
FROM BDCDJB.JZD J WHERE EXISTS ( SELECT 1 FROM BDCDJB.ZHJBXX D WHERE D.ZHDM=J.ZDZHDM AND
EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBSM=D.BSM AND Q.DYBM='ZHJBXX' AND Q.ZXYYYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}')) ]]>
</Table>
<!--房地产权+ 租赁使用权-->
<Table No="表9" Name="C" tablemark="H_FDCQ" mustfillfield="" description="层表数据。">
<![CDATA[ SELECT * FROM BDCDJB.C C WHERE EXISTS (SELECT 1 FROM BDCDJB.H D WHERE D.CBSM=C.BSM AND EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.HBSM=D.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')) ]]>
</Table>
<!--FDCQ1，FDCQ2 首次登记+ FDCQ3 获取层信息(包含业主共用部分)-->
<Table No="表9" Name="C" tablemark="H_FDCQ_YZGY" mustfillfield="" description="层表数据(包含业主共用部分)。">
<![CDATA[ SELECT * FROM BDCDJB.C C WHERE EXISTS (SELECT 1 FROM BDCDJB.H D WHERE D.CBSM=C.BSM AND D.BSM IN ( SELECT Q.HBSM FROM BDCDJB.{QLBM} Q WHERE Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' UNION SELECT Q.HBSM FROM BDCDJB.FDCQ3 Q WHERE Q.YWH='{YWH}')) ]]>
</Table>
<Table No="表9" Name="C" tablemark="H_FDCQ_ZX" mustfillfield="" description="层表数据。">
<![CDATA[ SELECT * FROM BDCDJB.C C WHERE EXISTS (SELECT 1 FROM BDCDJB.H D WHERE D.CBSM=C.BSM AND EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.HBSM=D.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')) ]]>
</Table>
<Table No="表9" Name="C" tablemark="H_TXQ" mustfillfield="" description="层表数据。">
<![CDATA[ SELECT * FROM BDCDJB.C C WHERE EXISTS (SELECT 1 FROM BDCDJB.H D WHERE D.CBSM=C.BSM AND EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBM='H' AND Q.DYBSM=D.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')) ]]>
</Table>
<Table No="表9" Name="C" tablemark="H_DYAQ_ZX" mustfillfield="" description="层表数据。">
<![CDATA[ SELECT * FROM BDCDJB.C C WHERE EXISTS (SELECT 1 FROM BDCDJB.H D WHERE D.CBSM=C.BSM AND EXISTS (SELECT 1 FROM BDCDJB.DYAQ Q WHERE Q.DYBM='H' AND Q.DYBSM=D.BSM AND Q.ZXDYYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}')) ]]>
</Table>
<Table No="表9" Name="C" tablemark="H_ZLSYQ_ZX" mustfillfield="" description="层表数据。">
<![CDATA[ SELECT * FROM BDCDJB.C C WHERE EXISTS (SELECT 1 FROM BDCDJB.H D WHERE D.CBSM=C.BSM AND EXISTS (SELECT 1 FROM BDCDJB.ZLSYQ Q WHERE Q.HBSM=D.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}')) ]]>
</Table>
<Table No="表9" Name="C" tablemark="H_JUZQ_ZX" mustfillfield="" description="层表数据。">
<![CDATA[ SELECT * FROM BDCDJB.C C WHERE EXISTS (SELECT 1 FROM BDCDJB.H D WHERE D.CBSM=C.BSM AND EXISTS (SELECT 1 FROM BDCDJB.JUZQ Q WHERE Q.DYBSM=D.BSM AND Q.DYBM='H' AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}')) ]]>
</Table>
<Table No="表9" Name="C" tablemark="H_YGDJ_ZX" mustfillfield="" description="层表数据。">
<![CDATA[ SELECT * FROM BDCDJB.C C WHERE EXISTS (SELECT 1 FROM BDCDJB.H D WHERE D.CBSM=C.BSM AND EXISTS (SELECT 1 FROM BDCDJB.YGDJ Q WHERE Q.DYBM='H' AND Q.DYBSM=D.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')) ]]>
</Table>
<Table No="表9" Name="C" tablemark="H_CFDJ_ZX" mustfillfield="" description="层表数据。">
<![CDATA[ SELECT * FROM BDCDJB.C C WHERE EXISTS (SELECT 1 FROM BDCDJB.H D WHERE D.CBSM=C.BSM AND EXISTS (SELECT 1 FROM BDCDJB.CFDJ Q WHERE Q.DYBM='H' AND Q.DYBSM=D.BSM AND Q.JFYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}')) ]]>
</Table>
<Table No="表9" Name="C" tablemark="H_DYIQ_ZX" mustfillfield="" description="层表数据。">
<![CDATA[ SELECT * FROM BDCDJB.C C WHERE EXISTS (SELECT 1 FROM BDCDJB.H D WHERE D.CBSM=C.BSM AND EXISTS (SELECT 1 FROM BDCDJB.DYIQ Q WHERE Q.DYBM='H' AND Q.DYBSM=D.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')) ]]>
</Table>
<Table No="表9" Name="C" tablemark="H_YYDJ_ZX" mustfillfield="" description="层表数据。">
<![CDATA[ SELECT * FROM BDCDJB.C C WHERE EXISTS (SELECT 1 FROM BDCDJB.H D WHERE D.CBSM=C.BSM AND EXISTS (SELECT 1 FROM BDCDJB.YYDJ Q WHERE Q.DYBM='H' AND Q.DYBSM=D.BSM AND Q.ZXYYYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}')) ]]>
</Table>
<Table No="表10" Name="H" tablemark="H_FDCQ" mustfillfield="" description="户表数据(房地产权相关FDCQ1,FDCQ2)。">
<![CDATA[ SELECT * FROM BDCDJB.H D WHERE EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.HBSM=D.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}') ]]>
</Table>
<!--FDCQ1，FDCQ2 首次登记+ FDCQ3 获取户信息(包含业主共用部分)-->
<Table No="表10" Name="H" tablemark="H_FDCQ_YZGY" mustfillfield="" description="户表数据(房地产权相关FDCQ1,FDCQ2,包含业主共用部分)。">
<![CDATA[ SELECT * FROM BDCDJB.H D WHERE D.BSM IN ( SELECT Q.HBSM FROM BDCDJB.{QLBM} Q WHERE Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' UNION SELECT Q.HBSM FROM BDCDJB.FDCQ3 Q WHERE Q.YWH='{YWH}') ]]>
</Table>
<Table No="表10" Name="H" tablemark="H_FDCQ_ZX" mustfillfield="" description="户表数据(房地产权相关FDCQ1,FDCQ2的注销业务)。">
<![CDATA[ SELECT * FROM BDCDJB.H D WHERE EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.HBSM=D.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}') ]]>
</Table>
<Table No="表10" Name="H" tablemark="H_TXQ" mustfillfield="" description="户表数据(抵押查封预告地役权异议等他项权)。">
<![CDATA[ SELECT * FROM BDCDJB.H D WHERE EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBM='H' AND Q.DYBSM=D.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}') ]]>
</Table>
<Table No="表10" Name="H" tablemark="H_DYAQ_ZX" mustfillfield="" description="户表数据(抵押权注销业务)。">
<![CDATA[ SELECT * FROM BDCDJB.H D WHERE EXISTS (SELECT 1 FROM BDCDJB.DYAQ Q WHERE Q.DYBM='H' AND Q.DYBSM=D.BSM AND Q.ZXDYYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}') ]]>
</Table>
<Table No="表10" Name="H" tablemark="H_ZLSYQ_ZX" mustfillfield="" description="户表数据(租赁使用权注销业务)。">
<![CDATA[ SELECT * FROM BDCDJB.H D WHERE EXISTS (SELECT 1 FROM BDCDJB.ZLSYQ Q WHERE Q.HBSM=D.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}') ]]>
</Table>
<Table No="表10" Name="H" tablemark="H_JUZQ_ZX" mustfillfield="" description="户表数据(居住权注销业务)。">
<![CDATA[ SELECT * FROM BDCDJB.H D WHERE EXISTS (SELECT 1 FROM BDCDJB.JUZQ Q WHERE Q.DYBSM=D.BSM AND Q.DYBM='H' AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}') ]]>
</Table>
<Table No="表10" Name="H" tablemark="H_CFDJ_ZX" mustfillfield="" description="户表数据(查封登记注销业务)。">
<![CDATA[ SELECT * FROM BDCDJB.H D WHERE EXISTS (SELECT 1 FROM BDCDJB.CFDJ Q WHERE Q.DYBM='H' AND Q.DYBSM=D.BSM AND Q.JFYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}') ]]>
</Table>
<Table No="表10" Name="H" tablemark="H_YGDJ_ZX" mustfillfield="" description="户表数据(预告登记注销业务)。">
<![CDATA[ SELECT * FROM BDCDJB.H D WHERE EXISTS (SELECT 1 FROM BDCDJB.YGDJ Q WHERE Q.DYBM='H' AND Q.DYBSM=D.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}') ]]>
</Table>
<Table No="表10" Name="H" tablemark="H_DYIQ_ZX" mustfillfield="" description="户表数据(地役权登记注销业务)。">
<![CDATA[ SELECT * FROM BDCDJB.H D WHERE EXISTS (SELECT 1 FROM BDCDJB.DYIQ Q WHERE Q.DYBM='H' AND Q.DYBSM=D.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}') ]]>
</Table>
<Table No="表10" Name="H" tablemark="H_YYDJ_ZX" mustfillfield="" description="户表数据(异议登记注销业务)。">
<![CDATA[ SELECT * FROM BDCDJB.H D WHERE EXISTS (SELECT 1 FROM BDCDJB.YYDJ Q WHERE Q.DYBM='H' AND Q.DYBSM=D.BSM AND Q.ZXYYYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}') ]]>
</Table>
<Table No="表11" Name="H_BHGX" tablemark="H_BHGX_FDCQ" mustfillfield="" description="户变化关系表数据(房地产权相关FDCQ1,FDCQ2,ZLSYQ)。">
<![CDATA[ SELECT B.BSM,B.YWH,B.YDYBSM,B.XDYBSM,B.BHSJ,B.QXDM,B.DJBSM,X.DJBSM AS XDYDJBSM,X.BBH AS XDYBBH,Y.DJBSM AS YDYDJBSM,Y.BBH AS YDYBBH FROM BDCDJB.H_BHGX B,BDCDJB.H X,BDCDJB.H Y WHERE B.XDYBSM=X.BSM AND B.YDYBSM=Y.BSM AND EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.HBSM=B.XDYBSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}') ]]>
</Table>
<Table No="表11" Name="H_BHGX" tablemark="H_BHGX_FDCQ_ZX" mustfillfield="" description="户变化关系表数据(房地产权相关FDCQ1,FDCQ2的注销业务)。">
<![CDATA[ SELECT B.BSM,B.YWH,B.YDYBSM,B.XDYBSM,B.BHSJ,B.QXDM,B.DJBSM,X.DJBSM AS XDYDJBSM,X.BBH AS XDYBBH,Y.DJBSM AS YDYDJBSM,Y.BBH AS YDYBBH FROM BDCDJB.H_BHGX B,BDCDJB.H X,BDCDJB.H Y WHERE B.XDYBSM=X.BSM AND B.YDYBSM=Y.BSM AND EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.HBSM=B.XDYBSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}') ]]>
</Table>
<Table No="表11" Name="H_BHGX" tablemark="H_BHGX_TXQ" mustfillfield="" description="户变化关系表数据(抵押查封预告地役权异议等他项权)。">
<![CDATA[ SELECT B.BSM,B.YWH,B.YDYBSM,B.XDYBSM,B.BHSJ,B.QXDM,B.DJBSM,X.DJBSM AS XDYDJBSM,X.BBH AS XDYBBH,Y.DJBSM AS YDYDJBSM,Y.BBH AS YDYBBH FROM BDCDJB.H_BHGX B,BDCDJB.H X,BDCDJB.H Y WHERE B.XDYBSM=X.BSM AND B.YDYBSM=Y.BSM AND EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.DYBM='H' AND Q.DYBSM=B.XDYBSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}') ]]>
</Table>
<Table No="表11" Name="H_BHGX" tablemark="H_BHGX_DYAQ_ZX" mustfillfield="" description="户变化关系表数据(抵押权注销业务)。">
<![CDATA[ SELECT B.BSM,B.YWH,B.YDYBSM,B.XDYBSM,B.BHSJ,B.QXDM,B.DJBSM,X.DJBSM AS XDYDJBSM,X.BBH AS XDYBBH,Y.DJBSM AS YDYDJBSM,Y.BBH AS YDYBBH FROM BDCDJB.H_BHGX B,BDCDJB.H X,BDCDJB.H Y WHERE B.XDYBSM=X.BSM AND B.YDYBSM=Y.BSM AND EXISTS (SELECT 1 FROM BDCDJB.DYAQ Q WHERE Q.DYBM='H' AND Q.DYBSM=B.XDYBSM AND Q.ZXDYYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}') ]]>
</Table>
<Table No="表11" Name="H_BHGX" tablemark="H_BHGX_CFDJ_ZX" mustfillfield="" description="户变化关系表数据(查封登记注销业务)。">
<![CDATA[ SELECT B.BSM,B.YWH,B.YDYBSM,B.XDYBSM,B.BHSJ,B.QXDM,B.DJBSM,X.DJBSM AS XDYDJBSM,X.BBH AS XDYBBH,Y.DJBSM AS YDYDJBSM,Y.BBH AS YDYBBH FROM BDCDJB.H_BHGX B,BDCDJB.H X,BDCDJB.H Y WHERE B.XDYBSM=X.BSM AND B.YDYBSM=Y.BSM AND EXISTS (SELECT 1 FROM BDCDJB.CFDJ Q WHERE Q.DYBM='H' AND Q.DYBSM=B.XDYBSM AND Q.JFYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}') ]]>
</Table>
<Table No="表11" Name="H_BHGX" tablemark="H_BHGX_YGDJ_ZX" mustfillfield="" description="户变化关系表数据(预告登记注销业务)。">
<![CDATA[ SELECT B.BSM,B.YWH,B.YDYBSM,B.XDYBSM,B.BHSJ,B.QXDM,B.DJBSM,X.DJBSM AS XDYDJBSM,X.BBH AS XDYBBH,Y.DJBSM AS YDYDJBSM,Y.BBH AS YDYBBH FROM BDCDJB.H_BHGX B,BDCDJB.H X,BDCDJB.H Y WHERE B.XDYBSM=X.BSM AND B.YDYBSM=Y.BSM AND EXISTS (SELECT 1 FROM BDCDJB.YGDJ Q WHERE Q.DYBM='H' AND Q.DYBSM=B.XDYBSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}') ]]>
</Table>
<Table No="表11" Name="H_BHGX" tablemark="H_BHGX_DYIQ_ZX" mustfillfield="" description="户变化关系表数据(地役权登记注销业务)。">
<![CDATA[ SELECT B.BSM,B.YWH,B.YDYBSM,B.XDYBSM,B.BHSJ,B.QXDM,B.DJBSM,X.DJBSM AS XDYDJBSM,X.BBH AS XDYBBH,Y.DJBSM AS YDYDJBSM,Y.BBH AS YDYBBH FROM BDCDJB.H_BHGX B,BDCDJB.H X,BDCDJB.H Y WHERE B.XDYBSM=X.BSM AND B.YDYBSM=Y.BSM AND EXISTS (SELECT 1 FROM BDCDJB.DYIQ Q WHERE Q.DYBM='H' AND Q.DYBSM=B.XDYBSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}') ]]>
</Table>
<Table No="表11" Name="H_BHGX" tablemark="H_BHGX_YYDJ_ZX" mustfillfield="" description="户变化关系表数据(异议登记注销业务)。">
<![CDATA[ SELECT B.BSM,B.YWH,B.YDYBSM,B.XDYBSM,B.BHSJ,B.QXDM,B.DJBSM,X.DJBSM AS XDYDJBSM,X.BBH AS XDYBBH,Y.DJBSM AS YDYDJBSM,Y.BBH AS YDYBBH FROM BDCDJB.H_BHGX B,BDCDJB.H X,BDCDJB.H Y WHERE B.XDYBSM=X.BSM AND B.YDYBSM=Y.BSM AND EXISTS (SELECT 1 FROM BDCDJB.YYDJ Q WHERE Q.DYBM='H' AND Q.DYBSM=B.XDYBSM AND Q.ZXYYYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}') ]]>
</Table>
<Table No="表12" Name="TDSYQ" tablemark="TDSYQ" mustfillfield="" description="土地所有权。">
<![CDATA[ SELECT Z.DJBSM AS ZDJBXXDJBSM,Z.BBH AS ZDJBXXBBH, Q.* FROM BDCDJB.TDSYQ Q,BDCDJB.ZDJBXX Z WHERE Q.ZDJBXXBSM=Z.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ]]>
</Table>
<Table No="表12" Name="TDSYQ" tablemark="TDSYQ_ZX" mustfillfield="" description="土地所有权（注销业务）。">
<![CDATA[ SELECT Z.DJBSM AS ZDJBXXDJBSM,Z.BBH AS ZDJBXXBBH, Q.* FROM BDCDJB.TDSYQ Q,BDCDJB.ZDJBXX Z WHERE Q.ZDJBXXBSM=Z.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ]]>
</Table>
<Table No="表13" Name="TDSYQ_BHGX" tablemark="TDSYQ" mustfillfield="" description="土地所有权变化关系。">
<![CDATA[ SELECT G.BSM,G.YWH,G.QLBSM,G.YQLBSM,G.BHSJ,G.QXDM,G.DJBSM,Q.DJBSM AS QLDJBSM,Q.BDCDYH AS QLBDCDYH,Y.DJBSM AS YQLDJBSM,Y.BDCDYH AS YQLBDCDYH FROM BDCDJB.TDSYQ_BHGX G,BDCDJB.TDSYQ Q,BDCDJB.TDSYQ Y WHERE G.QLBSM=Q.BSM AND G.YQLBSM=Y.BSM AND EXISTS ( SELECT 1 FROM BDCDJB.TDSYQ Q WHERE Q.BSM=G.QLBSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ) ]]>
</Table>
<Table No="表13" Name="TDSYQ_BHGX" tablemark="TDSYQ_ZX" mustfillfield="" description="土地所有权变化关系（注销业务）。">
<![CDATA[ SELECT G.BSM,G.YWH,G.QLBSM,G.YQLBSM,G.BHSJ,G.QXDM,G.DJBSM,Q.DJBSM AS QLDJBSM,Q.BDCDYH AS QLBDCDYH,Y.DJBSM AS YQLDJBSM,Y.BDCDYH AS YQLBDCDYH FROM BDCDJB.TDSYQ_BHGX G,BDCDJB.TDSYQ Q,BDCDJB.TDSYQ Y WHERE G.QLBSM=Q.BSM AND G.YQLBSM=Y.BSM AND EXISTS ( SELECT 1 FROM BDCDJB.TDSYQ Q WHERE Q.BSM=G.QLBSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ) ]]>
</Table>
<Table No="表14" Name="JSYDSYQ" tablemark="JSYDSYQ" mustfillfield="" description="建设用地使用权。">
<![CDATA[ SELECT Z.DJBSM AS ZDJBXXDJBSM,Z.BBH AS ZDJBXXBBH, Q.* FROM BDCDJB.JSYDSYQ Q,BDCDJB.ZDJBXX Z WHERE Q.ZDJBXXBSM=Z.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ]]>
</Table>
<Table No="表14" Name="JSYDSYQ" tablemark="JSYDSYQ_ZX" mustfillfield="" description="建设用地使用权（注销业务）。">
<![CDATA[ SELECT Z.DJBSM AS ZDJBXXDJBSM,Z.BBH AS ZDJBXXBBH, Q.* FROM BDCDJB.JSYDSYQ Q,BDCDJB.ZDJBXX Z WHERE Q.ZDJBXXBSM=Z.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ]]>
</Table>
<Table No="表15" Name="JSYDSYQ_BHGX" tablemark="JSYDSYQ" mustfillfield="" description="建设用地使用权变化关系。">
<![CDATA[ SELECT G.BSM,G.YWH,G.QLBSM,G.YQLBSM,G.BHSJ,G.QXDM,G.DJBSM,Q.DJBSM AS QLDJBSM,Q.BDCDYH AS QLBDCDYH,Y.DJBSM AS YQLDJBSM,Y.BDCDYH AS YQLBDCDYH FROM BDCDJB.JSYDSYQ_BHGX G,BDCDJB.JSYDSYQ Q,BDCDJB.JSYDSYQ Y WHERE G.QLBSM=Q.BSM AND G.YQLBSM=Y.BSM AND EXISTS ( SELECT 1 FROM BDCDJB.JSYDSYQ Q WHERE Q.BSM=G.QLBSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ) ]]>
</Table>
<Table No="表15" Name="JSYDSYQ_BHGX" tablemark="JSYDSYQ_ZX" mustfillfield="" description="建设用地使用权变化关系（注销业务）。">
<![CDATA[ SELECT G.BSM,G.YWH,G.QLBSM,G.YQLBSM,G.BHSJ,G.QXDM,G.DJBSM,Q.DJBSM AS QLDJBSM,Q.BDCDYH AS QLBDCDYH,Y.DJBSM AS YQLDJBSM,Y.BDCDYH AS YQLBDCDYH FROM BDCDJB.JSYDSYQ_BHGX G,BDCDJB.JSYDSYQ Q,BDCDJB.JSYDSYQ Y WHERE G.QLBSM=Q.BSM AND G.YQLBSM=Y.BSM AND EXISTS ( SELECT 1 FROM BDCDJB.JSYDSYQ Q WHERE Q.BSM=G.QLBSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ) ]]>
</Table>
<Table No="表16" Name="FDCQ1" tablemark="FDCQ1" mustfillfield="" description="房地产权。">
<![CDATA[ SELECT Z.DJBSM AS ZDJBXXDJBSM,Z.BBH AS ZDJBXXBBH,D.DJBSM AS HDJBSM,D.BBH AS HBBH, Q.* FROM BDCDJB.FDCQ1 Q,BDCDJB.ZDJBXX Z,BDCDJB.H D WHERE Q.ZDJBXXBSM=Z.BSM AND Q.HBSM=D.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ]]>
</Table>
<Table No="表16" Name="FDCQ1" tablemark="FDCQ1_ZX" mustfillfield="" description="房地产权（注销业务）。">
<![CDATA[ SELECT Z.DJBSM AS ZDJBXXDJBSM,Z.BBH AS ZDJBXXBBH,D.DJBSM AS HDJBSM,D.BBH AS HBBH, Q.* FROM BDCDJB.FDCQ1 Q,BDCDJB.ZDJBXX Z,BDCDJB.H D WHERE Q.ZDJBXXBSM=Z.BSM AND Q.HBSM=D.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ]]>
</Table>
<Table No="表17" Name="FDCQXM" tablemark="FDCQ1" mustfillfield="" description="房地产权项目。">
<![CDATA[ SELECT * FROM BDCDJB.FDCQXM X WHERE EXISTS (SELECT 1 FROM BDCDJB.FDCQ1 Q WHERE Q.YWH=X.YWH AND Q.BDCDYH=X.BDCDYH AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}') ]]>
</Table>
<Table No="表17" Name="FDCQXM" tablemark="FDCQ1_ZX" mustfillfield="" description="房地产权项目（注销业务）。">
<![CDATA[ SELECT * FROM BDCDJB.FDCQXM X WHERE EXISTS (SELECT 1 FROM BDCDJB.FDCQ1 Q WHERE Q.YWH=X.YWH AND Q.BDCDYH=X.BDCDYH AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}') ]]>
</Table>
<Table No="表18" Name="FDCQ1_BHGX" tablemark="FDCQ1" mustfillfield="" description="房地产权变化关系。">
<![CDATA[ SELECT G.BSM,G.YWH,G.QLBSM,G.YQLBSM,G.BHSJ,G.QXDM,G.DJBSM,Q.DJBSM AS QLDJBSM,Q.BDCDYH AS QLBDCDYH,Y.DJBSM AS YQLDJBSM,Y.BDCDYH AS YQLBDCDYH FROM BDCDJB.FDCQ1_BHGX G,BDCDJB.FDCQ1 Q,BDCDJB.FDCQ1 Y WHERE G.QLBSM=Q.BSM AND G.YQLBSM=Y.BSM AND EXISTS ( SELECT 1 FROM BDCDJB.FDCQ1 Q WHERE Q.BSM=G.QLBSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ) ]]>
</Table>
<Table No="表18" Name="FDCQ1_BHGX" tablemark="FDCQ1_ZX" mustfillfield="" description="房地产权变化关系（注销业务）。">
<![CDATA[ SELECT G.BSM,G.YWH,G.QLBSM,G.YQLBSM,G.BHSJ,G.QXDM,G.DJBSM,Q.DJBSM AS QLDJBSM,Q.BDCDYH AS QLBDCDYH,Y.DJBSM AS YQLDJBSM,Y.BDCDYH AS YQLBDCDYH FROM BDCDJB.FDCQ1_BHGX G,BDCDJB.FDCQ1 Q,BDCDJB.FDCQ1 Y WHERE G.QLBSM=Q.BSM AND G.YQLBSM=Y.BSM AND EXISTS ( SELECT 1 FROM BDCDJB.FDCQ1 Q WHERE Q.BSM=G.QLBSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ) ]]>
</Table>
<Table No="表19" Name="FDCQ2" tablemark="FDCQ2" mustfillfield="" description="房地产权。">
<![CDATA[ SELECT Z.DJBSM AS ZDJBXXDJBSM,Z.BBH AS ZDJBXXBBH,D.DJBSM AS HDJBSM,D.BBH AS HBBH, Q.* FROM BDCDJB.FDCQ2 Q,BDCDJB.ZDJBXX Z,BDCDJB.H D WHERE Q.ZDJBXXBSM=Z.BSM AND Q.HBSM=D.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ]]>
</Table>
<Table No="表19" Name="FDCQ2" tablemark="FDCQ2_ZX" mustfillfield="" description="房地产权（注销业务）。">
<![CDATA[ SELECT Z.DJBSM AS ZDJBXXDJBSM,Z.BBH AS ZDJBXXBBH,D.DJBSM AS HDJBSM,D.BBH AS HBBH, Q.* FROM BDCDJB.FDCQ2 Q,BDCDJB.ZDJBXX Z,BDCDJB.H D WHERE Q.ZDJBXXBSM=Z.BSM AND Q.HBSM=D.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ]]>
</Table>
<Table No="表20" Name="FDCQ2_BHGX" tablemark="FDCQ2" mustfillfield="" description="房地产权变化关系。">
<![CDATA[ SELECT G.BSM,G.YWH,G.QLBSM,G.YQLBSM,G.BHSJ,G.QXDM,G.DJBSM,Q.DJBSM AS QLDJBSM,Q.BDCDYH AS QLBDCDYH,Y.DJBSM AS YQLDJBSM,Y.BDCDYH AS YQLBDCDYH FROM BDCDJB.FDCQ2_BHGX G,BDCDJB.FDCQ2 Q,BDCDJB.FDCQ2 Y WHERE G.QLBSM=Q.BSM AND G.YQLBSM=Y.BSM AND EXISTS ( SELECT 1 FROM BDCDJB.FDCQ2 Q WHERE Q.BSM=G.QLBSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ) ]]>
</Table>
<Table No="表20" Name="FDCQ2_BHGX" tablemark="FDCQ2_ZX" mustfillfield="" description="房地产权变化关系（注销业务）。">
<![CDATA[ SELECT G.BSM,G.YWH,G.QLBSM,G.YQLBSM,G.BHSJ,G.QXDM,G.DJBSM,Q.DJBSM AS QLDJBSM,Q.BDCDYH AS QLBDCDYH,Y.DJBSM AS YQLDJBSM,Y.BDCDYH AS YQLBDCDYH FROM BDCDJB.FDCQ2_BHGX G,BDCDJB.FDCQ2 Q,BDCDJB.FDCQ2 Y WHERE G.QLBSM=Q.BSM AND G.YQLBSM=Y.BSM AND EXISTS ( SELECT 1 FROM BDCDJB.FDCQ2 Q WHERE Q.BSM=G.QLBSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ) ]]>
</Table>
<Table No="表21" Name="FDCQ3" tablemark="FDCQ3" mustfillfield="" description="房地产权首次登记的业主共用部分（非必要）。">
<![CDATA[ SELECT * FROM BDCDJB.FDCQ3 Q WHERE Q.YWH='{YWH}' ]]>
</Table>
<Table No="表21" Name="BDCDYQLGX" tablemark="FDCQ" mustfillfield="" description="不动产单元权利关系（非必要）。">
<![CDATA[ SELECT * FROM BDCDJB.BDCDYQLGX G WHERE G.DJDZWQLBSM={DJQLBSM} ]]>
</Table>
<Table No="表22" Name="HYSYQ" tablemark="HYSYQ" mustfillfield="" description="海域(含无居民海岛)使用权。">
<![CDATA[ SELECT Z.DJBSM AS ZHJBXXDJBSM,Z.BBH AS ZHJBXXBBH, Q.* FROM BDCDJB.HYSYQ Q,BDCDJB.ZHJBXX Z WHERE Q.ZHJBXXBSM=Z.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ]]>
</Table>
<Table No="表22" Name="HYSYQ" tablemark="HYSYQ_ZX" mustfillfield="" description="海域(含无居民海岛)使用权（注销业务）。">
<![CDATA[ SELECT Z.DJBSM AS ZHJBXXDJBSM,Z.BBH AS ZHJBXXBBH, Q.* FROM BDCDJB.HYSYQ Q,BDCDJB.ZHJBXX Z WHERE Q.ZHJBXXBSM=Z.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ]]>
</Table>
<Table No="表23" Name="HYSYQ_BHGX" tablemark="HYSYQ" mustfillfield="" description="海域(含无居民海岛)使用权变化关系。">
<![CDATA[ SELECT G.BSM,G.YWH,G.QLBSM,G.YQLBSM,G.BHSJ,G.QXDM,G.DJBSM,Q.DJBSM AS QLDJBSM,Q.BDCDYH AS QLBDCDYH,Y.DJBSM AS YQLDJBSM,Y.BDCDYH AS YQLBDCDYH FROM BDCDJB.HYSYQ_BHGX G,BDCDJB.HYSYQ Q,BDCDJB.HYSYQ Y WHERE G.QLBSM=Q.BSM AND G.YQLBSM=Y.BSM AND EXISTS ( SELECT 1 FROM BDCDJB.HYSYQ Q WHERE Q.BSM=G.QLBSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ) ]]>
</Table>
<Table No="表23" Name="HYSYQ_BHGX" tablemark="HYSYQ_ZX" mustfillfield="" description="海域(含无居民海岛)使用权变化关系（注销业务）。">
<![CDATA[ SELECT G.BSM,G.YWH,G.QLBSM,G.YQLBSM,G.BHSJ,G.QXDM,G.DJBSM,Q.DJBSM AS QLDJBSM,Q.BDCDYH AS QLBDCDYH,Y.DJBSM AS YQLDJBSM,Y.BDCDYH AS YQLBDCDYH FROM BDCDJB.HYSYQ_BHGX G,BDCDJB.HYSYQ Q,BDCDJB.HYSYQ Y WHERE G.QLBSM=Q.BSM AND G.YQLBSM=Y.BSM AND EXISTS ( SELECT 1 FROM BDCDJB.HYSYQ Q WHERE Q.BSM=G.QLBSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ) ]]>
</Table>
<Table No="表24" Name="NYDSYQ" tablemark="NYDSYQ" mustfillfield="" description="农用地使用权。">
<![CDATA[ SELECT Z.DJBSM AS ZDJBXXDJBSM,Z.BBH AS ZDJBXXBBH, Q.* FROM BDCDJB.NYDSYQ Q,BDCDJB.ZDJBXX Z WHERE Q.ZDJBXXBSM=Z.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ]]>
</Table>
<Table No="表24" Name="NYDSYQ" tablemark="NYDSYQ_ZX" mustfillfield="" description="农用地使用权（注销业务）。">
<![CDATA[ SELECT Z.DJBSM AS ZDJBXXDJBSM,Z.BBH AS ZDJBXXBBH, Q.* FROM BDCDJB.NYDSYQ Q,BDCDJB.ZDJBXX Z WHERE Q.ZDJBXXBSM=Z.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ]]>
</Table>
<Table No="表25" Name="NYDSYQ_BHGX" tablemark="NYDSYQ" mustfillfield="" description="农用地使用权变化关系。">
<![CDATA[ SELECT G.BSM,G.YWH,G.QLBSM,G.YQLBSM,G.BHSJ,G.QXDM,G.DJBSM,Q.DJBSM AS QLDJBSM,Q.BDCDYH AS QLBDCDYH,Y.DJBSM AS YQLDJBSM,Y.BDCDYH AS YQLBDCDYH FROM BDCDJB.NYDSYQ_BHGX G,BDCDJB.NYDSYQ Q,BDCDJB.NYDSYQ Y WHERE G.QLBSM=Q.BSM AND G.YQLBSM=Y.BSM AND EXISTS ( SELECT 1 FROM BDCDJB.NYDSYQ Q WHERE Q.BSM=G.QLBSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ) ]]>
</Table>
<Table No="表25" Name="NYDSYQ_BHGX" tablemark="NYDSYQ_ZX" mustfillfield="" description="农用地使用权变化关系（注销业务）。">
<![CDATA[ SELECT G.BSM,G.YWH,G.QLBSM,G.YQLBSM,G.BHSJ,G.QXDM,G.DJBSM,Q.DJBSM AS QLDJBSM,Q.BDCDYH AS QLBDCDYH,Y.DJBSM AS YQLDJBSM,Y.BDCDYH AS YQLBDCDYH FROM BDCDJB.NYDSYQ_BHGX G,BDCDJB.NYDSYQ Q,BDCDJB.NYDSYQ Y WHERE G.QLBSM=Q.BSM AND G.YQLBSM=Y.BSM AND EXISTS ( SELECT 1 FROM BDCDJB.NYDSYQ Q WHERE Q.BSM=G.QLBSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ) ]]>
</Table>
<Table No="表26" Name="LQ" tablemark="LQ" mustfillfield="" description="林权。">
<![CDATA[ SELECT Z.DJBSM AS ZDJBXXDJBSM,Z.BBH AS ZDJBXXBBH, Q.* FROM BDCDJB.LQ Q,BDCDJB.ZDJBXX Z WHERE Q.ZDJBXXBSM=Z.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ]]>
</Table>
<Table No="表26" Name="LQ" tablemark="LQ_ZX" mustfillfield="" description="林权（注销业务）。">
<![CDATA[ SELECT Z.DJBSM AS ZDJBXXDJBSM,Z.BBH AS ZDJBXXBBH, Q.* FROM BDCDJB.LQ Q,BDCDJB.ZDJBXX Z WHERE Q.ZDJBXXBSM=Z.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ]]>
</Table>
<Table No="表27" Name="LQ_BHGX" tablemark="LQ" mustfillfield="" description="林权变化关系。">
<![CDATA[ SELECT G.BSM,G.YWH,G.QLBSM,G.YQLBSM,G.BHSJ,G.QXDM,G.DJBSM,Q.DJBSM AS QLDJBSM,Q.BDCDYH AS QLBDCDYH,Y.DJBSM AS YQLDJBSM,Y.BDCDYH AS YQLBDCDYH FROM BDCDJB.LQ_BHGX G,BDCDJB.LQ Q,BDCDJB.LQ Y WHERE G.QLBSM=Q.BSM AND G.YQLBSM=Y.BSM AND EXISTS ( SELECT 1 FROM BDCDJB.LQ Q WHERE Q.BSM=G.QLBSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ) ]]>
</Table>
<Table No="表27" Name="LQ_BHGX" tablemark="LQ_ZX" mustfillfield="" description="林权变化关系（注销业务）。">
<![CDATA[ SELECT G.BSM,G.YWH,G.QLBSM,G.YQLBSM,G.BHSJ,G.QXDM,G.DJBSM,Q.DJBSM AS QLDJBSM,Q.BDCDYH AS QLBDCDYH,Y.DJBSM AS YQLDJBSM,Y.BDCDYH AS YQLBDCDYH FROM BDCDJB.LQ_BHGX G,BDCDJB.LQ Q,BDCDJB.LQ Y WHERE G.QLBSM=Q.BSM AND G.YQLBSM=Y.BSM AND EXISTS ( SELECT 1 FROM BDCDJB.LQ Q WHERE Q.BSM=G.QLBSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ) ]]>
</Table>
<Table No="表28" Name="DYIQ" tablemark="DYIQ" mustfillfield="" description="地役权。">
<![CDATA[ SELECT D.DJBSM AS DYDJBSM,D.BBH AS DYBBH,NVL(C.DJBSM,0) AS QLDJBSM,C.YWH AS QLYWH,Q.* FROM BDCDJB.DYIQ Q,BDCDJB.V_DJB_DY D,BDCDJB.V_DJB_QL C WHERE Q.DYBSM=D.BSM AND Q.QLBSM=C.BSM(+) AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ]]>
</Table>
<Table No="表28" Name="DYIQ" tablemark="DYIQ_ZX" mustfillfield="" description="地役权（注销业务）。">
<![CDATA[ SELECT D.DJBSM AS DYDJBSM,D.BBH AS DYBBH,NVL(C.DJBSM,0) AS QLDJBSM,C.YWH AS QLYWH,Q.* FROM BDCDJB.DYIQ Q,BDCDJB.V_DJB_DY D,BDCDJB.V_DJB_QL C WHERE Q.DYBSM=D.BSM AND Q.QLBSM=C.BSM(+) AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}']]>
</Table>
<Table No="表29" Name="DYIQ_BHGX" tablemark="DYIQ" mustfillfield="" description="地役权变化关系。">
<![CDATA[ SELECT G.BSM,G.YWH,G.YQLBSM,G.QLBSM,G.QXDM,G.DJBSM,Q.DJBSM AS QLDJBSM,Q.XYDBDCDYH AS QLBDCDYH,Y.DJBSM AS YQLDJBSM,Y.XYDBDCDYH AS YQLBDCDYH FROM BDCDJB.DYIQ_BHGX G,BDCDJB.DYIQ Q,BDCDJB.DYIQ Y WHERE G.QLBSM=Q.BSM AND G.YQLBSM =Y.BSM AND EXISTS ( SELECT 1 FROM BDCDJB.DYIQ Q WHERE Q.BSM=G.QLBSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ) ]]>
</Table>
<Table No="表29" Name="DYIQ_BHGX" tablemark="DYIQ_ZX" mustfillfield="" description="地役权变化关系（注销业务）。">
<![CDATA[ SELECT G.BSM,G.YWH,G.YQLBSM,G.QLBSM,G.QXDM,G.DJBSM,Q.DJBSM AS QLDJBSM,Q.XYDBDCDYH AS QLBDCDYH,Y.DJBSM AS YQLDJBSM,Y.XYDBDCDYH AS YQLBDCDYH FROM BDCDJB.DYIQ_BHGX G,BDCDJB.DYIQ Q,BDCDJB.DYIQ Y WHERE G.QLBSM=Q.BSM AND G.YQLBSM =Y.BSM AND EXISTS ( SELECT 1 FROM BDCDJB.DYIQ Q WHERE Q.BSM=G.QLBSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}') ]]>
</Table>
<Table No="表30" Name="DYAQ" tablemark="DYAQ" mustfillfield="" description="抵押权。">
<![CDATA[ SELECT D.DJBSM AS DYDJBSM,D.BBH AS DYBBH,NVL(C.DJBSM,0) AS QLDJBSM,C.YWH AS QLYWH,Q.* FROM BDCDJB.DYAQ Q,BDCDJB.V_DJB_DY D,BDCDJB.V_DJB_QL C WHERE Q.DYBSM=D.BSM AND Q.QLBSM=C.BSM(+) AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ]]>
</Table>
<Table No="表30" Name="DYAQ" tablemark="DYAQ_ZX" mustfillfield="" description="抵押权（注销业务）。">
<![CDATA[ SELECT D.DJBSM AS DYDJBSM,D.BBH AS DYBBH,NVL(C.DJBSM,0) AS QLDJBSM,C.YWH AS QLYWH,Q.* FROM BDCDJB.DYAQ Q,BDCDJB.V_DJB_DY D,BDCDJB.V_DJB_QL C WHERE Q.DYBSM=D.BSM AND Q.QLBSM=C.BSM(+) AND Q.ZXDYYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}']]>
</Table>
<Table No="表31" Name="DYAQ_BHGX" tablemark="DYAQ" mustfillfield="" description="抵押权变化关系。">
<![CDATA[ SELECT G.BSM,G.YWH,G.QLBSM,G.YQLBSM,G.QXDM,G.BHCS,G.DJBSM,Q.DJBSM AS QLDJBSM,Q.BDCDYH AS QLBDCDYH,Y.DJBSM AS YQLDJBSM,Y.BDCDYH AS YQLBDCDYH FROM BDCDJB.DYAQ_BHGX G,BDCDJB.DYAQ Q,BDCDJB.DYAQ Y WHERE G.QLBSM=Q.BSM AND G.YQLBSM=Y.BSM AND EXISTS ( SELECT 1 FROM BDCDJB.DYAQ Q WHERE Q.BSM=G.QLBSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ) ]]>
</Table>
<Table No="表31" Name="DYAQ_BHGX" tablemark="DYAQ_ZX" mustfillfield="" description="抵押权变化关系（注销业务）。">
<![CDATA[ SELECT G.BSM,G.YWH,G.QLBSM,G.YQLBSM,G.QXDM,G.BHCS,G.DJBSM,Q.DJBSM AS QLDJBSM,Q.BDCDYH AS QLBDCDYH,Y.DJBSM AS YQLDJBSM,Y.BDCDYH AS YQLBDCDYH FROM BDCDJB.DYAQ_BHGX G,BDCDJB.DYAQ Q,BDCDJB.DYAQ Y WHERE G.QLBSM=Q.BSM AND G.YQLBSM=Y.BSM AND EXISTS ( SELECT 1 FROM BDCDJB.DYAQ Q WHERE Q.BSM=G.QLBSM AND Q.ZXDYYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}') ]]>
</Table>
<Table No="表32" Name="YGDJ" tablemark="YGDJ" mustfillfield="" description="预告登记。">
<![CDATA[ SELECT D.DJBSM AS DYDJBSM,D.BBH AS DYBBH,NVL(C.DJBSM,0) AS QLDJBSM,C.YWH AS QLYWH,Q.* FROM BDCDJB.YGDJ Q,BDCDJB.V_DJB_DY D,BDCDJB.V_DJB_QL C WHERE Q.DYBSM=D.BSM AND Q.QLBSM=C.BSM(+) AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ]]>
</Table>
<Table No="表32" Name="YGDJ" tablemark="YGDJ_ZX" mustfillfield="" description="预告登记（注销业务）。">
<![CDATA[ SELECT D.DJBSM AS DYDJBSM,D.BBH AS DYBBH,NVL(C.DJBSM,0) AS QLDJBSM,C.YWH AS QLYWH,Q.* FROM BDCDJB.YGDJ Q,BDCDJB.V_DJB_DY D,BDCDJB.V_DJB_QL C WHERE Q.DYBSM=D.BSM AND Q.QLBSM=C.BSM(+) AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ]]>
</Table>
<Table No="表33" Name="YGDJ_BHGX" tablemark="YGDJ" mustfillfield="" description="预告登记变化关系。">
<![CDATA[ SELECT G.BSM,G.YWH,G.YQLBSM,G.QLBSM,G.QXDM,G.DJBSM,Q.DJBSM AS QLDJBSM,Q.BDCDYH AS QLBDCDYH,Y.DJBSM AS YQLDJBSM,Y.BDCDYH AS YQLBDCDYH FROM BDCDJB.YGDJ_BHGX G,BDCDJB.YGDJ Q,BDCDJB.YGDJ Y WHERE G.QLBSM=Q.BSM AND G.YQLBSM =Y.BSM AND EXISTS ( SELECT 1 FROM BDCDJB.YGDJ Q WHERE Q.BSM=G.QLBSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ) ]]>
</Table>
<Table No="表33" Name="YGDJ_BHGX" tablemark="YGDJ_ZX" mustfillfield="" description="预告登记变化关系（注销业务）。">
<![CDATA[ SELECT G.BSM,G.YWH,G.YQLBSM,G.QLBSM,G.QXDM,G.DJBSM,Q.DJBSM AS QLDJBSM,Q.BDCDYH AS QLBDCDYH,Y.DJBSM AS YQLDJBSM,Y.BDCDYH AS YQLBDCDYH FROM BDCDJB.YGDJ_BHGX G,BDCDJB.YGDJ Q,BDCDJB.YGDJ Y WHERE G.QLBSM=Q.BSM AND G.YQLBSM =Y.BSM AND EXISTS ( SELECT 1 FROM BDCDJB.YGDJ Q WHERE Q.BSM=G.QLBSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}') ]]>
</Table>
<Table No="表34" Name="YYDJ" tablemark="YYDJ" mustfillfield="" description="异议登记。">
<![CDATA[ SELECT D.DJBSM AS DYDJBSM,D.BBH AS DYBBH,NVL(C.DJBSM,0) AS QLDJBSM,C.YWH AS QLYWH,Q.* FROM BDCDJB.YYDJ Q,BDCDJB.V_DJB_DY D,BDCDJB.V_DJB_QL C WHERE Q.DYBSM=D.BSM AND Q.QLBSM=C.BSM(+) AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ]]>
</Table>
<Table No="表34" Name="YYDJ" tablemark="YYDJ_ZX" mustfillfield="" description="异议登记（注销业务）。">
<![CDATA[ SELECT D.DJBSM AS DYDJBSM,D.BBH AS DYBBH,NVL(C.DJBSM,0) AS QLDJBSM,C.YWH AS QLYWH,Q.* FROM BDCDJB.YYDJ Q,BDCDJB.V_DJB_DY D,BDCDJB.V_DJB_QL C WHERE Q.DYBSM=D.BSM AND Q.QLBSM=C.BSM(+) AND Q.ZXYYYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}']]>
</Table>
<Table No="表35" Name="YYDJ_BHGX" tablemark="YYDJ" mustfillfield="" description="异议登记变化关系。">
<![CDATA[ SELECT G.BSM,G.YWH,G.YQLBSM,G.QLBSM,G.QXDM,G.DJBSM,Q.DJBSM AS QLDJBSM,Q.BDCDYH AS QLBDCDYH,Y.DJBSM AS YQLDJBSM,Y.BDCDYH AS YQLBDCDYH FROM BDCDJB.YYDJ_BHGX G,BDCDJB.YYDJ Q,BDCDJB.YYDJ Y WHERE G.QLBSM=Q.BSM AND G.YQLBSM =Y.BSM AND EXISTS ( SELECT 1 FROM BDCDJB.YYDJ Q WHERE Q.BSM=G.QLBSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}') ]]>
</Table>
<Table No="表35" Name="YYDJ_BHGX" tablemark="YYDJ_ZX" mustfillfield="" description="异议登记变化关系（注销业务）。">
<![CDATA[ SELECT G.BSM,G.YWH,G.YQLBSM,G.QLBSM,G.QXDM,G.DJBSM,Q.DJBSM AS QLDJBSM,Q.BDCDYH AS QLBDCDYH,Y.DJBSM AS YQLDJBSM,Y.BDCDYH AS YQLBDCDYH FROM BDCDJB.YYDJ_BHGX G,BDCDJB.YYDJ Q,BDCDJB.YYDJ Y WHERE G.QLBSM=Q.BSM AND G.YQLBSM =Y.BSM AND EXISTS ( SELECT 1 FROM BDCDJB.YYDJ Q WHERE Q.BSM=G.QLBSM AND Q.ZXYYYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}') ]]>
</Table>
<Table No="表36" Name="CFDJ" tablemark="CFDJ" mustfillfield="" description="查封登记。">
<![CDATA[ SELECT D.DJBSM AS DYDJBSM,D.BBH AS DYBBH,NVL(C.DJBSM,0) AS QLDJBSM,C.YWH AS QLYWH,Q.* FROM BDCDJB.CFDJ Q,BDCDJB.V_DJB_DY D,BDCDJB.V_DJB_QL C WHERE Q.DYBSM=D.BSM AND Q.QLBSM=C.BSM(+) AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ]]>
</Table>
<Table No="表36" Name="CFDJ" tablemark="CFDJ_ZX" mustfillfield="" description="查封登记（注销业务）。">
<![CDATA[ SELECT D.DJBSM AS DYDJBSM,D.BBH AS DYBBH,NVL(C.DJBSM,0) AS QLDJBSM,C.YWH AS QLYWH,Q.* FROM BDCDJB.CFDJ Q,BDCDJB.V_DJB_DY D,BDCDJB.V_DJB_QL C WHERE Q.DYBSM=D.BSM AND Q.QLBSM=C.BSM(+) AND Q.JFYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}' ]]>
</Table>
<Table No="表37" Name="CFDJ_BHGX" tablemark="CFDJ" mustfillfield="" description="查封登记变化关系。">
<![CDATA[ SELECT G.BSM,G.YWH,G.CFDJBSM,G.YCFDJBSM,G.QXDM,G.BHCS,G.DJBSM,Q.DJBSM AS QLDJBSM,Q.BDCDYH AS QLBDCDYH,Y.DJBSM AS YQLDJBSM,Y.BDCDYH AS YQLBDCDYH FROM BDCDJB.CFDJ_BHGX G,BDCDJB.CFDJ Q,BDCDJB.CFDJ Y WHERE G.CFDJBSM=Q.BSM AND G.YCFDJBSM=Y.BSM AND EXISTS ( SELECT 1 FROM BDCDJB.CFDJ Q WHERE Q.BSM=G.CFDJBSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ) ]]>
</Table>
<Table No="表37" Name="CFDJ_BHGX" tablemark="CFDJ_ZX" mustfillfield="" description="查封登记变化关系（注销业务）。">
<![CDATA[ SELECT G.BSM,G.YWH,G.CFDJBSM,G.YCFDJBSM,G.QXDM,G.BHCS,G.DJBSM,Q.DJBSM AS QLDJBSM,Q.BDCDYH AS QLBDCDYH,Y.DJBSM AS YQLDJBSM,Y.BDCDYH AS YQLBDCDYH FROM BDCDJB.CFDJ_BHGX G,BDCDJB.CFDJ Q,BDCDJB.CFDJ Y WHERE G.CFDJBSM=Q.BSM AND G.YCFDJBSM=Y.BSM AND EXISTS ( SELECT 1 FROM BDCDJB.CFDJ Q WHERE Q.BSM=G.CFDJBSM AND Q.JFYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}') ]]>
</Table>
<Table No="表38" Name="QLR" tablemark="QLR_QL" mustfillfield="" description="权利人表(产权权利，抵押，查封，预告，地役权，异议，租赁)。">
<![CDATA[ SELECT * FROM BDCDJB.QLR R WHERE R.YWH='{YWH}' AND EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.YWH=R.YWH AND Q.BSM=R.QLBSM AND Q.BDCDYH=R.BDCDYH AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}') ]]>
</Table>
<Table No="表38" Name="QLR" tablemark="QLR_QL_ZX" mustfillfield="" description="权利人表(产权权利注销、预告登记注销)。">
<![CDATA[ SELECT * FROM BDCDJB.QLR R WHERE R.YWH='{YWH}' AND EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.ZXYWH=R.YWH AND Q.BSM=R.QLBSM AND Q.BDCDYH=R.BDCDYH AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}') ]]>
</Table>
<Table No="表38" Name="QLR" tablemark="QLR_QL_TXQ" mustfillfield="" description="权利人表(他项权匹配权利人,地役权除外)。">
<![CDATA[ SELECT * FROM BDCDJB.QLR R WHERE R.YWH='{YWH}' AND EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.YWH=R.YWH AND Q.BSM=R.QLBSM AND Q.BDCDYH=R.BDCDYH AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}') ]]>
</Table>
<Table No="表38" Name="QLR" tablemark="QLR_QL_DYIQ" mustfillfield="" description="权利人表(抵押权登记)。">
<![CDATA[ SELECT * FROM BDCDJB.QLR R WHERE R.YWH='{YWH}' AND EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.YWH=R.YWH AND Q.BSM=R.QLBSM AND Q.GYDBDCDYH=R.BDCDYH AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}') ]]>
</Table>
<Table No="表38" Name="QLR" tablemark="QLR_DYAQ_ZX" mustfillfield="" description="权利人表(抵押权注销)。">
<![CDATA[ SELECT * FROM BDCDJB.QLR R WHERE R.YWH='{YWH}' AND EXISTS (SELECT 1 FROM BDCDJB.DYAQ Q WHERE Q.ZXDYYWH=R.YWH AND Q.BSM=R.QLBSM AND Q.BDCDYH=R.BDCDYH AND Q.ZXDYYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}') ]]>
</Table>
<Table No="表38" Name="QLR" tablemark="QLR_ZLSYQ_ZX" mustfillfield="" description="权利人表(租赁使用权注销)。">
<![CDATA[ SELECT * FROM BDCDJB.QLR R WHERE R.YWH='{YWH}' AND EXISTS (SELECT 1 FROM BDCDJB.ZLSYQ Q WHERE Q.ZXYWH=R.YWH AND Q.BSM=R.QLBSM AND Q.BDCDYH=R.BDCDYH AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}') ]]>
</Table>
<Table No="表38" Name="QLR" tablemark="QLR_JUZQ_ZX" mustfillfield="" description="权利人表(居住权注销)。">
<![CDATA[ SELECT * FROM BDCDJB.QLR R WHERE R.YWH='{YWH}' AND EXISTS (SELECT 1 FROM BDCDJB.JUZQ Q WHERE Q.ZXYWH=R.YWH AND Q.BSM=R.QLBSM AND Q.BDCDYH=R.BDCDYH AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}') ]]>
</Table>
<Table No="表38" Name="QLR" tablemark="QLR_CFDJ_ZX" mustfillfield="" description="权利人表(查封登记注销)。">
<![CDATA[ SELECT * FROM BDCDJB.QLR R WHERE R.YWH='{YWH}' AND EXISTS (SELECT 1 FROM BDCDJB.CFDJ Q WHERE Q.JFYWH=R.YWH AND Q.BSM=R.QLBSM AND Q.BDCDYH=R.BDCDYH AND Q.JFYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}') ]]>
</Table>
<Table No="表38" Name="QLR" tablemark="QLR_DYIQ_ZX" mustfillfield="" description="权利人表(地役权登记注销)。">
<![CDATA[ SELECT * FROM BDCDJB.QLR R WHERE R.YWH='{YWH}' AND EXISTS (SELECT 1 FROM BDCDJB.DYIQ Q WHERE Q.ZXYWH=R.YWH AND Q.BSM=R.QLBSM AND Q.GYDBDCDYH=R.BDCDYH AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}') ]]>
</Table>
<Table No="表38" Name="QLR" tablemark="QLR_YYDJ_ZX" mustfillfield="" description="权利人表(异议登记注销)。">
<![CDATA[ SELECT * FROM BDCDJB.QLR R WHERE R.YWH='{YWH}' AND EXISTS (SELECT 1 FROM BDCDJB.YYDJ Q WHERE Q.ZXYYYWH=R.YWH AND Q.BSM=R.QLBSM AND Q.BDCDYH=R.BDCDYH AND Q.ZXYYYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}') ]]>
</Table>
<Table No="表39" Name="SLSQ" tablemark="" mustfillfield="" description="受理申请。">
<![CDATA[ SELECT * FROM BDCDJB.SLSQ S WHERE S.YWH='{YWH}']]>
</Table>
<Table No="表40" Name="SH" tablemark="SH_QL" mustfillfield="" description="审核信息(产权权利，抵押，查封，预告，地役权，异议,租赁)。">
<![CDATA[ SELECT * FROM BDCDJB.SH S WHERE S.YWH='{YWH}' AND EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.YWH=S.YWH AND Q.BSM=S.QLBSM AND Q.SHBSM=S.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}') ]]>
</Table>
<Table No="表40" Name="SH" tablemark="SH_QL_ZX" mustfillfield="" description="审核信息(产权权利注销、预告登记注销)。">
<![CDATA[ SELECT * FROM BDCDJB.SH S WHERE S.YWH='{YWH}' AND EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.ZXYWH=S.YWH AND Q.BSM=S.QLBSM AND Q.ZXSHBSM=S.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}') ]]>
</Table>
<Table No="表40" Name="SH" tablemark="SH_QL_TXQ" mustfillfield="" description="审核信息(他项权匹配审核)。">
<![CDATA[ SELECT * FROM BDCDJB.SH S WHERE S.YWH='{YWH}' AND EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.YWH=S.YWH AND Q.BSM=S.QLBSM AND Q.SHBSM=S.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')]]>
</Table>
<Table No="表40" Name="SH" tablemark="SH_DYAQ_ZX" mustfillfield="" description="审核信息(抵押权登记注销)。">
<![CDATA[ SELECT * FROM BDCDJB.SH S WHERE S.YWH='{YWH}' AND EXISTS (SELECT 1 FROM BDCDJB.DYAQ Q WHERE Q.ZXDYYWH=S.YWH AND Q.BSM=S.QLBSM AND Q.ZXSHBSM=S.BSM AND Q.ZXDYYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}') ]]>
</Table>
<Table No="表40" Name="SH" tablemark="SH_ZLSYQ_ZX" mustfillfield="" description="审核信息(租赁使用权登记注销)。">
<![CDATA[ SELECT * FROM BDCDJB.SH S WHERE S.YWH='{YWH}' AND EXISTS (SELECT 1 FROM BDCDJB.ZLSYQ Q WHERE Q.ZXYWH=S.YWH AND Q.BSM=S.QLBSM AND Q.ZXSHBSM=S.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}') ]]>
</Table>
<Table No="表40" Name="SH" tablemark="SH_JUZQ_ZX" mustfillfield="" description="审核信息(居住权登记注销)。">
<![CDATA[ SELECT * FROM BDCDJB.SH S WHERE S.YWH='{YWH}' AND EXISTS (SELECT 1 FROM BDCDJB.JUZQ Q WHERE Q.ZXYWH=S.YWH AND Q.BSM=S.QLBSM AND Q.ZXSHBSM=S.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}') ]]>
</Table>
<Table No="表40" Name="SH" tablemark="SH_CFDJ_ZX" mustfillfield="" description="审核信息(查封登记注销)。">
<![CDATA[ SELECT * FROM BDCDJB.SH S WHERE S.YWH='{YWH}' AND EXISTS (SELECT 1 FROM BDCDJB.CFDJ Q WHERE Q.JFYWH=S.YWH AND Q.BSM=S.QLBSM AND Q.ZXSHBSM=S.BSM AND Q.JFYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}') ]]>
</Table>
<Table No="表40" Name="SH" tablemark="SH_DYIQ_ZX" mustfillfield="" description="审核信息(地役权登记注销)。">
<![CDATA[ SELECT * FROM BDCDJB.SH S WHERE S.YWH='{YWH}' AND EXISTS (SELECT 1 FROM BDCDJB.DYIQ Q WHERE Q.ZXYWH=S.YWH AND Q.BSM=S.QLBSM AND Q.ZXSHBSM=S.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}') ]]>
</Table>
<Table No="表40" Name="SH" tablemark="SH_YYDJ_ZX" mustfillfield="" description="审核信息(异议登记注销)。">
<![CDATA[ SELECT * FROM BDCDJB.SH S WHERE S.YWH='{YWH}' AND EXISTS (SELECT 1 FROM BDCDJB.YYDJ Q WHERE Q.ZXYYYWH=S.YWH AND Q.BSM=S.QLBSM AND Q.ZXSHBSM=S.BSM AND Q.ZXYYYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}') ]]>
</Table>
<Table No="表41" Name="SQR" tablemark="" mustfillfield="" description="申请人信息。">
<![CDATA[ SELECT * FROM BDCDJB.SQR S WHERE S.YWH='{YWH}' AND S.DJBSM='{DJQLBSM}' ]]>
</Table>
<Table No="表42" Name="BDCDY" tablemark="BDCDY_FDCQ" mustfillfield="" description="不动产单元(房地产权)。">
<![CDATA[ SELECT * FROM BDCDJB.BDCDY D WHERE EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.HBSM = D.DYBSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')]]>
</Table>
<Table No="表42" Name="BDCDY" tablemark="BDCDY_FDCQ_ZX" mustfillfield="" description="不动产单元(房地产权注销)。">
<![CDATA[ SELECT * FROM BDCDJB.BDCDY D WHERE EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.HBSM = D.DYBSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')]]>
</Table>
<Table No="表42" Name="BDCDY" tablemark="BDCDY_ZD" mustfillfield="" description="不动产单元(宗地业务)。">
<![CDATA[ SELECT * FROM BDCDJB.BDCDY D WHERE EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.ZDJBXXBSM = D.DYBSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')]]>
</Table>
<Table No="表42" Name="BDCDY" tablemark="BDCDY_ZD_ZX" mustfillfield="" description="不动产单元(宗地注销业务)。">
<![CDATA[ SELECT * FROM BDCDJB.BDCDY D WHERE EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.ZDJBXXBSM = D.DYBSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')]]>
</Table>
<Table No="表42" Name="BDCDY" tablemark="BDCDY_ZH" mustfillfield="" description="不动产单元(宗海业务)。">
<![CDATA[ SELECT * FROM BDCDJB.BDCDY D WHERE EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.ZHJBXXBSM = D.DYBSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')]]>
</Table>
<Table No="表42" Name="BDCDY" tablemark="BDCDY_ZH_ZX" mustfillfield="" description="不动产单元(宗海注销业务)。">
<![CDATA[ SELECT * FROM BDCDJB.BDCDY D WHERE EXISTS (SELECT 1 FROM BDCDJB.{QLBM} Q WHERE Q.ZHJBXXBSM = D.DYBSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')]]>
</Table>
<Table No="表51" Name="JTCY" tablemark="JTCY" mustfillfield="" description="家庭成员">
<![CDATA[ SELECT * FROM BDCDJB.JTCY J WHERE J.YWH='{YWH}' AND J.DJQLBSM='{DJQLBSM}']]>
</Table>
<Table No="表52" Name="ZLSYQ" tablemark="ZLSYQ" mustfillfield="" description="租赁使用权。">
<![CDATA[ SELECT D.DJBSM AS DYDJBSM,D.BBH AS DYBBH,NVL(C.DJBSM,0) AS QLDJBSM,C.YWH AS QLYWH,Q.* FROM BDCDJB.ZLSYQ Q,BDCDJB.V_DJB_DY D,BDCDJB.V_DJB_QL C WHERE Q.HBSM=D.BSM AND Q.QLBSM=C.BSM(+) AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ]]>
</Table>
<Table No="表52" Name="ZLSYQ" tablemark="ZLSYQ_ZX" mustfillfield="" description="租赁使用权（注销业务）。">
<![CDATA[ SELECT D.DJBSM AS DYDJBSM,D.BBH AS DYBBH,NVL(C.DJBSM,0) AS QLDJBSM,C.YWH AS QLYWH,Q.* FROM BDCDJB.ZLSYQ Q,BDCDJB.V_DJB_DY D,BDCDJB.V_DJB_QL C WHERE Q.HBSM=D.BSM AND Q.QLBSM=C.BSM(+) AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}']]>
</Table>
<Table No="表53" Name="ZLSYQ_BHGX" tablemark="ZLSYQ" mustfillfield="" description="租赁使用权变化关系。">
<![CDATA[ SELECT G.BSM,G.YWH,G.QLBSM,G.YQLBSM,G.QXDM,G.DJBSM,Q.DJBSM AS QLDJBSM,Q.BDCDYH AS QLBDCDYH,Y.DJBSM AS YQLDJBSM,Y.BDCDYH AS YQLBDCDYH FROM BDCDJB.ZLSYQ_BHGX G,BDCDJB.ZLSYQ Q,BDCDJB.ZLSYQ Y WHERE G.QLBSM=Q.BSM AND G.YQLBSM=Y.BSM AND EXISTS ( SELECT 1 FROM BDCDJB.ZLSYQ Q WHERE Q.BSM=G.QLBSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ) ]]>
</Table>
<Table No="表53" Name="ZLSYQ_BHGX" tablemark="ZLSYQ_ZX" mustfillfield="" description="租赁使用权变化关系（注销业务）。">
<![CDATA[ SELECT G.BSM,G.YWH,G.QLBSM,G.YQLBSM,G.QXDM,G.DJBSM,Q.DJBSM AS QLDJBSM,Q.BDCDYH AS QLBDCDYH,Y.DJBSM AS YQLDJBSM,Y.BDCDYH AS YQLBDCDYH FROM BDCDJB.ZLSYQ_BHGX G,BDCDJB.ZLSYQ Q,BDCDJB.ZLSYQ Y WHERE G.QLBSM=Q.BSM AND G.YQLBSM=Y.BSM AND EXISTS ( SELECT 1 FROM BDCDJB.ZLSYQ Q WHERE Q.BSM=G.QLBSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}') ]]>
</Table>
<Table No="表54" Name="GJZWSYQ" tablemark="" mustfillfield="" description="构（建）筑物所有权">
<![CDATA[ SELECT Z.DJBSM AS GZWDJBSM,Z.BBH AS GZWBBH, Q.* FROM BDCDJB.GJZWSYQ Q,BDCDJB.GZW Z WHERE Q.GZWBSM=Z.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}']]>
</Table>
<Table No="表54" Name="GJZWSYQ" tablemark="GJZWSYQ_ZX" mustfillfield="" description="构（建）筑物所有权注销业务">
<![CDATA[ SELECT Z.DJBSM AS GZWDJBSM,Z.BBH AS GZWBBH, Q.* FROM BDCDJB.GJZWSYQ Q,BDCDJB.GZW Z WHERE Q.GZWBSM=Z.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}']]>
</Table>
<Table No="表55" Name="GJZWSYQ_BHGX" tablemark="" mustfillfield="" description="构（建）筑物所有权变化关系(注销业务不需组装)">
<![CDATA[ SELECT G.BSM,G.YWH,G.QLBSM,G.YQLBSM,G.BHSJ,G.QXDM,G.DJBSM,Q.DJBSM AS QLDJBSM,Q.BDCDYH AS QLBDCDYH,Y.DJBSM AS YQLDJBSM,Y.BDCDYH AS YQLBDCDYH
FROM BDCDJB.GJZWSYQ_BHGX G,BDCDJB.GJZWSYQ Q,BDCDJB.GJZWSYQ Y
WHERE G.QLBSM=Q.BSM AND G.YQLBSM=Y.BSM AND EXISTS ( SELECT 1 FROM BDCDJB.GJZWSYQ Q WHERE Q.BSM=G.QLBSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')]]>
</Table>
<Table No="表56" Name="GZW" tablemark="" mustfillfield="" description="构筑物单元表">
<![CDATA[ SELECT * FROM BDCDJB.GZW D WHERE EXISTS (SELECT 1 FROM BDCDJB.GJZWSYQ Q WHERE Q.GZWBSM=D.BSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')]]>
</Table>
<Table No="表56" Name="GZW" tablemark="GJZWSYQ_ZX" mustfillfield="" description="构筑物单元表（构（建）筑物所有权注销业务）">
<![CDATA[ SELECT * FROM BDCDJB.GZW D WHERE EXISTS (SELECT 1 FROM BDCDJB.GJZWSYQ Q WHERE Q.GZWBSM=D.BSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{DJQLBSM}')]]>
</Table>
<Table No="表57" Name="JUZQ" tablemark="JUZQ" mustfillfield="" description="居住权。">
<![CDATA[ SELECT D.DJBSM AS DYDJBSM,D.BBH AS DYBBH,NVL(C.DJBSM,0) AS QLDJBSM,C.YWH AS QLYWH,Q.* FROM BDCDJB.JUZQ Q,BDCDJB.V_DJB_DY D,BDCDJB.V_DJB_QL C WHERE Q.DYBSM=D.BSM AND Q.QLBSM=C.BSM(+) AND Q.DYBM='H' AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}']]>
</Table>
<Table No="表57" Name="JUZQ" tablemark="JUZQ_ZX" mustfillfield="" description="居住权（注销业务）。">
<![CDATA[ SELECT D.DJBSM AS DYDJBSM,D.BBH AS DYBBH,NVL(C.DJBSM,0) AS QLDJBSM,C.YWH AS QLYWH,Q.* FROM BDCDJB.ZLSYQ Q,BDCDJB.V_DJB_DY D,BDCDJB.V_DJB_QL C WHERE Q.HBSM=D.BSM AND Q.QLBSM=C.BSM(+) AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}']]>
</Table>
<Table No="表58" Name="JUZQ_BHGX" tablemark="JUZQ" mustfillfield="" description="居住权变化关系。">
<![CDATA[ SELECT G.BSM,G.YWH,G.QLBSM,G.YQLBSM,G.QXDM,G.DJBSM,Q.DJBSM AS QLDJBSM,Q.BDCDYH AS QLBDCDYH,Y.DJBSM AS YQLDJBSM,Y.BDCDYH AS YQLBDCDYH FROM BDCDJB.JUZQ_BHGX G,BDCDJB.JUZQ Q,BDCDJB.JUZQ Y WHERE G.QLBSM=Q.BSM AND G.YQLBSM=Y.BSM AND EXISTS ( SELECT 1 FROM BDCDJB.JUZQ Q WHERE Q.BSM=G.QLBSM AND Q.YWH='{YWH}' AND Q.DJBSM='{DJQLBSM}' ) ]]>
</Table>
<Table No="表58" Name="JUZQ_BHGX" tablemark="JUZQ_ZX" mustfillfield="" description="居住权变化关系（注销业务）。">
<![CDATA[ SELECT G.BSM,G.YWH,G.QLBSM,G.YQLBSM,G.QXDM,G.DJBSM,Q.DJBSM AS QLDJBSM,Q.BDCDYH AS QLBDCDYH,Y.DJBSM AS YQLDJBSM,Y.BDCDYH AS YQLBDCDYH FROM BDCDJB.JUZQ_BHGX G,BDCDJB.JUZQ Q,BDCDJB.JUZQ Y WHERE G.QLBSM=Q.BSM AND G.YQLBSM=Y.BSM AND EXISTS ( SELECT 1 FROM BDCDJB.JUZQ Q WHERE Q.BSM=G.QLBSM AND Q.ZXYWH='{YWH}' AND Q.DJBSM='{ZXDJBSM}') ]]>
</Table>
</root>
