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

TABLE: HR.DT_COLUMN_PROMPTS_TL

Object Details
Object Name: DT_COLUMN_PROMPTS_TL
Object Type: TABLE
Owner: HR
FND Design Data: TableDT.DT_COLUMN_PROMPTS_TL
Subobject Name:
Status: VALID


DT_COLUMN_PROMPTS_TL holds the default prompts for the columns of each
DateTrack history view in Oracle HRMS Release 11. These column
prompts may be amended by users and saved in their own folders.


Storage Details
Tablespace: TablespaceAPPS_TS_ARCHIVE
PCT Free: 10
PCT Used:
Primary Key: DT_COLUMN_PROMPTS_TL_PK
  1. ColumnVIEW_NAME
  2. ColumnCOLUMN_NAME
  3. ColumnLANGUAGE
Indexes
Index Type Uniqueness Tablespace Column
DT_COLUMN_PROMPTS_TL_PK NORMAL UNIQUE TablespaceAPPS_TS_ARCHIVE ColumnVIEW_NAME
ColumnCOLUMN_NAME
ColumnLANGUAGE
Columns
Name Datatype Length Mandatory Comments
COLUMN_NAME VARCHAR2 (30) Yes Name of the view column.
VIEW_NAME VARCHAR2 (30) Yes Name of the DateTrack History view.
SOURCE_LANG VARCHAR2 (4) Yes Identifies the souce language of the prompt.
LANGUAGE VARCHAR2 (4) Yes Identifies the language of the prompt.
COLUMN_PROMPT VARCHAR2 (80)
Text of the prompt.
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 COLUMN_NAME
,      VIEW_NAME
,      SOURCE_LANG
,      LANGUAGE
,      COLUMN_PROMPT
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.DT_COLUMN_PROMPTS_TL;

Dependencies

[top of page]

HR.DT_COLUMN_PROMPTS_TL does not reference any database object

HR.DT_COLUMN_PROMPTS_TL is referenced by following:

SchemaAPPS
SynonymDT_COLUMN_PROMPTS_TL
TriggerDT_COLUMN_PROMPTS_TL041445_WHO
SchemaPUBLIC
SynonymDT_COLUMN_PROMPTS_TL