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