[Home] [Help] [Dependency Information]
Object Name: | RG_REPORT_AXIS_SETS |
---|---|
Object Type: | TABLE |
Owner: | RG |
FND Design Data: | RG.RG_REPORT_AXIS_SETS |
Subobject Name: | |
Status: | VALID |
RG_REPORT_AXIS_SETS stores information about all of the row sets and column sets currently defined in Financial Statement Generator. Each row includes an axis set identifier, a row set name or a column set name, and a structure identifier to assign a specific chart of accounts to the row set or column set.
Financial Statement Generator uses the report axis sets as the basis which many report axes, axis contents, and report calculations can be linked for later reporting.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
RG_REPORT_AXIS_SETS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | AXIS_SET_ID |
RG_REPORT_AXIS_SETS_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
NAME
AXIS_SET_TYPE APPLICATION_ID |
RG_REPORT_AXIS_SETS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SEEDED_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | (15) | Yes | Application defining column |
AXIS_SET_ID | NUMBER | (15) | Yes | Row set or column set 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 | Row set or column set name |
AXIS_SET_TYPE | VARCHAR2 | (1) | Yes | Row set or column set |
DISPLAY_IN_LIST_FLAG | VARCHAR2 | (1) | No longer used | |
PERIOD_SET_NAME | VARCHAR2 | (15) | No longer used | |
DESCRIPTION | VARCHAR2 | (240) | Row set or column set description | |
ROW_SET_TITLE | VARCHAR2 | (240) | No longer used | |
SEGMENT_NAME | VARCHAR2 | (30) | Override segment | |
ID_FLEX_CODE_11I | VARCHAR2 | (4) | Obsolete | |
STRUCTURE_ID | NUMBER | (15) | Key flexfield structure defining column | |
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 | |
COLUMN_SET_HEADER | LONG | (0) | Column set header | |
TAXONOMY_ID | NUMBER | (15) | Oracle Internal use only - reserved for future use | |
ID_FLEX_CODE | VARCHAR2 | (4) | GLLE | |
SECURITY_FLAG | VARCHAR2 | (1) | Yes | Security flag |
SEEDED_NAME | VARCHAR2 | (30) | Seeded name |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICATION_ID
, AXIS_SET_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, NAME
, AXIS_SET_TYPE
, DISPLAY_IN_LIST_FLAG
, PERIOD_SET_NAME
, DESCRIPTION
, ROW_SET_TITLE
, SEGMENT_NAME
, ID_FLEX_CODE_11I
, STRUCTURE_ID
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, COLUMN_SET_HEADER
, TAXONOMY_ID
, ID_FLEX_CODE
, SECURITY_FLAG
, SEEDED_NAME
FROM RG.RG_REPORT_AXIS_SETS;
RG.RG_REPORT_AXIS_SETS does not reference any database object
RG.RG_REPORT_AXIS_SETS is referenced by following:
|
|
|