eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: OTA.OTA_BOOKING_STATUS_HISTORIES

Object Details

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

A booking status history holds a record of the enrollment status
changes for a student enrollment. It also holds the reason for the
change.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: OTA_BOOKING_STATUS_HISTORY_PK

BOOKING_ID
BOOKING_STATUS_TYPE_ID
START_DATE

Indexes

Index	Type	Uniqueness	Tablespace	Column
OTA_BOOKING_STATUS_HISTORY_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	BOOKING_ID BOOKING_STATUS_TYPE_ID START_DATE
OTA_BOOKING_STATUS_HISTORI_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BOOKING_STATUS_TYPE_ID

Foreign Keys

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

Columns

Name	Datatype	Length	Mandatory	Comments
BOOKING_ID	NUMBER	(9)	Yes	Foreign key to OTA_DELEGATE_BOOKINGS
BOOKING_STATUS_TYPE_ID	NUMBER	(9)	Yes	Foreign key to OTA_BOOKING_STATUS_TYPES
OBJECT_VERSION_NUMBER	NUMBER	(5)	Yes	Version control parameter
START_DATE	DATE		Yes	The date on which this status was valid
CHANGED_BY	NUMBER	(9)		The person who made this
COMMENTS	VARCHAR2	(2000)		Free text comments
LAST_UPDATE_DATE	DATE			Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
CREATED_BY	NUMBER	(15)		Standard Who Column
CREATION_DATE	DATE			Standard Who Column

Query Text

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


SELECT BOOKING_ID
,      BOOKING_STATUS_TYPE_ID
,      OBJECT_VERSION_NUMBER
,      START_DATE
,      CHANGED_BY
,      COMMENTS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM OTA.OTA_BOOKING_STATUS_HISTORIES;

Dependencies

[top of page]

OTA.OTA_BOOKING_STATUS_HISTORIES does not reference any database object

OTA.OTA_BOOKING_STATUS_HISTORIES is referenced by following:

APPS: OTA_BOOKING_STATUS_HISTORIES; OTA_BOOKING_STATUS_HISTORI_WHO