WLF_LM_CLASSES_VL

Details

• Schema: FUSION

• Object owner: WLF

• Object type: VIEW

Columns

Name

CLASS_ID CLASS_NUMBER VENDOR_ID COURSE_ID ORGANIZATION_ID PARENT_CLASS_ID CLASS_TYPE ACTUAL_COST BUDGET_COST CENTRE COMMENTS END_DATE END_TIME START_DATE START_TIME DURATION DURATION_UNITS ENROLMENT_END_DATE ENROLMENT_START_DATE LANGUAGE_ID PUBLIC_FLAG USER_STATUS DEVELOPMENT_TYPE CLASS_STATUS PRICE_BASIS SECURE_FLAG BOOK_INDEPENDENT_FLAG CURRENCY_CODE MAXIMUM_ATTENDEES MAXIMUM_INTERNAL_ATTENDEES MINIMUM_ATTENDEES STANDARD_PRICE CATEGORY_CODE PROJECT_ID OWNER_ID LINE_ID ORG_ID TRAINING_CENTER_ID LOCATION_ID TIMEZONE DATA_SOURCE AVAILABILITY DELIVERY_MODE CONTENT_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN ENTERPRISE_ID OBJECT_VERSION_NUMBER CLS_ATTRIBUTE_CATEGORY CLS_ATTRIBUTE1 CLS_ATTRIBUTE2 CLS_ATTRIBUTE3 CLS_ATTRIBUTE4 CLS_ATTRIBUTE5 CLS_ATTRIBUTE6 CLS_ATTRIBUTE7 CLS_ATTRIBUTE8 CLS_ATTRIBUTE9 CLS_ATTRIBUTE10 CLS_ATTRIBUTE11 CLS_ATTRIBUTE12 CLS_ATTRIBUTE13 CLS_ATTRIBUTE14 CLS_ATTRIBUTE15 CLS_ATTRIBUTE16 CLS_ATTRIBUTE17 CLS_ATTRIBUTE18 CLS_ATTRIBUTE19 CLS_ATTRIBUTE20 CLS_ATTRIBUTE_NUMBER1 CLS_ATTRIBUTE_NUMBER2 CLS_ATTRIBUTE_NUMBER3 CLS_ATTRIBUTE_NUMBER4 CLS_ATTRIBUTE_NUMBER5 CLS_ATTRIBUTE_NUMBER6 CLS_ATTRIBUTE_NUMBER7 CLS_ATTRIBUTE_NUMBER8 CLS_ATTRIBUTE_NUMBER9 CLS_ATTRIBUTE_NUMBER10 CLS_ATTRIBUTE_NUMBER11 CLS_ATTRIBUTE_NUMBER12 CLS_ATTRIBUTE_NUMBER13 CLS_ATTRIBUTE_NUMBER14 CLS_ATTRIBUTE_NUMBER15 CLS_ATTRIBUTE_NUMBER16 CLS_ATTRIBUTE_NUMBER17 CLS_ATTRIBUTE_NUMBER18 CLS_ATTRIBUTE_NUMBER19 CLS_ATTRIBUTE_NUMBER20 CLS_ATTRIBUTE_DATE1 CLS_ATTRIBUTE_DATE2 CLS_ATTRIBUTE_DATE3 CLS_ATTRIBUTE_DATE4 CLS_ATTRIBUTE_DATE5 CLS_ATTRIBUTE_DATE6 CLS_ATTRIBUTE_DATE7 CLS_ATTRIBUTE_DATE8 CLS_ATTRIBUTE_DATE9 CLS_ATTRIBUTE_DATE10 CLS_ATTRIBUTE_DATE11 CLS_ATTRIBUTE_DATE12 CLS_ATTRIBUTE_DATE13 CLS_ATTRIBUTE_DATE14 CLS_ATTRIBUTE_DATE15 NAME DESCRIPTION

Query

SQL_Statement

SELECT B.CLASS_ID, B.CLASS_NUMBER, B.VENDOR_ID, B.COURSE_ID, B.ORGANIZATION_ID, B.PARENT_CLASS_ID, B.CLASS_TYPE, B.ACTUAL_COST, B.BUDGET_COST, B.CENTRE, B.COMMENTS, B.END_DATE, B.END_TIME, B.START_DATE, B.START_TIME, B.DURATION, B.DURATION_UNITS, B.ENROLMENT_END_DATE, B.ENROLMENT_START_DATE, B.LANGUAGE_ID, B.PUBLIC_FLAG, B.USER_STATUS, B.DEVELOPMENT_TYPE, B.CLASS_STATUS, B.PRICE_BASIS, B.SECURE_FLAG, B.BOOK_INDEPENDENT_FLAG, B.CURRENCY_CODE, B.MAXIMUM_ATTENDEES, B.MAXIMUM_INTERNAL_ATTENDEES, B.MINIMUM_ATTENDEES, B.STANDARD_PRICE, B.CATEGORY_CODE, B.PROJECT_ID, B.OWNER_ID, B.LINE_ID, B.ORG_ID, B.TRAINING_CENTER_ID, B.LOCATION_ID, B.TIMEZONE, B.DATA_SOURCE, B.AVAILABILITY, B.DELIVERY_MODE, B.CONTENT_ID, 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.CLS_ATTRIBUTE_CATEGORY, B.CLS_ATTRIBUTE1, B.CLS_ATTRIBUTE2, B.CLS_ATTRIBUTE3, B.CLS_ATTRIBUTE4, B.CLS_ATTRIBUTE5, B.CLS_ATTRIBUTE6, B.CLS_ATTRIBUTE7, B.CLS_ATTRIBUTE8, B.CLS_ATTRIBUTE9, B.CLS_ATTRIBUTE10, B.CLS_ATTRIBUTE11, B.CLS_ATTRIBUTE12, B.CLS_ATTRIBUTE13, B.CLS_ATTRIBUTE14, B.CLS_ATTRIBUTE15, B.CLS_ATTRIBUTE16, B.CLS_ATTRIBUTE17, B.CLS_ATTRIBUTE18, B.CLS_ATTRIBUTE19, B.CLS_ATTRIBUTE20, B.CLS_ATTRIBUTE_NUMBER1, B.CLS_ATTRIBUTE_NUMBER2, B.CLS_ATTRIBUTE_NUMBER3, B.CLS_ATTRIBUTE_NUMBER4, B.CLS_ATTRIBUTE_NUMBER5, B.CLS_ATTRIBUTE_NUMBER6, B.CLS_ATTRIBUTE_NUMBER7, B.CLS_ATTRIBUTE_NUMBER8, B.CLS_ATTRIBUTE_NUMBER9, B.CLS_ATTRIBUTE_NUMBER10, B.CLS_ATTRIBUTE_NUMBER11, B.CLS_ATTRIBUTE_NUMBER12, B.CLS_ATTRIBUTE_NUMBER13, B.CLS_ATTRIBUTE_NUMBER14, B.CLS_ATTRIBUTE_NUMBER15, B.CLS_ATTRIBUTE_NUMBER16, B.CLS_ATTRIBUTE_NUMBER17, B.CLS_ATTRIBUTE_NUMBER18, B.CLS_ATTRIBUTE_NUMBER19, B.CLS_ATTRIBUTE_NUMBER20, B.CLS_ATTRIBUTE_DATE1, B.CLS_ATTRIBUTE_DATE2, B.CLS_ATTRIBUTE_DATE3, B.CLS_ATTRIBUTE_DATE4, B.CLS_ATTRIBUTE_DATE5, B.CLS_ATTRIBUTE_DATE6, B.CLS_ATTRIBUTE_DATE7, B.CLS_ATTRIBUTE_DATE8, B.CLS_ATTRIBUTE_DATE9, B.CLS_ATTRIBUTE_DATE10, B.CLS_ATTRIBUTE_DATE11, B.CLS_ATTRIBUTE_DATE12, B.CLS_ATTRIBUTE_DATE13, B.CLS_ATTRIBUTE_DATE14, B.CLS_ATTRIBUTE_DATE15, TL.NAME, TL.DESCRIPTION FROM WLF_LM_CLASSES_B B, WLF_LM_CLASSES_TL TL WHERE B.CLASS_ID = TL.CLASS_ID AND TL.LANGUAGE = USERENV('lang')