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

TABLE: HR.PER_HTML_TOOLKIT_REC_TYPES

Object Details
Object Name: PER_HTML_TOOLKIT_REC_TYPES
Object Type: TABLE
Owner: HR
FND Design Data: TablePER.PER_HTML_TOOLKIT_REC_TYPES
Subobject Name:
Status: VALID


Default values for the HR html toolkit.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 20
PCT Used:
Primary Key: PER_HTML_TOOLKIT_REC_TYPES_PK
  1. ColumnHTML_TOOLKIT_REC_TYPE_ID
Unique Key: PER_HTML_TOOLKIT_REC_TYPES_U1
  1. ColumnOBJECT_TYPE_NAME
  2. ColumnRECORD_TYPE_NAME
  3. ColumnRECORD_TYPE_SEQUENCE
  4. ColumnATTRIBUTE_NAME
Indexes
Index Type Uniqueness Tablespace Column
PER_HTML_TOOKIT_REC_TYPES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnOBJECT_TYPE_NAME
ColumnRECORD_TYPE_NAME
ColumnRECORD_TYPE_SEQUENCE
ColumnATTRIBUTE_NAME
PER_HTML_TOOLKIT_REC_TYPES_PK NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnHTML_TOOLKIT_REC_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
HTML_TOOLKIT_REC_TYPE_ID NUMBER (15) Yes System generated Primary Key
OBJECT_TYPE_NAME VARCHAR2 (80) Yes HTML object type.
RECORD_TYPE_NAME VARCHAR2 (80) Yes Name of the corresponding record value in the toolkit. e.g. PromptFormat
RECORD_TYPE_SEQUENCE NUMBER (9) Yes Display order.
ATTRIBUTE_NAME VARCHAR2 (80) Yes The name of an attribute within the record type. e.g. ALIGN)
DATA_TYPE VARCHAR2 (1) Yes The datatype of the attribute.
DEFAULT_VALUE VARCHAR2 (80)
The default value for the attribute.
CUSTOM_VALUE VARCHAR2 (80)
The customer value for the attribute. (This will be substituted for the default value at runtime.)
MESSAGE_NAME VARCHAR2 (30)
Foreign Key to FND_NEW_MESSAGES to provide a description of the object type.
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 HTML_TOOLKIT_REC_TYPE_ID
,      OBJECT_TYPE_NAME
,      RECORD_TYPE_NAME
,      RECORD_TYPE_SEQUENCE
,      ATTRIBUTE_NAME
,      DATA_TYPE
,      DEFAULT_VALUE
,      CUSTOM_VALUE
,      MESSAGE_NAME
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.PER_HTML_TOOLKIT_REC_TYPES;

Dependencies

[top of page]

HR.PER_HTML_TOOLKIT_REC_TYPES does not reference any database object

HR.PER_HTML_TOOLKIT_REC_TYPES is referenced by following:

SchemaHR
ViewPER_HTML_TOOLKIT_REC_TYPES#