[Home] [Help] [Dependency Information]
Object Name: | MLOG$_MTH_445_PERIOD_CALEN |
---|---|
Object Type: | TABLE |
Owner: | MTH |
Subobject Name: | |
Status: | VALID |
snapshot log for master table MTH.MTH_445_PERIOD_CALENDAR
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DAY | DATE | |||
DAY_DESCRIPTION | VARCHAR2 | (2000) | ||
DAY_END_DATE | DATE | |||
DAY_ID | NUMBER | |||
DAY_NAME | VARCHAR2 | (25) | ||
DAY_OF_FISCAL_MONTH | NUMBER | |||
DAY_OF_FISCAL_QUARTER | NUMBER | |||
DAY_OF_FISCAL_WEEK | NUMBER | |||
DAY_OF_FISCAL_YEAR | NUMBER | |||
DAY_START_DATE | DATE | |||
DAY_TIME_SPAN | NUMBER | |||
DIMENSION_KEY | NUMBER | |||
FISCAL_MONTH_DESCRIPTION | VARCHAR2 | (2000) | ||
FISCAL_MONTH_END_DATE | DATE | |||
FISCAL_MONTH_NAME | VARCHAR2 | (25) | ||
FISCAL_MONTH_START_DATE | DATE | |||
FISCAL_MONTH_TIME_SPAN | NUMBER | |||
FISCAL_QUARTER_DESCRIPTION | VARCHAR2 | (2000) | ||
FISCAL_QUARTER_END_DATE | DATE | |||
FISCAL_QUARTER_ID | NUMBER | |||
FISCAL_QUARTER_NAME | VARCHAR2 | (25) | ||
FISCAL_QUARTER_START_DATE | DATE | |||
FISCAL_QUARTER_TIME_SPAN | NUMBER | |||
FISCAL_WEEK_DESCRIPTION | VARCHAR2 | (2000) | ||
FISCAL_WEEK_END_DATE | DATE | |||
FISCAL_WEEK_ID | NUMBER | |||
FISCAL_WEEK_NAME | VARCHAR2 | (25) | ||
FISCAL_WEEK_START_DATE | DATE | |||
FISCAL_WEEK_TIME_SPAN | NUMBER | |||
FISCAL_YEAR_DESCRIPTION | VARCHAR2 | (2000) | ||
FISCAL_YEAR_END_DATE | DATE | |||
FISCAL_YEAR_ID | NUMBER | |||
FISCAL_YEAR_NAME | VARCHAR2 | (25) | ||
FISCAL_YEAR_START_DATE | DATE | |||
FISCAL_YEAR_TIME_SPAN | NUMBER | |||
FIS_MONTH_NUMBER | NUMBER | |||
FIS_QUARTER_NUMBER | NUMBER | |||
FIS_WEEK_NUMBER | NUMBER | |||
FIS_YEAR_NUMBER | NUMBER | |||
JULIAN_DATE | NUMBER | |||
MONTH_OF_FISCAL_QUARTER | NUMBER | |||
MONTH_OF_FISCAL_YEAR | NUMBER | |||
QUARTER_OF_FISCAL_YEAR | NUMBER | |||
WEEK_OF_FISCAL_MONTH | NUMBER | |||
WEEK_OF_FISCAL_QUARTER | NUMBER | |||
WEEK_OF_FISCAL_YEAR | NUMBER | |||
M_ROW$$ | VARCHAR2 | (255) | ||
SEQUENCE$$ | NUMBER | |||
SNAPTIME$$ | DATE | |||
DMLTYPE$$ | VARCHAR2 | (1) | ||
OLD_NEW$$ | VARCHAR2 | (1) | ||
CHANGE_VECTOR$$ | RAW | (255) | ||
XID$$ | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT DAY
, DAY_DESCRIPTION
, DAY_END_DATE
, DAY_ID
, DAY_NAME
, DAY_OF_FISCAL_MONTH
, DAY_OF_FISCAL_QUARTER
, DAY_OF_FISCAL_WEEK
, DAY_OF_FISCAL_YEAR
, DAY_START_DATE
, DAY_TIME_SPAN
, DIMENSION_KEY
, FISCAL_MONTH_DESCRIPTION
, FISCAL_MONTH_END_DATE
, FISCAL_MONTH_NAME
, FISCAL_MONTH_START_DATE
, FISCAL_MONTH_TIME_SPAN
, FISCAL_QUARTER_DESCRIPTION
, FISCAL_QUARTER_END_DATE
, FISCAL_QUARTER_ID
, FISCAL_QUARTER_NAME
, FISCAL_QUARTER_START_DATE
, FISCAL_QUARTER_TIME_SPAN
, FISCAL_WEEK_DESCRIPTION
, FISCAL_WEEK_END_DATE
, FISCAL_WEEK_ID
, FISCAL_WEEK_NAME
, FISCAL_WEEK_START_DATE
, FISCAL_WEEK_TIME_SPAN
, FISCAL_YEAR_DESCRIPTION
, FISCAL_YEAR_END_DATE
, FISCAL_YEAR_ID
, FISCAL_YEAR_NAME
, FISCAL_YEAR_START_DATE
, FISCAL_YEAR_TIME_SPAN
, FIS_MONTH_NUMBER
, FIS_QUARTER_NUMBER
, FIS_WEEK_NUMBER
, FIS_YEAR_NUMBER
, JULIAN_DATE
, MONTH_OF_FISCAL_QUARTER
, MONTH_OF_FISCAL_YEAR
, QUARTER_OF_FISCAL_YEAR
, WEEK_OF_FISCAL_MONTH
, WEEK_OF_FISCAL_QUARTER
, WEEK_OF_FISCAL_YEAR
, M_ROW$$
, SEQUENCE$$
, SNAPTIME$$
, DMLTYPE$$
, OLD_NEW$$
, CHANGE_VECTOR$$
, XID$$
FROM MTH.MLOG$_MTH_445_PERIOD_CALEN;
MTH.MLOG$_MTH_445_PERIOD_CALEN does not reference any database object
MTH.MLOG$_MTH_445_PERIOD_CALEN is referenced by following:
|
|
|