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


VIEW: APPS.OTFV_TRAINING_EVENTS

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

View Type

A Business Intelligence System view


This view shows the information for Training Events.


[View Source]

Columns
Name Datatype Length Mandatory Comments
BUSINESS_GROUP_NAME VARCHAR2 (240) Yes
EVENT_TITLE VARCHAR2 (80) Yes
EVENT_COMMENTS VARCHAR2 (2000)
Any special comments or notes for this event. Descriptive only.
EVENT_TYPE VARCHAR2 (4000)
EVENT_STATUS VARCHAR2 (4000)
WEEK_NUMBER VARCHAR2 (2)
COURSE_START_DATE DATE

COURSE_END_DATE DATE

COURSE_START_TIME VARCHAR2 (5)
COURSE_END_TIME VARCHAR2 (5)
TIME_ZONE VARCHAR2 (30)
DURATION NUMBER

DURATION_UNITS VARCHAR2 (4000)
ENROLLMENT_START_DATE DATE

ENROLLMENT_END_DATE DATE

RESOURCE_BOOKED VARCHAR2 (4000)
PUBLIC_EVENT VARCHAR2 (4000)
MINIMUM_ATTENDEES NUMBER (9)
MAXIMUM_ATTENDEES NUMBER (9)
MAXIMUM_INTERNAL_ATTENDEES NUMBER (9)
STANDARD_PRICE NUMBER

BOOK_INDEPENDENT VARCHAR2 (4000)
ACTUAL_COST NUMBER

BUDGET_COST NUMBER

BUDGET_COST_CURRENCY VARCHAR2 (4000)
The Currency of the Budgetted and Actual Cost
EVENT_CENTER VARCHAR2 (240)
DEVELOPMENT_EVENT_TYPE VARCHAR2 (4000)
USER_STATUS VARCHAR2 (4000)
User Definition of the Event Status
SECURED_EVENT VARCHAR2 (4000)
ORGANIZATION_NAME VARCHAR2 (4000)
LANGUAGE VARCHAR2 (4000)
PRICE_BASIS VARCHAR2 (4000)
Price basis of the Event : Student or Customer
PROGRAMME_CODE VARCHAR2 (4000)
ACTIVITY_NAME VARCHAR2 (80)
The name of the training activity
ACTIVITY_TYPE VARCHAR2 (240)
INVOICE_AMOUNT NUMBER

SUPPLIER_NAME VARCHAR2 (240)
PROJECT_NAME VARCHAR2 (30)
User-defined name that uniquely identifies the project
PROJECT_NUMBER VARCHAR2 (25)
The project number that uniquely identifies the project. The project number can be user-entered or system-generated as defined in the implementation options
OWNER_NAME VARCHAR2 (240)
CATEGORY_NAME VARCHAR2 (240)
_DF CHAR (22)
ONLINE_FLAG VARCHAR2 (1)
BUSINESS_GROUP_ID NUMBER (9) Yes
EVENT_ID NUMBER (9) Yes
PARENT_EVENT_ID NUMBER (9)
ORGANIZATION_ID NUMBER (9)
LANGUAGE_CODE VARCHAR2 (30)
ACTIVITY_VERSION_ID NUMBER (9)
ACTIVITY_ID NUMBER (9)
VENDOR_ID NUMBER

PROJECT_ID NUMBER (15)
LINE_ID NUMBER (15)
ORG_ID NUMBER (15)
TRAINING_CENTER_ID NUMBER (15)
OWNER_ID NUMBER (10)
RCO_ID NUMBER

OFFERING_ID NUMBER (9)
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT BUSINESS_GROUP_NAME
,      EVENT_TITLE
,      EVENT_COMMENTS
,      EVENT_TYPE
,      EVENT_STATUS
,      WEEK_NUMBER
,      COURSE_START_DATE
,      COURSE_END_DATE
,      COURSE_START_TIME
,      COURSE_END_TIME
,      TIME_ZONE
,      DURATION
,      DURATION_UNITS
,      ENROLLMENT_START_DATE
,      ENROLLMENT_END_DATE
,      RESOURCE_BOOKED
,      PUBLIC_EVENT
,      MINIMUM_ATTENDEES
,      MAXIMUM_ATTENDEES
,      MAXIMUM_INTERNAL_ATTENDEES
,      STANDARD_PRICE
,      BOOK_INDEPENDENT
,      ACTUAL_COST
,      BUDGET_COST
,      BUDGET_COST_CURRENCY
,      EVENT_CENTER
,      DEVELOPMENT_EVENT_TYPE
,      USER_STATUS
,      SECURED_EVENT
,      ORGANIZATION_NAME
,      LANGUAGE
,      PRICE_BASIS
,      PROGRAMME_CODE
,      ACTIVITY_NAME
,      ACTIVITY_TYPE
,      INVOICE_AMOUNT
,      SUPPLIER_NAME
,      PROJECT_NAME
,      PROJECT_NUMBER
,      OWNER_NAME
,      CATEGORY_NAME
,      _DF
,      ONLINE_FLAG
,      BUSINESS_GROUP_ID
,      EVENT_ID
,      PARENT_EVENT_ID
,      ORGANIZATION_ID
,      LANGUAGE_CODE
,      ACTIVITY_VERSION_ID
,      ACTIVITY_ID
,      VENDOR_ID
,      PROJECT_ID
,      LINE_ID
,      ORG_ID
,      TRAINING_CENTER_ID
,      OWNER_ID
,      RCO_ID
,      OFFERING_ID
FROM APPS.OTFV_TRAINING_EVENTS;

Dependencies

[top of page]

APPS.OTFV_TRAINING_EVENTS references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_BIS - show dependent code
SynonymOTA_ACTIVITY_DEFINITIONS
SynonymOTA_ACTIVITY_DEFINITIONS_TL
SynonymOTA_ACTIVITY_VERSIONS
SynonymOTA_ACTIVITY_VERSIONS_TL
SynonymOTA_CATEGORY_USAGES
SynonymOTA_CATEGORY_USAGES_TL
SynonymOTA_EVENTS
SynonymOTA_EVENTS_TL
PL/SQL PackageOTA_EVT_SHD - show dependent code
PL/SQL PackageOTA_GENERAL - show dependent code
SynonymOTA_OFFERINGS
PL/SQL PackageOTA_UTILITY - show dependent code
SynonymPA_PROJECTS
SynonymPER_ALL_PEOPLE_F
ViewPO_VENDORS

APPS.OTFV_TRAINING_EVENTS is not referenced by any database object