[Home] [Help] [Dependency Information]
Object Name: | RG_REPORT_EXCEPTIONS |
---|---|
Object Type: | TABLE |
Owner: | RG |
FND Design Data: | RG.RG_REPORT_EXCEPTIONS |
Subobject Name: | |
Status: | VALID |
RG_REPORT_EXCEPTIONS stores information about the conditions that must be met in order for each exception to be true. Each row contains an axis set identifier, an axis sequence number, an exception identifier, and a condition.
Financial Statement Generator uses this information to link exception conditions and the exception flag to a particular column in a column set. You can define only one flag and one set of conditions per column. .
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
RG_REPORT_EXCEPTIONS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
EXCEPTION_ID
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 the exception refers to |
AXIS_SEQ | NUMBER | Yes | Sequence number of the column the exception is defined on | |
EXCEPTION_ID | NUMBER | (15) | Yes | Exception 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 |
CONDITION | VARCHAR2 | (2) | Yes | Condition for this exception (>, <, <=, etc.) |
CONSTANT | NUMBER | Yes | Constant value to compare column value against | |
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
, EXCEPTION_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
, CONDITION
, CONSTANT
, CONTEXT
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
FROM RG.RG_REPORT_EXCEPTIONS;
RG.RG_REPORT_EXCEPTIONS does not reference any database object
RG.RG_REPORT_EXCEPTIONS is referenced by following:
|
|
|