Wednesday, October 25, 2017

Oracle Discoverer Metadata

Get a list of business area:

SELECT eb.ba_name business_area 
from  EUL_US.EUL5_BAS eb;

--

Get a list of folders:

SELECT eo.OBJ_TYPE
,      eo.OBJ_NAME folder_name
,      eo.OBJ_DESCRIPTION
FROM EUL_US.EUL5_objs eo
INNER JOIN EUL_US.EUL5_BA_OBJ_LINKS ebol
ON ebol.BOL_OBJ_ID = eo.OBJ_ID
INNER JOIN EUL_US.EUL5_BAS eb
ON eb.BA_ID = ebol.BOL_BA_ID
WHERE eb.ba_name = 'Financial';


No comments: