VIEW: LBACSYS.DBA_SA_LEVELS

Source

View Text - Preformatted

SELECT p.pol_name AS policy_name, l.level# AS level_num,
          l.code AS short_name, l.name AS long_name
   FROM LBACSYS.ols$pol p, LBACSYS.ols$levels l
   WHERE p.pol# = l.pol#

View Text - HTML Formatted

SELECT P.POL_NAME AS POLICY_NAME
, L.LEVEL# AS LEVEL_NUM
, L.CODE AS SHORT_NAME
, L.NAME AS LONG_NAME
FROM LBACSYS.OLS$POL P
, LBACSYS.OLS$LEVELS L
WHERE P.POL# = L.POL#