[Home] [Help] [Dependency Information]
Object Name: | MSC_NET_CHANGE_CRITERIA |
---|---|
Object Type: | TABLE |
Owner: | MSC |
FND Design Data: | MSC.MSC_NET_CHANGE_CRITERIA |
Subobject Name: | |
Status: | VALID |
This table stores the criteria used in Plan Comparison Reports.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MSC_NET_CHANGE_CRITERIA_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
CRITERIA_ID
USER_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
CRITERIA_ID | NUMBER | Yes | criteira identifier | |
CRITERIA_NAME | VARCHAR2 | (80) | Yes | criteria name |
USER_ID | NUMBER | Yes | the user who created this criteria | |
PUBLIC_FLAG | NUMBER | Is this criteria available to the other users? | ||
AUTO_QUERY_FLAG | NUMBER | auto query flag | ||
EXCEPTION_GROUP | VARCHAR2 | (200) | exception group | |
EXCEPTION_TYPE | VARCHAR2 | (500) | exception type | |
ALL_EXCEPTIONS | NUMBER | display all exceptions or not | ||
GROUP_BY_ID | NUMBER | group by id, not used yet | ||
OPTIONS_FLAG | NUMBER | to calculate plan options or not | ||
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 |
Cut, paste (and edit) the following text to query this object:
SELECT CRITERIA_ID
, CRITERIA_NAME
, USER_ID
, PUBLIC_FLAG
, AUTO_QUERY_FLAG
, EXCEPTION_GROUP
, EXCEPTION_TYPE
, ALL_EXCEPTIONS
, GROUP_BY_ID
, OPTIONS_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
FROM MSC.MSC_NET_CHANGE_CRITERIA;
MSC.MSC_NET_CHANGE_CRITERIA does not reference any database object
MSC.MSC_NET_CHANGE_CRITERIA is referenced by following:
|
|
|