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

TABLE: OTA.OTA_TITLE_CONVERSIONS

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


Holds the conversion relationship between Person Titles held in RA and
HR models.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: OTA_TITLE_CONVERSIONS_PK
  1. ColumnAR_TITLE
  2. ColumnHR_TITLE
Indexes
Index Type Uniqueness Tablespace Column
OTA_TITLE_CONVERSIONS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnAR_TITLE
ColumnHR_TITLE
Columns
Name Datatype Length Mandatory Comments
AR_TITLE VARCHAR2 (30) Yes AR CONTACT_TITLE value corresponding to an HR TITLE
HR_TITLE VARCHAR2 (30) Yes HR TITLE corresponding to AR CONTACT_TITLE
Query Text

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


SELECT AR_TITLE
,      HR_TITLE
FROM OTA.OTA_TITLE_CONVERSIONS;

Dependencies

[top of page]

OTA.OTA_TITLE_CONVERSIONS does not reference any database object

OTA.OTA_TITLE_CONVERSIONS is referenced by following:

SchemaAPPS
SynonymOTA_TITLE_CONVERSIONS