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: APPS.MTH_445_PERIOD_CAL_HOUR_MV#

Object Details

Object Name:	MTH_445_PERIOD_CAL_HOUR_MV#
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

ORGANIZATION HEAP PCTFREE 10 PCTUSED 40 INITRANS 10 MAXTRANS 255
NOCOMPRESS LOGGING
STORAGE( INITIAL 16384 NEXT 65536 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 4 FREELIST GROUPS 4
BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "APPS_TS_SUMMARY"
BUILD DEFERRED
USING INDEX
REFRESH FORCE ON DEMAND
USING DEFAULT LOCAL ROLLBACK SEGMENT
USING ENFORCED CONSTRAINTS DISABLE QUERY REWRITE

[View Source]

Columns

Name	Datatype	Length	Mandatory
DAY	DATE
DAY_DESCRIPTION	VARCHAR2	(2000)
DAY_END_DATE	DATE
DAY_NAME	VARCHAR2	(25)
DAY_OF_FISCAL_MONTH	NUMBER
DAY_OF_FISCAL_QUARTER	NUMBER
DAY_OF_FISCAL_WEEK	NUMBER
DAY_OF_FISCAL_YEAR	NUMBER
DAY_START_DATE	DATE
DAY_TIME_SPAN	NUMBER
DIMENSION_KEY	NUMBER		Yes
FIS_MONTH_NUMBER	NUMBER
FIS_QUARTER_NUMBER	NUMBER
FIS_WEEK_NUMBER	NUMBER
FIS_YEAR_NUMBER	NUMBER
FISCAL_MONTH_DESCRIPTION	VARCHAR2	(2000)
FISCAL_MONTH_END_DATE	DATE
FISCAL_MONTH_NAME	VARCHAR2	(25)
FISCAL_MONTH_START_DATE	DATE
FISCAL_MONTH_TIME_SPAN	NUMBER
FISCAL_QUARTER_DESCRIPTION	VARCHAR2	(2000)
FISCAL_QUARTER_END_DATE	DATE
FISCAL_QUARTER_NAME	VARCHAR2	(25)
FISCAL_QUARTER_START_DATE	DATE
FISCAL_QUARTER_TIME_SPAN	NUMBER
FISCAL_WEEK_DESCRIPTION	VARCHAR2	(2000)
FISCAL_WEEK_END_DATE	DATE
FISCAL_WEEK_NAME	VARCHAR2	(25)
FISCAL_WEEK_START_DATE	DATE
FISCAL_WEEK_TIME_SPAN	NUMBER
FISCAL_YEAR_DESCRIPTION	VARCHAR2	(2000)
FISCAL_YEAR_END_DATE	DATE
FISCAL_YEAR_NAME	VARCHAR2	(25)
FISCAL_YEAR_START_DATE	DATE
FISCAL_YEAR_TIME_SPAN	NUMBER
JULIAN_DATE	NUMBER
MONTH_OF_FISCAL_QUARTER	NUMBER
MONTH_OF_FISCAL_YEAR	NUMBER
QUARTER_OF_FISCAL_YEAR	NUMBER
WEEK_OF_FISCAL_MONTH	NUMBER
WEEK_OF_FISCAL_QUARTER	NUMBER
WEEK_OF_FISCAL_YEAR	NUMBER
HOUR_PK_KEY	NUMBER		Yes
FROM_TIME	DATE
TO_TIME	DATE
HOUR_PK	VARCHAR2	(120)	Yes
CROWID	ROWID	(10)
HROWID	ROWID	(10)

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# references the following:

APPS: MTH_445_PERIOD_CALENDAR; MTH_HOUR_D

APPS.MTH_445_PERIOD_CAL_HOUR_MV# is not referenced by any database object