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]

TABLE: MSC.MSC_BIS_TARGETS

Object Details

Object Name:	MSC_BIS_TARGETS
Object Type:	TABLE
Owner:	MSC
FND Design Data:	MSC.MSC_BIS_TARGETS
Subobject Name:
Status:	VALID

MSC_BIS_TARGETS stores the target values for the BIS reports.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MSC_BIS_TARGETS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	SR_INSTANCE_ID TARGET_ID
MSC_BIS_TARGETS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	TARGET_LEVEL_ID SR_INSTANCE_ID ORG_LEVEL_VALUE_ID BUSINESS_PLAN_ID TIME_LEVEL_VALUE_ID DIM1_LEVEL_VALUE_ID DIM2_LEVEL_VALUE_ID DIM3_LEVEL_VALUE_ID DIM4_LEVEL_VALUE_ID DIM5_LEVEL_VALUE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TARGET_ID	NUMBER		Yes	Target identifier
SR_INSTANCE_ID	NUMBER		Yes	Source application instance identifier
TARGET_LEVEL_ID	NUMBER		Yes	Target level identifier
BUSINESS_PLAN_ID	NUMBER		Yes	Business plan identifier
ORG_LEVEL_VALUE_ID	VARCHAR2	(80)		Org level value identifier
TIME_LEVEL_VALUE_ID	VARCHAR2	(80)		Time level value identifier
DIM1_LEVEL_VALUE_ID	VARCHAR2	(80)		First dimension level value identifier
DIM2_LEVEL_VALUE_ID	VARCHAR2	(80)		Second dimension level value identifier
DIM3_LEVEL_VALUE_ID	VARCHAR2	(80)		Third dimension level value identifier
DIM4_LEVEL_VALUE_ID	VARCHAR2	(80)		Forth dimension level value identifier
DIM5_LEVEL_VALUE_ID	VARCHAR2	(80)		Fifth dimension level value identifier
TARGET	NUMBER			Target number
RANGE1_LOW	NUMBER			Low number of the first range
RANGE1_HIGH	NUMBER			High number of the first range
RANGE2_LOW	NUMBER			Low number of the second range
RANGE2_HIGH	NUMBER			High number of the second range
RANGE3_LOW	NUMBER			Low number of the third range
RANGE3_HIGH	NUMBER			High number of the third range
NOTIFY_RESP1_ID	NUMBER			First notify identifier
NOTIFY_RESP1_SHORT_NAME	VARCHAR2	(100)		Short name of the first notify
NOTIFY_RESP2_ID	NUMBER			Second notify identifier
NOTIFY_RESP2_SHORT_NAME	VARCHAR2	(100)		Short name of the second notify
NOTIFY_RESP3_ID	NUMBER			Third notify identifier
NOTIFY_RESP3_SHORT_NAME	VARCHAR2	(100)		Short name of the third notify
REFRESH_NUMBER	NUMBER			Refresh number populated by the collection program
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER		Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
CREATED_BY	NUMBER		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER			Standard who column
REQUEST_ID	NUMBER			Concurrent Who column
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Who column
PROGRAM_ID	NUMBER			Concurrent Who column
PROGRAM_UPDATE_DATE	DATE			Concurrent Who column

Query Text

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


SELECT TARGET_ID
,      SR_INSTANCE_ID
,      TARGET_LEVEL_ID
,      BUSINESS_PLAN_ID
,      ORG_LEVEL_VALUE_ID
,      TIME_LEVEL_VALUE_ID
,      DIM1_LEVEL_VALUE_ID
,      DIM2_LEVEL_VALUE_ID
,      DIM3_LEVEL_VALUE_ID
,      DIM4_LEVEL_VALUE_ID
,      DIM5_LEVEL_VALUE_ID
,      TARGET
,      RANGE1_LOW
,      RANGE1_HIGH
,      RANGE2_LOW
,      RANGE2_HIGH
,      RANGE3_LOW
,      RANGE3_HIGH
,      NOTIFY_RESP1_ID
,      NOTIFY_RESP1_SHORT_NAME
,      NOTIFY_RESP2_ID
,      NOTIFY_RESP2_SHORT_NAME
,      NOTIFY_RESP3_ID
,      NOTIFY_RESP3_SHORT_NAME
,      REFRESH_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM MSC.MSC_BIS_TARGETS;

Dependencies

[top of page]

MSC.MSC_BIS_TARGETS does not reference any database object

MSC.MSC_BIS_TARGETS is referenced by following:

MSC: MSC_BIS_TARGETS#