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

VIEW: APPS.BISBV_TARGET_LEVELS

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

View Type

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


BISBV_TARGET_LEVELS is the business view which provides information about the entity BIS_TARGET_LEVELS.
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 understand columns.


[View Source]

Columns
Name Datatype Length Mandatory Comments
TARGET_LEVEL_ID NUMBER
Yes Target Level ID Column
TARGET_LEVEL_SHORT_NAME VARCHAR2 (80) Yes Target Level Short Name
TARGET_LEVEL_NAME VARCHAR2 (80) Yes Target Level Name
DESCRIPTION VARCHAR2 (240)
Target Level Description
MEASURE_ID NUMBER
Yes Measure ID
ORG_LEVEL_ID NUMBER

No Longer Used
TIME_LEVEL_ID NUMBER

No Longer Used
DIMENSION1_LEVEL_ID NUMBER

Dimension1 Level ID
DIMENSION2_LEVEL_ID NUMBER

Dimension2 Level ID
DIMENSION3_LEVEL_ID NUMBER

Dimension3 Level ID
DIMENSION4_LEVEL_ID NUMBER

Dimension4 Level ID
DIMENSION5_LEVEL_ID NUMBER

Dimension5 Level ID
DIMENSION6_LEVEL_ID NUMBER

Dimension6 Level ID
DIMENSION7_LEVEL_ID NUMBER

Dimension7 Level ID
WORKFLOW_ITEM_TYPE VARCHAR2 (8)
The Workflow type attached to the dimension level combination
WORKFLOW_PROCESS_SHORT_NAME VARCHAR2 (30)
The Workflow process which belongs to the selected workflow item type and is assigned to the dimension level combination
DEFAULT_NOTIFY_RESP_ID NUMBER

No Longer Used
DEFAULT_NOTIFY_RESP_SHORT_NAME VARCHAR2 (100)
No Longer Used
COMPUTING_FUNCTION_ID NUMBER

Computing Function ID
REPORT_FUNCTION_ID NUMBER

No Longer Used
UNIT_OF_MEASURE VARCHAR2 (25)
No Longer Used
SYSTEM_FLAG VARCHAR2 (1)
No Longer Used
Query Text

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


SELECT TARGET_LEVEL_ID
,      TARGET_LEVEL_SHORT_NAME
,      TARGET_LEVEL_NAME
,      DESCRIPTION
,      MEASURE_ID
,      ORG_LEVEL_ID
,      TIME_LEVEL_ID
,      DIMENSION1_LEVEL_ID
,      DIMENSION2_LEVEL_ID
,      DIMENSION3_LEVEL_ID
,      DIMENSION4_LEVEL_ID
,      DIMENSION5_LEVEL_ID
,      DIMENSION6_LEVEL_ID
,      DIMENSION7_LEVEL_ID
,      WORKFLOW_ITEM_TYPE
,      WORKFLOW_PROCESS_SHORT_NAME
,      DEFAULT_NOTIFY_RESP_ID
,      DEFAULT_NOTIFY_RESP_SHORT_NAME
,      COMPUTING_FUNCTION_ID
,      REPORT_FUNCTION_ID
,      UNIT_OF_MEASURE
,      SYSTEM_FLAG
FROM APPS.BISBV_TARGET_LEVELS;

Dependencies

[top of page]

APPS.BISBV_TARGET_LEVELS references the following:

SchemaAPPS
SynonymBIS_TARGET_LEVELS
SynonymBIS_TARGET_LEVELS_TL
APPS.BISBV_TARGET_LEVELS is referenced by following:

SchemaAPPS
Package BodyBISVIEWER_PMF - show dependent code
Package BodyBIS_CONCURRENT_MANAGER_PVT - show dependent code
Package BodyBIS_INDICATOR_REGION_UI_PVT - show dependent code
Package BodyBIS_MEASURE_SECURITY_PVT - show dependent code
Package BodyBIS_PMF_DEFINER_WRAPPER_PVT - show dependent code
Package BodyBIS_PMF_PORTLET_UTIL - show dependent code
Package BodyBIS_PMV_PMF_PVT - show dependent code
Package BodyBIS_PORTLET_PMREGION - show dependent code
Package BodyBIS_TARGET_LEVEL_PVT - show dependent code
Package BodyBIS_TARGET_PVT - show dependent code
Package BodyBIS_TARGET_VALIDATE_PVT - show dependent code
Package BodyBIX_ALERT - show dependent code
Package BodyGL_BIS_ALERTS_PKG - show dependent code
Package BodyHR_BIS_ALERTS - show dependent code
Package BodyMST_CMP_KPIS - show dependent code
Package BodyPMI_COMMON_PKG - show dependent code
Package BodyWIP_BIS_UTZ_ALERT - show dependent code
Package BodyWIP_BIS_YDSP_ALERT - show dependent code