VIEW: LBACSYS.DBA_SA_GROUPS

Source

View Text - Preformatted

SELECT p.pol_name AS policy_name, g.group# AS group_num,
          g.code AS short_name, g.name AS long_name,
          g.parent# AS parent_num, pg.code AS parent_name
   FROM LBACSYS.ols$pol p, LBACSYS.ols$groups g, LBACSYS.ols$groups pg
   WHERE p.pol# = g.pol# AND
         g.pol# = pg.pol# (+) AND
         g.parent# = pg.group#(+)

View Text - HTML Formatted

SELECT P.POL_NAME AS POLICY_NAME
, G.GROUP# AS GROUP_NUM
, G.CODE AS SHORT_NAME
, G.NAME AS LONG_NAME
, G.PARENT# AS PARENT_NUM
, PG.CODE AS PARENT_NAME
FROM LBACSYS.OLS$POL P
, LBACSYS.OLS$GROUPS G
, LBACSYS.OLS$GROUPS PG
WHERE P.POL# = G.POL# AND G.POL# = PG.POL# (+) AND G.PARENT# = PG.GROUP#(+)