WLF_INSTRUCTORS_VISIBILITY_V

Details

• Schema: FUSION

• Object owner: WLF

• Object type: VIEW

Columns

Name
LEARNING_ITEM_ID EVENT_TYPE LEARNER_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE

Query

SQL_Statement

SELECT itm.LEARNING_ITEM_ID, recs.EVENT_TYPE, recs.LEARNER_ID, itm.EFFECTIVE_START_DATE, itm.EFFECTIVE_END_DATE FROM WLF_LEARNING_ITEMS_F itm, WLF_ACCESS_PERMISSIONS_F prms, WLF_ASSIGNMENT_RECORDS_F recs WHERE itm.LEARNING_ITEM_ID = recs.LEARNING_ITEM_ID AND recs.EVENT_TYPE = 'ORA_LI_INSTRUCT' AND recs.ACCESS_PERMISSION_ID = prms.ACCESS_PERMISSION_ID AND prms.INSTRUCTOR_ACCESS_MODE = 'Y' AND recs.LEARNER_ID NOT IN (SELECT AR.LEARNER_ID AS INSTRUCTOR_PERSON_ID FROM WLF_ASSIGNMENT_RECORDS_F AR JOIN WLF_EVENT_ASSIGNMENTS_F EA ON (AR.EVENT_ASSIGNMENT_ID = EA.EVENT_ASSIGNMENT_ID) JOIN WLF_ACCESS_PERMISSIONS_F AP ON (AP.ACCESS_PERMISSION_ID = AR.ACCESS_PERMISSION_ID) WHERE EA.IS_ADHOC = 'Y' AND AP.INSTRUCTOR_ACCESS_MODE = 'N' AND AR.LEARNING_ITEM_ID = RECS.LEARNING_ITEM_ID) AND NOT(recs.STATUS = 'ORA_ASSN_REC_DELETED') AND TRUNC(SYSDATE) BETWEEN itm.EFFECTIVE_START_DATE AND itm.EFFECTIVE_END_DATE AND TRUNC(SYSDATE) BETWEEN prms.EFFECTIVE_START_DATE AND prms.EFFECTIVE_END_DATE AND TRUNC(SYSDATE) BETWEEN recs.EFFECTIVE_START_DATE AND recs.EFFECTIVE_END_DATE