SELECT
    SUBJECTCODE,
    SUBJECTNAME,
    NVL(UPPER(A.INSTITUTION), '-') AS INSTANTION,
    COURSE.CREDIT,
    STUDYPROGRAMNAME,
    CLASS,
    LECTURERCODE,
                EMPLOYEESNAME LECTURERNAME,
    NIDN,
    TRIM(ACADEMICGRADESID) ACADEMICFUNCPOSITION,
    LASTACADEMICTITLE,
    INSTITUTIONNAME,
    COURSECOORDINATOR,
    EPSBED_LECTURER,
    MAJOR,
    F.FACULTYNAME
FROM
    VIEW_COURSE_TEAM_TEACHING COURSE
JOIN (
    SELECT
        SUBJECTID,
        SUBJECTCODE,
        CREDIT,
        SUBJECTNAME,
        SUBJECTSERVICE,
        SUBJECTEXCEPTION
    FROM
        SUBJECTS
    WHERE
        1 = 1 )
        USING (SUBJECTID,
    SUBJECTCODE)
JOIN MASTERDATA.STUDYPROGRAM SP
        USING (STUDYPROGRAMID)
JOIN MASTERDATA.FACULTIES F ON
    (SP.FACULTYID = F.FACULTYID)
JOIN LECTURERVIEW A
        USING (LECTURERCODE)
LEFT JOIN MASTERDATA.LECTURERLASTEDUCATION
        USING (LECTURERCODE,
    LASTACADEMICTITLE)
WHERE
    1 = 1
    AND (STUDYPROGRAMID = '77'
        OR TRIM(SUBJECTSERVICE)= '77')
    AND SEMESTER = '2'
    AND SCHOOLYEAR = '2324'
    AND POSITION = 1
    AND F.FACULTYID IN (
    SELECT
        FACULTYID
    FROM
        USEROFFACULTY
    WHERE
        USERID = '401')
    AND ACTIVATEDSTATUS = 'YA'