信息披露文件

 SELECT A.TITLE 附件标题, 
           '/home/crm2/data/app/TCUST_APP_XTWJ/'||case when a.CC='CRM'  AND A.FNAME IS NOT NULL THEN 'attach2/'||a.fname else a.fname end 附件路径 
           FROM TFP_CPZXXX A 
           where a.scope=3 and a.qxfw in(1,2)
           and exists(select 1 from tfp_xtjh t where t.id=a.cpid and exists(select 1 from tfp_cpdm cp 
           where cp.fcpdm_ta=t.xmid_ta 
           and exists(select 1 from thtxx ht where ht.cpid=cp.id and ht.khh=85503
           --and a.dytabt like '%pdf'
           and ht.cpid=36709)))