DIS Worksheet SQLs

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Discoverer worksheet SQL queries.
While the workbook documents are stored in a binary format in eul5_documents.doc_document and it's difficult extract their content (https://community.oracle.com/thread/2494216 ...  Discoverer worksheet SQL queries.
While the workbook documents are stored in a binary format in eul5_documents.doc_document and it's difficult extract their content (https://community.oracle.com/thread/2494216), there is an active trigger function
select ef.* from eul_us.eul5_functions ef where ef.fun_name='eul_trigger$post_save_document'
writing each worksheets' SQL query to table ams_discoverer_sql   more
Run DIS Worksheet SQLs and other Oracle EBS reports with Blitz Report™ on our demo environment
select
ads.workbook_name workbook,
ads.worksheet_name Worksheet,
xxen_util.dis_user_name(ads.workbook_owner_name) workbook_owner,
eqs.access_count,
eqs.last_accessed,
xxen_util.dis_worksheet_sql(ads.workbook_owner_name, ads.workbook_name, ads.worksheet_name) worksheet_sql,
xxen_util.user_name(ads.last_updated_by) last_updated_by,
xxen_util.client_time(ads.last_update_date) last_update_date
from
(
select distinct
ads.workbook_owner_name,
ads.workbook_name,
ads.worksheet_name,
max(ads.last_updated_by) over (partition by ads.workbook_owner_name, ads.workbook_name, ads.worksheet_name) last_updated_by,
max(ads.last_update_date) over (partition by ads.workbook_owner_name, ads.workbook_name, ads.worksheet_name) last_update_date
from
ams_discoverer_sql ads
where
1=1
) ads,
(
select
upper(eqs.qs_doc_owner) qs_doc_owner,
eqs.qs_doc_name,
eqs.qs_doc_details,
count(*) access_count,
max(eqs.qs_created_date) last_accessed
from
&eul.eul5_qpp_stats eqs
where
2=2
group by
upper(eqs.qs_doc_owner),
eqs.qs_doc_name,
eqs.qs_doc_details
) eqs
where
3=3 and
ads.workbook_name=eqs.qs_doc_name(+) and
ads.worksheet_name=eqs.qs_doc_details(+)
order by
ads.last_update_date desc
Parameter Name SQL text Validation
Workbook 
ads.workbook_name=:workbook
 LOV
Worksheet 
ads.worksheet_name=:worksheet
 LOV
Access Count within x Days 
eqs.qs_created_date>sysdate-:days
 Number
Show Active only 
eqs.qs_doc_name is not null
 LOV
End User Layer 
<parameter_value>
 LOV
Download
 
Related Blitz Reports
DIS Workbook Import Validation COPY OF: DIS Workbook Import Validation DIS End User Layers DIS Workbooks, Folders, Items and LOVs DIS Folders, Business Areas, Items and LOVs DIS Workbook Export Script DIS Access Privileges DIS Worksheet Execution Summary DIS Worksheet Execution History
Blitz Report™

Blitz Report™ provides multiple benefits: