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

Object Details

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

This view replaces the zpb_session_metadata_labels table. It contains the labels for dimensions, hierarchies, levels, attributes, and measures. Before executing this query the following two environment variables should be initialized:sys_context('ZPB_CONTEXT', 'business_area_id') and userenv('Lang').

[View Source]

Columns

Name	Datatype	Length	Comments
OBJECT_TYPE	VARCHAR2	(9)	DIMENSION, HIERARCHY, LEVEL, ATTRIBUTE, or MEASURE
DIMENSION	VARCHAR2	(30)	Dimension name in the workspace
HIERARCHY	VARCHAR2	(30)	Name of hierarchy, where applicable
OBJECT_SHORT_LABEL	VARCHAR2	(255)	Short Label of Object
OBJECT_LONG_LABEL	VARCHAR2	(255)	Object Long Label
OBJECT_PLURAL_SHORT_LABEL	VARCHAR2	(255)	Object Plural Short Label
OBJECT_PLURAL_LONG_LABEL	VARCHAR2	(255)	Object Plural Long Label
OBJECT_SHAR_CWM_NAME	VARCHAR2	(60)	CWM name of object in the shared workspace
OBJECT_CWM_NAME	VARCHAR2	(240)	CWM name of object in the personal workspace
OBJECT_AW_NAME	VARCHAR2	(30)	Object name in the workspace
DIMENSION_ID	NUMBER		Primary key of zpb_dimensions table
DISPLAY_ORDER	NUMBER		Used to order objects for display

Query Text

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


SELECT OBJECT_TYPE
,      DIMENSION
,      HIERARCHY
,      OBJECT_SHORT_LABEL
,      OBJECT_LONG_LABEL
,      OBJECT_PLURAL_SHORT_LABEL
,      OBJECT_PLURAL_LONG_LABEL
,      OBJECT_SHAR_CWM_NAME
,      OBJECT_CWM_NAME
,      OBJECT_AW_NAME
,      DIMENSION_ID
,      DISPLAY_ORDER
FROM APPS.ZPB_MD_LABELS_V;

Dependencies

[top of page]

APPS.ZPB_MD_LABELS_V references the following:

APPS: ZPB_ATTRIBUTES_VL; ZPB_CUBES; ZPB_DIMENSIONS_VL; ZPB_HIERARCHIES; ZPB_HIERARCHIES_VL; ZPB_HIER_LEVEL; ZPB_LEVELS_VL; ZPB_MEASURES

APPS.ZPB_MD_LABELS_V is not referenced by any database object