[Home] [Help]
[Dependency Information]
Object Name: | MSC_PLAN_EXCP_TYPES |
---|---|
Object Type: | TABLE |
Owner: | MSC |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MSC_PLAN_EXCP_TYPES_U1 | NORMAL | UNIQUE |
![]() |
![]() ![]() ![]() |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXCP_TYPE | VARCHAR2 | (10) | Yes | Excp Type |
EXCP_GROUP | VARCHAR2 | (10) | Yes | Excp Group |
IN_ASCP_PLAN | VARCHAR2 | (10) | In Ascp Plan yes, no | |
IN_IO_PLAN | VARCHAR2 | (10) | In IO Plan yes, no | |
IN_DRP_PLAN | VARCHAR2 | (10) | In DRP Plan yes, no | |
CREATED_BY | NUMBER | Standard Who Columns | ||
CREATION_DATE | DATE | Standard Who Columns | ||
LAST_UPDATE_DATE | DATE | Standard Who Columns | ||
LAST_UPDATED_BY | NUMBER | Standard Who Columns | ||
LAST_UPDATE_LOGIN | NUMBER | Standard Who Columns | ||
IN_SRP_PLAN | VARCHAR2 | (10) | In SRP Plan 1-yes, 2-no | |
IN_MNT_SCH | VARCHAR2 | (10) | In Maintenance Schedule: yes,no | |
IN_MFG_SCH | VARCHAR2 | (10) | In Manufacturing Schedule: yes, no | |
IS_EXCEPTION | VARCHAR2 | (10) | 1 - Exception, 2 - Recommendation. | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT EXCP_TYPE
, EXCP_GROUP
, IN_ASCP_PLAN
, IN_IO_PLAN
, IN_DRP_PLAN
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, IN_SRP_PLAN
, IN_MNT_SCH
, IN_MFG_SCH
, IS_EXCEPTION
, ZD_EDITION_NAME
FROM MSC.MSC_PLAN_EXCP_TYPES;
MSC.MSC_PLAN_EXCP_TYPES does not reference any database object
MSC.MSC_PLAN_EXCP_TYPES is referenced by following:
|
|
|