[Home] [Help]
[Dependency Information]
Object Name: | MSC_ST_BIS_TARGETS |
---|---|
Object Type: | TABLE |
Owner: | MSC |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
The staging table used by the collection program to validate and process
data for table MSC_BIS_TARGETS.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TARGET_ID | NUMBER | Target identifier | ||
TARGET_LEVEL_ID | NUMBER | Target level identifier | ||
BUSINESS_PLAN_ID | NUMBER | 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 | |
DELETED_FLAG | NUMBER | Yes/No flag indicating whether the row will be deleted | ||
LAST_UPDATE_DATE | DATE | Standard Who column | ||
LAST_UPDATED_BY | NUMBER | Standard Who column | ||
CREATION_DATE | DATE | Standard Who column | ||
CREATED_BY | NUMBER | 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 | ||
REFRESH_ID | NUMBER | Refresh identifier | ||
SR_INSTANCE_ID | NUMBER | Source application instance identifier |
Cut, paste (and edit) the following text to query this object:
SELECT TARGET_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
, DELETED_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REFRESH_ID
, SR_INSTANCE_ID
FROM MSC.MSC_ST_BIS_TARGETS;
MSC.MSC_ST_BIS_TARGETS does not reference any database object
MSC.MSC_ST_BIS_TARGETS is referenced by following:
|
|
|