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_PERFORMANCE_MEASURES

Object Details

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

View Type

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

BISFV_PERFORMANCE_MEASURES is the full view which duplicates all the columns and expands lookups and foreign keys for the table BIS_INDICATORS.
Full views are used as a one-stop template for building up ad-hoc queries.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
MEASURE_ID	NUMBER		Yes	Performance Measure ID
MEASURE_SHORT_NAME	VARCHAR2	(30)	Yes	Short Name for Performance Measure
MEASURE_NAME	VARCHAR2	(255)	Yes	Performance Measure Name
DESCRIPTION	VARCHAR2	(1024)		Performance Measure Description
DIMENSION1_ID	NUMBER			Dimension1 ID
DIMENSION1_SHORT_NAME	VARCHAR2	(30)		Dimension1 Short Name
DIMENSION1_NAME	VARCHAR2	(255)		Dimension1 Name
DIMENSION2_ID	NUMBER			Dimension2 ID
DIMENSION2_SHORT_NAME	VARCHAR2	(30)		Dimension2 Short Name
DIMENSION2_NAME	VARCHAR2	(255)		Dimension2 Name
DIMENSION3_ID	NUMBER			Dimension3 ID
DIMENSION3_SHORT_NAME	VARCHAR2	(30)		Dimension3 Short Name
DIMENSION3_NAME	VARCHAR2	(255)		Dimensions3 Name
DIMENSION4_ID	NUMBER			Dimension4 ID
DIMENSION4_SHORT_NAME	VARCHAR2	(30)		Dimension4 Short Name
DIMENSION4_NAME	VARCHAR2	(255)		Dimension4 Name
DIMENSION5_ID	NUMBER			Dimension5 ID
DIMENSION5_SHORT_NAME	VARCHAR2	(30)		Dimension5 Short Name
DIMENSION5_NAME	VARCHAR2	(255)		Dimension5 Name
DIMENSION6_ID	NUMBER			Dimension6 ID
DIMENSION6_SHORT_NAME	VARCHAR2	(30)		Dimension6 Short Name
DIMENSION6_NAME	VARCHAR2	(255)		Dimension6 Name
DIMENSION7_ID	NUMBER			Dimension7 ID
DIMENSION7_SHORT_NAME	VARCHAR2	(30)		Dimension7 Short Name
DIMENSION7_NAME	VARCHAR2	(255)		Dimension7 Name
UNIT_OF_MEASURE_CLASS	VARCHAR2	(10)		Unit of Measure
ACTUAL_DATA_SOURCE_TYPE	VARCHAR2	(30)		Actual Data Source Type
ACTUAL_DATA_SOURCE	VARCHAR2	(240)		Actual Data Source
FUNCTION_NAME	VARCHAR2	(480)		Function Name
COMPARISON_SOURCE	VARCHAR2	(240)		Comparison Source
INCREASE_IN_MEASURE	VARCHAR2	(1)		Increase In Measure
ENABLE_LINK	VARCHAR2	(1)		Enable Link
DATASET_ID	NUMBER	(5)		Dataset Id
ENABLED	VARCHAR2	(1)		Enabled Flag
OBSOLETE	VARCHAR2	(1)		Obsolete Flag
MEASURE_TYPE	VARCHAR2	(30)		MEASURE_TYPE

Query Text

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


SELECT MEASURE_ID
,      MEASURE_SHORT_NAME
,      MEASURE_NAME
,      DESCRIPTION
,      DIMENSION1_ID
,      DIMENSION1_SHORT_NAME
,      DIMENSION1_NAME
,      DIMENSION2_ID
,      DIMENSION2_SHORT_NAME
,      DIMENSION2_NAME
,      DIMENSION3_ID
,      DIMENSION3_SHORT_NAME
,      DIMENSION3_NAME
,      DIMENSION4_ID
,      DIMENSION4_SHORT_NAME
,      DIMENSION4_NAME
,      DIMENSION5_ID
,      DIMENSION5_SHORT_NAME
,      DIMENSION5_NAME
,      DIMENSION6_ID
,      DIMENSION6_SHORT_NAME
,      DIMENSION6_NAME
,      DIMENSION7_ID
,      DIMENSION7_SHORT_NAME
,      DIMENSION7_NAME
,      UNIT_OF_MEASURE_CLASS
,      ACTUAL_DATA_SOURCE_TYPE
,      ACTUAL_DATA_SOURCE
,      FUNCTION_NAME
,      COMPARISON_SOURCE
,      INCREASE_IN_MEASURE
,      ENABLE_LINK
,      DATASET_ID
,      ENABLED
,      OBSOLETE
,      MEASURE_TYPE
FROM APPS.BISFV_PERFORMANCE_MEASURES;

Dependencies

[top of page]

APPS.BISFV_PERFORMANCE_MEASURES references the following:

APPS: BIS_DIMENSIONS; BIS_DIMENSIONS_TL; BIS_INDICATORS; BIS_INDICATORS_TL; BIS_INDICATOR_DIMENSIONS

APPS.BISFV_PERFORMANCE_MEASURES is referenced by following:

APPS: BSC_PMF_UI_WRAPPER - show dependent code