SELECT
     AC0691.SYSID
    ,AC0691.KAKINS_TELNO
    ,AC0691.CONT_KEI_NO
    ,AC0691.CHRG_TRGT_YM
    ,AC0691.PCALL_STAYMD
    ,AC0691.PCALL_STA_HMS
    ,AC0691.HASHIN_TELNO
    ,AC0691.INCOMING_TELNO
    ,AC0691.PCALL_ENDYMD
    ,AC0691.PCALL_END_HMS
    ,TO_CHAR(AC0691.PCALL_SEC_CNT) AS PCALL_SEC_CNT
    ,TO_CHAR(AC0691.PCALL_DOSU) AS PCALL_DOSU
    ,TO_CHAR(AC0691.PCALL_TANKA) AS PCALL_TANKA
    ,TO_CHAR(AC0691.PCALL_PRC) AS PCALL_PRC
    ,AC0691.PCALL_SBT_CD
    ,AC0691.KAZEI_HIKAZEI_CD
    ,AC0691.TUWA_SVC_SKBT_CD
    ,AC0691.CUT_RSN_DIV_SIP
    ,AC0691.CUT_RSN_DIV_ISUP
    ,AC0691.CUT_RSN_DIV
    ,AC0691.CUT_DTAIL_INFO_DKMK_IDX_NO
    ,AC0691.CUT_DTAIL_INFO_CKMK_IDX_NO
    ,AC0691.CUT_DTAIL_INFO_HTCK_SBT_CD
    ,AC0691.CHRG_DSP_CD
    ,AC0691.EMG_KO_FLG
    ,TO_CHAR(AC0691.CHG_SIGNAL_RCV_CNT) AS CHG_SIGNAL_RCV_CNT
    ,AC0691.TENSO_JI_HASHIN_TELNO
    ,AC0691.COUNTRY_NM
    ,AC0691.CHRG_KH
FROM
    AC_T_CN050AP_TWDL_JT AC0691
WHERE
    AC0691.CHRG_TRGT_YM = :OPE_DATE
ORDER BY
     AC0691.KAKINS_TELNO
    ,AC0691.PCALL_STAYMD
    ,AC0691.PCALL_STA_HMS
    ,AC0691.TENSO_JI_HASHIN_TELNO
    ,AC0691.PCALL_SBT_CD