[Home] [Help] [Dependency Information]
Object Name: | PV_GE_QSNR_ELEMENTS_TL |
---|---|
Object Type: | TABLE |
Owner: | PV |
FND Design Data: | PV.PV_GE_QSNR_ELEMENTS_TL |
Subobject Name: | |
Status: | VALID |
PV_GE_QSNR_ELEMENTS_TL captures the translatable data for questionnaire elements.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PV_GE_QSNR_ELEMENTS_TL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
LANGUAGE
QSNR_ELEMENT_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
QSNR_ELEMENT_ID | NUMBER | Yes | Unique identifier for the Questionnaire Element | |
LANGUAGE | VARCHAR2 | (4) | Yes | Language of the translated record.The language the text columns will mirror to. 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. |
ELMT_CONTENT | VARCHAR2 | (2000) | The content of questions or sections. For example, "What was your company's total gross revenue?" | |
SOURCE_LANG | VARCHAR2 | (4) | Yes | The source language of the record. |
CREATED_BY | NUMBER | (15) | Yes | Standard WHO column |
CREATION_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO column |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO column |
Cut, paste (and edit) the following text to query this object:
SELECT QSNR_ELEMENT_ID
, LANGUAGE
, ELMT_CONTENT
, SOURCE_LANG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM PV.PV_GE_QSNR_ELEMENTS_TL;
PV.PV_GE_QSNR_ELEMENTS_TL does not reference any database object
PV.PV_GE_QSNR_ELEMENTS_TL is referenced by following:
|
|
|