SELECT A.CMPY_ID      ,
       A.CMPY_NM      ,
       A.BRNO         ,
       A.ADDR         ,
       A.TEL          ,
       A.FCSM_NMBR    ,
       A.RPRV_NM      ,
       A.CHGR_NM      ,
       A.CHGR_HP_NMBR ,
       A.CHGR_EMAL    ,
       A.ADTN_NM      ,
       A.ADTN_DT      ,
       A.CHNG_NM      ,
       A.CHNG_DT      ,
       A.DEL_YN       
  FROM TB_FCLT_CMPY A
 ORDER BY A.CMPY_ID

SELECT *
FROM TB_FCLT_CMPY
