[Home] [Help] [Dependency Information]
Object Name: | GR_PROPERTY_VALUES_TL |
---|---|
Object Type: | TABLE |
Owner: | GR |
FND Design Data: | GR.GR_PROPERTY_VALUES_TL |
Subobject Name: | |
Status: | VALID |
Contains the Description, Value, and Meaning used to validate the data entered for the property.
For example, Marine Pollutants can have values of N (Not a Pollutant), P (Marine Pollutant), PP (Severe Pollutant), and U (Unknown).
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GR_PROPERTY_VALUES_TL_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PROPERTY_ID
LANGUAGE VALUE ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROPERTY_ID | VARCHAR2 | (6) | Yes | The unique property id code. |
LANGUAGE | VARCHAR2 | (4) | Yes | Language code |
VALUE | VARCHAR2 | (30) | Yes | The allowable values for the Property are Celsius, Fahrenheit, and Kelvin. |
DISPLAY_ORDER | NUMBER | (15) | Yes | The Sequence Number to determine the sequence that will be used for displaying or printing the Label Property on the document. |
SOURCE_LANG | VARCHAR2 | (4) | Yes | 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. |
MEANING | VARCHAR2 | (240) | The description of the Property Value. | |
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 | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT PROPERTY_ID
, LANGUAGE
, VALUE
, DISPLAY_ORDER
, SOURCE_LANG
, MEANING
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ZD_EDITION_NAME
FROM GR.GR_PROPERTY_VALUES_TL;
GR.GR_PROPERTY_VALUES_TL does not reference any database object
GR.GR_PROPERTY_VALUES_TL is referenced by following:
|
|
|