Blitz Report Record History SQL Text Creation
Description
Categories: Enginatics
Repository: Github
Repository: Github
Creates a string for the record history columns, based on a table alias.
Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS
Contact us to schedule a demo or if you need help with the installation
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 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Table Alias |
|
Char | |
Prefix |
|
Char |