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_ENTITY_PLANNED_USAGE_HR_V

Object Details

Object Name:	MTH_ENTITY_PLANNED_USAGE_HR_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
HRID	ROWID	(10)	Hour Table Row ID
CRID	ROWID	(10)	445 Perid Calendar table Row ID
URID	ROWID	(10)	Entity Planned Usge Table Row ID
PERIOD_PROFILE	VARCHAR2	(7)	Period Profile
ENTITY_FK_KEY	NUMBER		Reference to entity
PLANNED_USAGE	NUMBER		Planned Usage
PERIOD_OF_USAGE	VARCHAR2	(25)	Period of Usage based on profile setting
USAGE_UOM	VARCHAR2	(30)	Unit of energy usage
DAY	DATE		Day
FISCAL_WEEK_NAME	VARCHAR2	(25)	Fiscal week name
FISCAL_QUARTER_NAME	VARCHAR2	(25)	Fiscal quarter name
FISCAL_YEAR_NAME	VARCHAR2	(25)	Fiscal year name
DAY_ID	NUMBER		Day identifier
FISCAL_WEEK_ID	NUMBER		Fiscal week identifier
FISCAL_QUARTER_ID	NUMBER		Fiscal quarter identifier
FISCAL_YEAR_ID	NUMBER		Fiscal year identifier
HOUR_FK_KEY	NUMBER		Reference to hour
FROM_TIME	DATE		From Time
TO_TIME	DATE		To Time
SUSTAIN_ASPECT_FK_KEY	NUMBER		Reference to Sustainability Aspect
ALLOCATED_PLANNED_USAGE	NUMBER		Allocated Planned Usage
UMARKER	NUMBER		Umarker

Query Text

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


SELECT HRID
,      CRID
,      URID
,      PERIOD_PROFILE
,      ENTITY_FK_KEY
,      PLANNED_USAGE
,      PERIOD_OF_USAGE
,      USAGE_UOM
,      DAY
,      FISCAL_WEEK_NAME
,      FISCAL_QUARTER_NAME
,      FISCAL_YEAR_NAME
,      DAY_ID
,      FISCAL_WEEK_ID
,      FISCAL_QUARTER_ID
,      FISCAL_YEAR_ID
,      HOUR_FK_KEY
,      FROM_TIME
,      TO_TIME
,      SUSTAIN_ASPECT_FK_KEY
,      ALLOCATED_PLANNED_USAGE
,      UMARKER
FROM APPS.MTH_ENTITY_PLANNED_USAGE_HR_V;

Dependencies

[top of page]

APPS.MTH_ENTITY_PLANNED_USAGE_HR_V references the following:

APPS: MTH_445_PERIOD_CALENDAR; MTH_ENTITY_PLANNED_USAGE; MTH_HOUR_D

APPS.MTH_ENTITY_PLANNED_USAGE_HR_V is not referenced by any database object