VIEW: OTA.OTA_LEARNING_OBJECTS#

Source

View Text - Preformatted

select LEARNING_OBJECT_ID LEARNING_OBJECT_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, NAME NAME, FOLDER_ID FOLDER_ID, SOURCE_LEARNING_OBJECT_ID SOURCE_LEARNING_OBJECT_ID, PARENT_LEARNING_OBJECT_ID PARENT_LEARNING_OBJECT_ID, START_DATE_ACTIVE START_DATE_ACTIVE, END_DATE_ACTIVE END_DATE_ACTIVE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, DESCRIPTION DESCRIPTION, LANGUAGE_ID LANGUAGE_ID, PUBLISHED_FLAG PUBLISHED_FLAG, CHILD_SEQ CHILD_SEQ, TRACKING_TYPE TRACKING_TYPE, IDENTIFIER IDENTIFIER, AUTHOR AUTHOR, CATALOG CATALOG, CATALOG_NUMBER CATALOG_NUMBER, KEYWORDS KEYWORDS, OBJECTIVES OBJECTIVES, AUDIENCE AUDIENCE, DURATION DURATION, VERSION VERSION, COPYRIGHTED_FLAG COPYRIGHTED_FLAG, COPYRIGHT_TEXT COPYRIGHT_TEXT, SECURED_FLAG SECURED_FLAG, STARTING_URL STARTING_URL, MASTERY_SCORE MASTERY_SCORE, MIME_TYPE MIME_TYPE, REQUIRED_HARDWARE_SOFTWARE REQUIRED_HARDWARE_SOFTWARE, TEST_ID TEST_ID, LAUNCH_DATA LAUNCH_DATA, EXTERNAL_IDENTIFIER EXTERNAL_IDENTIFIER, EXTERNAL_SOURCE EXTERNAL_SOURCE, DATA_SOURCE DATA_SOURCE, CONTENT_SERVER_ID CONTENT_SERVER_ID, CONTENT_DIRECTORY CONTENT_DIRECTORY, INITIAL_FILE INITIAL_FILE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, MEETING_ID MEETING_ID, CONFERENCE_SERVER_ID CONFERENCE_SERVER_ID, PLAYER_TIMEOUT_MINUTES PLAYER_TIMEOUT_MINUTES, LAUNCH_DATA2 LAUNCH_DATA2, LAUNCH_OUTSIDE_PLAYER LAUNCH_OUTSIDE_PLAYER, LANGUAGE_CODE LANGUAGE_CODE, TIME_LIMIT_ACTION TIME_LIMIT_ACTION, ROLLUP_PROGRESS_WEIGHT ROLLUP_PROGRESS_WEIGHT, IS_VISIBLE IS_VISIBLE from "OTA"."OTA_LEARNING_OBJECTS"

View Text - HTML Formatted

SELECT LEARNING_OBJECT_ID LEARNING_OBJECT_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, NAME NAME
, FOLDER_ID FOLDER_ID
, SOURCE_LEARNING_OBJECT_ID SOURCE_LEARNING_OBJECT_ID
, PARENT_LEARNING_OBJECT_ID PARENT_LEARNING_OBJECT_ID
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, DESCRIPTION DESCRIPTION
, LANGUAGE_ID LANGUAGE_ID
, PUBLISHED_FLAG PUBLISHED_FLAG
, CHILD_SEQ CHILD_SEQ
, TRACKING_TYPE TRACKING_TYPE
, IDENTIFIER IDENTIFIER
, AUTHOR AUTHOR
, CATALOG CATALOG
, CATALOG_NUMBER CATALOG_NUMBER
, KEYWORDS KEYWORDS
, OBJECTIVES OBJECTIVES
, AUDIENCE AUDIENCE
, DURATION DURATION
, VERSION VERSION
, COPYRIGHTED_FLAG COPYRIGHTED_FLAG
, COPYRIGHT_TEXT COPYRIGHT_TEXT
, SECURED_FLAG SECURED_FLAG
, STARTING_URL STARTING_URL
, MASTERY_SCORE MASTERY_SCORE
, MIME_TYPE MIME_TYPE
, REQUIRED_HARDWARE_SOFTWARE REQUIRED_HARDWARE_SOFTWARE
, TEST_ID TEST_ID
, LAUNCH_DATA LAUNCH_DATA
, EXTERNAL_IDENTIFIER EXTERNAL_IDENTIFIER
, EXTERNAL_SOURCE EXTERNAL_SOURCE
, DATA_SOURCE DATA_SOURCE
, CONTENT_SERVER_ID CONTENT_SERVER_ID
, CONTENT_DIRECTORY CONTENT_DIRECTORY
, INITIAL_FILE INITIAL_FILE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, MEETING_ID MEETING_ID
, CONFERENCE_SERVER_ID CONFERENCE_SERVER_ID
, PLAYER_TIMEOUT_MINUTES PLAYER_TIMEOUT_MINUTES
, LAUNCH_DATA2 LAUNCH_DATA2
, LAUNCH_OUTSIDE_PLAYER LAUNCH_OUTSIDE_PLAYER
, LANGUAGE_CODE LANGUAGE_CODE
, TIME_LIMIT_ACTION TIME_LIMIT_ACTION
, ROLLUP_PROGRESS_WEIGHT ROLLUP_PROGRESS_WEIGHT
, IS_VISIBLE IS_VISIBLE
FROM "OTA"."OTA_LEARNING_OBJECTS"