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)))
信息披露文件
最新推荐文章于 2024-09-26 19:09:26 发布