1. Tables and Views for HCM
  2. WLF_LMC_CONTENT_OBJECTS_VL

WLF_LMC_CONTENT_OBJECTS_VL

Details

  • Schema: FUSION

  • Object owner: WLF

  • Object type: VIEW

Columns

Name

CONTENT_ID

NAME

DESCRIPTION

TRACKING_TYPE

EXTERNAL_IDENTIFIER

LANGUAGE_ID

AUTHOR

CATALOG

CATALOG_NUMBER

KEYWORDS

VERSION

PRICE

MONETARY_UNIT

IS_COPYRIGHTED

COPYRIGHT_TEXT

IS_CONTROLLED

CONTENT_SERVER_ID

INITIAL_FILE

CONTENT_DIRECTORY

STARTING_URL

MASTERY_SCORE

TEST_ID

LAUNCH_DATA

DURATION

LAST_UPDATE_METHOD

EXTERNAL_SRC

EXTRA_INFO

IS_NOTIFICATION

LAUNCH_OUTSIDE_PLAYER

IS_VISIBLE

USE_PLAYER_PREFERENCES

SHOW_TOOLBAR

TOOLBAR_BUTTONS

NEW_PLAYER_WINDOW

WINDOW_WIDTH

WINDOW_HEIGHT

TIME_LIMIT_ACTION

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

ENTERPRISE_ID

CLD_ATTRIBUTE_CATEGORY

CLD_ATTRIBUTE1

CLD_ATTRIBUTE2

CLD_ATTRIBUTE3

CLD_ATTRIBUTE4

CLD_ATTRIBUTE5

CLD_ATTRIBUTE6

CLD_ATTRIBUTE7

CLD_ATTRIBUTE8

CLD_ATTRIBUTE9

CLD_ATTRIBUTE10

CLD_ATTRIBUTE11

CLD_ATTRIBUTE12

CLD_ATTRIBUTE13

CLD_ATTRIBUTE14

CLD_ATTRIBUTE15

CLD_ATTRIBUTE16

CLD_ATTRIBUTE17

CLD_ATTRIBUTE18

CLD_ATTRIBUTE19

CLD_ATTRIBUTE20

CLD_ATTRIBUTE21

CLD_ATTRIBUTE22

CLD_ATTRIBUTE23

CLD_ATTRIBUTE24

CLD_ATTRIBUTE25

CLD_ATTRIBUTE26

CLD_ATTRIBUTE27

CLD_ATTRIBUTE28

CLD_ATTRIBUTE29

CLD_ATTRIBUTE30

CLD_ATTRIBUTE_NUMBER1

CLD_ATTRIBUTE_NUMBER2

CLD_ATTRIBUTE_NUMBER3

CLD_ATTRIBUTE_NUMBER4

CLD_ATTRIBUTE_NUMBER5

CLD_ATTRIBUTE_NUMBER6

CLD_ATTRIBUTE_NUMBER7

CLD_ATTRIBUTE_NUMBER8

CLD_ATTRIBUTE_NUMBER9

CLD_ATTRIBUTE_NUMBER10

CLD_ATTRIBUTE_NUMBER11

CLD_ATTRIBUTE_NUMBER12

CLD_ATTRIBUTE_NUMBER13

CLD_ATTRIBUTE_NUMBER14

CLD_ATTRIBUTE_NUMBER15

CLD_ATTRIBUTE_NUMBER16

CLD_ATTRIBUTE_NUMBER17

CLD_ATTRIBUTE_NUMBER18

CLD_ATTRIBUTE_NUMBER19

CLD_ATTRIBUTE_NUMBER20

CLD_ATTRIBUTE_DATE1

CLD_ATTRIBUTE_DATE2

CLD_ATTRIBUTE_DATE3

CLD_ATTRIBUTE_DATE4

CLD_ATTRIBUTE_DATE5

CLD_ATTRIBUTE_DATE6

CLD_ATTRIBUTE_DATE7

CLD_ATTRIBUTE_DATE8

CLD_ATTRIBUTE_DATE9

CLD_ATTRIBUTE_DATE10

CLD_ATTRIBUTE_DATE11

CLD_ATTRIBUTE_DATE12

CLD_ATTRIBUTE_DATE13

CLD_ATTRIBUTE_DATE14

CLD_ATTRIBUTE_DATE15

Query

SQL_Statement

select

R.CONTENT_ID,

C.name,

C.description,

R.TRACKING_TYPE,

R.EXTERNAL_IDENTIFIER,

R.LANGUAGE_ID,

R.AUTHOR,

R.CATALOG,

R.CATALOG_NUMBER,

R.KEYWORDS,

R.VERSION,

R.PRICE,

R.MONETARY_UNIT,

R.IS_COPYRIGHTED,

R.COPYRIGHT_TEXT,

R.IS_CONTROLLED,

R.CONTENT_SERVER_ID,

R.INITIAL_FILE,

R.CONTENT_DIRECTORY,

R.STARTING_URL,

R.MASTERY_SCORE,

R.TEST_ID,

R.LAUNCH_DATA,

R.DURATION,

R.LAST_UPDATE_METHOD,

R.EXTERNAL_SRC,

R.EXTRA_INFO,

R.IS_NOTIFICATION,

R.LAUNCH_OUTSIDE_PLAYER,

R.IS_VISIBLE,

R.USE_PLAYER_PREFERENCES,

R.SHOW_TOOLBAR,

R.TOOLBAR_BUTTONS,

R.NEW_PLAYER_WINDOW,

R.WINDOW_WIDTH,

R.WINDOW_HEIGHT,

R.TIME_LIMIT_ACTION,

R.CREATED_BY,

R.CREATION_DATE,

R.LAST_UPDATED_BY,

R.LAST_UPDATE_DATE,

R.LAST_UPDATE_LOGIN,

R.OBJECT_VERSION_NUMBER,

R.ENTERPRISE_ID,

R.CLD_ATTRIBUTE_CATEGORY,

R.CLD_ATTRIBUTE1,

R.CLD_ATTRIBUTE2,

R.CLD_ATTRIBUTE3,

R.CLD_ATTRIBUTE4,

R.CLD_ATTRIBUTE5,

R.CLD_ATTRIBUTE6,

R.CLD_ATTRIBUTE7,

R.CLD_ATTRIBUTE8,

R.CLD_ATTRIBUTE9,

R.CLD_ATTRIBUTE10,

R.CLD_ATTRIBUTE11,

R.CLD_ATTRIBUTE12,

R.CLD_ATTRIBUTE13,

R.CLD_ATTRIBUTE14,

R.CLD_ATTRIBUTE15,

R.CLD_ATTRIBUTE16,

R.CLD_ATTRIBUTE17,

R.CLD_ATTRIBUTE18,

R.CLD_ATTRIBUTE19,

R.CLD_ATTRIBUTE20,

R.CLD_ATTRIBUTE21,

R.CLD_ATTRIBUTE22,

R.CLD_ATTRIBUTE23,

R.CLD_ATTRIBUTE24,

R.CLD_ATTRIBUTE25,

R.CLD_ATTRIBUTE26,

R.CLD_ATTRIBUTE27,

R.CLD_ATTRIBUTE28,

R.CLD_ATTRIBUTE29,

R.CLD_ATTRIBUTE30,

R.CLD_ATTRIBUTE_NUMBER1,

R.CLD_ATTRIBUTE_NUMBER2,

R.CLD_ATTRIBUTE_NUMBER3,

R.CLD_ATTRIBUTE_NUMBER4,

R.CLD_ATTRIBUTE_NUMBER5,

R.CLD_ATTRIBUTE_NUMBER6,

R.CLD_ATTRIBUTE_NUMBER7,

R.CLD_ATTRIBUTE_NUMBER8,

R.CLD_ATTRIBUTE_NUMBER9,

R.CLD_ATTRIBUTE_NUMBER10,

R.CLD_ATTRIBUTE_NUMBER11,

R.CLD_ATTRIBUTE_NUMBER12,

R.CLD_ATTRIBUTE_NUMBER13,

R.CLD_ATTRIBUTE_NUMBER14,

R.CLD_ATTRIBUTE_NUMBER15,

R.CLD_ATTRIBUTE_NUMBER16,

R.CLD_ATTRIBUTE_NUMBER17,

R.CLD_ATTRIBUTE_NUMBER18,

R.CLD_ATTRIBUTE_NUMBER19,

R.CLD_ATTRIBUTE_NUMBER20,

R.CLD_ATTRIBUTE_DATE1,

R.CLD_ATTRIBUTE_DATE2,

R.CLD_ATTRIBUTE_DATE3,

R.CLD_ATTRIBUTE_DATE4,

R.CLD_ATTRIBUTE_DATE5,

R.CLD_ATTRIBUTE_DATE6,

R.CLD_ATTRIBUTE_DATE7,

R.CLD_ATTRIBUTE_DATE8,

R.CLD_ATTRIBUTE_DATE9,

R.CLD_ATTRIBUTE_DATE10,

R.CLD_ATTRIBUTE_DATE11,

R.CLD_ATTRIBUTE_DATE12,

R.CLD_ATTRIBUTE_DATE13,

R.CLD_ATTRIBUTE_DATE14,

R.CLD_ATTRIBUTE_DATE15

from wlf_cm_contents_vl C, wlf_lmc_content_details R

where C.content_id = R.content_id

and C.status = 'ACTIVE'