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: BIS.BIS_TARGET_LEVELS

Object Details

Object Name:	BIS_TARGET_LEVELS
Object Type:	TABLE
Owner:	BIS
FND Design Data:	BIS.BIS_TARGET_LEVELS
Subobject Name:
Status:	VALID

BIS_TARGET_LEVELS contains different combinations of dimension levels to be applied simultaneously to get a performance indicator relevant to a particular reporting need.
For example, if someone wants ot know sales revenues broken down by month and by product and by state, then this combinaiton of parameters woudl be captured in a target level.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
BIS_TARGET_LEVELS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	TARGET_LEVEL_ID
BIS_TARGET_LEVELS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	SHORT_NAME
BIS_TARGET_LEVELS_U3	NORMAL	UNIQUE	APPS_TS_TX_IDX	INDICATOR_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

Columns

Name	Datatype	Length	Mandatory	Comments
TARGET_LEVEL_ID	NUMBER		Yes	Target Level ID Column
INDICATOR_ID	NUMBER		Yes	Performance Measure ID
SHORT_NAME	VARCHAR2	(80)	Yes	Target Level Short Name
TIME_LEVEL_ID	NUMBER			No Longer Used
ORG_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
DEFAULT_ROLE_ID	NUMBER			No Longer Used
WF_ITEM_TYPE	VARCHAR2	(8)		The Workflow type attached to the dimension level combination
WF_PROCESS	VARCHAR2	(30)		The Workflow process which belongs to the selected workflow item type and is assigned to the dimension level combination
SYSTEM_FLAG	VARCHAR2	(1)		No Longer Used
DEFAULT_ROLE	VARCHAR2	(100)		No Longer Used
DEFAULT_COMPUTING_FUNCTION_ID	NUMBER			Computing Function ID
REPORT_FUNCTION_ID	NUMBER			No Longer Used
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER		Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
DIMENSION6_LEVEL_ID	NUMBER			Dimension6 Level ID
DIMENSION7_LEVEL_ID	NUMBER			Dimension7 Level ID
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
,      INDICATOR_ID
,      SHORT_NAME
,      TIME_LEVEL_ID
,      ORG_LEVEL_ID
,      DIMENSION1_LEVEL_ID
,      DIMENSION2_LEVEL_ID
,      DIMENSION3_LEVEL_ID
,      DIMENSION4_LEVEL_ID
,      DIMENSION5_LEVEL_ID
,      DEFAULT_ROLE_ID
,      WF_ITEM_TYPE
,      WF_PROCESS
,      SYSTEM_FLAG
,      DEFAULT_ROLE
,      DEFAULT_COMPUTING_FUNCTION_ID
,      REPORT_FUNCTION_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      DIMENSION6_LEVEL_ID
,      DIMENSION7_LEVEL_ID
,      SOURCE
FROM BIS.BIS_TARGET_LEVELS;

Dependencies

[top of page]

BIS.BIS_TARGET_LEVELS does not reference any database object

BIS.BIS_TARGET_LEVELS is referenced by following:

APPS: BIS_TARGET_LEVELS