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_BUSAREA_DIMENSIONS_VL

Object Details

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

View Type

A Business Intelligence System view

Business Area Dimensions View

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		Row ID
VERSION_ID	NUMBER	(10)	Yes	Version ID
DIMENSION_ID	NUMBER	(9)	Yes	Dimension ID
LOGICAL_DIM_ID	NUMBER	(10)	Yes
FUNC_DIM_SET_ID	NUMBER	(10)
AW_DIM_NAME	VARCHAR2	(30)	Yes
AW_DIM_PREFIX	VARCHAR2	(30)	Yes
DIMENSION_TYPE	VARCHAR2	(80)	Yes	Dimension Type
DIMENSION_TYPE_CODE	VARCHAR2	(30)	Yes	Dimension Type Code
NAME	VARCHAR2	(150)		Dimension Name
DESCRIPTION	VARCHAR2	(255)		Dimension Description
DEFAULT_MEMBER_ID	VARCHAR2	(32)		Default Member ID (not used)
DEFAULT_MEMBER_VSET	NUMBER			Default Member Valut Set (not used)
DEFAULT_MEMBER_NAME	VARCHAR2	(4000)		Default Member Name (not used)
DEFAULT_MEMBER_DESC	VARCHAR2	(4000)		Default Member Description
DEFAULT_HIERARCHY_ID	NUMBER	(9)		Default Hierarchy ID
DEFAULT_HIERARCHY_NAME	VARCHAR2	(150)		Default Hierarchy Name
EPB_LINE_DIMENSION	VARCHAR2	(1)	Yes	Is the dimension handled as an EPB line dim
LINE_HIERARCHY	NUMBER	(9)		If the dimension is a EPB line dimension, the line hierarchy to use to make the multi-line hierarchy
CREATED_BY	NUMBER		Yes	who column
CREATION_DATE	DATE		Yes	who column
LAST_UPDATED_BY	NUMBER		Yes	who column
LAST_UPDATE_DATE	DATE		Yes	who column
LAST_UPDATE_LOGIN	NUMBER			who column

Query Text

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


SELECT ROW_ID
,      VERSION_ID
,      DIMENSION_ID
,      LOGICAL_DIM_ID
,      FUNC_DIM_SET_ID
,      AW_DIM_NAME
,      AW_DIM_PREFIX
,      DIMENSION_TYPE
,      DIMENSION_TYPE_CODE
,      NAME
,      DESCRIPTION
,      DEFAULT_MEMBER_ID
,      DEFAULT_MEMBER_VSET
,      DEFAULT_MEMBER_NAME
,      DEFAULT_MEMBER_DESC
,      DEFAULT_HIERARCHY_ID
,      DEFAULT_HIERARCHY_NAME
,      EPB_LINE_DIMENSION
,      LINE_HIERARCHY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.ZPB_BUSAREA_DIMENSIONS_VL;

Dependencies

[top of page]

APPS.ZPB_BUSAREA_DIMENSIONS_VL references the following:

APPS: FEM_DIMENSIONS_VL; FEM_FUNC_DIM_SETS_VL; FEM_OBJECT_CATALOG_VL; FEM_XDIM_DIMENSIONS; FND_LOOKUP_VALUES_VL; ZPB_BUSAREA_DIMENSIONS; ZPB_FEM_UTILS_PKG - show dependent code

APPS.ZPB_BUSAREA_DIMENSIONS_VL is referenced by following:

APPS: ZPB_BUSAREA_VAL - show dependent code