[Home] [Help] [Dependency Information]
Object Name: | RG_ROW_ORDERS |
---|---|
Object Type: | TABLE |
Owner: | RG |
FND Design Data: | RG.RG_ROW_ORDERS |
Subobject Name: | |
Status: | VALID |
RG_ROW_ORDERS stores information about how to expand rows in a report. Each row includes a row order identifier, a row rank type (ascending or descending), the name and sequence number of the column used to rank the report and the row order name used to identify that particular row order.
Financial Statement Generator uses this information to order the values in an expanded row, by linking that row order to a particular row and/or row ranking sequence.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
RG_ROW_ORDERS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | ROW_ORDER_ID |
RG_ROW_ORDERS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
NAME
APPLICATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | (15) | Yes | Application defining column |
ROW_ORDER_ID | NUMBER | (15) | Yes | Row order defining column |
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 |
NAME | VARCHAR2 | (30) | Yes | Name of this row order |
ROW_RANK_TYPE | VARCHAR2 | (1) | Indicates whether report information is ranked in ascending or descending order | |
ID_FLEX_CODE_11I | VARCHAR2 | (4) | Obsolete | |
STRUCTURE_ID | NUMBER | (15) | Key Flexfield structure defining column | |
DESCRIPTION | VARCHAR2 | (240) | Description of the row order | |
COLUMN_NUMBER | NUMBER | (15) | The sequence number of the column used to rank your report | |
COLUMN_NAME | VARCHAR2 | (30) | The name of the column used to rank the report. Denormalized from RG_REPORT_AXES | |
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 | |
SECURITY_FLAG | VARCHAR2 | (1) | Yes | Reserved for future use |
ID_FLEX_CODE | VARCHAR2 | (4) | Reserved for future use |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICATION_ID
, ROW_ORDER_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, NAME
, ROW_RANK_TYPE
, ID_FLEX_CODE_11I
, STRUCTURE_ID
, DESCRIPTION
, COLUMN_NUMBER
, COLUMN_NAME
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SECURITY_FLAG
, ID_FLEX_CODE
FROM RG.RG_ROW_ORDERS;
RG.RG_ROW_ORDERS does not reference any database object
RG.RG_ROW_ORDERS is referenced by following:
|
|
|