Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement