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

DIS Busines Areas and Folders

Description
Categories: Application, Enginatics
Discoverer business areas and folders

select
eb.ba_name business_area,
eb.ba_description description,
eb.ba_developer_key key,
(select count(*) from &eul.eul5_ba_obj_links ebol where eb.ba_id=ebol.bol_ba_id) folder_count,
xxen_util.disco_user_name(eb.ba_created_by) created_by,
eb.ba_created_date creation_date,
xxen_util.disco_user_name(eb.ba_updated_by) last_updated_by,
eb.ba_updated_date last_update_date
from
&eul.eul5_bas eb
where
1=1
order by
eb.ba_updated_date desc

Parameter Name SQL text Validation
End User Layer
<parameter_value>
LOV