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

TABLE: OTA.OTA_BOOKING_STATUS_TYPES_TL

Object Details
Object Name: OTA_BOOKING_STATUS_TYPES_TL
Object Type: TABLE
Owner: OTA
FND Design Data: TableOTA.OTA_BOOKING_STATUS_TYPES_TL
Subobject Name:
Status: VALID


This table only contains a subset of the columns from the base table.
Contains translated name and description of Booking Status.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: OTA_BOOKING_STATUS_TYPES_TL
  1. ColumnBOOKING_STATUS_TYPE_ID
  2. ColumnLANGUAGE
Indexes
Index Type Uniqueness Tablespace Column
OTA_BOOKING_STATUS_TYPES_TL_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnBOOKING_STATUS_TYPE_ID
ColumnLANGUAGE
Columns
Name Datatype Length Mandatory Comments
BOOKING_STATUS_TYPE_ID NUMBER (9) Yes System generated surrogate key
LANGUAGE VARCHAR2 (4) Yes Language
NAME VARCHAR2 (80) Yes The unique name to identify this status type.
DESCRIPTION VARCHAR2 (240)
Free text describing this status type
SOURCE_LANG VARCHAR2 (4) Yes Source of Language
CREATED_BY NUMBER (15)
Standard Who Column
CREATION_DATE DATE

Standard Who Column
LAST_UPDATE_DATE DATE

Standard Who Column
LAST_UPDATED_BY NUMBER (15)
Standard Who Column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who Column
Query Text

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


SELECT BOOKING_STATUS_TYPE_ID
,      LANGUAGE
,      NAME
,      DESCRIPTION
,      SOURCE_LANG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM OTA.OTA_BOOKING_STATUS_TYPES_TL;

Dependencies

[top of page]

OTA.OTA_BOOKING_STATUS_TYPES_TL does not reference any database object

OTA.OTA_BOOKING_STATUS_TYPES_TL is referenced by following:

SchemaAPPS
TriggerOTA_BOOKING_STATUS_T041317_WHO
SynonymOTA_BOOKING_STATUS_TYPES_TL