[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MSC_ST_BIS_TARGETS |
|---|---|
| Object Type: | TABLE |
| Owner: | MSC |
| FND Design Data: |  MSC.MSC_ST_BIS_TARGETS
|
| Subobject Name: | |
| Status: | VALID |
The staging table used by the collection program to validate and process
data for table MSC_BIS_TARGETS.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| 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:
MSC
MSC_ST_BIS_TARGETS#
|
|
|
|