WLF_LM_LP_SECTIONS_VL

Details

• Schema: FUSION

• Object owner: WLF

• Object type: VIEW

Columns

Name

LEARNING_PATH_SECTION_ID LEARNING_PATH_ID SECTION_SEQUENCE COMPLETION_TYPE_CODE NO_OF_MANDATORY_COURSES CREATED_BY CREATION_DATE LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN ENTERPRISE_ID OBJECT_VERSION_NUMBER LPC_ATTRIBUTE_CATEGORY LPC_ATTRIBUTE1 LPC_ATTRIBUTE2 LPC_ATTRIBUTE3 LPC_ATTRIBUTE4 LPC_ATTRIBUTE5 LPC_ATTRIBUTE6 LPC_ATTRIBUTE7 LPC_ATTRIBUTE8 LPC_ATTRIBUTE9 LPC_ATTRIBUTE10 LPC_ATTRIBUTE11 LPC_ATTRIBUTE12 LPC_ATTRIBUTE13 LPC_ATTRIBUTE14 LPC_ATTRIBUTE15 LPC_ATTRIBUTE16 LPC_ATTRIBUTE17 LPC_ATTRIBUTE18 LPC_ATTRIBUTE19 LPC_ATTRIBUTE20 LPC_ATTRIBUTE_NUMBER1 LPC_ATTRIBUTE_NUMBER2 LPC_ATTRIBUTE_NUMBER3 LPC_ATTRIBUTE_NUMBER4 LPC_ATTRIBUTE_NUMBER5 LPC_ATTRIBUTE_NUMBER6 LPC_ATTRIBUTE_NUMBER7 LPC_ATTRIBUTE_NUMBER8 LPC_ATTRIBUTE_NUMBER9 LPC_ATTRIBUTE_NUMBER10 LPC_ATTRIBUTE_NUMBER11 LPC_ATTRIBUTE_NUMBER12 LPC_ATTRIBUTE_NUMBER13 LPC_ATTRIBUTE_NUMBER14 LPC_ATTRIBUTE_NUMBER15 LPC_ATTRIBUTE_NUMBER16 LPC_ATTRIBUTE_NUMBER17 LPC_ATTRIBUTE_NUMBER18 LPC_ATTRIBUTE_NUMBER19 LPC_ATTRIBUTE_NUMBER20 LPC_ATTRIBUTE_DATE1 LPC_ATTRIBUTE_DATE2 LPC_ATTRIBUTE_DATE3 LPC_ATTRIBUTE_DATE4 LPC_ATTRIBUTE_DATE5 LPC_ATTRIBUTE_DATE6 LPC_ATTRIBUTE_DATE7 LPC_ATTRIBUTE_DATE8 LPC_ATTRIBUTE_DATE9 LPC_ATTRIBUTE_DATE10 LPC_ATTRIBUTE_DATE11 LPC_ATTRIBUTE_DATE12 LPC_ATTRIBUTE_DATE13 LPC_ATTRIBUTE_DATE14 LPC_ATTRIBUTE_DATE15 NAME DESCRIPTION

Query

SQL_Statement

SELECT B.LEARNING_PATH_SECTION_ID, B.LEARNING_PATH_ID, B.SECTION_SEQUENCE, B.COMPLETION_TYPE_CODE, B.NO_OF_MANDATORY_COURSES, 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.LPC_ATTRIBUTE_CATEGORY, B.LPC_ATTRIBUTE1, B.LPC_ATTRIBUTE2, B.LPC_ATTRIBUTE3, B.LPC_ATTRIBUTE4, B.LPC_ATTRIBUTE5, B.LPC_ATTRIBUTE6, B.LPC_ATTRIBUTE7, B.LPC_ATTRIBUTE8, B.LPC_ATTRIBUTE9, B.LPC_ATTRIBUTE10, B.LPC_ATTRIBUTE11, B.LPC_ATTRIBUTE12, B.LPC_ATTRIBUTE13, B.LPC_ATTRIBUTE14, B.LPC_ATTRIBUTE15, B.LPC_ATTRIBUTE16, B.LPC_ATTRIBUTE17, B.LPC_ATTRIBUTE18, B.LPC_ATTRIBUTE19, B.LPC_ATTRIBUTE20, B.LPC_ATTRIBUTE_NUMBER1, B.LPC_ATTRIBUTE_NUMBER2, B.LPC_ATTRIBUTE_NUMBER3, B.LPC_ATTRIBUTE_NUMBER4, B.LPC_ATTRIBUTE_NUMBER5, B.LPC_ATTRIBUTE_NUMBER6, B.LPC_ATTRIBUTE_NUMBER7, B.LPC_ATTRIBUTE_NUMBER8, B.LPC_ATTRIBUTE_NUMBER9, B.LPC_ATTRIBUTE_NUMBER10, B.LPC_ATTRIBUTE_NUMBER11, B.LPC_ATTRIBUTE_NUMBER12, B.LPC_ATTRIBUTE_NUMBER13, B.LPC_ATTRIBUTE_NUMBER14, B.LPC_ATTRIBUTE_NUMBER15, B.LPC_ATTRIBUTE_NUMBER16, B.LPC_ATTRIBUTE_NUMBER17, B.LPC_ATTRIBUTE_NUMBER18, B.LPC_ATTRIBUTE_NUMBER19, B.LPC_ATTRIBUTE_NUMBER20, B.LPC_ATTRIBUTE_DATE1, B.LPC_ATTRIBUTE_DATE2, B.LPC_ATTRIBUTE_DATE3, B.LPC_ATTRIBUTE_DATE4, B.LPC_ATTRIBUTE_DATE5, B.LPC_ATTRIBUTE_DATE6, B.LPC_ATTRIBUTE_DATE7, B.LPC_ATTRIBUTE_DATE8, B.LPC_ATTRIBUTE_DATE9, B.LPC_ATTRIBUTE_DATE10, B.LPC_ATTRIBUTE_DATE11, B.LPC_ATTRIBUTE_DATE12, B.LPC_ATTRIBUTE_DATE13, B.LPC_ATTRIBUTE_DATE14, B.LPC_ATTRIBUTE_DATE15, TL.NAME, TL.DESCRIPTION FROM WLF_LM_LP_SECTIONS_B B, WLF_LM_LP_SECTIONS_TL TL WHERE B.LEARNING_PATH_SECTION_ID = TL.LEARNING_PATH_SECTION_ID AND TL.LANGUAGE = USERENV('lang')