[Home] [Help] [Dependency Information]
Object Name: | OTV_SCHEDULED_EVENTS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OTA.OTV_SCHEDULED_EVENTS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTIVITY_NAME | VARCHAR2 | (80) | ||
EVENT_TITLE | VARCHAR2 | (80) | Yes | |
COURSE_START_DATE | DATE | |||
COURSE_END_DATE | DATE | |||
COURSE_START_TIME | VARCHAR2 | (5) | ||
COURSE_END_TIME | VARCHAR2 | (5) | ||
DURATION | NUMBER | |||
DURATION_UNITS | VARCHAR2 | (4000) | ||
AVAILABLE_PLACES | NUMBER | |||
CENTRE | VARCHAR2 | (4000) | ||
CENTRE_LOOKUP_CODE | VARCHAR2 | (30) | ||
VENDOR_NAME | VARCHAR2 | (240) | ||
ENROLMENT_START_DATE | DATE | |||
ENROLMENT_END_DATE | DATE | |||
EVENT_TYPE | VARCHAR2 | (4000) | ||
LANGUAGE | VARCHAR2 | (4000) | ||
EVENT_STATUS | VARCHAR2 | (4000) | ||
USER_STATUS | VARCHAR2 | (4000) | ||
MINIMUM_ATTENDEES | NUMBER | (9) | ||
MAXIMUM_ATTENDEES | NUMBER | (9) | ||
STANDARD_PRICE | NUMBER | |||
CURRENCY_CODE | VARCHAR2 | (80) | ||
SECURE_EVENT_FLAG | VARCHAR2 | (30) | ||
RESTRICTIONS_APPLY | VARCHAR2 | (4000) | ||
ACTIVITY_VERSION_ID | NUMBER | (9) | Yes | |
EVENT_ID | NUMBER | (9) | Yes | |
BOOK_INDEPENDENT_FLAG_CODE | VARCHAR2 | (30) | ||
EVENT_FULL_FLAG | VARCHAR2 | (4000) | ||
EVENT_TENTATIVE_FLAG | VARCHAR2 | (4000) | ||
BUSINESS_GROUP_ID | NUMBER | (9) | Yes | |
BUSINESS_GROUP_NAME | VARCHAR2 | (240) | Yes | |
TRAINING_CENTER_ID | NUMBER | (15) | Foriegn key to HR_ALL_ORGANIZATION_UNITS. | |
LOCATION_ID | NUMBER | (15) | Foriegn key to HR_LOCATIONS. | |
LANGUAGE_ID | NUMBER | (9) |
Cut, paste (and edit) the following text to query this object:
SELECT ACTIVITY_NAME
, EVENT_TITLE
, COURSE_START_DATE
, COURSE_END_DATE
, COURSE_START_TIME
, COURSE_END_TIME
, DURATION
, DURATION_UNITS
, AVAILABLE_PLACES
, CENTRE
, CENTRE_LOOKUP_CODE
, VENDOR_NAME
, ENROLMENT_START_DATE
, ENROLMENT_END_DATE
, EVENT_TYPE
, LANGUAGE
, EVENT_STATUS
, USER_STATUS
, MINIMUM_ATTENDEES
, MAXIMUM_ATTENDEES
, STANDARD_PRICE
, CURRENCY_CODE
, SECURE_EVENT_FLAG
, RESTRICTIONS_APPLY
, ACTIVITY_VERSION_ID
, EVENT_ID
, BOOK_INDEPENDENT_FLAG_CODE
, EVENT_FULL_FLAG
, EVENT_TENTATIVE_FLAG
, BUSINESS_GROUP_ID
, BUSINESS_GROUP_NAME
, TRAINING_CENTER_ID
, LOCATION_ID
, LANGUAGE_ID
FROM APPS.OTV_SCHEDULED_EVENTS;
|
|
|