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

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

BISFV_DIMENSIONS is is the full view which duplicates all the columns and expands lookups and foreign keys for the table BIS_DIMENSIONS.
Full views are used as a one-stop template for building up ad-hoc queries; the user retains only thos columns fothe view which are pertinent to the report.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DIMENSION_ID	NUMBER		Yes	Dimension Defining Column
DIM_GRP_ID	NUMBER			Dimension Groupd Defining Column
APPLICATION_ID	NUMBER			Application Id
DIMENSION_SHORT_NAME	VARCHAR2	(30)	Yes	Short Name for the Dimensions
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
,      APPLICATION_ID
,      DIMENSION_SHORT_NAME
,      DIMENSION_NAME
,      DESCRIPTION
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM APPS.BISFV_DIMENSIONS;

Dependencies

[top of page]

APPS.BISFV_DIMENSIONS references the following:

APPS: BIS_DIMENSIONS; BIS_DIMENSIONS_TL

APPS.BISFV_DIMENSIONS is referenced by following:

APPS: BSC_PMF_UI_API_PUB - show dependent code