WLF_LM_COURSES_VL

Details

• Schema: FUSION

• Object owner: WLF

• Object type: VIEW

Columns

Name

COURSE_ID COURSE_NUMBER DEVELOPER_ORGANIZATION_ID CONTROLLING_PERSON_ID VENDOR_ID ACTUAL_COST BUDGET_COST BUDGET_CURRENCY_CODE COMMENTS DURATION DURATION_UNITS END_DATE EXPENSES_ALLOWED INTENDED_AUDIENCE LANGUAGE_ID MAXIMUM_ATTENDEES MAXIMUM_INTERNAL_ATTENDEES MINIMUM_ATTENDEES OBJECTIVES PROFESSIONAL_CREDIT_TYPE PROFESSIONAL_CREDITS START_DATE SUCCESS_CRITERIA THUMBNAIL_ID USER_STATUS INVENTORY_ITEM_ID ORGANIZATION_ID RCO_ID VERSION_CODE DATA_SOURCE COMPETENCY_UPDATE_LEVEL ERES_ENABLED CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN ENTERPRISE_ID OBJECT_VERSION_NUMBER CRS_ATTRIBUTE_CATEGORY CRS_ATTRIBUTE1 CRS_ATTRIBUTE2 CRS_ATTRIBUTE3 CRS_ATTRIBUTE4 CRS_ATTRIBUTE5 CRS_ATTRIBUTE6 CRS_ATTRIBUTE7 CRS_ATTRIBUTE8 CRS_ATTRIBUTE9 CRS_ATTRIBUTE10 CRS_ATTRIBUTE11 CRS_ATTRIBUTE12 CRS_ATTRIBUTE13 CRS_ATTRIBUTE14 CRS_ATTRIBUTE15 CRS_ATTRIBUTE16 CRS_ATTRIBUTE17 CRS_ATTRIBUTE18 CRS_ATTRIBUTE19 CRS_ATTRIBUTE20 CRS_ATTRIBUTE_NUMBER1 CRS_ATTRIBUTE_NUMBER2 CRS_ATTRIBUTE_NUMBER3 CRS_ATTRIBUTE_NUMBER4 CRS_ATTRIBUTE_NUMBER5 CRS_ATTRIBUTE_NUMBER6 CRS_ATTRIBUTE_NUMBER7 CRS_ATTRIBUTE_NUMBER8 CRS_ATTRIBUTE_NUMBER9 CRS_ATTRIBUTE_NUMBER10 CRS_ATTRIBUTE_NUMBER11 CRS_ATTRIBUTE_NUMBER12 CRS_ATTRIBUTE_NUMBER13 CRS_ATTRIBUTE_NUMBER14 CRS_ATTRIBUTE_NUMBER15 CRS_ATTRIBUTE_NUMBER16 CRS_ATTRIBUTE_NUMBER17 CRS_ATTRIBUTE_NUMBER18 CRS_ATTRIBUTE_NUMBER19 CRS_ATTRIBUTE_NUMBER20 CRS_ATTRIBUTE_DATE1 CRS_ATTRIBUTE_DATE2 CRS_ATTRIBUTE_DATE3 CRS_ATTRIBUTE_DATE4 CRS_ATTRIBUTE_DATE5 CRS_ATTRIBUTE_DATE6 CRS_ATTRIBUTE_DATE7 CRS_ATTRIBUTE_DATE8 CRS_ATTRIBUTE_DATE9 CRS_ATTRIBUTE_DATE10 CRS_ATTRIBUTE_DATE11 CRS_ATTRIBUTE_DATE12 CRS_ATTRIBUTE_DATE13 CRS_ATTRIBUTE_DATE14 CRS_ATTRIBUTE_DATE15 NAME KEYWORDS DESCRIPTION TRIAL_VIDEO_CONTENT_ID EFFORT_TEXT DURATION_TEXT CONTENT_ID

Query

SQL_Statement

SELECT B.COURSE_ID, B.COURSE_NUMBER, B.DEVELOPER_ORGANIZATION_ID, B.CONTROLLING_PERSON_ID, B.VENDOR_ID, B.ACTUAL_COST, B.BUDGET_COST, B.BUDGET_CURRENCY_CODE, B.COMMENTS, B.DURATION, B.DURATION_UNITS, B.END_DATE, B.EXPENSES_ALLOWED, B.INTENDED_AUDIENCE, B.LANGUAGE_ID, B.MAXIMUM_ATTENDEES, B.MAXIMUM_INTERNAL_ATTENDEES, B.MINIMUM_ATTENDEES, B.OBJECTIVES, B.PROFESSIONAL_CREDIT_TYPE, B.PROFESSIONAL_CREDITS, B.START_DATE, B.SUCCESS_CRITERIA, B.THUMBNAIL_ID, B.USER_STATUS, B.INVENTORY_ITEM_ID, B.ORGANIZATION_ID, B.RCO_ID, B.VERSION_CODE, B.DATA_SOURCE, B.COMPETENCY_UPDATE_LEVEL, B.ERES_ENABLED, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.ENTERPRISE_ID, B.OBJECT_VERSION_NUMBER, B.CRS_ATTRIBUTE_CATEGORY, B.CRS_ATTRIBUTE1, B.CRS_ATTRIBUTE2, B.CRS_ATTRIBUTE3, B.CRS_ATTRIBUTE4, B.CRS_ATTRIBUTE5, B.CRS_ATTRIBUTE6, B.CRS_ATTRIBUTE7, B.CRS_ATTRIBUTE8, B.CRS_ATTRIBUTE9, B.CRS_ATTRIBUTE10, B.CRS_ATTRIBUTE11, B.CRS_ATTRIBUTE12, B.CRS_ATTRIBUTE13, B.CRS_ATTRIBUTE14, B.CRS_ATTRIBUTE15, B.CRS_ATTRIBUTE16, B.CRS_ATTRIBUTE17, B.CRS_ATTRIBUTE18, B.CRS_ATTRIBUTE19, B.CRS_ATTRIBUTE20, B.CRS_ATTRIBUTE_NUMBER1, B.CRS_ATTRIBUTE_NUMBER2, B.CRS_ATTRIBUTE_NUMBER3, B.CRS_ATTRIBUTE_NUMBER4, B.CRS_ATTRIBUTE_NUMBER5, B.CRS_ATTRIBUTE_NUMBER6, B.CRS_ATTRIBUTE_NUMBER7, B.CRS_ATTRIBUTE_NUMBER8, B.CRS_ATTRIBUTE_NUMBER9, B.CRS_ATTRIBUTE_NUMBER10, B.CRS_ATTRIBUTE_NUMBER11, B.CRS_ATTRIBUTE_NUMBER12, B.CRS_ATTRIBUTE_NUMBER13, B.CRS_ATTRIBUTE_NUMBER14, B.CRS_ATTRIBUTE_NUMBER15, B.CRS_ATTRIBUTE_NUMBER16, B.CRS_ATTRIBUTE_NUMBER17, B.CRS_ATTRIBUTE_NUMBER18, B.CRS_ATTRIBUTE_NUMBER19, B.CRS_ATTRIBUTE_NUMBER20, B.CRS_ATTRIBUTE_DATE1, B.CRS_ATTRIBUTE_DATE2, B.CRS_ATTRIBUTE_DATE3, B.CRS_ATTRIBUTE_DATE4, B.CRS_ATTRIBUTE_DATE5, B.CRS_ATTRIBUTE_DATE6, B.CRS_ATTRIBUTE_DATE7, B.CRS_ATTRIBUTE_DATE8, B.CRS_ATTRIBUTE_DATE9, B.CRS_ATTRIBUTE_DATE10, B.CRS_ATTRIBUTE_DATE11, B.CRS_ATTRIBUTE_DATE12, B.CRS_ATTRIBUTE_DATE13, B.CRS_ATTRIBUTE_DATE14, B.CRS_ATTRIBUTE_DATE15, TL.NAME, TL.KEYWORDS, TL.DESCRIPTION, B.TRIAL_VIDEO_CONTENT_ID, B.EFFORT_TEXT, B.DURATION_TEXT, B.CONTENT_ID FROM WLF_LM_COURSES_B B, WLF_LM_COURSES_TL TL WHERE B.COURSE_ID = TL.COURSE_ID AND TL.LANGUAGE = USERENV('lang')