[Home] [Help] [Dependency Information]
Object Name: | OTFV_ONE_TIME_TRAINING_EVENTS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OTA.OTFV_ONE_TIME_TRAINING_EVENTS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This view shows the one time training events available to employees in your enterprise. One time events maybe unique or informal events, conferences or team 'away days'.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUSINESS_GROUP_NAME | VARCHAR2 | (240) | Yes | |
EVENT_NAME | VARCHAR2 | (80) | Yes | |
EVENT_COMMENTS | VARCHAR2 | (2000) | Any special comments or notes for this event. Descriptive only. | |
EVENT_START_DATE | DATE | |||
EVENT_END_DATE | DATE | |||
EVENT_START_TIME | VARCHAR2 | (5) | ||
EVENT_END_TIME | VARCHAR2 | (5) | ||
TIME_ZONE | VARCHAR2 | (30) | ||
DURATION | NUMBER | |||
DURATION_UNITS | VARCHAR2 | (4000) | ||
TRAINING_CENTRE | VARCHAR2 | (240) | ||
SUPPLIER_NAME | VARCHAR2 | (240) | ||
_DF | CHAR | (22) | ||
BUSINESS_GROUP_ID | NUMBER | (9) | Yes | |
EVENT_ID | NUMBER | (9) | Yes | |
TRAINING_CENTER_ID | NUMBER | (15) | ||
OFFERING_ID | NUMBER | (9) |
Cut, paste (and edit) the following text to query this object:
SELECT BUSINESS_GROUP_NAME
, EVENT_NAME
, EVENT_COMMENTS
, EVENT_START_DATE
, EVENT_END_DATE
, EVENT_START_TIME
, EVENT_END_TIME
, TIME_ZONE
, DURATION
, DURATION_UNITS
, TRAINING_CENTRE
, SUPPLIER_NAME
, _DF
, BUSINESS_GROUP_ID
, EVENT_ID
, TRAINING_CENTER_ID
, OFFERING_ID
FROM APPS.OTFV_ONE_TIME_TRAINING_EVENTS;
APPS.OTFV_ONE_TIME_TRAINING_EVENTS is not referenced by any database object
|
|
|