[Home] [Help] [Dependency Information]
Object Name: | GL_OASIS_FIN_METRICS_11I |
---|---|
Object Type: | TABLE |
Owner: | GL |
FND Design Data: | SQLGL.GL_OASIS_FIN_METRICS_11I |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
GL_OASIS_FIN_METRICS_U1 | NORMAL | UNIQUE | APPS_TS_INTERFACE |
SET_OF_BOOKS_ID
FIN_METRIC_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Accounting books defining column |
FIN_METRIC_CODE | VARCHAR2 | (30) | Yes | Indicates the desired financial metric |
EFFECTIVE_PERIOD_NUM | NUMBER | Yes | Effective period number of the current period (the one the program was run for) | |
CREATION_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | (15) | Yes | Standard Who 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 |
REPORT_NAME | VARCHAR2 | (2000) | Name of the report associated with this metric | |
REPORT_PARAMETERS | VARCHAR2 | (2000) | Parameters for the report associated with this metric | |
QUARTER1_VALUE | NUMBER | Value of the metric for quarter 1 | ||
QUARTER2_VALUE | NUMBER | Value of the metric for quarter 2 | ||
QUARTER3_VALUE | NUMBER | Value of the metric for quarter 3 | ||
QUARTER4_VALUE | NUMBER | Value of the metric for quarter 4 | ||
YEAR_VALUE | NUMBER | Year-to-date value of the metric |
Cut, paste (and edit) the following text to query this object:
SELECT SET_OF_BOOKS_ID
, FIN_METRIC_CODE
, EFFECTIVE_PERIOD_NUM
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REPORT_NAME
, REPORT_PARAMETERS
, QUARTER1_VALUE
, QUARTER2_VALUE
, QUARTER3_VALUE
, QUARTER4_VALUE
, YEAR_VALUE
FROM GL.GL_OASIS_FIN_METRICS_11I;
GL.GL_OASIS_FIN_METRICS_11I does not reference any database object
GL.GL_OASIS_FIN_METRICS_11I is referenced by following:
|
|
|