[Home] [Help] [Dependency Information]
Object Name: | SY_PARA_CDS_TL |
---|---|
Object Type: | TABLE |
Owner: | GMA |
FND Design Data: | GMA.SY_PARA_CDS_TL |
Subobject Name: | |
Status: | VALID |
Stores Oracle Process Manufacturing Paragraph Codes, which are used to
categorize text entered against any row in any OPM table. Paragraphs can be
defined at multiple levels, including by language and sub-paragraph code.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
SY_PARA_CDS_TL_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX |
TABLE_NAME
PARAGRAPH_CODE SUB_PARACODE LANGUAGE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TABLE_NAME | VARCHAR2 | (32) | Yes | Table name |
LANG_CODE | VARCHAR2 | (4) | Yes | Indicates language used in text. |
PARAGRAPH_CODE | VARCHAR2 | (4) | Yes | Paragraph code |
SUB_PARACODE | NUMBER | (5) | Yes | Sub Paragraph code |
PARA_DESC | VARCHAR2 | (255) | Yes | Description of the Paragraph code |
NONPRINTABLE_IND | NUMBER | (5) | Yes | Indicates whether the paragraph is printable |
CREATION_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
LANGUAGE | VARCHAR2 | (4) | Yes | The value stored in this column represents the Language in which the data will be displayed. |
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. |
SY_PARA_CDS_TL_TEXT_CODE | NUMBER | (10) | Translation text code | |
SY_PARA_CDS_TL_LANG_CODE | VARCHAR2 | (4) | Translation language code | |
SY_PARA_CDS_TL_PARAGRAPH_CODE | VARCHAR2 | (4) | Translation paragraph code | |
SY_PARA_CDS_TL_SUB_PARACODE | NUMBER | (5) | Translation subparagraph code | |
SY_PARA_CDS_TL_LINE_NO | NUMBER | (5) | Translation line number | |
SY_PARA_CDS_TL_LANGUAGE | VARCHAR2 | (4) | Translation language |
Cut, paste (and edit) the following text to query this object:
SELECT TABLE_NAME
, LANG_CODE
, PARAGRAPH_CODE
, SUB_PARACODE
, PARA_DESC
, NONPRINTABLE_IND
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LANGUAGE
, SOURCE_LANG
, SY_PARA_CDS_TL_TEXT_CODE
, SY_PARA_CDS_TL_LANG_CODE
, SY_PARA_CDS_TL_PARAGRAPH_CODE
, SY_PARA_CDS_TL_SUB_PARACODE
, SY_PARA_CDS_TL_LINE_NO
, SY_PARA_CDS_TL_LANGUAGE
FROM GMA.SY_PARA_CDS_TL;
GMA.SY_PARA_CDS_TL does not reference any database object
GMA.SY_PARA_CDS_TL is referenced by following:
|
|
|