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

TABLE: OTA.OTA_PREREQUISITES

Object Details
Object Name: OTA_PREREQUISITES
Object Type: TABLE
Owner: OTA
FND Design Data: TableOTA.OTA_PREREQUISITES
Subobject Name:
Status: VALID


These are known as "Player Prerequisites".
They are defined against a target learning object, and define what other learning objects or tests must be completed before the target learning object can be played by a learner.
If the learner has not met the prerequisites, then the target learning object cannot be played by the learner until the prerequisites have been completed.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Unique Key: OTA_PREREQUISITES_UK1
  1. ColumnOBJECT_ID
  2. ColumnPARENT_OBJECT_ID
  3. ColumnPARENT_TYPE
Indexes
Index Type Uniqueness Tablespace Column
OTA_PREREQUISITES_UK1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnOBJECT_ID
ColumnPARENT_OBJECT_ID
ColumnPARENT_TYPE
Columns
Name Datatype Length Mandatory Comments
OBJECT_ID NUMBER (15)
Determine which object that need pre-requisites
PARENT_OBJECT_ID NUMBER (15) Yes Determine which object is the object pre-requisites from.
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ALL_ORGANIZATION_UNITS
ENFORCED_FLAG VARCHAR2 (1) Yes Determine whether pre-requisites is enforced.
PARENT_TYPE VARCHAR2 (30)
Determin type of the object in which the object pre-requisite from.
OBJECT_VERSION_NUMBER NUMBER (9) Yes Version control parameter
CREATED_BY NUMBER (15)
Standard Who Column
LAST_UPDATE_DATE DATE

Standard Who Column
CREATION_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER (15)
Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
Query Text

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


SELECT OBJECT_ID
,      PARENT_OBJECT_ID
,      BUSINESS_GROUP_ID
,      ENFORCED_FLAG
,      PARENT_TYPE
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM OTA.OTA_PREREQUISITES;

Dependencies

[top of page]

OTA.OTA_PREREQUISITES does not reference any database object

OTA.OTA_PREREQUISITES is referenced by following:

SchemaOTA
ViewOTA_PREREQUISITES#