Blitz Report Record History SQL Text Creation

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Creates a string for the record history columns, based on a table alias.
Run Blitz Report Record History SQL Text Creation and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Download
Related Blitz Reports
ECC Admin - Concurrent Programs BEN Life Events Summary CAC Inventory Accounts Setup CAC Cost Group Accounts Setup OPM Reconcilation ECC Oracle Asset Tracking, Oracle Asset Tracking: Assets CAC WIP Resource Efficiency with Method and Lot Variances CAC Manufacturing Variance Detail CAC Manufacturing Variance Summary CAC WIP Accounts Setup
Blitz Report™

Blitz Report™ provides multiple benefits: