[Home] [Help] [Dependency Information]
Object Name: | OTA_EVENTS_VL |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OTA.OTA_EVENTS_VL |
Subobject Name: | |
Status: | VALID |
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.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
EVENT_ID | NUMBER | (9) | Yes | |
BUSINESS_GROUP_ID | NUMBER | (9) | Yes | Foreign key to HR_ALL_ORGANIZATION_UNITS |
ORGANIZATION_ID | NUMBER | (9) | Foreign key to HR_ALL_ORGANIZATION_UNITS | |
ACTIVITY_VERSION_ID | NUMBER | (9) | Foreign key to OTA_ACTIVITY_VERSIONS | |
VENDOR_ID | NUMBER | (15) | Foreign key to PO_VENDORS. | |
PARENT_EVENT_ID | NUMBER | (9) | Foreign key to OTA_EVENTS | |
EVENT_TYPE | VARCHAR2 | (30) | Yes | The type of module activity. |
OBJECT_VERSION_NUMBER | NUMBER | (5) | Yes | Version control parameter |
TITLE | VARCHAR2 | (80) | Yes | The name or title associated with this event. |
ACTUAL_COST | NUMBER | The actual cost of the Event | ||
BUDGET_COST | NUMBER | The Budgetted Cost for the Event | ||
BUDGET_CURRENCY_CODE | VARCHAR2 | (30) | The Currency of the Budgetted and Actual Cost | |
CENTRE | VARCHAR2 | (30) | The centre at which this event is to take place. | |
COMMENTS | VARCHAR2 | (2000) | Any special comments or notes for this entry. Descriptive only. | |
COURSE_END_DATE | DATE | The Date on which the Event Ends | ||
COURSE_END_TIME | VARCHAR2 | (5) | The end time of the event | |
COURSE_START_DATE | DATE | The Date on which the Event Starts | ||
COURSE_START_TIME | VARCHAR2 | (5) | The start time of the event | |
DURATION | NUMBER | The duration of the event measured in units specified in UNIT | ||
DURATION_UNITS | VARCHAR2 | (30) | The units in which the duration is measured | |
ENROLMENT_END_DATE | DATE | The closing date for bookings of this entry. | ||
ENROLMENT_START_DATE | DATE | The earliest date on which bookings may be taken for this entry. | ||
LANGUAGE_ID | NUMBER | (9) | The language in which the course is taught. | |
PUBLIC_EVENT_FLAG | VARCHAR2 | (30) | An indication of whether an Event can have associations | |
USER_STATUS | VARCHAR2 | (80) | User Definition of the Event Status | |
DEVELOPMENT_EVENT_TYPE | VARCHAR2 | (30) | The user description of the developement type defined. | |
EVENT_STATUS | VARCHAR2 | (30) | The status of this schedule entry. | |
PRICE_BASIS | VARCHAR2 | (30) | Price basis of the Event : Student or Customer | |
SECURE_EVENT_FLAG | VARCHAR2 | (30) | An indication of whether an event can be maintained by employees of the administering organization only. | |
BOOK_INDEPENDENT_FLAG | VARCHAR2 | (30) | Whether the Scheduled can be indepepndent of a program | |
CURRENCY_CODE | VARCHAR2 | (30) | The currency in which the standard price is defined. | |
MAXIMUM_ATTENDEES | NUMBER | (9) | The maximum number of students who may attend | |
MAXIMUM_INTERNAL_ATTENDEES | NUMBER | (9) | The maximum number of internal students | |
MINIMUM_ATTENDEES | NUMBER | (9) | The minimum number of students for this entry to be viable. | |
STANDARD_PRICE | NUMBER | The standard price per (price basis) booking for this entry | ||
CATEGORY_CODE | VARCHAR2 | (30) | Identifies the programme of activities for the event group | |
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 | ||
EVT_INFORMATION_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
EVT_INFORMATION1 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
EVT_INFORMATION2 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
EVT_INFORMATION3 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
EVT_INFORMATION4 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
EVT_INFORMATION5 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
EVT_INFORMATION6 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
EVT_INFORMATION7 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
EVT_INFORMATION8 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
EVT_INFORMATION9 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
EVT_INFORMATION10 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
EVT_INFORMATION11 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
EVT_INFORMATION12 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
EVT_INFORMATION13 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
EVT_INFORMATION14 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
EVT_INFORMATION15 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
EVT_INFORMATION16 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
EVT_INFORMATION17 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
EVT_INFORMATION18 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
EVT_INFORMATION19 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
EVT_INFORMATION20 | VARCHAR2 | (150) | Descriptive flexfield segment column | |
PROJECT_ID | NUMBER | (15) | Foreign Key to PA_PROJECTS_ALL. | |
OWNER_ID | NUMBER | (10) | Foriegn key to PER_ALL_PEOPLE_F. | |
LINE_ID | NUMBER | (15) | Foriegn key to OE_ORDER_LINES_ALL. | |
ORG_ID | NUMBER | (15) | The number of the Org ID that is associated to the enrollment through OM or OTA. | |
TRAINING_CENTER_ID | NUMBER | (15) | Foriegn key to HR_ALL_ORGANIZATION_UNITS. | |
LOCATION_ID | NUMBER | (15) | Foriegn key to HR_LOCATIONS. | |
OFFERING_ID | NUMBER | iLearning Offering unique identifier | ||
TIMEZONE | VARCHAR2 | (30) | Timezone of the Event Date | |
PARENT_OFFERING_ID | NUMBER | (9) | ||
DATA_SOURCE | VARCHAR2 | (30) | ||
EVENT_AVAILABILITY | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, EVENT_ID
, BUSINESS_GROUP_ID
, ORGANIZATION_ID
, ACTIVITY_VERSION_ID
, VENDOR_ID
, PARENT_EVENT_ID
, EVENT_TYPE
, OBJECT_VERSION_NUMBER
, TITLE
, ACTUAL_COST
, BUDGET_COST
, BUDGET_CURRENCY_CODE
, CENTRE
, COMMENTS
, COURSE_END_DATE
, COURSE_END_TIME
, COURSE_START_DATE
, COURSE_START_TIME
, DURATION
, DURATION_UNITS
, ENROLMENT_END_DATE
, ENROLMENT_START_DATE
, LANGUAGE_ID
, PUBLIC_EVENT_FLAG
, USER_STATUS
, DEVELOPMENT_EVENT_TYPE
, EVENT_STATUS
, PRICE_BASIS
, SECURE_EVENT_FLAG
, BOOK_INDEPENDENT_FLAG
, CURRENCY_CODE
, MAXIMUM_ATTENDEES
, MAXIMUM_INTERNAL_ATTENDEES
, MINIMUM_ATTENDEES
, STANDARD_PRICE
, CATEGORY_CODE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, EVT_INFORMATION_CATEGORY
, EVT_INFORMATION1
, EVT_INFORMATION2
, EVT_INFORMATION3
, EVT_INFORMATION4
, EVT_INFORMATION5
, EVT_INFORMATION6
, EVT_INFORMATION7
, EVT_INFORMATION8
, EVT_INFORMATION9
, EVT_INFORMATION10
, EVT_INFORMATION11
, EVT_INFORMATION12
, EVT_INFORMATION13
, EVT_INFORMATION14
, EVT_INFORMATION15
, EVT_INFORMATION16
, EVT_INFORMATION17
, EVT_INFORMATION18
, EVT_INFORMATION19
, EVT_INFORMATION20
, PROJECT_ID
, OWNER_ID
, LINE_ID
, ORG_ID
, TRAINING_CENTER_ID
, LOCATION_ID
, OFFERING_ID
, TIMEZONE
, PARENT_OFFERING_ID
, DATA_SOURCE
, EVENT_AVAILABILITY
FROM APPS.OTA_EVENTS_VL;
|
|
|