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.QPR_TIME_ALLHIER_V

Object Details

Object Name:	QPR_TIME_ALLHIER_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
ALL_SR_LEVEL_PK	NUMBER		Identifies the members of the 'All Years' level
ALL_DESC	VARCHAR2	(4000)	Description of the members in 'All Years' level
ALL_YEAR_SPAN	NUMBER		Time span of the members at 'All Years' level
ALL_YEAR_END_DATE	DATE		End date of the members at 'All Years' level
YEAR	VARCHAR2	(15)
YEAR_END_DATE	DATE
YEAR_SPAN	NUMBER
YEAR_DESCRIPTION	VARCHAR2	(80)
FISCAL_YEAR	VARCHAR2	(15)
FISCAL_YEAR_END_DATE	DATE
FISCAL_YEAR_SPAN	NUMBER
FISCAL_YEAR_DESCRIPTION	VARCHAR2	(80)
QUARTER	VARCHAR2	(15)
QUARTER_END_DATE	DATE
QUARTER_SPAN	NUMBER
QUARTER_DESCRIPTION	VARCHAR2	(80)
FISCAL_QUARTER	VARCHAR2	(15)
FISCAL_QUARTER_END_DATE	DATE
FISCAL_QUARTER_SPAN	NUMBER
FISCAL_QUARTER_DESCRIPTION	VARCHAR2	(80)
MONTH	VARCHAR2	(15)
MONTH_END_DATE	DATE
MONTH_SPAN	NUMBER
MONTH_DESCRIPTION	VARCHAR2	(80)
FISCAL_MONTH	VARCHAR2	(15)
FISCAL_MONTH_END_DATE	DATE
FISCAL_MONTH_SPAN	NUMBER
FISCAL_MONTH_DESCRIPTION	VARCHAR2	(80)
WEEK	VARCHAR2	(80)
WEEK_END_DATE	DATE
WEEK_SPAN	NUMBER
WEEK_DESCRIPTION	VARCHAR2	(80)
FISCAL_WEEK	VARCHAR2	(80)
FISCAL_WEEK_END_DATE	DATE
FISCAL_WEEK_SPAN	NUMBER
FISCAL_WEEK_DESCRIPTION	VARCHAR2	(80)
DAY	DATE
DAY_SPAN	NUMBER
DAY_DESCRIPTION	VARCHAR2	(80)
INSTANCE_ID	NUMBER

Query Text

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


SELECT ALL_SR_LEVEL_PK
,      ALL_DESC
,      ALL_YEAR_SPAN
,      ALL_YEAR_END_DATE
,      YEAR
,      YEAR_END_DATE
,      YEAR_SPAN
,      YEAR_DESCRIPTION
,      FISCAL_YEAR
,      FISCAL_YEAR_END_DATE
,      FISCAL_YEAR_SPAN
,      FISCAL_YEAR_DESCRIPTION
,      QUARTER
,      QUARTER_END_DATE
,      QUARTER_SPAN
,      QUARTER_DESCRIPTION
,      FISCAL_QUARTER
,      FISCAL_QUARTER_END_DATE
,      FISCAL_QUARTER_SPAN
,      FISCAL_QUARTER_DESCRIPTION
,      MONTH
,      MONTH_END_DATE
,      MONTH_SPAN
,      MONTH_DESCRIPTION
,      FISCAL_MONTH
,      FISCAL_MONTH_END_DATE
,      FISCAL_MONTH_SPAN
,      FISCAL_MONTH_DESCRIPTION
,      WEEK
,      WEEK_END_DATE
,      WEEK_SPAN
,      WEEK_DESCRIPTION
,      FISCAL_WEEK
,      FISCAL_WEEK_END_DATE
,      FISCAL_WEEK_SPAN
,      FISCAL_WEEK_DESCRIPTION
,      DAY
,      DAY_SPAN
,      DAY_DESCRIPTION
,      INSTANCE_ID
FROM APPS.QPR_TIME_ALLHIER_V;