[Home] [Help] [Dependency Information]
Object Name: | OTFV_COMBINED_TRAINING_HISTORY |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | OTA.OTFV_COMBINED_TRAINING_HISTORY |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
This view shows the data for Internal as well as external training taken by students.
In this view students can be either internal employees or customers.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BUSINESS_GROUP_NAME | VARCHAR2 | (240) | ||
TRAINING_TITLE | VARCHAR2 | (80) | ||
TRAINING_COMPLETION_DATE | DATE | |||
TRAINING_TYPE | VARCHAR2 | (4000) | ||
TRAINING_CENTER | VARCHAR2 | (240) | ||
TRAINING_PROVIDER | VARCHAR2 | (240) | ||
TRAINING_AWARD | VARCHAR2 | (80) | ||
TRAINING_RATING | VARCHAR2 | (30) | ||
TRAINING_DURATION | NUMBER | |||
TRAINING_DURATION_UNITS | VARCHAR2 | (4000) | ||
TRAINING_STATUS | VARCHAR2 | (4000) | ||
TOTAL_TRAINING_TIME | VARCHAR2 | (10) | ||
PLAYER_STATUS | VARCHAR2 | (4000) | ||
TEST_SCORE | NUMBER | |||
NUMBER_OF_MODULES_COMPLETED | NUMBER | |||
TOTAL_MODULES | NUMBER | |||
ORGANIZATION_NAME | VARCHAR2 | (240) | ||
CUSTOMER_NAME | VARCHAR2 | (50) | ||
PERSON_NAME | VARCHAR2 | (301) | ||
CONTACT_NAME | VARCHAR2 | (301) | ||
OTA_EQUI_ACTIVITY_NAME | VARCHAR2 | (80) | ||
OTA_EQUI_ACTIVITY_TYPE | VARCHAR2 | (240) | ||
DATA_SOURCE | VARCHAR2 | (7) | ||
_DF:NON_OTA | VARCHAR2 | (39) | ||
_DF:OTA | VARCHAR2 | (40) | ||
ACTIVITY_VERSION_ID | NUMBER | (9) | ||
ACTIVITY_ID | NUMBER | (9) | ||
CONTACT_ID | NUMBER | |||
PERSON_ID | NUMBER | (10) | ||
CUSTOMER_ID | NUMBER | |||
ORGANIZATION_ID | NUMBER | |||
BUSINESS_GROUP_ID | NUMBER | (9) | ||
TRAINING_CENTER_ID | NUMBER | |||
RCO_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT BUSINESS_GROUP_NAME
, TRAINING_TITLE
, TRAINING_COMPLETION_DATE
, TRAINING_TYPE
, TRAINING_CENTER
, TRAINING_PROVIDER
, TRAINING_AWARD
, TRAINING_RATING
, TRAINING_DURATION
, TRAINING_DURATION_UNITS
, TRAINING_STATUS
, TOTAL_TRAINING_TIME
, PLAYER_STATUS
, TEST_SCORE
, NUMBER_OF_MODULES_COMPLETED
, TOTAL_MODULES
, ORGANIZATION_NAME
, CUSTOMER_NAME
, PERSON_NAME
, CONTACT_NAME
, OTA_EQUI_ACTIVITY_NAME
, OTA_EQUI_ACTIVITY_TYPE
, DATA_SOURCE
, _DF:NON_OTA
, _DF:OTA
, ACTIVITY_VERSION_ID
, ACTIVITY_ID
, CONTACT_ID
, PERSON_ID
, CUSTOMER_ID
, ORGANIZATION_ID
, BUSINESS_GROUP_ID
, TRAINING_CENTER_ID
, RCO_ID
FROM APPS.OTFV_COMBINED_TRAINING_HISTORY;
APPS.OTFV_COMBINED_TRAINING_HISTORY is not referenced by any database object
|
|
|