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_ACTIVITY_VERSIONS

Object Details

Object Name:	OTA_ACTIVITY_VERSIONS
Object Type:	TABLE
Owner:	OTA
FND Design Data:	OTA.OTA_ACTIVITY_VERSIONS
Subobject Name:
Status:	VALID

This contains metadata of courses, such as objectives, intended
audience , numbers of students that may attend any class based on the
course, and actual and budgeted costs.
A Course may be superseded by another version or it may
supersede one itself. The validity dates on the course is
available for scheduling as a class.
A course may belong to one or more categories.
A course can therefore be classified for searching
elsewhere in the system, it can be identified as being part of a
program of courses, or it can be identified as part of a package of
course that are to have price discounts applied.
A course can also be part of a learning path.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: OTA_ACTIVITY_VERSIONS_PK

ACTIVITY_VERSION_ID

Unique Key: OTA_ACTIVITY_VERSIONS_UK5

RCO_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
OTA_ACTIVITY_VERSIONS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ACTIVITY_VERSION_ID
OTA_ACTIVITY_VERSIONS_UK5	NORMAL	UNIQUE	APPS_TS_TX_IDX	RCO_ID
OTA_ACTIVITY_VERSIONS_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACTIVITY_ID
OTA_ACTIVITY_VERSIONS_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUPERSEDED_BY_ACT_VERSION_ID
OTA_ACTIVITY_VERSIONS_FK3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DEVELOPER_ORGANIZATION_ID
OTA_ACTIVITY_VERSIONS_FK4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUSINESS_GROUP_ID
OTA_ACTIVITY_VERSIONS_N50	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONTROLLING_PERSON_ID
OTA_ACTIVITY_VERSIONS_N51	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VENDOR_ID
OTA_ACTIVITY_VERSIONS_N56	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VERSION_CODE
OTA_ACTIVITY_VERSION_N53	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VERSION_NAME

Foreign Keys

Table	Foreign Table	Foreign Key Column
OTA_ACTIVITY_VERSIONS	OTA_ACTIVITY_DEFINITIONS	OTA_ACTIVITY_VERSIONS ACTIVITY_ID
OTA_ACT_CAT_INCLUSIONS	OTA_ACTIVITY_VERSIONS	OTA_ACT_CAT_INCLUSIONS ACTIVITY_VERSION_ID
OTA_BOOKING_DEALS	OTA_ACTIVITY_VERSIONS	OTA_BOOKING_DEALS ACTIVITY_VERSION_ID
OTA_EVENTS	OTA_ACTIVITY_VERSIONS	OTA_EVENTS ACTIVITY_VERSION_ID
OTA_NOTRNG_HISTORIES	OTA_ACTIVITY_VERSIONS	OTA_NOTRNG_HISTORIES ACTIVITY_VERSION_ID
OTA_PRICE_LIST_ENTRIES	OTA_ACTIVITY_VERSIONS	OTA_PRICE_LIST_ENTRIES ACTIVITY_VERSION_ID
OTA_SKILL_PROVISIONS	OTA_ACTIVITY_VERSIONS	OTA_SKILL_PROVISIONS ACTIVITY_VERSION_ID
OTA_TRAINING_PLAN_MEMBERS	OTA_ACTIVITY_VERSIONS	OTA_TRAINING_PLAN_MEMBERS ACTIVITY_VERSION_ID
OTA_VENDOR_SUPPLIES	OTA_ACTIVITY_VERSIONS	OTA_VENDOR_SUPPLIES ACTIVITY_VERSION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ACTIVITY_VERSION_ID	NUMBER	(9)	Yes	System generated surrogate key for each distinct module version.
ACTIVITY_ID	NUMBER	(9)	Yes	Foreign key to OTA_ACTIVITY_VERSIONS.
SUPERSEDED_BY_ACT_VERSION_ID	NUMBER	(9)		Foreign key to OTA_ACTIVITY_VERSIONS.
DEVELOPER_ORGANIZATION_ID	NUMBER	(9)	Yes	Foreign key to HR_ALL_ORGANIZATION_UNITS.
CONTROLLING_PERSON_ID	NUMBER	(10)		Foreign key to PER_ALL_PEOPLE_F.
VENDOR_ID	NUMBER	(15)		Foreign key to PO_VENDORS.
OBJECT_VERSION_NUMBER	NUMBER	(5)	Yes	Version control parameter.
VERSION_NAME	VARCHAR2	(80)		The name associated with this course of the module.
ACTUAL_COST	NUMBER			The Actual Cost of the course in the Budgetted Currency.
BUDGET_COST	NUMBER			The Budgetted cost of the course.
BUDGET_CURRENCY_CODE	VARCHAR2	(30)		The Currency of the Nedgetted Cost.
COMMENTS	VARCHAR2	(2000)		Comments.
DESCRIPTION	VARCHAR2	(4000)		Free text description for this course.
DURATION	NUMBER	(9)		The estimated length of the module.
DURATION_UNITS	VARCHAR2	(30)		The units for the duration.
END_DATE	DATE			The last date on which this course is valid to be scheduled.
EXPENSES_ALLOWED	VARCHAR2	(30)		Whether expenses are allowed.
INTENDED_AUDIENCE	VARCHAR2	(4000)		The intended audience.
LANGUAGE_ID	NUMBER	(9)		The language this course is defined in.
MAXIMUM_ATTENDEES	NUMBER	(9)		The maximum number of delgates allowed to attend.
MAXIMUM_INTERNAL_ATTENDEES	NUMBER	(9)		The maximum number of internal delegates allowed to attend.
MINIMUM_ATTENDEES	NUMBER	(9)		The minimum number of delegates required for this module.
OBJECTIVES	VARCHAR2	(4000)		The objectives of the course.
PROFESSIONAL_CREDIT_TYPE	VARCHAR2	(30)		The type of professional credit provided.
PROFESSIONAL_CREDITS	NUMBER			The number of Professional Credits the course provides.
START_DATE	DATE			The date on which this course becomes valid to schedule.
SUCCESS_CRITERIA	VARCHAR2	(30)		The user defined success criteria for a module.
USER_STATUS	VARCHAR2	(30)		The user defined status of a module version.
LAST_UPDATE_DATE	DATE			Standard Who Column.
LAST_UPDATED_BY	NUMBER	(15)		Standard Who Column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column.
CREATED_BY	NUMBER	(15)		Standard Who Column.
CREATION_DATE	DATE			Standard Who Column.
TAV_INFORMATION_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure defining column.
TAV_INFORMATION1	VARCHAR2	(150)		Descriptive flexfield segment column.
TAV_INFORMATION2	VARCHAR2	(150)		Descriptive flexfield segment column.
TAV_INFORMATION3	VARCHAR2	(150)		Descriptive flexfield segment column.
TAV_INFORMATION4	VARCHAR2	(150)		Descriptive flexfield segment column.
TAV_INFORMATION5	VARCHAR2	(150)		Descriptive flexfield segment column.
TAV_INFORMATION6	VARCHAR2	(150)		Descriptive flexfield segment column.
TAV_INFORMATION7	VARCHAR2	(150)		Descriptive flexfield segment column.
TAV_INFORMATION8	VARCHAR2	(150)		Descriptive flexfield segment column.
TAV_INFORMATION9	VARCHAR2	(150)		Descriptive flexfield segment column.
TAV_INFORMATION10	VARCHAR2	(150)		Descriptive flexfield segment column.
TAV_INFORMATION11	VARCHAR2	(150)		Descriptive flexfield segment column.
TAV_INFORMATION12	VARCHAR2	(150)		Descriptive flexfield segment column.
TAV_INFORMATION13	VARCHAR2	(150)		Descriptive flexfield segment column.
TAV_INFORMATION14	VARCHAR2	(150)		Descriptive flexfield segment column.
TAV_INFORMATION15	VARCHAR2	(150)		Descriptive flexfield segment column.
TAV_INFORMATION16	VARCHAR2	(150)		Descriptive flexfield segment column.
TAV_INFORMATION17	VARCHAR2	(150)		Descriptive flexfield segment column.
TAV_INFORMATION18	VARCHAR2	(150)		Descriptive flexfield segment column.
TAV_INFORMATION19	VARCHAR2	(150)		Descriptive flexfield segment column.
TAV_INFORMATION20	VARCHAR2	(150)		Descriptive flexfield segment column.
INVENTORY_ITEM_ID	NUMBER	(10)		Foreign key to MTL_SYSTEM_ITEMS_B.
ORGANIZATION_ID	NUMBER	(15)		Inventory Organization
RCO_ID	NUMBER			Obsolete
VERSION_CODE	VARCHAR2	(30)		Course Code.
BUSINESS_GROUP_ID	NUMBER	(15)		Foreign key to HR_ALL_ORGANIZATIONS_UNITS.
DATA_SOURCE	VARCHAR2	(30)		The module that course originated in.
COMPETENCY_UPDATE_LEVEL	VARCHAR2	(30)		Determine the procedure of updating competencies when learner complete the Course

Query Text

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


SELECT ACTIVITY_VERSION_ID
,      ACTIVITY_ID
,      SUPERSEDED_BY_ACT_VERSION_ID
,      DEVELOPER_ORGANIZATION_ID
,      CONTROLLING_PERSON_ID
,      VENDOR_ID
,      OBJECT_VERSION_NUMBER
,      VERSION_NAME
,      ACTUAL_COST
,      BUDGET_COST
,      BUDGET_CURRENCY_CODE
,      COMMENTS
,      DESCRIPTION
,      DURATION
,      DURATION_UNITS
,      END_DATE
,      EXPENSES_ALLOWED
,      INTENDED_AUDIENCE
,      LANGUAGE_ID
,      MAXIMUM_ATTENDEES
,      MAXIMUM_INTERNAL_ATTENDEES
,      MINIMUM_ATTENDEES
,      OBJECTIVES
,      PROFESSIONAL_CREDIT_TYPE
,      PROFESSIONAL_CREDITS
,      START_DATE
,      SUCCESS_CRITERIA
,      USER_STATUS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      TAV_INFORMATION_CATEGORY
,      TAV_INFORMATION1
,      TAV_INFORMATION2
,      TAV_INFORMATION3
,      TAV_INFORMATION4
,      TAV_INFORMATION5
,      TAV_INFORMATION6
,      TAV_INFORMATION7
,      TAV_INFORMATION8
,      TAV_INFORMATION9
,      TAV_INFORMATION10
,      TAV_INFORMATION11
,      TAV_INFORMATION12
,      TAV_INFORMATION13
,      TAV_INFORMATION14
,      TAV_INFORMATION15
,      TAV_INFORMATION16
,      TAV_INFORMATION17
,      TAV_INFORMATION18
,      TAV_INFORMATION19
,      TAV_INFORMATION20
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      RCO_ID
,      VERSION_CODE
,      BUSINESS_GROUP_ID
,      DATA_SOURCE
,      COMPETENCY_UPDATE_LEVEL
FROM OTA.OTA_ACTIVITY_VERSIONS;

Dependencies

[top of page]

OTA.OTA_ACTIVITY_VERSIONS does not reference any database object

OTA.OTA_ACTIVITY_VERSIONS is referenced by following:

APPS: OTA_ACTIVITY_VERSIONS; OTA_ACTIVITY_VERSIONS_WHO