Skip to content

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

VIEW: OTA.OTA_ACTIVITY_VERSIONS#

Object Details
Object Name: OTA_ACTIVITY_VERSIONS#
Object Type: VIEW
Owner: OTA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ACTIVITY_VERSION_ID NUMBER (9) Yes
ACTIVITY_ID NUMBER (9) Yes
SUPERSEDED_BY_ACT_VERSION_ID NUMBER (9)
DEVELOPER_ORGANIZATION_ID NUMBER (9) Yes
CONTROLLING_PERSON_ID NUMBER (10)
VENDOR_ID NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER (5) Yes
VERSION_NAME VARCHAR2 (80)
ACTUAL_COST NUMBER

BUDGET_COST NUMBER

BUDGET_CURRENCY_CODE VARCHAR2 (30)
COMMENTS VARCHAR2 (2000)
DESCRIPTION VARCHAR2 (4000)
DURATION NUMBER (9)
DURATION_UNITS VARCHAR2 (30)
END_DATE DATE

EXPENSES_ALLOWED VARCHAR2 (30)
INTENDED_AUDIENCE VARCHAR2 (4000)
LANGUAGE_ID NUMBER (9)
MAXIMUM_ATTENDEES NUMBER (9)
MAXIMUM_INTERNAL_ATTENDEES NUMBER (9)
MINIMUM_ATTENDEES NUMBER (9)
OBJECTIVES VARCHAR2 (4000)
PROFESSIONAL_CREDIT_TYPE VARCHAR2 (30)
PROFESSIONAL_CREDITS NUMBER

START_DATE DATE

SUCCESS_CRITERIA VARCHAR2 (30)
USER_STATUS VARCHAR2 (30)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

TAV_INFORMATION_CATEGORY VARCHAR2 (30)
TAV_INFORMATION1 VARCHAR2 (150)
TAV_INFORMATION2 VARCHAR2 (150)
TAV_INFORMATION3 VARCHAR2 (150)
TAV_INFORMATION4 VARCHAR2 (150)
TAV_INFORMATION5 VARCHAR2 (150)
TAV_INFORMATION6 VARCHAR2 (150)
TAV_INFORMATION7 VARCHAR2 (150)
TAV_INFORMATION8 VARCHAR2 (150)
TAV_INFORMATION9 VARCHAR2 (150)
TAV_INFORMATION10 VARCHAR2 (150)
TAV_INFORMATION11 VARCHAR2 (150)
TAV_INFORMATION12 VARCHAR2 (150)
TAV_INFORMATION13 VARCHAR2 (150)
TAV_INFORMATION14 VARCHAR2 (150)
TAV_INFORMATION15 VARCHAR2 (150)
TAV_INFORMATION16 VARCHAR2 (150)
TAV_INFORMATION17 VARCHAR2 (150)
TAV_INFORMATION18 VARCHAR2 (150)
TAV_INFORMATION19 VARCHAR2 (150)
TAV_INFORMATION20 VARCHAR2 (150)
INVENTORY_ITEM_ID NUMBER (10)
ORGANIZATION_ID NUMBER (15)
RCO_ID NUMBER

VERSION_CODE VARCHAR2 (30)
BUSINESS_GROUP_ID NUMBER (15)
DATA_SOURCE VARCHAR2 (30)
COMPETENCY_UPDATE_LEVEL VARCHAR2 (30)
ERES_ENABLED VARCHAR2 (1)
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
,      ERES_ENABLED
FROM OTA.OTA_ACTIVITY_VERSIONS#;

Dependencies

[top of page]

OTA.OTA_ACTIVITY_VERSIONS# references the following:

SchemaOTA
TableOTA_ACTIVITY_VERSIONS
OTA.OTA_ACTIVITY_VERSIONS# is referenced by following:

SchemaAPPS
SynonymOTA_ACTIVITY_VERSIONS
TriggerOTA_ACTIVITY_VERSIONS_WHO