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_445_PERIOD_CALENDAR

Object Details

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

This table stores 445/544 period calendar

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTH_445_PERIOD_CALENDAR_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DAY
MTH_445_PERIOD_CALENDAR_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	DIMENSION_KEY

Columns

Name	Datatype	Length	Mandatory	Comments
DIMENSION_KEY	NUMBER		Yes	Hierarchy identifier
DAY_START_DATE	DATE			Day start date
DAY_OF_FISCAL_YEAR	NUMBER			Day of the fiscal year
JULIAN_DATE	NUMBER			Unique julian date identifier
DAY_OF_FISCAL_WEEK	NUMBER			Day of the fiscal week
DAY_TIME_SPAN	NUMBER			Time span for the day
DAY	DATE			Report date
DAY_ID	NUMBER			Day identifier
DAY_DAY_CODE	NUMBER			Day code
DAY_DESCRIPTION	VARCHAR2	(2000)		Description for Day
DAY_NAME	VARCHAR2	(25)		Day name
DAY_END_DATE	DATE			Day end date
DAY_OF_FISCAL_QUARTER	NUMBER			Day of the fiscal quarter
DAY_OF_FISCAL_MONTH	NUMBER			Day of the fiscal month
FISCAL_WEEK_START_DATE	DATE			Fiscal week start date
FISCAL_WEEK_FIS_WEEK_CODE	NUMBER			Fiscal week code
FISCAL_WEEK_DESCRIPTION	VARCHAR2	(2000)		Description for fiscal week
WEEK_OF_FISCAL_MONTH	NUMBER			Week of the fiscal month
FISCAL_WEEK_TIME_SPAN	NUMBER			Time span for the fiscal week
WEEK_OF_FISCAL_YEAR	NUMBER			Week of the fiscal year
FIS_WEEK_NUMBER	NUMBER			Fiscal week number
FISCAL_WEEK_END_DATE	DATE			Fiscal week end date
FISCAL_WEEK_ID	NUMBER			Fiscal week identifier
FISCAL_WEEK_NAME	VARCHAR2	(25)		Fiscal week name
WEEK_OF_FISCAL_QUARTER	NUMBER			Week of the fiscal quarter
FISCAL_MONTH_START_DATE	DATE			Fiscal month start date
FISCAL_MONTH_FIS_MONTH_CODE	NUMBER			Fiscal month code
FISCAL_MONTH_DESCRIPTION	VARCHAR2	(2000)		Description of the fiscal month
MONTH_OF_FISCAL_QUARTER	NUMBER			Month of the fiscal quarter
FISCAL_MONTH_END_DATE	DATE			Fiscal month end date
FISCAL_MONTH_ID	NUMBER			Fiscal month identifier
FISCAL_MONTH_NAME	VARCHAR2	(25)		Fiscal month name
FIS_MONTH_NUMBER	NUMBER			Fiscal month number
FISCAL_MONTH_TIME_SPAN	NUMBER			Time span for the fiscal month
MONTH_OF_FISCAL_YEAR	NUMBER			Month of the fiscal year
FISCAL_QUARTER_TIME_SPAN	NUMBER			Time span for the fiscal quarter
QUARTER_OF_FISCAL_YEAR	NUMBER			Quarter of the fiscal year
FISCAL_QUARTER_FIS_QUARTER_CO	NUMBER			Fiscal quarter code
FIS_QUARTER_NUMBER	NUMBER			Fiscal quarter number
FISCAL_QUARTER_NAME	VARCHAR2	(25)		Fiscal quarter number
FISCAL_QUARTER_END_DATE	DATE			Fiscal quarter name
FISCAL_QUARTER_ID	NUMBER			Fiscal quarter identifier
FISCAL_QUARTER_DESCRIPTION	VARCHAR2	(2000)		Description for fiscal quarter
FISCAL_QUARTER_START_DATE	DATE			Fiscal quarter start date
FISCAL_YEAR_ID	NUMBER			Fiscal year identifier
FISCAL_YEAR_NAME	VARCHAR2	(25)		Fiscal year name
FIS_YEAR_NUMBER	NUMBER			Fiscal year number
FISCAL_YEAR_START_DATE	DATE			Fiscal year start date
FISCAL_YEAR_TIME_SPAN	NUMBER			Time span for the fiscal year
FISCAL_YEAR_FIS_YEAR_CODE	NUMBER			Fiscal year code
FISCAL_YEAR_DESCRIPTION	VARCHAR2	(2000)		Description for fiscal year
FISCAL_YEAR_END_DATE	DATE			Fiscal year end 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_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;

Dependencies

[top of page]

MTH.MTH_445_PERIOD_CALENDAR does not reference any database object

MTH.MTH_445_PERIOD_CALENDAR is referenced by following:

APPS: MTH_445_PERIOD_CAL_HOUR_MV; MTH_ENTITY_PLANNED_USAGE_MV
MTH: MTH_445_PERIOD_CALENDAR#