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

VIEW: APPS.OTFV_ENROLLMENT_STATUSES

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

View Type

A Business Intelligence System view


This view shows each enrollment/booking status and status type


[View Source]

Columns
Name Datatype Length Mandatory Comments
BUSINESS_GROUP_NAME VARCHAR2 (240) Yes
ENROLLMENT_STATUS VARCHAR2 (80) Yes
ENROLLMENT_STATUS_TYPE VARCHAR2 (4000)
DEFAULT_FLAG VARCHAR2 (4000)
PLACE_USED VARCHAR2 (4000)
An indication of whether the status implies that a place on an event has been allocated.
ACTIVE_FLAG VARCHAR2 (4000)
DESCRIPTION VARCHAR2 (240)
COMMENTS VARCHAR2 (2000)
ENROLLMENT_STATUS_TYPE_CODE VARCHAR2 (30) Yes
DEFAULT_FLAG_CODE VARCHAR2 (30) Yes
PLACE_USED_CODE VARCHAR2 (30)
ACTIVE_FLAG_CODE VARCHAR2 (30) Yes
_DF CHAR (36)
BUSINESS_GROUP_ID NUMBER (9) Yes
BOOKING_STATUS_TYPE_ID NUMBER (9) Yes
Query Text

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


SELECT BUSINESS_GROUP_NAME
,      ENROLLMENT_STATUS
,      ENROLLMENT_STATUS_TYPE
,      DEFAULT_FLAG
,      PLACE_USED
,      ACTIVE_FLAG
,      DESCRIPTION
,      COMMENTS
,      ENROLLMENT_STATUS_TYPE_CODE
,      DEFAULT_FLAG_CODE
,      PLACE_USED_CODE
,      ACTIVE_FLAG_CODE
,      _DF
,      BUSINESS_GROUP_ID
,      BOOKING_STATUS_TYPE_ID
FROM APPS.OTFV_ENROLLMENT_STATUSES;

Dependencies

[top of page]

APPS.OTFV_ENROLLMENT_STATUSES references the following:

SchemaAPPS
SynonymHR_ALL_ORGANIZATION_UNITS
SynonymHR_ALL_ORGANIZATION_UNITS_TL
PL/SQL PackageHR_BIS - show dependent code
SynonymOTA_BOOKING_STATUS_TYPES
SynonymOTA_BOOKING_STATUS_TYPES_TL
PL/SQL PackageOTA_GENERAL - show dependent code
APPS.OTFV_ENROLLMENT_STATUSES is referenced by following:

SchemaPUBLIC
SynonymOTFV_ENROLLMENT_STATUSES