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

VIEW: APPS.BISFV_APPLICATION_MEASURES

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

View Type

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


BISFV_APPLICATION_MEASURES is is the full view which duplicates all the columns and expands lookups and foreign keys for the table BIS_APPLICATION_MEASURES.
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
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
APPLICATION_SHORT_NAME VARCHAR2 (50) Yes Application Short Name
APPLICATION_NAME VARCHAR2 (240) Yes Application Name
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
,      APPLICATION_SHORT_NAME
,      APPLICATION_NAME
,      OWNING_APPLICATION
,      DATASET_ID
FROM APPS.BISFV_APPLICATION_MEASURES;

Dependencies

[top of page]

APPS.BISFV_APPLICATION_MEASURES references the following:

SchemaAPPS
SynonymBIS_APPLICATION_MEASURES
SynonymBIS_INDICATORS
SynonymBIS_INDICATORS_TL
ViewFND_APPLICATION_VL
APPS.BISFV_APPLICATION_MEASURES is referenced by following:

SchemaAPPS
Package BodyBIS_APPLICATION_MEASURE_PVT - show dependent code