question: public String sqlAD_getTranslatedColumns ( String vendorName , String catalogName , String schemaName ) { String searchTableName = "AD_Column" ; ArrayList < String > columnNames = new ArrayList < String > ( ) ; columnNames . add ( "t.ColumnName" ) ; ArrayList < String > aliasNames = null ; ArrayList < String > joinTypes = new ArrayList < String > ( ) ; joinTypes . add ( "INNER JOIN" ) ; ArrayList < String > joinTables = new ArrayList < String > ( ) ; joinTables . add ( "AD_Table" ) ; ArrayList < String > joinConditions = new ArrayList < String > ( ) ; joinConditions . add ( "t.AD_Table_ID = t0.AD_Table_ID" ) ; ArrayList < String > conditions = new ArrayList < String > ( ) ; conditions . add ( "t0.TableName LIKE ?" ) ; conditions . add ( "t.IsTranslated = 'Y'" ) ; conditions . add ( "t.IsActive = 'Y'" ) ; ArrayList < String > sortColumns = new ArrayList < String > ( ) ; sortColumns . add ( "1" ) ; return sql_select ( vendorName , catalogName , schemaName , searchTableName , null , columnNames , aliasNames , joinTypes , joinTables , null , joinConditions , conditions , sortColumns , false ) ; }
target:  gets the database specific SQL command to find columns which have translations