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

TABLE: MSC.MSC_PLAN_ORDER_TYPES

Object Details
Object Name: MSC_PLAN_ORDER_TYPES
Object Type: TABLE
Owner: MSC
Subobject Name:
Status: VALID


Stores Seeded Data listing Order types Specific to Plan types


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_PLAN_ORDER_TYPES_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnORDER_TYPE
ColumnORDER_GROUP
ColumnZD_EDITION_NAME
Columns
Name Datatype Length Mandatory Comments
ORDER_TYPE NUMBER
Yes Order type - uses lookups for description
ORDER_GROUP VARCHAR2 (10) Yes Order Source - SUPPLY, DEMAND
IN_ASCP_PLAN NUMBER

In ASCP Plan 1-yes, 2-no
IN_IO_PLAN NUMBER

In IO Plan 1-yes, 2-no
IN_DRP_PLAN NUMBER

In DRP Plan 1-yes, 2-no
IN_SRP_PLAN NUMBER

In SRP Plan 1-yes, 2-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_RP_PLAN NUMBER

ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ORDER_TYPE
,      ORDER_GROUP
,      IN_ASCP_PLAN
,      IN_IO_PLAN
,      IN_DRP_PLAN
,      IN_SRP_PLAN
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      IN_RP_PLAN
,      ZD_EDITION_NAME
FROM MSC.MSC_PLAN_ORDER_TYPES;

Dependencies

[top of page]

MSC.MSC_PLAN_ORDER_TYPES does not reference any database object

MSC.MSC_PLAN_ORDER_TYPES is referenced by following:

SchemaMSC
ViewMSC_PLAN_ORDER_TYPES#