BOS单位置查找
SELECT it.FID,it.FFunctionID as FSubSysID,it.FName_CHS as FName,tdfss.FName as FSysName FROM ICClassType it INNER JOIN t_DataFlowSubSystem tdfss ON it.FFunctionID=tdfss.FSubSysID WHERE it.FName_CHS like '%现金银行%' ORDER BY tdfss.FName,it.FName_CHS
单据转流程位置查找
SELECT
it.FID,it.FSubSysID,it.FName_CHS as FName,tdfss.FName as FSysName FROM
ICClassWorkFlow it INNER JOIN t_DataFlowSubSystem tdfss ON
it.FSubSysID=tdfss.FSubSysID WHERE it.FName_CHS like '%单据转换名称%