eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.BISVV_TARGETS

Object Details

Object Name:	BISVV_TARGETS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	BIS.BISVV_TARGETS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory
TARGET_ID	NUMBER		Yes
TARGET_LEVEL_ID	NUMBER		Yes
TARGET_LEVEL_SHORT_NAME	VARCHAR2	(80)	Yes
TARGET_LEVEL_NAME	VARCHAR2	(80)	Yes
MEASURE_ID	NUMBER		Yes
PLAN_ID	NUMBER		Yes
PLAN_SHORT_NAME	VARCHAR2	(30)	Yes
PLAN_NAME	VARCHAR2	(80)	Yes
ORG_LEVEL_VALUE_ID	VARCHAR2	(80)
TIME_LEVEL_VALUE_ID	VARCHAR2	(80)
PERIOD_SET_NAME	VARCHAR2	(80)
PERIOD_NAME	VARCHAR2	(80)
DIM1_LEVEL_VALUE_ID	VARCHAR2	(80)
DIM2_LEVEL_VALUE_ID	VARCHAR2	(80)
DIM3_LEVEL_VALUE_ID	VARCHAR2	(80)
DIM4_LEVEL_VALUE_ID	VARCHAR2	(80)
DIM5_LEVEL_VALUE_ID	VARCHAR2	(80)
TARGET	NUMBER
COMPUTING_FUNCTION_ID	NUMBER
COMPUTING_FUNCTION_NAME	VARCHAR2	(4000)
COMPUTING_USER_FUNCTION_NAME	VARCHAR2	(4000)
RANGE1_LOW	NUMBER
RANGE1_HIGH	NUMBER
RANGE2_LOW	NUMBER
RANGE2_HIGH	NUMBER
RANGE3_LOW	NUMBER
RANGE3_HIGH	NUMBER
NOTIFY_RESP1_ID	NUMBER
NOTIFY_RESP1_SHORT_NAME	VARCHAR2	(100)
NOTIFY_RESP1_NAME	VARCHAR2	(4000)
NOTIFY_RESP2_ID	NUMBER
NOTIFY_RESP2_SHORT_NAME	VARCHAR2	(100)
NOTIFY_RESP2_NAME	VARCHAR2	(4000)
NOTIFY_RESP3_ID	NUMBER
NOTIFY_RESP3_SHORT_NAME	VARCHAR2	(100)
NOTIFY_RESP3_NAME	VARCHAR2	(4000)
WORKFLOW_ITEM_TYPE	VARCHAR2	(8)
WORKFLOW_PROCESS_SHORT_NAME	VARCHAR2	(30)
WORKFLOW_PROCESS_NAME	VARCHAR2	(4000)
UNIT_OF_MEASURE	VARCHAR2	(25)
REPORT_FUNCTION_ID	NUMBER
REPORT_FUNCTION_NAME	VARCHAR2	(4000)
REPORT_USER_FUNCTION_NAME	VARCHAR2	(4000)

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
,      MEASURE_ID
,      PLAN_ID
,      PLAN_SHORT_NAME
,      PLAN_NAME
,      ORG_LEVEL_VALUE_ID
,      TIME_LEVEL_VALUE_ID
,      PERIOD_SET_NAME
,      PERIOD_NAME
,      DIM1_LEVEL_VALUE_ID
,      DIM2_LEVEL_VALUE_ID
,      DIM3_LEVEL_VALUE_ID
,      DIM4_LEVEL_VALUE_ID
,      DIM5_LEVEL_VALUE_ID
,      TARGET
,      COMPUTING_FUNCTION_ID
,      COMPUTING_FUNCTION_NAME
,      COMPUTING_USER_FUNCTION_NAME
,      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
,      WORKFLOW_ITEM_TYPE
,      WORKFLOW_PROCESS_SHORT_NAME
,      WORKFLOW_PROCESS_NAME
,      UNIT_OF_MEASURE
,      REPORT_FUNCTION_ID
,      REPORT_FUNCTION_NAME
,      REPORT_USER_FUNCTION_NAME
FROM APPS.BISVV_TARGETS;

Dependencies

[top of page]

APPS.BISVV_TARGETS references the following:

APPS: BIS_BUSINESS_PLANS; BIS_BUSINESS_PLANS_TL; BIS_TARGET_LEVELS; BIS_TARGET_LEVELS_TL; BIS_TARGET_VALUES; BIS_UTILITIES_PUB - show dependent code

APPS.BISVV_TARGETS is not referenced by any database object