public List<StandardUnitMeasurementBean> getAllOpticalStandardUnitMeasurementBeans()
{
OleDbParameter[] parameters = new OleDbParameter[] { };
return CreateList<StandardUnitMeasurementBean>("SELECT * FROM "
+ StandardUnitMeasurementBean._TABLE_NAME
+ " WHERE ("
+ StandardUnitMeasurementBean._DEPRECATED
+ " <> 'Y' OR "
+ StandardUnitMeasurementBean._DEPRECATED
+ " IS NULL ) "
+ " AND "
+ StandardUnitMeasurementBean._OPTICAL
+ " = 'Y'"
, parameters);
}