WLF_LM_LEARNING_PATHS_VL

Details

• Schema: FUSION

• Object owner: WLF

• Object type: VIEW

Columns

Name

LEARNING_PATH_ID LEARNING_PATH_NUMBER PERSON_ID DURATION_UNITS DUE_IN_DAYS DUE_DATE DUEDATE_IN_NUM_YRS CERTIFICATION_FLAG VALIDITY_PERIOD RENEWABLE_FLAG RENEWAL_PERIOD NOTIFY_DAYS_BEFORE_TARGET PATH_SOURCE_CODE SOURCE_FUNCTION_CODE ASSIGNMENT_ID PUBLIC_FLAG SOURCE_ID THUMBNAIL_ID CONTACT_ID DISPLAY_TO_LEARNER_FLAG COMPETENCY_UPDATE_LEVEL START_DATE END_DATE INITIAL_COMPLETION_DATE INITIAL_COMPLETION_DURATION INITIAL_COMPL_DURATION_UNITS RENEWAL_DURATION RENEWAL_DURATION_UNITS NOTIFY_DAYS_BEFORE_EXPIRE VALIDITY_DURATION VALIDITY_DURATION_UNITS VALIDITY_START_TYPE CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN ENTERPRISE_ID OBJECT_VERSION_NUMBER LPA_ATTRIBUTE_CATEGORY LPA_ATTRIBUTE1 LPA_ATTRIBUTE2 LPA_ATTRIBUTE3 LPA_ATTRIBUTE4 LPA_ATTRIBUTE5 LPA_ATTRIBUTE6 LPA_ATTRIBUTE7 LPA_ATTRIBUTE8 LPA_ATTRIBUTE9 LPA_ATTRIBUTE10 LPA_ATTRIBUTE11 LPA_ATTRIBUTE12 LPA_ATTRIBUTE13 LPA_ATTRIBUTE14 LPA_ATTRIBUTE15 LPA_ATTRIBUTE16 LPA_ATTRIBUTE17 LPA_ATTRIBUTE18 LPA_ATTRIBUTE19 LPA_ATTRIBUTE20 LPA_ATTRIBUTE_NUMBER1 LPA_ATTRIBUTE_NUMBER2 LPA_ATTRIBUTE_NUMBER3 LPA_ATTRIBUTE_NUMBER4 LPA_ATTRIBUTE_NUMBER5 LPA_ATTRIBUTE_NUMBER6 LPA_ATTRIBUTE_NUMBER7 LPA_ATTRIBUTE_NUMBER8 LPA_ATTRIBUTE_NUMBER9 LPA_ATTRIBUTE_NUMBER10 LPA_ATTRIBUTE_NUMBER11 LPA_ATTRIBUTE_NUMBER12 LPA_ATTRIBUTE_NUMBER13 LPA_ATTRIBUTE_NUMBER14 LPA_ATTRIBUTE_NUMBER15 LPA_ATTRIBUTE_NUMBER16 LPA_ATTRIBUTE_NUMBER17 LPA_ATTRIBUTE_NUMBER18 LPA_ATTRIBUTE_NUMBER19 LPA_ATTRIBUTE_NUMBER20 LPA_ATTRIBUTE_DATE1 LPA_ATTRIBUTE_DATE2 LPA_ATTRIBUTE_DATE3 LPA_ATTRIBUTE_DATE4 LPA_ATTRIBUTE_DATE5 LPA_ATTRIBUTE_DATE6 LPA_ATTRIBUTE_DATE7 LPA_ATTRIBUTE_DATE8 LPA_ATTRIBUTE_DATE9 LPA_ATTRIBUTE_DATE10 LPA_ATTRIBUTE_DATE11 LPA_ATTRIBUTE_DATE12 LPA_ATTRIBUTE_DATE13 LPA_ATTRIBUTE_DATE14 LPA_ATTRIBUTE_DATE15 NAME DESCRIPTION OBJECTIVES PURPOSE KEYWORDS TRIAL_VIDEO_CONTENT_ID CONTENT_ID

Query

SQL_Statement

SELECT B.LEARNING_PATH_ID, B.LEARNING_PATH_NUMBER, B.PERSON_ID, B.DURATION_UNITS, B.DUE_IN_DAYS, B.DUE_DATE, B.DUEDATE_IN_NUM_YRS, B.CERTIFICATION_FLAG, B.VALIDITY_PERIOD, B.RENEWABLE_FLAG, B.RENEWAL_PERIOD, B.NOTIFY_DAYS_BEFORE_TARGET, B.PATH_SOURCE_CODE, B.SOURCE_FUNCTION_CODE, B.ASSIGNMENT_ID, B.PUBLIC_FLAG, B.SOURCE_ID, B.THUMBNAIL_ID, B.CONTACT_ID, B.DISPLAY_TO_LEARNER_FLAG, B.COMPETENCY_UPDATE_LEVEL, B.START_DATE, B.END_DATE, B.INITIAL_COMPLETION_DATE, B.INITIAL_COMPLETION_DURATION, B.INITIAL_COMPL_DURATION_UNITS, B.RENEWAL_DURATION, B.RENEWAL_DURATION_UNITS, B.NOTIFY_DAYS_BEFORE_EXPIRE, B.VALIDITY_DURATION, B.VALIDITY_DURATION_UNITS, B.VALIDITY_START_TYPE, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, B.ENTERPRISE_ID, B.OBJECT_VERSION_NUMBER, B.LPA_ATTRIBUTE_CATEGORY, B.LPA_ATTRIBUTE1, B.LPA_ATTRIBUTE2, B.LPA_ATTRIBUTE3, B.LPA_ATTRIBUTE4, B.LPA_ATTRIBUTE5, B.LPA_ATTRIBUTE6, B.LPA_ATTRIBUTE7, B.LPA_ATTRIBUTE8, B.LPA_ATTRIBUTE9, B.LPA_ATTRIBUTE10, B.LPA_ATTRIBUTE11, B.LPA_ATTRIBUTE12, B.LPA_ATTRIBUTE13, B.LPA_ATTRIBUTE14, B.LPA_ATTRIBUTE15, B.LPA_ATTRIBUTE16, B.LPA_ATTRIBUTE17, B.LPA_ATTRIBUTE18, B.LPA_ATTRIBUTE19, B.LPA_ATTRIBUTE20, B.LPA_ATTRIBUTE_NUMBER1, B.LPA_ATTRIBUTE_NUMBER2, B.LPA_ATTRIBUTE_NUMBER3, B.LPA_ATTRIBUTE_NUMBER4, B.LPA_ATTRIBUTE_NUMBER5, B.LPA_ATTRIBUTE_NUMBER6, B.LPA_ATTRIBUTE_NUMBER7, B.LPA_ATTRIBUTE_NUMBER8, B.LPA_ATTRIBUTE_NUMBER9, B.LPA_ATTRIBUTE_NUMBER10, B.LPA_ATTRIBUTE_NUMBER11, B.LPA_ATTRIBUTE_NUMBER12, B.LPA_ATTRIBUTE_NUMBER13, B.LPA_ATTRIBUTE_NUMBER14, B.LPA_ATTRIBUTE_NUMBER15, B.LPA_ATTRIBUTE_NUMBER16, B.LPA_ATTRIBUTE_NUMBER17, B.LPA_ATTRIBUTE_NUMBER18, B.LPA_ATTRIBUTE_NUMBER19, B.LPA_ATTRIBUTE_NUMBER20, B.LPA_ATTRIBUTE_DATE1, B.LPA_ATTRIBUTE_DATE2, B.LPA_ATTRIBUTE_DATE3, B.LPA_ATTRIBUTE_DATE4, B.LPA_ATTRIBUTE_DATE5, B.LPA_ATTRIBUTE_DATE6, B.LPA_ATTRIBUTE_DATE7, B.LPA_ATTRIBUTE_DATE8, B.LPA_ATTRIBUTE_DATE9, B.LPA_ATTRIBUTE_DATE10, B.LPA_ATTRIBUTE_DATE11, B.LPA_ATTRIBUTE_DATE12, B.LPA_ATTRIBUTE_DATE13, B.LPA_ATTRIBUTE_DATE14, B.LPA_ATTRIBUTE_DATE15, TL.NAME, TL.DESCRIPTION, TL.OBJECTIVES, TL.PURPOSE, TL.KEYWORDS, B.TRIAL_VIDEO_CONTENT_ID, B.CONTENT_ID FROM WLF_LM_LEARNING_PATHS_B B, WLF_LM_LEARNING_PATHS_TL TL WHERE B.LEARNING_PATH_ID = TL.LEARNING_PATH_ID AND TL.LANGUAGE = USERENV('lang')