gistfile1.sql

SELECT TWO.STFN_ID,
  LISTAGG(TWO.PDOB_NAME, ',') WITHIN GROUP (ORDER BY TWO.PDOB_NAME) "PROC"
FROM
  (SELECT ONE.STFN_ID,
    ONE.STFN_PARENT,
    ONE.STFN_NAME,
    ONE.STFN_INFO,
    PROC.PDOB_NAME,
    PROC.PDOB_INFO
  FROM
    (SELECT SYS.*,
      R.PDOB_ID
    FROM T_SYSTEM_FUNC SYS
    LEFT JOIN T_FUNC_PROCEDURE R
    ON SYS.STFN_ID     = R.STFN_ID
    WHERE SYS.IS_USING = 1
    ) ONE
  LEFT JOIN T_PROCEDURE_OBJ PROC
  ON ONE.PDOB_ID      = PROC.PDOB_ID
  WHERE PROC.IS_USING = 1
  ) TWO GROUP BY TWO.STFN_ID;