조직도
SELECT A.SPRVR_ORG_ID DEPTCD, A.WDY_CD_NM DEPTNM, SUBSTR (SYS_CONNECT_BY_PATH (A.WDY_CD_NM2, '|'), 7) DEPTLONGNM, ROWNUM DEPTPOSNO, A.ORG_LEVEL_SEQ DEPTLVL, A.ORG_LEVEL_SEQ TREELVL, A.UPR_ORG_ID PARENTDEPTCD, A.APPLY_STRT_DATE DEPTSTARTDT, '' DEPTENDDT FROM (SELECT B.WDY_CD_NM, B.WDY_CD_NM2, A.* FROM IF7T02SVS.XSTG_ORGSPRVR_SVSKR_TOV A, (SELECT CASE WHEN INSTR (B.WDY_CD_NM, '(') > 0 THEN SUBSTR ..
2023. 1. 27.