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

VIEW: APPS.OTA_ACTIVITY_VERSIONS_VL

Object Details
Object Name: OTA_ACTIVITY_VERSIONS_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOTA.OTA_ACTIVITY_VERSIONS_VL
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
ACTIVITY_VERSION_ID NUMBER (9) Yes System generated surrogate key for each distinct module version.
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) Yes The name associated with this version of the module.
ACTUAL_COST NUMBER

The Actual Cost of the version in the Budgetted Currency.
BUDGET_COST NUMBER

The Budgetted cost of the version.
BUDGET_CURRENCY_CODE VARCHAR2 (30)
The Currency of the Nedgetted Cost.
COMMENTS VARCHAR2 (2000)
Comments.
DESCRIPTION VARCHAR2 (4000)
Free text description for this version.
DURATION NUMBER (9)
The estimated length of the module in dates (99..99)
DURATION_UNITS VARCHAR2 (30)
The units for the duration.
END_DATE DATE

The last date on which this version 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 version is defined in.
ACTIVITY_ID NUMBER (9) Yes Foreign key to OTA_ACTIVITY_VERSIONS.
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 Activity Version.
PROFESSIONAL_CREDIT_TYPE VARCHAR2 (30)
The type of professional credit provided.
PROFESSIONAL_CREDITS NUMBER

The number of Professional Credits the TAV provides.
START_DATE DATE

The date on which this version 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

iLearning Content Object unique identifier
VERSION_CODE VARCHAR2 (30)
Course Code.
BUSINESS_GROUP_ID NUMBER (15)
Foreign key to HR_ALL_ORGANIZATIONS.
DATA_SOURCE VARCHAR2 (30)
KEYWORDS VARCHAR2 (2000)
COMPETENCY_UPDATE_LEVEL VARCHAR2 (30)
ERES_ENABLED VARCHAR2 (1)
Query Text

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


SELECT ROW_ID
,      ACTIVITY_VERSION_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
,      ACTIVITY_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
,      KEYWORDS
,      COMPETENCY_UPDATE_LEVEL
,      ERES_ENABLED
FROM APPS.OTA_ACTIVITY_VERSIONS_VL;

Dependencies

[top of page]

APPS.OTA_ACTIVITY_VERSIONS_VL references the following:

SchemaAPPS
SynonymOTA_ACTIVITY_VERSIONS
SynonymOTA_ACTIVITY_VERSIONS_TL
APPS.OTA_ACTIVITY_VERSIONS_VL is referenced by following:

SchemaAPPS
Package BodyOTA_CLASSIC_UPGRADE - show dependent code
Package BodyOTA_CPE_UTIL - show dependent code
Package BodyOTA_ILEARNING - show dependent code
Package BodyOTA_TAV_API_BUSINESS_RULES - show dependent code
Package BodyOTA_TRAINING_RECORD - show dependent code
PL/SQL PackageOTA_TRAINING_RECORD - show dependent code
Package BodyPQP_RIW_COURSE_WRAPPER - show dependent code