[Home] [Help] [Dependency Information]
Object Name: | MTH_445_PERIOD_CALENDAR# |
---|---|
Object Type: | VIEW |
Owner: | MTH |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DIMENSION_KEY | NUMBER | Yes | ||
DAY_START_DATE | DATE | |||
DAY_OF_FISCAL_YEAR | NUMBER | |||
JULIAN_DATE | NUMBER | |||
DAY_OF_FISCAL_WEEK | NUMBER | |||
DAY_TIME_SPAN | NUMBER | |||
DAY | DATE | |||
DAY_ID | NUMBER | |||
DAY_DAY_CODE | NUMBER | |||
DAY_DESCRIPTION | VARCHAR2 | (2000) | ||
DAY_NAME | VARCHAR2 | (25) | ||
DAY_END_DATE | DATE | |||
DAY_OF_FISCAL_QUARTER | NUMBER | |||
DAY_OF_FISCAL_MONTH | NUMBER | |||
FISCAL_WEEK_START_DATE | DATE | |||
FISCAL_WEEK_FIS_WEEK_CODE | NUMBER | |||
FISCAL_WEEK_DESCRIPTION | VARCHAR2 | (2000) | ||
WEEK_OF_FISCAL_MONTH | NUMBER | |||
FISCAL_WEEK_TIME_SPAN | NUMBER | |||
WEEK_OF_FISCAL_YEAR | NUMBER | |||
FIS_WEEK_NUMBER | NUMBER | |||
FISCAL_WEEK_END_DATE | DATE | |||
FISCAL_WEEK_ID | NUMBER | |||
FISCAL_WEEK_NAME | VARCHAR2 | (25) | ||
WEEK_OF_FISCAL_QUARTER | NUMBER | |||
FISCAL_MONTH_START_DATE | DATE | |||
FISCAL_MONTH_FIS_MONTH_CODE | NUMBER | |||
FISCAL_MONTH_DESCRIPTION | VARCHAR2 | (2000) | ||
MONTH_OF_FISCAL_QUARTER | NUMBER | |||
FISCAL_MONTH_END_DATE | DATE | |||
FISCAL_MONTH_ID | NUMBER | |||
FISCAL_MONTH_NAME | VARCHAR2 | (25) | ||
FIS_MONTH_NUMBER | NUMBER | |||
FISCAL_MONTH_TIME_SPAN | NUMBER | |||
MONTH_OF_FISCAL_YEAR | NUMBER | |||
FISCAL_QUARTER_TIME_SPAN | NUMBER | |||
QUARTER_OF_FISCAL_YEAR | NUMBER | |||
FISCAL_QUARTER_FIS_QUARTER_CO | NUMBER | |||
FIS_QUARTER_NUMBER | NUMBER | |||
FISCAL_QUARTER_NAME | VARCHAR2 | (25) | ||
FISCAL_QUARTER_END_DATE | DATE | |||
FISCAL_QUARTER_ID | NUMBER | |||
FISCAL_QUARTER_DESCRIPTION | VARCHAR2 | (2000) | ||
FISCAL_QUARTER_START_DATE | DATE | |||
FISCAL_YEAR_ID | NUMBER | |||
FISCAL_YEAR_NAME | VARCHAR2 | (25) | ||
FIS_YEAR_NUMBER | NUMBER | |||
FISCAL_YEAR_START_DATE | DATE | |||
FISCAL_YEAR_TIME_SPAN | NUMBER | |||
FISCAL_YEAR_FIS_YEAR_CODE | NUMBER | |||
FISCAL_YEAR_DESCRIPTION | VARCHAR2 | (2000) | ||
FISCAL_YEAR_END_DATE | DATE | |||
CREATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
LAST_UPDATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
LAST_UPDATE_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT DIMENSION_KEY
, DAY_START_DATE
, DAY_OF_FISCAL_YEAR
, JULIAN_DATE
, DAY_OF_FISCAL_WEEK
, DAY_TIME_SPAN
, DAY
, DAY_ID
, DAY_DAY_CODE
, DAY_DESCRIPTION
, DAY_NAME
, DAY_END_DATE
, DAY_OF_FISCAL_QUARTER
, DAY_OF_FISCAL_MONTH
, FISCAL_WEEK_START_DATE
, FISCAL_WEEK_FIS_WEEK_CODE
, FISCAL_WEEK_DESCRIPTION
, WEEK_OF_FISCAL_MONTH
, FISCAL_WEEK_TIME_SPAN
, WEEK_OF_FISCAL_YEAR
, FIS_WEEK_NUMBER
, FISCAL_WEEK_END_DATE
, FISCAL_WEEK_ID
, FISCAL_WEEK_NAME
, WEEK_OF_FISCAL_QUARTER
, FISCAL_MONTH_START_DATE
, FISCAL_MONTH_FIS_MONTH_CODE
, FISCAL_MONTH_DESCRIPTION
, MONTH_OF_FISCAL_QUARTER
, FISCAL_MONTH_END_DATE
, FISCAL_MONTH_ID
, FISCAL_MONTH_NAME
, FIS_MONTH_NUMBER
, FISCAL_MONTH_TIME_SPAN
, MONTH_OF_FISCAL_YEAR
, FISCAL_QUARTER_TIME_SPAN
, QUARTER_OF_FISCAL_YEAR
, FISCAL_QUARTER_FIS_QUARTER_CO
, FIS_QUARTER_NUMBER
, FISCAL_QUARTER_NAME
, FISCAL_QUARTER_END_DATE
, FISCAL_QUARTER_ID
, FISCAL_QUARTER_DESCRIPTION
, FISCAL_QUARTER_START_DATE
, FISCAL_YEAR_ID
, FISCAL_YEAR_NAME
, FIS_YEAR_NUMBER
, FISCAL_YEAR_START_DATE
, FISCAL_YEAR_TIME_SPAN
, FISCAL_YEAR_FIS_YEAR_CODE
, FISCAL_YEAR_DESCRIPTION
, FISCAL_YEAR_END_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
FROM MTH.MTH_445_PERIOD_CALENDAR#;
|
|
|