SELECT
    STUDENTID,
    TO_CHAR( COUNCILDATE, 'dd MON, yyyy' ) COUNCILDATE,
    SUBJECTCODE || ' ' || SUBJECTNAME SUBJECTCODE,
    OPERATION,
    NOTE,
    NVL( FULLNAME, UPDATEBY ) ACTOR,
    TO_CHAR( UPDATETIME, 'dd MON, yyyy hh24:mi:ss' ) UPDATETIME,
    ( SCHOOLYEAR || '/' || SEMESTER ) SCHOOLPERIODE,
    ( LASTINDEX || ' To ' || INDEXPOINT ) INDEXCHANGE,
    CHANGEID,
    DECODE( APPROVALSTATUS, 'Y', 'Yes', 'N', 'No', '' ) || ' (' || TO_CHAR( APPROVALDATE, 'dd MON, yyyy hh24:mi:ss' ) || ')' STATUS2,
    UPDATEBY,
    STUDYPROGRAMNAME,
    DECODE( APPROVALSTATUSWADEK, 'Y', 'Yes', 'N', 'No', '' ) || ' (' || TO_CHAR( APPROVALDATEWADEK, 'dd MON, yyyy hh24:mi:ss' ) || ')' STATUS,
    APPROVALSTATUS,
    APPROVALBYWADEK,
    COMPLETECOURSEPOINTCHANGE.ACTIVESTATUS,
    EVIDANCEDESC,
    EVIDANCEURL
FROM
    COMPLETECOURSEPOINTCHANGE
    JOIN SUBJECTS USING ( SUBJECTID, SUBJECTCODE )
    JOIN ( SELECT STUDENTID, STUDYPROGRAMNAME FROM MASTERDATA.STUDENT JOIN MASTERDATA.STUDYPROGRAM USING ( STUDYPROGRAMID ) WHERE 1 = 1 ) USING ( STUDENTID )
    LEFT JOIN ( SELECT DISTINCT EMPLOYEEID, FULLNAME FROM MASTERDATA.EMPLOYEEMASTER ) fusers ON ( fusers.EMPLOYEEID = UPDATEBY )
WHERE
    1 = 1
    AND APPROVALSTATUS IS NULL
    AND APPROVALSTATUSWADEK IS NULL
ORDER BY
    UPDATETIME DESC