--List of Business Areas
SELECT ba_name "Business Area"
, ba_created_by "Creator"
, ba_created_date "Creation Date"
, ba_updated_by "Updated By "
, ba_updated_date "Last Update Date"
, ba_id
FROM eul5_us.eul5_bas
/
--List of Folders
SELECT b.ba_name
, f.obj_name folder_name
, f.obj_id
, f.obj_ext_owner owner
FROM eul5_us.eul5_objs f
, eul5_us.eul5_ba_obj_links l
, eul5_us.eul5_bas b
WHERE 1 = 1
AND f.obj_id = l.bol_obj_id
AND b.ba_id = l.bol_ba_id
AND UPPER (b.ba_name) LIKE UPPER ('%'||'&Business_area'||'%')
AND UPPER (f.obj_name) LIKE UPPER ('%'||'&FOLDER_NAME'||'%')
ORDER BY b.ba_name
, f.obj_name
/
--List of Folder Items
SELECT i.exp_name item_name
, i.exp_id
, i.it_ext_column
, f.obj_name folder_name
, b.ba_name
FROM eul5_us.eul5_expressions i
, eul5_us.eul5_objs f
, eul5_us.eul5_ba_obj_links l
, eul5_us.eul5_bas b
WHERE f.obj_id = i.it_obj_id
AND f.obj_id = l.bol_obj_id
AND b.ba_id = l.bol_ba_id
AND UPPER (i.exp_name) LIKE UPPER ('%'||'&ITEM_NAME'||'%')
AND UPPER (b.ba_name) LIKE UPPER ('%'||'&Business_area'||'%')
AND UPPER (f.obj_name) LIKE UPPER ('%'||'&FOLDER_NAME'||'%')
ORDER BY b.ba_name
, f.obj_name
, i.exp_name
/
--List of Workbooks
SELECT doc_name "Document"
, doc_developer_key
, doc_description "Description"
FROM eul5_us.eul5_documents
/
