[Home] [Help] [Dependency Information]
Object Name: | FII_TIME_ROLLING_OFFSETS |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.FII_TIME_ROLLING_OFFSETS |
Subobject Name: | |
Status: | VALID |
Contains rolling period offsets used to support rolling period reports in DBI
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERIOD_TYPE | VARCHAR2 | (50) | Period type | |
COMPARISON_TYPE | VARCHAR2 | (15) | Comparison type | |
OFFSET | NUMBER | Rolling period offset | ||
START_DATE_OFFSET | NUMBER | Start Date offset | ||
PERIOD_NUMBER | NUMBER | Period Number | ||
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) | Standard Who column |
Cut, paste (and edit) the following text to query this object:
SELECT PERIOD_TYPE
, COMPARISON_TYPE
, OFFSET
, START_DATE_OFFSET
, PERIOD_NUMBER
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM FII.FII_TIME_ROLLING_OFFSETS;
FII.FII_TIME_ROLLING_OFFSETS does not reference any database object
FII.FII_TIME_ROLLING_OFFSETS is referenced by following:
|
|
|