ITS_OP/SRC - 스마트교차로 테이블 연계 이전 소스/MakeIfscXml.SQL

SELECT IFSC_ID, IFSC_NM, DRCT_CD, STRT_NM, END_NM, SECT_LNGT,             
       EXTR_CNCT_SECT_YN, DEL_YN, RMRK, F_NODE_ID, T_NODE_ID,             
       SECT_GRAD_CD, AREA_CD, DECODE(AREA_CD, 'LAT001', 'Y', 'N') REGN_YN 
  FROM TB_IFSC                                                            
 ORDER BY IFSC_ID