eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: MTH.MTH_GREGORIAN_CALENDAR#

Object Details

Object Name:	MTH_GREGORIAN_CALENDAR#
Object Type:	VIEW
Owner:	MTH
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
DIMENSION_KEY	NUMBER		Yes
DAY_DESCRIPTION	VARCHAR2	(2000)
DAY_NAME	VARCHAR2	(25)
DAY_START_DATE	DATE
DAY	DATE
DAY_END_DATE	DATE
DAY_OF_CAL_YEAR	NUMBER
DAY_ID	NUMBER
DAY_OF_CAL_WEEK	NUMBER
DAY_OF_CAL_QUARTER	NUMBER
JULIAN_DATE	NUMBER
DAY_TIME_SPAN	NUMBER
DAY_OF_CAL_MONTH	NUMBER
DAY_DAY_CODE	NUMBER
CALENDAR_MONTH_ID	NUMBER
MONTH_OF_YEAR	NUMBER
CALENDAR_MONTH_DESCRIPTION	VARCHAR2	(2000)
CAL_MONTH_NUMBER	NUMBER
CALENDAR_MONTH_TIME_SPAN	NUMBER
CALENDAR_MONTH_START_DATE	DATE
CALENDAR_MONTH_CAL_MONTH_CODE	NUMBER
CALENDAR_MONTH_NAME	VARCHAR2	(25)
MONTH_OF_QUARTER	NUMBER
CALENDAR_MONTH_END_DATE	DATE
CALENDAR_QUARTER_TIME_SPAN	NUMBER
CALENDAR_QUART_CAL_QUARTER_CO	NUMBER
CALENDAR_QUARTER_START_DATE	DATE
CALENDAR_QUARTER_END_DATE	DATE
CALENDAR_QUARTER_ID	NUMBER
CALENDAR_QUARTER_DESCRIPTION	VARCHAR2	(2000)
CAL_QUARTER_NUMBER	NUMBER
CALENDAR_QUARTER_NAME	VARCHAR2	(25)
QUARTER_OF_YEAR	NUMBER
CALENDAR_YEAR_END_DATE	DATE
CALENDAR_YEAR_ID	NUMBER
CAL_YEAR_NUMBER	NUMBER
CALENDAR_YEAR_NAME	VARCHAR2	(25)
CALENDAR_YEAR_TIME_SPAN	NUMBER
CALENDAR_YEAR_CAL_YEAR_CODE	NUMBER
CALENDAR_YEAR_DESCRIPTION	VARCHAR2	(2000)
CALENDAR_YEAR_START_DATE	DATE
CREATED_BY	NUMBER	(15)
LAST_UPDATE_LOGIN	NUMBER	(15)
LAST_UPDATED_BY	NUMBER	(15)
CREATION_DATE	DATE
LAST_UPDATE_DATE	DATE

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DIMENSION_KEY
,      DAY_DESCRIPTION
,      DAY_NAME
,      DAY_START_DATE
,      DAY
,      DAY_END_DATE
,      DAY_OF_CAL_YEAR
,      DAY_ID
,      DAY_OF_CAL_WEEK
,      DAY_OF_CAL_QUARTER
,      JULIAN_DATE
,      DAY_TIME_SPAN
,      DAY_OF_CAL_MONTH
,      DAY_DAY_CODE
,      CALENDAR_MONTH_ID
,      MONTH_OF_YEAR
,      CALENDAR_MONTH_DESCRIPTION
,      CAL_MONTH_NUMBER
,      CALENDAR_MONTH_TIME_SPAN
,      CALENDAR_MONTH_START_DATE
,      CALENDAR_MONTH_CAL_MONTH_CODE
,      CALENDAR_MONTH_NAME
,      MONTH_OF_QUARTER
,      CALENDAR_MONTH_END_DATE
,      CALENDAR_QUARTER_TIME_SPAN
,      CALENDAR_QUART_CAL_QUARTER_CO
,      CALENDAR_QUARTER_START_DATE
,      CALENDAR_QUARTER_END_DATE
,      CALENDAR_QUARTER_ID
,      CALENDAR_QUARTER_DESCRIPTION
,      CAL_QUARTER_NUMBER
,      CALENDAR_QUARTER_NAME
,      QUARTER_OF_YEAR
,      CALENDAR_YEAR_END_DATE
,      CALENDAR_YEAR_ID
,      CAL_YEAR_NUMBER
,      CALENDAR_YEAR_NAME
,      CALENDAR_YEAR_TIME_SPAN
,      CALENDAR_YEAR_CAL_YEAR_CODE
,      CALENDAR_YEAR_DESCRIPTION
,      CALENDAR_YEAR_START_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
FROM MTH.MTH_GREGORIAN_CALENDAR#;

Dependencies

[top of page]

MTH.MTH_GREGORIAN_CALENDAR# references the following:

MTH: MTH_GREGORIAN_CALENDAR

MTH.MTH_GREGORIAN_CALENDAR# is referenced by following:

APPS: MTH_GREGORIAN_CALENDAR