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

TABLE: QP.QP_PARAMETERS_TL

Object Details
Object Name: QP_PARAMETERS_TL
Object Type: TABLE
Owner: QP
FND Design Data: TableQP.QP_PARAMETERS_TL
Subobject Name:
Status: VALID


Stores the translatable columns, name and description of the paramter , in each of the available languages in the database.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
QP_PARAMETERS_TL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLANGUAGE
ColumnPARAMETER_ID
ColumnZD_EDITION_NAME
QP_PARAMETERS_TL_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPARAMETER_NAME
ColumnLANGUAGE
Columns
Name Datatype Length Mandatory Comments
PARAMETER_ID NUMBER
Yes References Primary Key of QP_PARAMETERS_B
PARAMETER_NAME VARCHAR2 (240) Yes Parameter Name
DESCRIPTION VARCHAR2 (2000)
Parameter Id description
LANGUAGE VARCHAR2 (4)
Language of current record
SOURCE_LANG VARCHAR2 (4)
The Language the text will mirror. If text is not yet translated into LANGUAGE then any changes to the text in the source language row will be reflected here as well.
CREATION_DATE DATE
Yes Standard who column
CREATED_BY NUMBER
Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
LAST_UPDATED_BY NUMBER
Yes Standard who column
LAST_UPDATE_LOGIN NUMBER

Standard who column
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT PARAMETER_ID
,      PARAMETER_NAME
,      DESCRIPTION
,      LANGUAGE
,      SOURCE_LANG
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      ZD_EDITION_NAME
FROM QP.QP_PARAMETERS_TL;

Dependencies

[top of page]

QP.QP_PARAMETERS_TL does not reference any database object

QP.QP_PARAMETERS_TL is referenced by following:

SchemaQP
ViewQP_PARAMETERS_TL#