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

TABLE: MSC.MSC_BIS_TARGET_LEVELS

Object Details
Object Name: MSC_BIS_TARGET_LEVELS
Object Type: TABLE
Owner: MSC
FND Design Data: TableMSC.MSC_BIS_TARGET_LEVELS
Subobject Name:
Status: VALID


MSC_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 to know sales revenues broken down by month and by product and by state, then this combinaiton of parameters would be captured in a target level.
.
MSC_BIS_TARGET_LEVELS contains data collected from source applications.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_BIS_TARGET_LEVELS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnSR_INSTANCE_ID
ColumnTARGET_LEVEL_ID
MSC_BIS_TARGET_LEVELS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTARGET_LEVEL_SHORT_NAME
ColumnSR_INSTANCE_ID
Columns
Name Datatype Length Mandatory Comments
TARGET_LEVEL_ID NUMBER
Yes Target level identifier
SR_INSTANCE_ID NUMBER
Yes Source application instance identifier
TARGET_LEVEL_SHORT_NAME VARCHAR2 (80) Yes Short name identifying the target level
TARGET_LEVEL_NAME VARCHAR2 (80) Yes Target level name
DESCRIPTION VARCHAR2 (240)
Decribe the target level
MEASURE_ID NUMBER
Yes Performance measure identifier
ORG_LEVEL_ID NUMBER

Organization level identifier
TIME_LEVEL_ID NUMBER

Time level identifier
DIMENSION1_LEVEL_ID NUMBER

First dimension level identifier
DIMENSION2_LEVEL_ID NUMBER

Second dimension level identifier
DIMENSION3_LEVEL_ID NUMBER

Third dimension level identifier
DIMENSION4_LEVEL_ID NUMBER

Forth dimension level identifier
DIMENSION5_LEVEL_ID NUMBER

Fifth dimension level identifier
WORKFLOW_ITEM_TYPE VARCHAR2 (8)
Workflow item type
WORKFLOW_PROCESS_SHORT_NAME VARCHAR2 (30)
Workflow process short name
DEFAULT_NOTIFY_RESP_ID NUMBER

Default notify identifier
DEFAULT_NOTIFY_RESP_SHORT_NAME VARCHAR2 (100)
Name of the default notify
COMPUTING_FUNCTION_ID NUMBER

Computing function identifier
REPORT_FUNCTION_ID NUMBER

Report function identifier
UNIT_OF_MEASURE VARCHAR2 (25)
Unit of measure
SYSTEM_FLAG VARCHAR2 (1)
System flag
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_LEVEL_ID
,      SR_INSTANCE_ID
,      TARGET_LEVEL_SHORT_NAME
,      TARGET_LEVEL_NAME
,      DESCRIPTION
,      MEASURE_ID
,      ORG_LEVEL_ID
,      TIME_LEVEL_ID
,      DIMENSION1_LEVEL_ID
,      DIMENSION2_LEVEL_ID
,      DIMENSION3_LEVEL_ID
,      DIMENSION4_LEVEL_ID
,      DIMENSION5_LEVEL_ID
,      WORKFLOW_ITEM_TYPE
,      WORKFLOW_PROCESS_SHORT_NAME
,      DEFAULT_NOTIFY_RESP_ID
,      DEFAULT_NOTIFY_RESP_SHORT_NAME
,      COMPUTING_FUNCTION_ID
,      REPORT_FUNCTION_ID
,      UNIT_OF_MEASURE
,      SYSTEM_FLAG
,      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_TARGET_LEVELS;

Dependencies

[top of page]

MSC.MSC_BIS_TARGET_LEVELS does not reference any database object

MSC.MSC_BIS_TARGET_LEVELS is referenced by following:

SchemaMSC
ViewMSC_BIS_TARGET_LEVELS#