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]

TABLE: ZPB.ZPB_BUSAREA_DIMENSIONS

Object Details

Object Name:	ZPB_BUSAREA_DIMENSIONS
Object Type:	TABLE
Owner:	ZPB
Subobject Name:
Status:	VALID

List of the dimensions in each version of a Business Area

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ZPB_BUSAREA_DIMENSIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	LOGICAL_DIM_ID VERSION_ID DIMENSION_ID FUNC_DIM_SET_ID

Columns

Name	Datatype	Length	Mandatory	Comments
VERSION_ID	NUMBER	(10)	Yes	Whether to include ancestors or children of an included member in a hierarchy
LOGICAL_DIM_ID	NUMBER	(10)	Yes
DIMENSION_ID	NUMBER	(9)	Yes	Dimension ID
FUNC_DIM_SET_ID	NUMBER	(10)
AW_DIM_NAME	VARCHAR2	(30)	Yes
AW_DIM_PREFIX	VARCHAR2	(30)	Yes
DEFAULT_MEMBER_ID	VARCHAR2	(32)		Default Member ID
DEFAULT_MEMBER_VSET	NUMBER			Deafult member value set
DEFAULT_HIERARCHY_ID	NUMBER	(9)		Hierarchy ID
USE_MEMBER_CONDITIONS	VARCHAR2	(1)	Yes	Use member conditions?
CONDITIONS_INCL_DESC	VARCHAR2	(1)		Include descendants?
CONDITIONS_INCL_ANC	VARCHAR2	(1)		Include ancestors?
EPB_LINE_DIMENSION	VARCHAR2	(1)	Yes	Handled as an EPB Line Dimension?
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 VERSION_ID
,      LOGICAL_DIM_ID
,      DIMENSION_ID
,      FUNC_DIM_SET_ID
,      AW_DIM_NAME
,      AW_DIM_PREFIX
,      DEFAULT_MEMBER_ID
,      DEFAULT_MEMBER_VSET
,      DEFAULT_HIERARCHY_ID
,      USE_MEMBER_CONDITIONS
,      CONDITIONS_INCL_DESC
,      CONDITIONS_INCL_ANC
,      EPB_LINE_DIMENSION
,      LINE_HIERARCHY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM ZPB.ZPB_BUSAREA_DIMENSIONS;

Dependencies

[top of page]

ZPB.ZPB_BUSAREA_DIMENSIONS does not reference any database object

ZPB.ZPB_BUSAREA_DIMENSIONS is referenced by following:

APPS: ZPB_BUSAREA_DIMENSIONS