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:
Post a Comment