question: public String sqlAD_getCustomizationChangeLogs ( String vendorName , String catalogName , String schemaName ) { String searchTableName = "AD_ChangeLog" ; ArrayList < String > columnNames = new ArrayList < String > ( ) ; columnNames . add ( "t0.TableName" ) ; columnNames . add ( "t.Record_ID" ) ; columnNames . add ( "t1.ColumnName" ) ; columnNames . add ( "t.NewValue" ) ; columnNames . add ( "t2.Name" ) ; ArrayList < String > aliasNames = new ArrayList < String > ( ) ; aliasNames . add ( "TABLENAME" ) ; aliasNames . add ( "RECORDID" ) ; aliasNames . add ( "COLUMNNAME" ) ; aliasNames . add ( "NEWVALUE" ) ; aliasNames . add ( "DISPLAYTYPE" ) ; ArrayList < String > joinTypes = new ArrayList < String > ( ) ; ArrayList < String > joinTables = new ArrayList < String > ( ) ; ArrayList < String > joinConditions = new ArrayList < String > ( ) ; joinTypes . add ( "INNER JOIN" ) ; joinTables . add ( "AD_Table" ) ; joinConditions . add ( "t.AD_Table_ID = t0.AD_Table_ID" ) ; joinTypes . add ( "INNER JOIN" ) ; joinTables . add ( "AD_Column" ) ; joinConditions . add ( "t.AD_Table_ID = t1.AD_Table_ID AND t.AD_Column_ID = t1.AD_Column_ID" ) ; joinTypes . add ( "INNER JOIN" ) ; joinTables . add ( "AD_Reference" ) ; joinConditions . add ( "t1.AD_Reference_ID = t2.AD_Reference_ID" ) ; ArrayList < String > conditions = new ArrayList < String > ( ) ; conditions . add ( "t.IsCustomization = 'Y'" ) ; conditions . add ( "t.IsActive = 'Y'" ) ; ArrayList < String > sortColumns = new ArrayList < String > ( ) ; sortColumns . add ( "1" ) ; sortColumns . add ( "2" ) ; sortColumns . add ( "3" ) ; 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 customizations which must be re-applied