oracle 业务主表关联字典表查询

SELECT d.ID,d.COMPANY,d.CDATE,d.AMOUNT,d.CLASS,d.INITIATOR,d.RANK,d.UNIT,d.STAFF,d.DEPARTMENT,d.DESCRIBE,d.EXPLAIN,d.REMARK,d.TBTIME
FROM INPUT_SA_CHECK d
WHERE
     1=1 ${if(len(csdate)==0,"","and d.CDATE >= '"+csdate+"'")}
     ${if(len(cedate)==0,"","and d.CDATE <= '"+cedate+"'")}
     ${if(len(com)==0,"","and d.COMPANY in ('"+com+"')")}
     ${if(len(cla)==0,"","and d.CLASS in ('"+cla+"')")}
and d.rank in
(select a.rank from INPUT_SA_CHECK A,BASE_DICTIONARY b where b.itemcode1='SA01')
and d.class in 
(select a.class from INPUT_SA_CHECK A,BASE_DICTIONARY c where c.itemcode1='SA02')
 order by d.CDATE desc  

需求:A表中的rank和class字段对应dictionary表中的itemcode2均为number类型,其分别对应的数据在dictionary表中以'itemcode2----itemname2'的形式存储,但在dictionary中所有字段均为varchar2类型

需要注意一下:我这个是在帆软里面做的报表开发写的内置数据集......所以有些操作就交给帆软设计器了