[Home] [Help] [Dependency Information]
Object Name: | AS_PERIOD_DAYS |
---|---|
Object Type: | TABLE |
Owner: | OSM |
FND Design Data: | AS.AS_PERIOD_DAYS |
Subobject Name: | |
Status: | VALID |
Simplifies gl_periods
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AS_PERIOD_DAYS_U1 | NORMAL | UNIQUE | APPS_TS_SUMMARY |
PERIOD_SET_NAME
PERIOD_NAME PERIOD_TYPE PERIOD_DAY |
AS_PERIOD_DAYS_U2 | FUNCTION-BASED NORMAL | UNIQUE | APPS_TS_SUMMARY | TRUNC("PERIOD_DAY") |
AS_PERIOD_DAYS_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
PERIOD_SET_NAME
PERIOD_TYPE PERIOD_DAY |
AS_PERIOD_DAYS_N2 | FUNCTION-BASED NORMAL | NONUNIQUE | APPS_TS_SUMMARY | TRUNC("PERIOD_DAY") |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERIOD_SET_NAME | VARCHAR2 | (15) | Yes | period set name |
PERIOD_NAME | VARCHAR2 | (15) | Yes | period name |
PERIOD_DAY | DATE | Yes | period day | |
START_DATE | DATE | Yes | start date | |
END_DATE | DATE | Yes | end date | |
PERIOD_TYPE | VARCHAR2 | (15) | Yes | period type |
OBJECT_VERSION_NUMBER | NUMBER | Object Version Number |
Cut, paste (and edit) the following text to query this object:
SELECT PERIOD_SET_NAME
, PERIOD_NAME
, PERIOD_DAY
, START_DATE
, END_DATE
, PERIOD_TYPE
, OBJECT_VERSION_NUMBER
FROM OSM.AS_PERIOD_DAYS;
OSM.AS_PERIOD_DAYS does not reference any database object
OSM.AS_PERIOD_DAYS is referenced by following:
|
|
|