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

TABLE: MSC.MSC_DESIGNATORS

Object Details
Object Name: MSC_DESIGNATORS
Object Type: TABLE
Owner: MSC
FND Design Data: TableMSC.MSC_DESIGNATORS
Subobject Name:
Status: VALID


This table stores MPS and MDS schedule names defined at
source applications and planning server.
MPS_RELIEF indicates whether or not the Planning Manager should
consume this master demand or master production schedule.
.
INVENTORY_ATP_FLAG indicates whether or not inventory can consider
this master production schedule as a source of supply as defined by
ATP rules. It will always be No for master demand schedules.
This table is populated by the Define Master Schedule Names form and
the Collection program.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MSC_DESIGNATORS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDESIGNATOR_ID
MSC_DESIGNATORS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnDESIGNATOR
ColumnORGANIZATION_ID
ColumnSR_INSTANCE_ID
ColumnSRC_DESIGNATOR
MSC_DESIGNATORS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCOPY_DESIGNATOR_ID
Columns
Name Datatype Length Mandatory Comments
DESIGNATOR_ID NUMBER
Yes Designator identifier
DESIGNATOR VARCHAR2 (10) Yes Source application schedule name
ORGANIZATION_ID NUMBER
Yes Source application organization identifier
SR_INSTANCE_ID NUMBER
Yes Source application identifier
DESIGNATOR_TYPE NUMBER (22) Yes Indicate the designator type: MPS, MDS, MRP, or DRP
MPS_RELIEF NUMBER
Yes Flag to indicate whether MPS relief performed against this designator
INVENTORY_ATP_FLAG NUMBER
Yes ATP supply flag
DESCRIPTION VARCHAR2 (50)
Description of the this designator
DISABLE_DATE DATE

Designator disable date
DEMAND_CLASS VARCHAR2 (34)
Demand class identifier
ORGANIZATION_SELECTION NUMBER

Single/Multiple organizations
PRODUCTION NUMBER

Flag for auto release
RECOMMENDATION_RELEASE NUMBER

Planned order release flag
REFRESH_NUMBER NUMBER

Refresh number populated by the collection program
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER
Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER
Yes 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
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
COLLECTED_FLAG NUMBER

Flag indicating whether the row is collected from source application instance
CONSUME_FORECAST NUMBER

Consume forecast flag
UPDATE_TYPE NUMBER

Forecast update type code
FORWARD_UPDATE_TIME_FENCE NUMBER

Forward consumption days
BACKWARD_UPDATE_TIME_FENCE NUMBER

Backward consumption days
OUTLIER_UPDATE_PERCENTAGE NUMBER

Forecast outlier update percentage
FORECAST_SET_ID VARCHAR2 (10)
Forecast set identifier
CUSTOMER_ID NUMBER

Customer identifier
SHIP_ID NUMBER

Forecast ship code identifier
BILL_ID NUMBER

Forecast billing address identifier
BUCKET_TYPE NUMBER

Forecast bucket type - days, weeks or periods
PROBABILITY NUMBER

Probability
LAUNCH_WORKFLOW_FLAG NUMBER

Launch Workflow Flag
COPY_DESIGNATOR_ID NUMBER

Stores the link between the original plan and the temp plan in case of 24x7 ATP
PURGE_CURRENT_PLAN NUMBER

Purge Current Plan
SRC_DESCRIPTION VARCHAR2 (4000)
Source Description
SRC_DESIGNATOR VARCHAR2 (80)
Source Designator
SRC_SIM_FCST_ID NUMBER

Query Text

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


SELECT DESIGNATOR_ID
,      DESIGNATOR
,      ORGANIZATION_ID
,      SR_INSTANCE_ID
,      DESIGNATOR_TYPE
,      MPS_RELIEF
,      INVENTORY_ATP_FLAG
,      DESCRIPTION
,      DISABLE_DATE
,      DEMAND_CLASS
,      ORGANIZATION_SELECTION
,      PRODUCTION
,      RECOMMENDATION_RELEASE
,      REFRESH_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      COLLECTED_FLAG
,      CONSUME_FORECAST
,      UPDATE_TYPE
,      FORWARD_UPDATE_TIME_FENCE
,      BACKWARD_UPDATE_TIME_FENCE
,      OUTLIER_UPDATE_PERCENTAGE
,      FORECAST_SET_ID
,      CUSTOMER_ID
,      SHIP_ID
,      BILL_ID
,      BUCKET_TYPE
,      PROBABILITY
,      LAUNCH_WORKFLOW_FLAG
,      COPY_DESIGNATOR_ID
,      PURGE_CURRENT_PLAN
,      SRC_DESCRIPTION
,      SRC_DESIGNATOR
,      SRC_SIM_FCST_ID
FROM MSC.MSC_DESIGNATORS;

Dependencies

[top of page]

MSC.MSC_DESIGNATORS does not reference any database object

MSC.MSC_DESIGNATORS is referenced by following:

SchemaAPPS
Materialized ViewMSC_ATP_PLAN_SN
SchemaMSC
ViewMSC_DESIGNATORS#