[Home] [Help] [Dependency Information]
Object Name: | RG_REPORT_STANDARD_AXES_B |
---|---|
Object Type: | TABLE |
Owner: | RG |
FND Design Data: | RG.RG_REPORT_STANDARD_AXES_B |
Subobject Name: | |
Status: | VALID |
RG_REPORT_STANDARD_AXES_B stores information about all of the amount types used for reporting by Financial Statement Generator. This information is represented by period-to-date, quarter-to-date, and year-to-date budget, encumbrance, and actual amounts.
Each row includes a standard axis identifier, a class, and the axis identifiers of those amount types used to create this one. Financial Statement Generator uses this information to define the contents of rows and columns in terms of whether the amounts are period-to-date, quarter-to-date, or year-to-date budget, encumbrance, or actual amounts.
The translated amount type name and descriptions for these amount types are stored in RG_REPORT_STANDARD_AXES_TL.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
RG_REPORT_STANDARD_AXES_B_U1 | NORMAL | UNIQUE | APPS_TS_SEED |
STANDARD_AXIS_ID
ZD_EDITION_NAME |
SYS_IL0000331698C00013$$ | LOB | UNIQUE | APPS_TS_SEED |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | (15) | Yes | Application defining column |
STANDARD_AXIS_ID | NUMBER | (15) | Yes | Standard axis 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 |
CLASS | VARCHAR2 | (1) | Yes | Class of standard axis, calculated or primitive |
DISPLAY_IN_STANDARD_LIST_FLAG | VARCHAR2 | (1) | Yes | Indicated whether to display in quick pick or not |
PRECEDENCE_LEVEL | NUMBER | (2) | Yes | Determine which precedence level this amount type should use in calculation |
DATABASE_COLUMN | VARCHAR2 | (30) | Indicates column in the data storage table to find the standard axis | |
SIMPLE_WHERE_NAME | VARCHAR2 | (30) | Query for this standard axis | |
PERIOD_QUERY | CLOB | (4000) | Query to find the period name | |
STANDARD_AXIS1_ID | NUMBER | (15) | First amount type that used to create this one | |
AXIS1_OPERATOR | VARCHAR2 | (1) | Operator used in first amount type | |
STANDARD_AXIS2_ID | NUMBER | (15) | Second amount type that use to create this one | |
AXIS2_OPERATOR | VARCHAR2 | (1) | Operator used in second amount type | |
CONSTANT | NUMBER | Constant used for calculation | ||
VARIANCE_FLAG | VARCHAR2 | (1) | Determine whether amount type is variance | |
SIGN_FLAG | VARCHAR2 | (1) | No longer used | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICATION_ID
, STANDARD_AXIS_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, CLASS
, DISPLAY_IN_STANDARD_LIST_FLAG
, PRECEDENCE_LEVEL
, DATABASE_COLUMN
, SIMPLE_WHERE_NAME
, PERIOD_QUERY
, STANDARD_AXIS1_ID
, AXIS1_OPERATOR
, STANDARD_AXIS2_ID
, AXIS2_OPERATOR
, CONSTANT
, VARIANCE_FLAG
, SIGN_FLAG
, ZD_EDITION_NAME
FROM RG.RG_REPORT_STANDARD_AXES_B;
RG.RG_REPORT_STANDARD_AXES_B does not reference any database object
RG.RG_REPORT_STANDARD_AXES_B is referenced by following:
|
|
|