ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN FCB37C486BA47668E0530100007FBA61 select 'xxen_util.user_name('||:table_alias||'.created_by) '||nvl2(:prefix,:prefix||'_',null)||'created_by, xxen_util.client_time('||:table_alias||'.creation_date) '||nvl2(:prefix,:prefix||'_',null)||'creation_date, xxen_util.user_name('||:table_alias||'.last_updated_by) '||nvl2(:prefix,:prefix||'_',null)||'last_updated_by, xxen_util.client_time('||:table_alias||'.last_update_date) '||nvl2(:prefix,:prefix||'_',null)||'last_update_date,' sql_text from dual Y US Blitz Report Record History SQL Text Creation Creates a string for the record history columns, based on a table alias. Enginatics :prefix :table_alias 1 10 :table_alias Char Y US Table Alias 2 20 :prefix Char US Prefix