eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: OTA.OTA_SCORM_SEQUENCING

Object Details

Object Name:	OTA_SCORM_SEQUENCING
Object Type:	TABLE
Owner:	OTA
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
OTA_SCORM_SEQUENCING_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	SCORM_SEQUENCING_ID

Columns

Name	Datatype	Length	Mandatory
SCORM_SEQUENCING_ID	NUMBER	(15)	Yes
CM_CHOICE	VARCHAR2	(1)
CM_CHOICE_EXIT	VARCHAR2	(1)
CM_FLOW	VARCHAR2	(1)
CM_FORWARD_ONLY	VARCHAR2	(1)
CM_USE_ATTEMPT_OBJECTIVE	VARCHAR2	(1)
CM_USE_ATTEMPT_PROGRESS	VARCHAR2	(1)
LC_ATTEMPT_LIMIT	NUMBER
LC_ATTEMPT_DURATION_LIMIT	NUMBER
ROLLUP_OBJECTIVE_SATISFIED	VARCHAR2	(1)
ROLLUP_PROGRESS_COMPLETION	VARCHAR2	(1)
ROLLUP_OBJ_MEASURE_WEIGHT	NUMBER	(7)
RANDOM_TIMING	VARCHAR2	(1)
RANDOM_SELECT_COUNT	NUMBER
RANDOM_REORDER_CHILDREN	VARCHAR2	(1)
RANDOM_SELECTION_TIMING	VARCHAR2	(1)
DELIVERY_TRACKED	VARCHAR2	(1)
DELIVERY_IS_COMPLETION_SET	VARCHAR2	(1)
DELIVERY_IS_OBJECTIVE_SET	VARCHAR2	(1)
PREVENT_ACTIVATION	VARCHAR2	(1)
CONSTRAIN_CHOICE	VARCHAR2	(1)
ROLLUP_REQD_FOR_SATISFIED	VARCHAR2	(1)
ROLLUP_REQD_FOR_NOT_SATISFIED	VARCHAR2	(1)
ROLLUP_REQD_FOR_COMPLETED	VARCHAR2	(1)
ROLLUP_REQD_FOR_INCOMPLETE	VARCHAR2	(1)
ROLLUP_MEASURE_SATIS_IF_ACTIV	VARCHAR2	(1)
NAV_HIDE_PREVIOUS	VARCHAR2	(1)
NAV_HIDE_CONTINUE	VARCHAR2	(1)
NAV_HIDE_EXIT	VARCHAR2	(1)
NAV_HIDE_EXIT_ALL	VARCHAR2	(1)
NAV_HIDE_ABANDON	VARCHAR2	(1)
NAV_HIDE_ABANDON_ALL	VARCHAR2	(1)
NAV_HIDE_SUSPEND_ALL	VARCHAR2	(1)
CREATED_BY	NUMBER	(15)
CREATION_DATE	DATE
LAST_UPDATED_BY	NUMBER	(15)
LAST_UPDATE_DATE	DATE
LAST_UPDATE_LOGIN	NUMBER	(15)
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes
IS_OBJECTIVES_GLOBAL_TO_SYSTEM	VARCHAR2	(1)
LEARNING_OBJECT_ID	NUMBER	(15)	Yes
IS_DATA_GLOBAL_TO_SYSTEM	VARCHAR2	(1)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SCORM_SEQUENCING_ID
,      CM_CHOICE
,      CM_CHOICE_EXIT
,      CM_FLOW
,      CM_FORWARD_ONLY
,      CM_USE_ATTEMPT_OBJECTIVE
,      CM_USE_ATTEMPT_PROGRESS
,      LC_ATTEMPT_LIMIT
,      LC_ATTEMPT_DURATION_LIMIT
,      ROLLUP_OBJECTIVE_SATISFIED
,      ROLLUP_PROGRESS_COMPLETION
,      ROLLUP_OBJ_MEASURE_WEIGHT
,      RANDOM_TIMING
,      RANDOM_SELECT_COUNT
,      RANDOM_REORDER_CHILDREN
,      RANDOM_SELECTION_TIMING
,      DELIVERY_TRACKED
,      DELIVERY_IS_COMPLETION_SET
,      DELIVERY_IS_OBJECTIVE_SET
,      PREVENT_ACTIVATION
,      CONSTRAIN_CHOICE
,      ROLLUP_REQD_FOR_SATISFIED
,      ROLLUP_REQD_FOR_NOT_SATISFIED
,      ROLLUP_REQD_FOR_COMPLETED
,      ROLLUP_REQD_FOR_INCOMPLETE
,      ROLLUP_MEASURE_SATIS_IF_ACTIV
,      NAV_HIDE_PREVIOUS
,      NAV_HIDE_CONTINUE
,      NAV_HIDE_EXIT
,      NAV_HIDE_EXIT_ALL
,      NAV_HIDE_ABANDON
,      NAV_HIDE_ABANDON_ALL
,      NAV_HIDE_SUSPEND_ALL
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      IS_OBJECTIVES_GLOBAL_TO_SYSTEM
,      LEARNING_OBJECT_ID
,      IS_DATA_GLOBAL_TO_SYSTEM
FROM OTA.OTA_SCORM_SEQUENCING;

Dependencies

[top of page]

OTA.OTA_SCORM_SEQUENCING does not reference any database object

OTA.OTA_SCORM_SEQUENCING is referenced by following:

OTA: OTA_SCORM_SEQUENCING#