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_DIMENSIONS_VL

Object Details

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

ZPB Dimensions with their name labels for the current user language. Language determined by the userenv('LANG') variable

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DIMENSION_ID	NUMBER		Yes	Primary key of zpb_dimensions table
BUS_AREA_ID	NUMBER		Yes	Business Area Id
NAME	VARCHAR2	(240)		Dimension name
AW_NAME	VARCHAR2	(30)		Dimension name in the workspace
DEFAULT_HIER	VARCHAR2	(60)		Name of default hierarchy for dimension
DEFAULT_MEMBER	VARCHAR2	(60)		Name of default dimension member
DIM_CODE	VARCHAR2	(30)		Dimension Code
DIM_TYPE	VARCHAR2	(30)		Dimension Type : (LINE, ORG, TIME, OTHER)
EPB_ID	VARCHAR2	(30)		EPB Id
IS_CURRENCY_DIM	VARCHAR2	(3)		Currency Dimension Flag
IS_DATA_DIM	VARCHAR2	(3)		Data Dimension Flag
IS_OWNER_DIM	VARCHAR2	(3)		Owner Dimension Flag
PERS_CWM_NAME	VARCHAR2	(60)		CWM name of dimension in the personal workspace
PERS_TABLE_ID	NUMBER			Foreign key into zpb_tables table linking the olap dimension-table for this dimension in the personal workspace
SHAR_CWM_NAME	VARCHAR2	(60)		CWM name of dimension in the shared workspace
SHAR_TABLE_ID	NUMBER			Foreign key into zpb_tables table linking the olap dimension-table for this dimension in the shared workspace
ANNOTATION_DIM	VARCHAR2	(30)		Name of annotation dimension for this dimension
CREATED_BY	NUMBER	(15)	Yes	Who Column
CREATION_DATE	DATE		Yes	Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Who Column
LAST_UPDATE_DATE	DATE		Yes	Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Who Column
PLURAL_NAME	VARCHAR2	(240)		Plural Name
PLURAL_LONG_NAME	VARCHAR2	(240)		Plural Long Name
LONG_NAME	VARCHAR2	(240)		Long Name

Query Text

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


SELECT DIMENSION_ID
,      BUS_AREA_ID
,      NAME
,      AW_NAME
,      DEFAULT_HIER
,      DEFAULT_MEMBER
,      DIM_CODE
,      DIM_TYPE
,      EPB_ID
,      IS_CURRENCY_DIM
,      IS_DATA_DIM
,      IS_OWNER_DIM
,      PERS_CWM_NAME
,      PERS_TABLE_ID
,      SHAR_CWM_NAME
,      SHAR_TABLE_ID
,      ANNOTATION_DIM
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PLURAL_NAME
,      PLURAL_LONG_NAME
,      LONG_NAME
FROM APPS.ZPB_DIMENSIONS_VL;

Dependencies

[top of page]

APPS.ZPB_DIMENSIONS_VL references the following:

APPS: ZPB_DIMENSIONS; ZPB_DIMENSIONS_TL

APPS.ZPB_DIMENSIONS_VL is referenced by following:

APPS: ZPB_BUSAREA_VAL - show dependent code; ZPB_DEBUG - show dependent code; ZPB_LAB_ATTRIBS_SCOPE_V; ZPB_LAB_ATTRIBS_V; ZPB_LAB_DIMLEVELS_SCOPE_V; ZPB_LAB_DIMS_V; ZPB_LAB_HIERARCHIES_SCOPE_V; ZPB_LAB_HIERARCHIES_V; ZPB_LAB_LEVELS_SCOPE_V; ZPB_LAB_LEVELS_V; ZPB_MD_LABELS_V; ZPB_OS_ATTRIBUTES_V; ZPB_OS_DIMENSIONS_V; ZPB_OS_MEAS_DIMS_V