Reports2017-11-18T12:27:27+00:00

DIS Execution History

Description
Categories: Application, Enginatics
Discoverer execution statistics from table eul5_qpp_stats, including folder objects used.
Parameter 'Expand Objects' switches between aggregate and List view of used folder objects.

select
eqs.qs_id id,
xxen_util.user_name(to_number(substr(eqs.qs_created_by,2))) user_name,
eqs.qs_doc_name report_name,
eqs.qs_doc_details report_details,
eqs.qs_created_date start_date,
xxen_util.time(eqs.seconds) time,
eqs.seconds,
eqs.qs_num_rows row_count,
eo.obj_name object_name,
eo.obj_developer_key object_key,
eo.sobj_ext_table ext_table,
xxen_util.meaning(case when eqs.qs_object_use_key like '%.%' then 'Y' end,'YES_NO',0) multiple_flag,
eo.obj_description object_description,
eo.obj_type,
eqs.obj_id,
eqs.qs_object_use_key use_key
from
(
select
rowgen.column_value,
trim(regexp_substr(eqs.qs_object_use_key,'[^\.]+',1,rowgen.column_value)) obj_id,
greatest(nvl(eqs.qs_act_cpu_time,0),nvl(eqs.qs_act_elap_time,0)) seconds,
eqs.*
from
&eul.eul5_qpp_stats eqs,
table(xxen_util.rowgen(regexp_count(eqs.qs_object_use_key,'\.')+1)) rowgen
where
1=1
) eqs,
&eul.eul5_objs eo
where
eqs.obj_id=eo.obj_id(+)
order by
eqs.qs_id desc

Parameter Name SQL text Validation
Submitted by User
eqs.qs_created_by in (select '#'||fu.user_id from fnd_user fu where fu.user_name=:user_name)
LOV
Report Name
upper(xrv.report_name) like upper(:report_name)
LOV
End User Layer
<parameter_value>
LOV
Business Area
select
eb.ba_name value,
eb.ba_description description
from
eul_usx.eul5_bas eb
order by
eb.ba_name
LOV
Report Type
ewffw
Start Date To
eqs.qs_created_date<=:start_date_to
DateTime
Start Date From
eqs.qs_created_date>=:start_date_from
DateTime
Started within Days
eqs.qs_created_date>sysdate-:days
Number
View / Table Name
erwgg
Folder
wefwW