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

VIEW: APPS.BISFV_TARGETS

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

View Type

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


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


[View Source]

Columns
Name Datatype Length Mandatory Comments
TARGET_ID NUMBER
Yes Target ID
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
PLAN_ID NUMBER
Yes Business Plan ID
PLAN_SHORT_NAME VARCHAR2 (30) Yes Business Plan Short Name
PLAN_NAME VARCHAR2 (80) Yes Business Plan Name
ORG_LEVEL_VALUE_ID VARCHAR2 (80)
No Longer Used
ORG_LEVEL_VALUE_NAME VARCHAR2 (80)
No Longer Used
TIME_LEVEL_VALUE_ID VARCHAR2 (80)
No Longer Used
TIME_LEVEL_VALUE_NAME VARCHAR2 (80)
No Longer Used
DIM1_LEVEL_VALUE_ID VARCHAR2 (80)
Dimension Level1 Value ID
DIM1_LEVEL_VALUE_NAME VARCHAR2 (80)
Dimensions Level1 Value Name
DIM2_LEVEL_VALUE_ID VARCHAR2 (80)
Dimension Level2 Value ID
DIM2_LEVEL_VALUE_NAME VARCHAR2 (80)
Dimensions Level2 Value Name
DIM3_LEVEL_VALUE_ID VARCHAR2 (80)
Dimension Level3 Value ID
DIM3_LEVEL_VALUE_NAME VARCHAR2 (80)
Dimensions Level3 Value Name
DIM4_LEVEL_VALUE_ID VARCHAR2 (80)
Dimension Level4 Value ID
DIM4_LEVEL_VALUE_NAME VARCHAR2 (80)
Dimensions Level4 Value Name
DIM5_LEVEL_VALUE_ID VARCHAR2 (80)
Dimension Level5 Value ID
DIM5_LEVEL_VALUE_NAME VARCHAR2 (80)
Dimensions Level5 Value Name
DIM6_LEVEL_VALUE_ID VARCHAR2 (80)
Dimension Level6 Vallue ID
DIM6_LEVEL_VALUE_NAME VARCHAR2 (80)
Dimensions Level6 Value Name
DIM7_LEVEL_VALUE_ID VARCHAR2 (80)
Dimension Level7 ID
DIM7_LEVEL_VALUE_NAME VARCHAR2 (80)
Dimensions Level7 Value Name
TARGET NUMBER

Value for the target
RANGE1_LOW NUMBER

Percentage of the first lower range
RANGE1_HIGH NUMBER

Percentage of the first upper range
RANGE2_LOW NUMBER

Percentage of the second lower range
RANGE2_HIGH NUMBER

Percentage of the second upper range
RANGE3_LOW NUMBER

Percentage of the third lower range
RANGE3_HIGH NUMBER

Percentage of the third upper range
NOTIFY_RESP1_ID NUMBER

Workflow role ID for the owner for the first range
NOTIFY_RESP1_SHORT_NAME VARCHAR2 (100)
Workflow role short name for the owner for the first range
NOTIFY_RESP1_NAME VARCHAR2 (4000)
Workflow role for the owner for the first range
NOTIFY_RESP2_ID NUMBER

Workflow role ID for the owner for the second range
NOTIFY_RESP2_SHORT_NAME VARCHAR2 (100)
Workflow role short name for the owner for the second range
NOTIFY_RESP2_NAME VARCHAR2 (4000)
Workflow role for the owner for the second range
NOTIFY_RESP3_ID NUMBER

Workflow role ID for the owner for the third range
NOTIFY_RESP3_SHORT_NAME VARCHAR2 (100)
Workflow role short name for the owner for the third range
NOTIFY_RESP3_NAME VARCHAR2 (4000)
Workflow role for the owner for the third range
Query Text

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


SELECT TARGET_ID
,      TARGET_LEVEL_ID
,      TARGET_LEVEL_SHORT_NAME
,      TARGET_LEVEL_NAME
,      PLAN_ID
,      PLAN_SHORT_NAME
,      PLAN_NAME
,      ORG_LEVEL_VALUE_ID
,      ORG_LEVEL_VALUE_NAME
,      TIME_LEVEL_VALUE_ID
,      TIME_LEVEL_VALUE_NAME
,      DIM1_LEVEL_VALUE_ID
,      DIM1_LEVEL_VALUE_NAME
,      DIM2_LEVEL_VALUE_ID
,      DIM2_LEVEL_VALUE_NAME
,      DIM3_LEVEL_VALUE_ID
,      DIM3_LEVEL_VALUE_NAME
,      DIM4_LEVEL_VALUE_ID
,      DIM4_LEVEL_VALUE_NAME
,      DIM5_LEVEL_VALUE_ID
,      DIM5_LEVEL_VALUE_NAME
,      DIM6_LEVEL_VALUE_ID
,      DIM6_LEVEL_VALUE_NAME
,      DIM7_LEVEL_VALUE_ID
,      DIM7_LEVEL_VALUE_NAME
,      TARGET
,      RANGE1_LOW
,      RANGE1_HIGH
,      RANGE2_LOW
,      RANGE2_HIGH
,      RANGE3_LOW
,      RANGE3_HIGH
,      NOTIFY_RESP1_ID
,      NOTIFY_RESP1_SHORT_NAME
,      NOTIFY_RESP1_NAME
,      NOTIFY_RESP2_ID
,      NOTIFY_RESP2_SHORT_NAME
,      NOTIFY_RESP2_NAME
,      NOTIFY_RESP3_ID
,      NOTIFY_RESP3_SHORT_NAME
,      NOTIFY_RESP3_NAME
FROM APPS.BISFV_TARGETS;

Dependencies

[top of page]

APPS.BISFV_TARGETS references the following:

SchemaAPPS
SynonymBIS_BUSINESS_PLANS
SynonymBIS_BUSINESS_PLANS_TL
SynonymBIS_TARGET_LEVELS
SynonymBIS_TARGET_LEVELS_TL
SynonymBIS_TARGET_VALUES
PL/SQL PackageBIS_UTILITIES_PUB - show dependent code
APPS.BISFV_TARGETS is referenced by following:

SchemaAPPS
Package BodyBIS_PMV_PMF_PVT - show dependent code
Package BodyBIS_TARGET_PVT - show dependent code
Package BodyBIX_ALERT - show dependent code
Package BodyHR_BIS_ALERTS - show dependent code
Package BodyMST_CMP_KPIS - show dependent code
Package BodyOE_BIS_ALERTS - show dependent code
Package BodyPOA_BIS_ALERTS - show dependent code