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

VIEW: APPS.BISFV_TARGET_LEVELS

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

View Type

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


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


[View Source]

Columns
Name Datatype Length Mandatory Comments
TARGET_LEVEL_ID NUMBER
Yes Target Level ID
TARGET_LEVEL_SHORT_NAME VARCHAR2 (80) Yes Target Level Short Name
TARGET_LEVEL_NAME VARCHAR2 (80) Yes Target Level Name
DESCRIPTION VARCHAR2 (240)
Description of Target Level
MEASURE_ID NUMBER
Yes Performance Measure ID
DATASET_ID NUMBER (5)
Dataset_Id
MEASURE_SHORT_NAME VARCHAR2 (30) Yes Performance Measure Short Name
MEASURE_NAME VARCHAR2 (255) Yes Name of Performance Measure
ORG_LEVEL_ID NUMBER

No Longer Used
ORG_LEVEL_SHORT_NAME VARCHAR2 (30)
No Longer Used
ORG_LEVEL_NAME VARCHAR2 (4000)
No Longer Used
TIME_LEVEL_ID NUMBER

No Longer Used
TIME_LEVEL_SHORT_NAME VARCHAR2 (30)
No Longer Used
TIME_LEVEL_NAME VARCHAR2 (4000)
No Longer Used
DIMENSION1_LEVEL_ID NUMBER

Dimension Level1 ID
DIMENSION1_LEVEL_SHORT_NAME VARCHAR2 (30)
DImension Level1 Short Name
DIMENSION1_LEVEL_NAME VARCHAR2 (4000)
Dimension Level1 Name
DIMENSION2_LEVEL_ID NUMBER

Dimension Level2 ID
DIMENSION2_LEVEL_SHORT_NAME VARCHAR2 (30)
DImension Level2 Short Name
DIMENSION2_LEVEL_NAME VARCHAR2 (4000)
Dimension Level2 Name
DIMENSION3_LEVEL_ID NUMBER

Dimension Level3 ID
DIMENSION3_LEVEL_SHORT_NAME VARCHAR2 (30)
DImension Level3 Short Name
DIMENSION3_LEVEL_NAME VARCHAR2 (4000)
Dimension Level3 Name
DIMENSION4_LEVEL_ID NUMBER

Dimension Level4 ID
DIMENSION4_LEVEL_SHORT_NAME VARCHAR2 (30)
DImension Level4 Short Name
DIMENSION4_LEVEL_NAME VARCHAR2 (4000)
Dimension Level4 Name
DIMENSION5_LEVEL_ID NUMBER

Dimension Level5 ID
DIMENSION5_LEVEL_SHORT_NAME VARCHAR2 (30)
DImension Level5 Short Name
DIMENSION5_LEVEL_NAME VARCHAR2 (4000)
Dimension Level5 Name
DIMENSION6_LEVEL_ID NUMBER

Dimension Level6 ID
DIMENSION6_LEVEL_SHORT_NAME VARCHAR2 (30)
DImension Level6 Short Name
DIMENSION6_LEVEL_NAME VARCHAR2 (4000)
Dimension Level6 Name
DIMENSION7_LEVEL_ID NUMBER

Dimension Level7 ID
DIMENSION7_LEVEL_SHORT_NAME VARCHAR2 (30)
DImension Level7 Short Name
DIMENSION7_LEVEL_NAME VARCHAR2 (4000)
Dimension Level7 Name
WORKFLOW_ITEM_TYPE VARCHAR2 (8)
The Workflow type attached to the dimension level combination
WORKFLOW_PROCESS_SHORT_NAME VARCHAR2 (30)
The Workflow process short name which belongs to the selected workflow item type and is assigned to the dimension level combination
WORKFLOW_PROCESS_NAME VARCHAR2 (4000)
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
DEFAULT_NOTIFY_RESP_NAME VARCHAR2 (4000)
No Longer Used
COMPUTING_FUNCTION_ID NUMBER

Computing Function ID
COMPUTING_FUNCTION_NAME VARCHAR2 (4000)
Computing Function Name
COMPUTING_USER_FUNCTION_NAME VARCHAR2 (4000)
Computing Function Name
REPORT_FUNCTION_ID NUMBER

No Longer Used
REPORT_FUNCTION_NAME VARCHAR2 (4000)
No Longer Used
REPORT_USER_FUNCTION_NAME VARCHAR2 (4000)
No Longer Used
UNIT_OF_MEASURE VARCHAR2 (25)
Unit of Measure
SYSTEM_FLAG VARCHAR2 (1)
No Longer Used
SOURCE VARCHAR2 (30) Yes Source system for the dimension level such as. OLTP, EDW etc.
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
,      DATASET_ID
,      MEASURE_SHORT_NAME
,      MEASURE_NAME
,      ORG_LEVEL_ID
,      ORG_LEVEL_SHORT_NAME
,      ORG_LEVEL_NAME
,      TIME_LEVEL_ID
,      TIME_LEVEL_SHORT_NAME
,      TIME_LEVEL_NAME
,      DIMENSION1_LEVEL_ID
,      DIMENSION1_LEVEL_SHORT_NAME
,      DIMENSION1_LEVEL_NAME
,      DIMENSION2_LEVEL_ID
,      DIMENSION2_LEVEL_SHORT_NAME
,      DIMENSION2_LEVEL_NAME
,      DIMENSION3_LEVEL_ID
,      DIMENSION3_LEVEL_SHORT_NAME
,      DIMENSION3_LEVEL_NAME
,      DIMENSION4_LEVEL_ID
,      DIMENSION4_LEVEL_SHORT_NAME
,      DIMENSION4_LEVEL_NAME
,      DIMENSION5_LEVEL_ID
,      DIMENSION5_LEVEL_SHORT_NAME
,      DIMENSION5_LEVEL_NAME
,      DIMENSION6_LEVEL_ID
,      DIMENSION6_LEVEL_SHORT_NAME
,      DIMENSION6_LEVEL_NAME
,      DIMENSION7_LEVEL_ID
,      DIMENSION7_LEVEL_SHORT_NAME
,      DIMENSION7_LEVEL_NAME
,      WORKFLOW_ITEM_TYPE
,      WORKFLOW_PROCESS_SHORT_NAME
,      WORKFLOW_PROCESS_NAME
,      DEFAULT_NOTIFY_RESP_ID
,      DEFAULT_NOTIFY_RESP_SHORT_NAME
,      DEFAULT_NOTIFY_RESP_NAME
,      COMPUTING_FUNCTION_ID
,      COMPUTING_FUNCTION_NAME
,      COMPUTING_USER_FUNCTION_NAME
,      REPORT_FUNCTION_ID
,      REPORT_FUNCTION_NAME
,      REPORT_USER_FUNCTION_NAME
,      UNIT_OF_MEASURE
,      SYSTEM_FLAG
,      SOURCE
FROM APPS.BISFV_TARGET_LEVELS;

Dependencies

[top of page]

APPS.BISFV_TARGET_LEVELS references the following:

SchemaAPPS
PL/SQL PackageBIS_DIMENSION_LEVEL_PUB - show dependent code
SynonymBIS_INDICATORS
SynonymBIS_INDICATORS_TL
SynonymBIS_LEVELS
SynonymBIS_LEVELS_TL
SynonymBIS_TARGET_LEVELS
SynonymBIS_TARGET_LEVELS_TL
PL/SQL PackageBIS_UTILITIES_PUB - show dependent code
APPS.BISFV_TARGET_LEVELS is referenced by following:

SchemaAPPS
Package BodyBIS_INDICATOR_REGION_UI_PVT - show dependent code
Package BodyBIS_PMF_DEFINER_WRAPPER_PVT - show dependent code
Package BodyBIS_TARGET_LEVEL_PVT - show dependent code
Package BodyHR_BIS_ALERTS - show dependent code
Package BodyOE_BIS_ALERTS - show dependent code
Package BodyPOA_BIS_ALERTS - show dependent code
Package BodyPOA_PORTAL_SUP_RISK_IND - show dependent code