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_DASHBOARD_MASTER_VL

Object Details

Object Name:	QPR_DASHBOARD_MASTER_VL
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.

This is a view of QPR_DASHBOARD_MASTER_B and QPR_DASHBOARD_MASTER_TL. Displays the dashboard definition for a user and price plan combination. Includes the translated columns of dashboard definition in the local language.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DASHBOARD_ID	NUMBER		Yes	Unique Identifier for the Dashboard
DASHBOARD_NAME	VARCHAR2	(240)		Name of the dashboard, translated to the local language of the user.
USER_ID	NUMBER	(15)		User ID to which the dashboard belongs
PLAN_ID	NUMBER			Price Plan to which the Dashboard belongs
DASHBOARD_TYPE	VARCHAR2	(1)	Yes	This column denotes whether the entity is a dashboard template or a dashboard instance.'T' denotes a dashboard template and 'I' denotes a dashboard instance.
DEFAULT_FLAG	VARCHAR2	(1)	Yes	This column denotes whether the the entity is the default template/instance for the given combination of user_id and plan_id. Takes values 'Y'/'N'
SOURCE_TEMPLATE_ID	NUMBER			For an entity which is a dashbaord instance this column indicates the template from which the instance has been generated.
CREATION_DATE	DATE		Yes	Standard Who Column
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column

Query Text

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


SELECT DASHBOARD_ID
,      DASHBOARD_NAME
,      USER_ID
,      PLAN_ID
,      DASHBOARD_TYPE
,      DEFAULT_FLAG
,      SOURCE_TEMPLATE_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM APPS.QPR_DASHBOARD_MASTER_VL;

Dependencies

[top of page]

APPS.QPR_DASHBOARD_MASTER_VL references the following:

APPS: QPR_DASHBOARD_MASTER_B; QPR_DASHBOARD_MASTER_TL

APPS.QPR_DASHBOARD_MASTER_VL is not referenced by any database object