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


VIEW: APPS.OTFV_COMBINED_TRAINING_HISTORY

Object Details
Object Name: OTFV_COMBINED_TRAINING_HISTORY
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOTA.OTFV_COMBINED_TRAINING_HISTORY
Subobject Name:
Status: VALID

View Type

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.


[View Source]

Columns
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

Query Text

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;

Dependencies

[top of page]

APPS.OTFV_COMBINED_TRAINING_HISTORY references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_BIS - show dependent code
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_CUST_ACCOUNT_ROLES
SynonymHZ_PARTIES
SynonymHZ_RELATIONSHIPS
SynonymOTA_ACTIVITY_DEFINITIONS
SynonymOTA_ACTIVITY_DEFINITIONS_TL
SynonymOTA_ACTIVITY_VERSIONS
SynonymOTA_ACTIVITY_VERSIONS_TL
SynonymOTA_DELEGATE_BOOKINGS
SynonymOTA_EVENTS
SynonymOTA_EVENTS_TL
PL/SQL PackageOTA_GENERAL - show dependent code
SynonymOTA_LEARNING_OBJECTS
SynonymOTA_NOTRNG_HISTORIES
SynonymOTA_OFFERINGS
SynonymOTA_PERFORMANCES
SynonymPER_ALL_PEOPLE_F
ViewPO_VENDORS

APPS.OTFV_COMBINED_TRAINING_HISTORY is not referenced by any database object