[Home] [Help] [Dependency Information]

TABLE: APPS.MTH_445_PERIOD_CAL_HOUR_MV

Object Details

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

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTH_445_PERIOD_CAL_HR_MV_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	HOUR_PK_KEY

Columns

Query Text

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

SELECT DAY
,      DAY_DESCRIPTION
,      DAY_END_DATE
,      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
,      FIS_MONTH_NUMBER
,      FIS_QUARTER_NUMBER
,      FIS_WEEK_NUMBER
,      FIS_YEAR_NUMBER
,      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_NAME
,      FISCAL_QUARTER_START_DATE
,      FISCAL_QUARTER_TIME_SPAN
,      FISCAL_WEEK_DESCRIPTION
,      FISCAL_WEEK_END_DATE
,      FISCAL_WEEK_NAME
,      FISCAL_WEEK_START_DATE
,      FISCAL_WEEK_TIME_SPAN
,      FISCAL_YEAR_DESCRIPTION
,      FISCAL_YEAR_END_DATE
,      FISCAL_YEAR_NAME
,      FISCAL_YEAR_START_DATE
,      FISCAL_YEAR_TIME_SPAN
,      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
,      HOUR_PK_KEY
,      FROM_TIME
,      TO_TIME
,      HOUR_PK
,      CROWID
,      HROWID
FROM APPS.MTH_445_PERIOD_CAL_HOUR_MV;

Dependencies

[top of page]

APPS.MTH_445_PERIOD_CAL_HOUR_MV does not reference any database object

APPS.MTH_445_PERIOD_CAL_HOUR_MV is referenced by following:

APPS

MTH_445_PERIOD_CAL_HOUR_MV