[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MSC_DESIGNATORS |
|---|---|
| Object Type: | TABLE |
| Owner: | MSC |
| FND Design Data: |  MSC.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.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| MSC_DESIGNATORS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 DESIGNATOR_ID
|
| MSC_DESIGNATORS_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
DESIGNATOR
ORGANIZATION_ID
SR_INSTANCE_ID
|
| MSC_DESIGNATORS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
COPY_DESIGNATOR_ID
|
| 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 |
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
FROM MSC.MSC_DESIGNATORS;
MSC.MSC_DESIGNATORS does not reference any database object
MSC.MSC_DESIGNATORS is referenced by following:
APPS
MSC_DESIGNATORS
MSC
MSC_ATP_PLAN_SN
|
|
|
|