1. Tables and Views for HCM
  2. WLF_LI_CONTENT_F_VL

WLF_LI_CONTENT_F_VL

Details

  • Schema: FUSION

  • Object owner: WLF

  • Object type: VIEW

Columns

Name

CONTENT_ID

LEARNING_ITEM_ID

NAME

DESCRIPTION

DESCRIPTION_LONG

LANGUAGE_ID

DURATION

DURATION_UOM

STATUS

START_DATE

END_DATE

TRACKING_TYPE

AUTHOR

KEYWORDS

VERSION

PRICE

CURRENCY

IS_COPYRIGHTED

COPYRIGHT_TEXT

IS_VISIBLE

STARTING_URL

MASTERY_SCORE

LAUNCH_DATA

LAST_UPDATE_METHOD

EXTERNAL_IDENTIFIER

CATALOG

CATALOG_NUMBER

TIME_LIMIT_ACTION

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

ENTERPRISE_ID

OBJECT_VERSION_NUMBER

Query

SQL_Statement

SELECT

R.CONTENT_ID,

R.LEARNING_ITEM_ID,

C.NAME,

C.DESCRIPTION,

C.DESCRIPTION_LONG,

C.LANGUAGE_ID,

C.DURATION,

C.DURATION_UOM,

C.STATUS,

C.START_DATE,

C.END_DATE,

R.TRACKING_TYPE,

R.AUTHOR,

R.KEYWORDS,

R.VERSION,

R.PRICE,

R.CURRENCY,

R.IS_COPYRIGHTED,

R.COPYRIGHT_TEXT,

R.IS_VISIBLE,

R.STARTING_URL,

R.MASTERY_SCORE,

R.LAUNCH_DATA,

R.LAST_UPDATE_METHOD,

R.EXTERNAL_IDENTIFIER,

R.CATALOG,

R.CATALOG_NUMBER,

R.TIME_LIMIT_ACTION,

R.CREATED_BY,

R.CREATION_DATE,

R.LAST_UPDATED_BY,

R.LAST_UPDATE_DATE,

R.LAST_UPDATE_LOGIN,

R.ENTERPRISE_ID,

R.OBJECT_VERSION_NUMBER

FROM WLF_LEARNING_ITEMS_F_VL C, WLF_LI_CONTENT_F R

WHERE C.LEARNING_ITEM_ID = R.LEARNING_ITEM_ID

AND C.STATUS = 'ACTIVE'