[Home] [Help] [Dependency Information]
Object Name: | RG_REPORT_CALCULATIONS |
---|---|
Object Type: | TABLE |
Owner: | RG |
FND Design Data: | RG.RG_REPORT_CALCULATIONS |
Subobject Name: | |
Status: | VALID |
RG_REPORT_CALCULATIONS stores information about all of the calculations defined in Financial Statement Generator. Each row includes an axis set identifier and an axis sequence which are used to link the calculations to a particular row or column. It also contains information about one specific calculation operation defined in Financial Statement Generator.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
RG_REPORT_CALCULATIONS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
AXIS_SET_ID
AXIS_SEQ |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | (15) | Yes | Application defining column |
AXIS_SET_ID | NUMBER | (15) | Yes | Defining column for the column set or row set these calculations belong to |
AXIS_SEQ | NUMBER | Yes | Sequence number of the column or row these calculations belong to | |
CALCULATION_SEQ | NUMBER | Yes | Sequence number of the calculation step | |
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 |
OPERATOR | VARCHAR2 | (10) | Operator to use in the calculation | |
AXIS_SEQ_LOW | NUMBER | Sequence number range low to perform calculation with | ||
AXIS_SEQ_HIGH | NUMBER | Sequence number range high to perform calculation with | ||
AXIS_NAME_LOW | VARCHAR2 | (30) | Name of column or row to perform calculation with | |
AXIS_NAME_HIGH | VARCHAR2 | (30) | Name of column or row to perform calculation with (same as axis_name_low) | |
CONSTANT | NUMBER | Constant value to perform calculation with | ||
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 |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICATION_ID
, AXIS_SET_ID
, AXIS_SEQ
, CALCULATION_SEQ
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, OPERATOR
, AXIS_SEQ_LOW
, AXIS_SEQ_HIGH
, AXIS_NAME_LOW
, AXIS_NAME_HIGH
, CONSTANT
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM RG.RG_REPORT_CALCULATIONS;
RG.RG_REPORT_CALCULATIONS does not reference any database object
RG.RG_REPORT_CALCULATIONS is referenced by following:
|
|
|