[Home] [Help] [Dependency Information]

TABLE: OTA.OTA_BOOKING_STATUS_TYPES

Object Details

Object Name:	OTA_BOOKING_STATUS_TYPES
Object Type:	TABLE
Owner:	OTA
FND Design Data:	OTA.OTA_BOOKING_STATUS_TYPES
Subobject Name:
Status:	VALID

The Oracle Training Administration product provides a seeded list of
system enrollment statuses. These system enrollment statuses are what
the application uses to determine the condition of a student
enrollment. These enrollment status records, also known as booking
status records, hold user-definitions of the system statuses. For
example, the system status Cancelled can be set up as Cancelled by
Administrator, Cancelled by Student, and so on. For each system
enrollment status type, there is one default user status which is
used to create new enrollments and throughout the enrollment life
cycle.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: OTA_BOOKING_STATUS_TYPES_PK

1. BOOKING_STATUS_TYPE_ID

Unique Key: OTA_BOOKING_STATUS_TYPES_UK2

1. NAME
2. BUSINESS_GROUP_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
OTA_BOOKING_STATUS_TYPES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	BOOKING_STATUS_TYPE_ID
OTA_BOOKING_STATUS_TYPES_UK2	NORMAL	UNIQUE	APPS_TS_TX_IDX	NAME BUSINESS_GROUP_ID
OTA_BOOKING_STATUS_TYPES_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUSINESS_GROUP_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
OTA_BOOKING_STATUS_EXCL		OTA_BOOKING_STATUS_TYPES	OTA_BOOKING_STATUS_EXCL BOOKING_STATUS_TYPE_ID
OTA_BOOKING_STATUS_HISTORIES		OTA_BOOKING_STATUS_TYPES	OTA_BOOKING_STATUS_HISTORIES BOOKING_STATUS_TYPE_ID
OTA_DELEGATE_BOOKINGS		OTA_BOOKING_STATUS_TYPES	OTA_DELEGATE_BOOKINGS BOOKING_STATUS_TYPE_ID

Columns

Query Text

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

SELECT BOOKING_STATUS_TYPE_ID
,      BUSINESS_GROUP_ID
,      ACTIVE_FLAG
,      DEFAULT_FLAG
,      PLACE_USED_FLAG
,      NAME
,      OBJECT_VERSION_NUMBER
,      TYPE
,      COMMENTS
,      DESCRIPTION
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      BST_INFORMATION_CATEGORY
,      BST_INFORMATION1
,      BST_INFORMATION2
,      BST_INFORMATION3
,      BST_INFORMATION4
,      BST_INFORMATION5
,      BST_INFORMATION6
,      BST_INFORMATION7
,      BST_INFORMATION8
,      BST_INFORMATION9
,      BST_INFORMATION10
,      BST_INFORMATION11
,      BST_INFORMATION12
,      BST_INFORMATION13
,      BST_INFORMATION14
,      BST_INFORMATION15
,      BST_INFORMATION16
,      BST_INFORMATION17
,      BST_INFORMATION18
,      BST_INFORMATION19
,      BST_INFORMATION20
FROM OTA.OTA_BOOKING_STATUS_TYPES;

Dependencies

[top of page]

OTA.OTA_BOOKING_STATUS_TYPES does not reference any database object

OTA.OTA_BOOKING_STATUS_TYPES is referenced by following:

APPS

OTA_BOOKING_STATUS_TYPES

OTA_BOOKING_STATUS_TYPES_WHO