改变VO中的sql
时间：2021-07-01 10:21:17
帮助过：27人阅读
null);
cuxOptionVO.setWhereClause(null);
if (!
flag) {
cuxOptionVO.setQuery(" select lookup_code FLEX_VALUE, meaning description\n" +
" from fnd_lookup_values_vl\n" +
" where lookup_type=‘CUX_PON_AUTO_EVALUATION‘ and lookup_code in (select target_name\n" +
" from CUX_POS_BASIC_INFO\n" +
" where org_id = :1)"
);
cuxOptionVO.setWhereClauseParam(0
, pageContext.getOrgId());
} else {
cuxOptionVO.setQuery("select ffv.FLEX_VALUE, ffv.DESCRIPTION\n" +
" from FND_FLEX_VALUE_SETS ffs, FND_FLEX_VALUES_VL ffv\n" +
" WHERE ffs.flex_value_set_id = ffv.FLEX_VALUE_SET_ID\n" +
" AND ffs.flex_value_set_name = ‘CUX_AUTO_EVALUATION_PARA‘\n" +
" and ffv.PARENT_FLEX_VALUE_low = :1\n" +
" order by flex_value"
);
cuxOptionVO.setWhereClauseParam(0
, autoAttr);
}
改变VO中的sql
标签：des and context esc style pre text lua order by
