[Home] [Help] [Dependency Information]
Object Name: | GR_PHRASES_TL |
---|---|
Object Type: | TABLE |
Owner: | GR |
FND Design Data: | GR.GR_PHRASES_TL |
Subobject Name: | |
Status: | VALID |
Contains information for indexing and the print image.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GR_PHRASES_TL_PK | NORMAL | UNIQUE | APPS_TS_SEED |
PHRASE_CODE
LANGUAGE |
GR_PHRASES_TL_N2 | NORMAL | NONUNIQUE | APPS_TS_SEED | LANGUAGE |
GR_PHRASES_TL_N3 | NORMAL | NONUNIQUE | APPS_TS_SEED | SOURCE_LANG |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PHRASE_CODE | VARCHAR2 | (10) | Yes | The Code assigned to the Phrase. |
LANGUAGE | VARCHAR2 | (4) | Yes | Language code. |
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. |
KEY_WORD1 | VARCHAR2 | (10) | A Keyword in the Phrase to search on. | |
KEY_WORD2 | VARCHAR2 | (10) | A Keyword in the Phrase to search on. | |
KEY_WORD3 | VARCHAR2 | (10) | A Keyword in the Phrase to search on. | |
KEY_WORD4 | VARCHAR2 | (10) | A Keyword in the Phrase to search on. | |
KEY_WORD5 | VARCHAR2 | (10) | A Keyword in the Phrase to search on. | |
KEY_WORD6 | VARCHAR2 | (10) | A Keyword in the Phrase to search on. | |
PHRASE_TEXT | VARCHAR2 | (2000) | Yes | The Phrase Text that will be used on the document. |
PRINT_FONT | VARCHAR2 | (3) | The Print Font that will be used in the document. | |
PRINT_SIZE | NUMBER | (2) | The Print Size that will be used in the document. | |
IMAGE_PATHNAME | VARCHAR2 | (255) | The Pathname for the bitmap Image associated with the Phrase. | |
IMAGE_PRINT_LOCATION | VARCHAR2 | (1) | B to print the image before or A to print the image after the document text. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive Flexfield Structure Defining Column | |
ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE16 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE17 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE18 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE19 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE20 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE21 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE22 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE23 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE24 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE25 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE26 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE27 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE28 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE29 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
ATTRIBUTE30 | VARCHAR2 | (240) | Descriptive Standard Flexfield Segment Column | |
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 PHRASE_CODE
, LANGUAGE
, SOURCE_LANG
, KEY_WORD1
, KEY_WORD2
, KEY_WORD3
, KEY_WORD4
, KEY_WORD5
, KEY_WORD6
, PHRASE_TEXT
, PRINT_FONT
, PRINT_SIZE
, IMAGE_PATHNAME
, IMAGE_PRINT_LOCATION
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, ATTRIBUTE21
, ATTRIBUTE22
, ATTRIBUTE23
, ATTRIBUTE24
, ATTRIBUTE25
, ATTRIBUTE26
, ATTRIBUTE27
, ATTRIBUTE28
, ATTRIBUTE29
, ATTRIBUTE30
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM GR.GR_PHRASES_TL;
GR.GR_PHRASES_TL does not reference any database object
GR.GR_PHRASES_TL is referenced by following:
|
|
|