[Home] [Help] [Dependency Information]
Object Name: | RG_ROW_SEGMENT_SEQUENCES |
---|---|
Object Type: | TABLE |
Owner: | RG |
FND Design Data: | RG.RG_ROW_SEGMENT_SEQUENCES |
Subobject Name: | |
Status: | VALID |
RG_ROW_SEGMENT_SEQUENCES stores different segment sequence information currently defined in Financial Statement Generator. Financial Statement Generator uses this information to arrange segments and to link the segment arrangement in a particular row order.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
RG_ROW_SEGMENT_SEQUENCES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ROW_SEGMENT_SEQUENCE_ID |
RG_ROW_SEGMENT_SEQUENCES_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ROW_ORDER_ID
STRUCTURE_ID SEGMENT_SEQUENCE |
RG_ROW_SEGMENT_SEQUENCES_U3 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
ROW_ORDER_ID
STRUCTURE_ID APPLICATION_COLUMN_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | (15) | Yes | Application defining column |
ROW_ORDER_ID | NUMBER | (15) | Yes | Row order defining column |
ROW_SEGMENT_SEQUENCE_ID | NUMBER | (15) | Yes | Primary key for table |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
SEGMENT_SEQUENCE | NUMBER | (15) | Yes | The sequence that the flexfield segment appears on the report |
SEG_ORDER_TYPE | VARCHAR2 | (1) | Yes | Indicates whether the segments are ordered alphabetically or by the column ranking |
SEG_DISPLAY_TYPE | VARCHAR2 | (1) | Yes | Indicates whether the flexfield segment value and/or description is displayed |
STRUCTURE_ID | NUMBER | (15) | Yes | Key Flexfield structure defining column |
SEGMENT_NAME | VARCHAR2 | (30) | The name of the segment used for sequencing. Denormalized from FND_ID_FLEX_SEGMENTS | |
SEGMENT_WIDTH | NUMBER | (15) | The number of characters that display on the report for a flexfield segment | |
CONTEXT | VARCHAR2 | (30) | Descriptive Flexfield context | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive Flexfield segment | |
APPLICATION_COLUMN_NAME | VARCHAR2 | (30) | Key Flexfield segment column |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICATION_ID
, ROW_ORDER_ID
, ROW_SEGMENT_SEQUENCE_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, SEGMENT_SEQUENCE
, SEG_ORDER_TYPE
, SEG_DISPLAY_TYPE
, STRUCTURE_ID
, SEGMENT_NAME
, SEGMENT_WIDTH
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, APPLICATION_COLUMN_NAME
FROM RG.RG_ROW_SEGMENT_SEQUENCES;
RG.RG_ROW_SEGMENT_SEQUENCES does not reference any database object
RG.RG_ROW_SEGMENT_SEQUENCES is referenced by following:
|
|
|