question: public String sqlAD_getTranslatedTables ( String vendorName , String catalogName , String schemaName ) { String tableName = "AD_Table" ; ArrayList < String > columnNames = new ArrayList < String > ( ) ; columnNames . add ( "SUBSTR(TableName, 1, LENGTH(TableName)-4)" ) ; ArrayList < String > aliasNames = new ArrayList < String > ( ) ; aliasNames . add ( "TableName" ) ; ArrayList < String > conditions = new ArrayList < String > ( ) ; conditions . add ( "UPPER(TableName) LIKE '%\\_TRL'" ) ; conditions . add ( "IsActive = 'Y'" ) ; conditions . add ( "IsView = 'N'" ) ; ArrayList < String > sortColumns = new ArrayList < String > ( ) ; sortColumns . add ( "1" ) ; return sql_select ( vendorName , catalogName , schemaName , tableName , null , columnNames , aliasNames , conditions , sortColumns , false ) ; }
target:  gets the database specific SQL command to find tables which have translations