ITS_OP/SRC/SQL/기관정보조회.sql

SELECT A.CNCT_INTN_MNGM_NMBR, A.CNCT_INTN_NM, A.CNCT_INTN_TYPE_CD,
       --fn_GetCodeName('COT', A.CNCT_INTN_TYPE_CD) AS CNCT_INTN_TYPE_NM ,
       A.CNCT_INTN_TEL, A.CNCT_INTN_ADDR, A.RMRK,
       A.FRST_REGR_NMBR, A.FRST_RGST_DT, 
       A.LAST_CRPR_NMBR, A.LAST_CRCT_DT
  FROM TB_CNCT_INTN A
 ORDER BY A.CNCT_INTN_MNGM_NMBR


SELECT A.CNCT_INTN_MNGM_NMBR, A.CNCT_INTN_NM, A.CNCT_INTN_TYPE_CD,      
       A.CNCT_INTN_TEL, A.CNCT_INTN_ADDR, A.RMRK,                       
       A.FRST_REGR_NMBR, A.FRST_RGST_DT,                                
       A.LAST_CRPR_NMBR, A.LAST_CRCT_DT, A.DEL_YN                       
  FROM TB_CNCT_INTN A                                                   
 ORDER BY A.CNCT_INTN_MNGM_NMBR