查询当前组织下的授信合同
select l.* from ledger_app_credit l,fw_organization o1,fw_organization o2 where o1.id_ =? and o2.hiberarchy_ like o1.hiberarchy_ || '%' and o2.id_ = l.orgid_ and l.enable_=1
发布时间: 2012-11-11 10:07:57 作者: rapoo
查询当前组织下的授信合同
select l.* from ledger_app_credit l,fw_organization o1,fw_organization o2 where o1.id_ =? and o2.hiberarchy_ like o1.hiberarchy_ || '%' and o2.id_ = l.orgid_ and l.enable_=1