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

Object Details

Object Name:	BISBV_DIMENSIONS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BIS.BISBV_DIMENSIONS
Subobject Name:
Status:	VALID

View Type

MultiLingual view (a language resolved view of the data.)

BISBV_DIMENSIONS is is the business view which currently provides an exact copy of the table BIS_DIMENSIONS.
BIS_DIMENSIONS is a flat list of all dimensions used throughout the BIS product
A dimension represents a unique way of partitioning rows in a transaction table.
Examples of dimensions include time, geography, organization, and product.
A transaction usually happens at a well-defined time, at a well-defined place,
in a particular organizational unit.
.
Business Views are intended to provide a consistent interface for ad-hoc queries by providing simple table joins for over-normalized data and plain english column names for hard to undertand columns.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DIMENSION_ID	NUMBER		Yes	Dimension Defining Column
DIM_GRP_ID	NUMBER			Dimension Group Defining Column
DIMENSION_SHORT_NAME	VARCHAR2	(30)	Yes	Short Name for the Dimensions
APPLICATION_ID	NUMBER			Application Id
HIDE_IN_DESIGN	VARCHAR2	(1)		Flag to indicate whether the dimension is hidden in all designers.
DIMENSION_NAME	VARCHAR2	(255)	Yes	Long Name for the Dimension
DESCRIPTION	VARCHAR2	(1024)		Description for Dimension
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).

Query Text

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


SELECT DIMENSION_ID
,      DIM_GRP_ID
,      DIMENSION_SHORT_NAME
,      APPLICATION_ID
,      HIDE_IN_DESIGN
,      DIMENSION_NAME
,      DESCRIPTION
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM APPS.BISBV_DIMENSIONS;

Dependencies

[top of page]

APPS.BISBV_DIMENSIONS references the following:

APPS: BIS_DIMENSIONS; BIS_DIMENSIONS_TL

APPS.BISBV_DIMENSIONS is referenced by following:

APPS: BIS_DIMENSION_PVT - show dependent code; BIS_MEASURE_VALIDATE_PVT - show dependent code; BIS_TARGET_LEVEL_PVT - show dependent code