[Home] [Help] [Dependency Information]
Object Name: | GR_PROPERTIES_TL |
---|---|
Object Type: | TABLE |
Owner: | GR |
FND Design Data: | GR.GR_PROPERTIES_TL |
Subobject Name: | |
Status: | VALID |
Contains the Property Description for the label attributes. A label can have several Property Codes.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GR_PROPERTIES_TL_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PROPERTY_ID
LANGUAGE ZD_EDITION_NAME |
GR_PROPERTIES_TL_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LANGUAGE |
GR_PROPERTIES_TL_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SOURCE_LANG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROPERTY_ID | VARCHAR2 | (6) | Yes | The unique property id code. |
LANGUAGE | VARCHAR2 | (4) | Yes | Language code |
DESCRIPTION | VARCHAR2 | (240) | Yes | The Property Description for the Label attribute. |
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. |
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
, DESCRIPTION
, SOURCE_LANG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ZD_EDITION_NAME
FROM GR.GR_PROPERTIES_TL;
GR.GR_PROPERTIES_TL does not reference any database object
GR.GR_PROPERTIES_TL is referenced by following:
|
|
|