SELECT count(*) RECORDCOUNT FROM CAMDS_STRUCTURE A, CAMDS_MATERIAL B
WHERE A.CKID = B.CKID AND A.CSID IN (SELECT distinct(CSID) from
(select * from CAMDS_STRUCTURE connect by nocycle prior CKID = CBLKID
start with CKID =*s* and cpsid is null) start with csid=*ss*
connect by (prior csid = cpsid and prior cref_flag = 0)
or (cpsid is not null and prior CKID = CBLKID and prior cref_flag = 1))
AND A.CNODE_TYPE = 3
AND B.CMAT_CLS_ID IN (*5.1.a*, *5.1.b*, *5.2*,*5.3*, *5.4*,*5.4.1*,*5.4.2*,*5.4.3*,*5.5.1*)