DIS Folders, Business Areas, Items and LOVs
Description
Categories: Enginatics
Repository: Github
Repository: Github
Discoverer folders, business areas and items.
Columns 'Access Count' and 'Last Accessed' shows how many times a folder was accessed by a worksheet within the past x days.
Parameter 'Show Active Only' restricts to folders which have been accessed by worksheet executions within the past x days.
Columns 'Access Count' and 'Last Accessed' shows how many times a folder was accessed by a worksheet within the past x days.
Parameter 'Show Active Only' restricts to folders which have been accessed by worksheet executions within the past x days.
Run
DIS Folders, Business Areas, Items and LOVs and other Oracle EBS reports with Blitz Report™ on our demo environment
select xxen_util.dis_business_area(eo.obj_id,:eul) business_area, eo.obj_id, &exp_id eo.obj_name folder, eo.obj_developer_key folder_identifier, xxen_util.dis_folder_type(eo.obj_type) folder_type, nvl2(eo.sobj_ext_table,nvl2((select dv.view_name from dba_views dv where eo.sobj_ext_table=dv.view_name and dv.owner='APPS'),'View','Table'),null) object_type, eo.sobj_ext_table object_name, eqs.access_count, eqs.last_accessed, &sql_text_columns eo.obj_description folder_description, &item_columns xxen_util.dis_user_name(eo.obj_created_by) created_by, xxen_util.client_time(eo.obj_created_date) creation_date, xxen_util.dis_user_name(eo.obj_updated_by) last_updated_by, xxen_util.client_time(eo.obj_updated_date) last_update_date from ( select ( select xxen_util.long_to_clob('SYS.VIEW$', 'TEXT', v.rowid) text from sys."_CURRENT_EDITION_OBJ" o, sys.view$ v, sys.user$ u where u.name='APPS' and eo.sobj_ext_table=o.name and o.obj#=v.obj# and o.owner#=u.user# ) text, eo.* from &eul.eul5_objs eo ) eo, ( select ee.it_obj_id obj_id, ee.* from &eul.eul5_expressions ee where '&show_items'='Y' and ee.exp_type in ('CI','CO') and ee.fil_obj_id is null union all select ee.fil_obj_id obj_id, ee.* from &eul.eul5_expressions ee where '&show_items'='Y' and ee.exp_type='FIL' and ee.it_obj_id is null ) ee, &eul.eul5_domains edo, &eul.eul5_expressions ee2, &eul.eul5_objs eo2, ( select eqs.obj_id, count(*) access_count, max(eqs.qs_created_date) last_accessed from ( select trim(regexp_substr(eqs.qs_object_use_key,'[^\.]+',1,rowgen.column_value)) obj_id, eqs.* from &eul.eul5_qpp_stats eqs, table(xxen_util.rowgen(regexp_count(eqs.qs_object_use_key,'\.')+1)) rowgen where 2=2 ) eqs where translate(eqs.obj_id,'x0123456789','x') is null group by eqs.obj_id ) eqs where 1=1 and eo.obj_id=ee.obj_id(+) and ee.it_dom_id=edo.dom_id(+) and edo.dom_it_id_lov=ee2.exp_id(+) and ee2.it_obj_id=eo2.obj_id(+) and eo.obj_id=eqs.obj_id(+) order by eo.obj_name, decode(ee.exp_type,'CO',1,'CI',2,'FIL',3,'JP',4), ee.exp_sequence |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Business Area |
|
LOV | |
Folder |
|
LOV | |
Folder Identifier |
|
LOV | |
Folder Type |
|
LOV | |
View Name |
|
LOV | |
Object Id |
|
Number | |
Used by Workbook |
|
LOV | |
Item |
|
LOV | |
Item Type |
|
LOV | |
Access Count within x Days |
|
Number | |
Show Active only |
|
LOV | |
Show Items |
|
LOV | |
Show Object SQL |
|
LOV | |
End User Layer |
|
LOV |