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