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_L_V

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

Mapping view for Time dimension in the datamart.

[View Source]

Columns

Name	Datatype	Length	Comments
ALL_SR_LEVEL_PK	NUMBER		Identifies the members at 'All Years' level
ALL_DESC	VARCHAR2	(4000)	Description of the members at the 'All Years' level
ALL_YEAR_SPAN	NUMBER		Time span of the members in the 'All Years' level
ALL_YEAR_END_DATE	DATE		End Date of the members at 'All Years' level
YEAR	VARCHAR2	(15)	Identifier of the members at the 'Year' level.
YEAR_END_DATE	DATE		Value of year end date attribute of the member at the 'Year' level.
YEAR_SPAN	NUMBER		Value of year span attribute of the member at the 'Year' level.
YEAR_DESCRIPTION	VARCHAR2	(80)	Description of the members at the 'Year' level.
FISCAL_YEAR	VARCHAR2	(15)	Identifier of the members at the 'Fiscal Year' level.
FISCAL_YEAR_END_DATE	DATE		Value of year end date attribute of the member at the 'Fiscal Year' level.
FISCAL_YEAR_SPAN	NUMBER		Value of year span attribute of the member at the 'Fiscal Year' level.
FISCAL_YEAR_DESCRIPTION	VARCHAR2	(80)	Description of the members at the 'Fiscal Year' level.
QUARTER	VARCHAR2	(15)	Identifier of the members at the 'Quarter' level.
QUARTER_END_DATE	DATE		Value of quarter end date attribute of the member at the 'Quarter' level.
QUARTER_SPAN	NUMBER		Value of quarter span attribute of the member at the 'Quarter' level.
QUARTER_DESCRIPTION	VARCHAR2	(80)	Description of the members at the 'Quarter' level.
FISCAL_QUARTER	VARCHAR2	(15)	Identifier of the members at the 'Fiscal Quarter' level.
FISCAL_QUARTER_END_DATE	DATE		Value of quarter end date attribute of the member at the 'Fiscal Quarter' level.
FISCAL_QUARTER_SPAN	NUMBER		Value of quarter span attribute of the member at the 'Fiscal Quarter' level.
FISCAL_QUARTER_DESCRIPTION	VARCHAR2	(80)	Description of the members at the 'Fiscal Quarter' level.
MONTH	VARCHAR2	(15)	Identifier of the members at the 'Month' level.
MONTH_END_DATE	DATE		Value of month end date attribute of the member at the 'Month' level.
MONTH_SPAN	NUMBER		Value of month span attribute of the member at the 'Month' level.
MONTH_DESCRIPTION	VARCHAR2	(80)	Description of the members at the 'Month' level.
FISCAL_MONTH	VARCHAR2	(15)	Identifier of the members at the 'Fiscal Month' level.
FISCAL_MONTH_END_DATE	DATE		Value of month end date attribute of the member at the 'Fiscal Month' level.
FISCAL_MONTH_SPAN	NUMBER		Value of month span attribute of the member at the 'Fiscal Month' level.
FISCAL_MONTH_DESCRIPTION	VARCHAR2	(80)	Description of the members at the 'Fiscal Month' level.
WEEK	VARCHAR2	(80)	Identifier of the members at the 'Week' level.
WEEK_END_DATE	DATE		Value of week end date attribute of the member at the 'Week' level.
WEEK_SPAN	NUMBER		Value of week span attribute of the member at the 'Week' level.
WEEK_DESCRIPTION	VARCHAR2	(80)	Description of the members at the 'Week' level.
FISCAL_WEEK	VARCHAR2	(80)	Identifier of the members at the 'Fiscal Week' level.
FISCAL_WEEK_END_DATE	DATE		Value of week end date attribute of the member at the 'Fiscal Week' level.
FISCAL_WEEK_SPAN	NUMBER		Value of week span attribute of the member at the 'Fiscal Week' level.
FISCAL_WEEK_DESCRIPTION	VARCHAR2	(80)	Description of the members at the 'Fiscal Week' level.
DAY	DATE		Identifier of the members at the 'Day' level.
DAY_SPAN	NUMBER		Value of day span attribute of the member at the 'Day' level.
DAY_DESCRIPTION	VARCHAR2	(80)	Description of the members at the 'Day' level.

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
FROM APPS.QPR_TIME_ALLHIER_L_V;

Dependencies

[top of page]

APPS.QPR_TIME_ALLHIER_L_V references the following:

APPS: QPR_MAINTAIN_AW - show dependent code; QPR_PRICE_PLANS_VL; QPR_SR_UTIL - show dependent code; QPR_TIME

APPS.QPR_TIME_ALLHIER_L_V is not referenced by any database object