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


VIEW: APPS.OTFV_HR_RESTRICTED_EVENTS

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

View Type

A Business Intelligence System view


This view shows the information about restricted events for internal employee


[View Source]

Columns
Name Datatype Length Mandatory Comments
BUSINESS_GROUP_NAME VARCHAR2 (240) Yes
EVENT_TITLE VARCHAR2 (80) Yes
EVENT_COMMENTS VARCHAR2 (2000)
EVENT_START_DATE DATE

EVENT_END_DATE DATE

EVENT_START_TIME VARCHAR2 (5)
EVENT_END_TIME VARCHAR2 (5)
EVENT_DURATION NUMBER

EVENT_DURATION_UNITS VARCHAR2 (4000)
SECURE_EVENT VARCHAR2 (4000)
RESOURCE_BOOKINGS VARCHAR2 (4000)
TRAINING_CENTER VARCHAR2 (240)
SUPPLIER_NAME VARCHAR2 (240)
ENROLLMENT_START_DATE DATE

ENROLLMENT_END_DATE DATE

LANGUAGE VARCHAR2 (4000)
EVENT_STATUS VARCHAR2 (4000)
EVENT_USER_STATUS VARCHAR2 (4000)
MINIMUM_ATTENDEES NUMBER (9)
MAXIMUM_ATTENDEES NUMBER (9)
STANDARD_PRICE NUMBER

CURRENCY VARCHAR2 (80)
ORGANIZATION_NAME VARCHAR2 (240)
JOB_NAME VARCHAR2 (700)
POSITION_NAME VARCHAR2 (240)
EVENT_ASSOCIATION_COMMENTS VARCHAR2 (2000)
TIME_ZONE VARCHAR2 (30)
_DF:EVENT CHAR (22)
_DF:ASSOC CHAR (34)
BUSINESS_GROUP_ID NUMBER (9) Yes
EVENT_ID NUMBER (9) Yes
ORGANIZATION_ID NUMBER (9)
JOB_ID NUMBER (15)
POSITION_ID VARCHAR2 (15)
EVENT_ASSOCIATION_ID NUMBER
Yes
TRAINING_CENTER_ID NUMBER (15)
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_START_DATE
,      EVENT_END_DATE
,      EVENT_START_TIME
,      EVENT_END_TIME
,      EVENT_DURATION
,      EVENT_DURATION_UNITS
,      SECURE_EVENT
,      RESOURCE_BOOKINGS
,      TRAINING_CENTER
,      SUPPLIER_NAME
,      ENROLLMENT_START_DATE
,      ENROLLMENT_END_DATE
,      LANGUAGE
,      EVENT_STATUS
,      EVENT_USER_STATUS
,      MINIMUM_ATTENDEES
,      MAXIMUM_ATTENDEES
,      STANDARD_PRICE
,      CURRENCY
,      ORGANIZATION_NAME
,      JOB_NAME
,      POSITION_NAME
,      EVENT_ASSOCIATION_COMMENTS
,      TIME_ZONE
,      _DF:EVENT
,      _DF:ASSOC
,      BUSINESS_GROUP_ID
,      EVENT_ID
,      ORGANIZATION_ID
,      JOB_ID
,      POSITION_ID
,      EVENT_ASSOCIATION_ID
,      TRAINING_CENTER_ID
,      OFFERING_ID
FROM APPS.OTFV_HR_RESTRICTED_EVENTS;

Dependencies

[top of page]

APPS.OTFV_HR_RESTRICTED_EVENTS references the following:

SchemaAPPS
ViewFND_CURRENCIES_VL
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_BIS - show dependent code
SynonymOTA_EVENTS
SynonymOTA_EVENTS_TL
SynonymOTA_EVENT_ASSOCIATIONS
PL/SQL PackageOTA_EVT_SHD - show dependent code
PL/SQL PackageOTA_GENERAL - show dependent code
ViewOTA_OFFERINGS_VL
PL/SQL PackageOTA_UTILITY - show dependent code
SynonymPER_ALL_POSITIONS
SynonymPER_JOBS
ViewPO_VENDORS

APPS.OTFV_HR_RESTRICTED_EVENTS is not referenced by any database object