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]

TABLE: MTH.MTH_GREGORIAN_CALENDAR

Object Details

Object Name:	MTH_GREGORIAN_CALENDAR
Object Type:	TABLE
Owner:	MTH
FND Design Data:	MTH.MTH_GREGORIAN_CALENDAR
Subobject Name:
Status:	VALID

This table stores gregorian calendar

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTH_GREGORIAN_CALENDAR_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DIMENSION_KEY
MTH_GREGORIAN_CALENDAR_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CALENDAR_MONTH_NAME DAY_ID CALENDAR_MONTH_ID
MTH_GREGORIAN_CALENDAR_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DAY DAY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DIMENSION_KEY	NUMBER		Yes	Hierarchy identifier
DAY_DESCRIPTION	VARCHAR2	(2000)		Description for Day
DAY_NAME	VARCHAR2	(25)		Day name
DAY_START_DATE	DATE			Day start date
DAY	DATE			Report date
DAY_END_DATE	DATE			Day end date
DAY_OF_CAL_YEAR	NUMBER			Day of the calendar year
DAY_ID	NUMBER			Day identifier
DAY_OF_CAL_WEEK	NUMBER			Day of the calendar week
DAY_OF_CAL_QUARTER	NUMBER			Day of the calendar quarter
JULIAN_DATE	NUMBER			Unique Julian date identifier
DAY_TIME_SPAN	NUMBER			Time span for the day
DAY_OF_CAL_MONTH	NUMBER			Day of the calendar month
DAY_DAY_CODE	NUMBER			Day code
CALENDAR_MONTH_ID	NUMBER			Calendar month identifier
MONTH_OF_YEAR	NUMBER			Month of the calendar year
CALENDAR_MONTH_DESCRIPTION	VARCHAR2	(2000)		Description for calendar month
CAL_MONTH_NUMBER	NUMBER			Calendar month number
CALENDAR_MONTH_TIME_SPAN	NUMBER			Time span for the calendar month
CALENDAR_MONTH_START_DATE	DATE			Calendar month start date
CALENDAR_MONTH_CAL_MONTH_CODE	NUMBER			Calendar month code
CALENDAR_MONTH_NAME	VARCHAR2	(25)		Calendar month name
MONTH_OF_QUARTER	NUMBER			Month of the quarter
CALENDAR_MONTH_END_DATE	DATE			Calendar month end date
CALENDAR_QUARTER_TIME_SPAN	NUMBER			Time span for the calendar quarter
CALENDAR_QUART_CAL_QUARTER_CO	NUMBER			Calendar quarter code
CALENDAR_QUARTER_START_DATE	DATE			Calendar quarter start date
CALENDAR_QUARTER_END_DATE	DATE			Calendar quarter end date
CALENDAR_QUARTER_ID	NUMBER			Calendar quarter identifier
CALENDAR_QUARTER_DESCRIPTION	VARCHAR2	(2000)		Description for calendar quarter
CAL_QUARTER_NUMBER	NUMBER			Calendar quarter number
CALENDAR_QUARTER_NAME	VARCHAR2	(25)		Calendar quarter name
QUARTER_OF_YEAR	NUMBER			Quarter of the year
CALENDAR_YEAR_END_DATE	DATE			Calendar year end date
CALENDAR_YEAR_ID	NUMBER			Calendar year identifier
CAL_YEAR_NUMBER	NUMBER			Calendar year number
CALENDAR_YEAR_NAME	VARCHAR2	(25)		Calendar year name
CALENDAR_YEAR_TIME_SPAN	NUMBER			Time span for the calendar year
CALENDAR_YEAR_CAL_YEAR_CODE	NUMBER			Calendar year code
CALENDAR_YEAR_DESCRIPTION	VARCHAR2	(2000)		Calendar year description
CALENDAR_YEAR_START_DATE	DATE			Calendar year start date
CREATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
CREATION_DATE	DATE			Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column

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 does not reference any database object

MTH.MTH_GREGORIAN_CALENDAR is referenced by following:

APPS: MTH_GREGORIAN_CALENDAR; MTH_MTL_CONS_IT_MV; MTH_MTL_PROD_IT_MV; MTH_RES_REQ_IT_MV; MTH_RES_TXN_IT_MV; MTH_SHIFT_GREGORIAN_DENORM_MV