DBA Data[Home] [Help] [Dependency Information]

TABLE: RRS.RRS_TRADE_AREAS_EXT_TL

Object Details
Object Name: RRS_TRADE_AREAS_EXT_TL
Object Type: TABLE
Owner: RRS
FND Design Data: TableRRS.RRS_TRADE_AREAS_EXT_TL
Subobject Name:
Status: VALID


This table stores the translated User Defined Attributes values associated with Trade Areas in multiple languages


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
RRS_TRADE_AREAS_EXT_TL_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnLANGUAGE
ColumnEXTENSION_ID
RRS_TRADE_AREAS_EXT_TL_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnLANGUAGE
ColumnTRADE_AREA_ID
RRS_TRADE_AREAS_EXT_TL_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnATTR_GROUP_ID
ColumnGROUP_ID
ColumnLANGUAGE
Columns
Name Datatype Length Mandatory Comments
EXTENSION_ID NUMBER
Yes System Generated Unique Identifier
DATA_LEVEL_ID NUMBER
Yes Internal representation of Trade Areas Entity for User Defined Attributes
TRADE_AREA_ID NUMBER
Yes Trade Area Identification number for which Attribute Values are assigned
GROUP_ID NUMBER
Yes Group ID of Trade Area
ATTR_GROUP_ID NUMBER
Yes Internal Identification ID of Attribute Group
SOURCE_LANG VARCHAR2 (4) Yes Installed base Language
LANGUAGE VARCHAR2 (4) Yes The language of translation
CREATED_BY NUMBER
Yes Standard WHO column
CREATION_DATE DATE
Yes Standard WHO column
LAST_UPDATED_BY NUMBER
Yes Standard WHO column
LAST_UPDATE_DATE DATE
Yes Standard WHO column
LAST_UPDATE_LOGIN NUMBER

Standard WHO column
TL_EXT_ATTR1 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR2 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR3 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR4 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR5 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR6 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR7 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR8 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR9 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR10 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR11 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR12 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR13 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR14 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR15 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR16 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR17 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR18 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR19 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR20 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR21 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR22 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR23 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR24 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR25 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR26 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR27 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR28 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR29 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR30 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR31 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR32 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR33 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR34 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR35 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR36 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR37 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR38 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR39 VARCHAR2 (1000)
Character Column for translated Attribute Value
TL_EXT_ATTR40 VARCHAR2 (1000)
Character Column for translated Attribute Value
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT EXTENSION_ID
,      DATA_LEVEL_ID
,      TRADE_AREA_ID
,      GROUP_ID
,      ATTR_GROUP_ID
,      SOURCE_LANG
,      LANGUAGE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      TL_EXT_ATTR1
,      TL_EXT_ATTR2
,      TL_EXT_ATTR3
,      TL_EXT_ATTR4
,      TL_EXT_ATTR5
,      TL_EXT_ATTR6
,      TL_EXT_ATTR7
,      TL_EXT_ATTR8
,      TL_EXT_ATTR9
,      TL_EXT_ATTR10
,      TL_EXT_ATTR11
,      TL_EXT_ATTR12
,      TL_EXT_ATTR13
,      TL_EXT_ATTR14
,      TL_EXT_ATTR15
,      TL_EXT_ATTR16
,      TL_EXT_ATTR17
,      TL_EXT_ATTR18
,      TL_EXT_ATTR19
,      TL_EXT_ATTR20
,      TL_EXT_ATTR21
,      TL_EXT_ATTR22
,      TL_EXT_ATTR23
,      TL_EXT_ATTR24
,      TL_EXT_ATTR25
,      TL_EXT_ATTR26
,      TL_EXT_ATTR27
,      TL_EXT_ATTR28
,      TL_EXT_ATTR29
,      TL_EXT_ATTR30
,      TL_EXT_ATTR31
,      TL_EXT_ATTR32
,      TL_EXT_ATTR33
,      TL_EXT_ATTR34
,      TL_EXT_ATTR35
,      TL_EXT_ATTR36
,      TL_EXT_ATTR37
,      TL_EXT_ATTR38
,      TL_EXT_ATTR39
,      TL_EXT_ATTR40
FROM RRS.RRS_TRADE_AREAS_EXT_TL;

Dependencies

[top of page]

RRS.RRS_TRADE_AREAS_EXT_TL does not reference any database object

RRS.RRS_TRADE_AREAS_EXT_TL is referenced by following:

SchemaAPPS
SynonymRRS_TRADE_AREAS_EXT_TL