DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.BISBV_APPLICATION_MEASURES

Object Details
Object Name: BISBV_APPLICATION_MEASURES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBIS.BISBV_APPLICATION_MEASURES
Subobject Name:
Status: VALID

View Type

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


BISBV_APPLICATION_MEASURES is is the business view which currently provides an exact copy of the table BIS_APPLICATION_MEASURES.

BIS_APPLICATION MEASURES is a list of associations between individual Oracle applications and sets of performance measures relevant to the application.
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
MEASURE_ID NUMBER
Yes Performance Measure ID
MEASURE_SHORT_NAME VARCHAR2 (30) Yes Performance Measure Short Name
MEASURE_NAME VARCHAR2 (255) Yes Long Name for the Performance Measure
APPLICATION_ID NUMBER
Yes Application ID Column
OWNING_APPLICATION VARCHAR2 (1) Yes Flag to distinguish whether this application is the owner of the performance measure
DATASET_ID NUMBER (5)
Dataset_Id
Query Text

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


SELECT MEASURE_ID
,      MEASURE_SHORT_NAME
,      MEASURE_NAME
,      APPLICATION_ID
,      OWNING_APPLICATION
,      DATASET_ID
FROM APPS.BISBV_APPLICATION_MEASURES;

Dependencies

[top of page]

APPS.BISBV_APPLICATION_MEASURES references the following:

SchemaAPPS
SynonymBIS_APPLICATION_MEASURES
SynonymBIS_INDICATORS
SynonymBIS_INDICATORS_TL
APPS.BISBV_APPLICATION_MEASURES is referenced by following:

SchemaAPPS
Package BodyBIS_APPLICATION_MEASURE_PVT - show dependent code
Package BodyMST_CMP_KPIS - show dependent code