[Home] [Help] [Dependency Information]
Object Name: | MRP_PLANNING_EXCEPTION_SETS |
---|---|
Object Type: | TABLE |
Owner: | MRP |
FND Design Data: | MRP.MRP_PLANNING_EXCEPTION_SETS |
Subobject Name: | |
Status: | VALID |
MRP_PLANNING_EXCEPTION_SETS stores a set of attributes that control
how Oracle Master Scheduling/MRP calculates exception messages. A
planning exception set is associated to one or more items. The
planner will read an item's exception set values to determine what
values to use to calculate the exception messages.
.
SHORTAGE_TYPE, EXCESS_TYPE, REP_VARIANCE_TYPE, and OVERPROMISED_TYPE
determine the period within which messages regarding shortages of
inventory, excess inventory levels, variance between the suggested
aggregate repetitive schedules and current aggregate repetitive
schedules, and negative ATP values (respectively) are computed.
.
MRP_PLANNING_EXCEPTION_SETS is populated by the Define Planning
Exception Sets form and used by the Planner.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 20 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MRP_PLANNING_EXCEPTION_SETS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
EXCEPTION_SET_NAME
ORGANIZATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EXCEPTION_SET_NAME | VARCHAR2 | (10) | Yes | Exception set identifier |
ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
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 | ||
EXCESS_QUANTITY | NUMBER | Yes | Quantity above which planning will generate an exception message | |
USER_TIME_FENCE | NUMBER | Yes | Number of days within which planning will generate an exception message | |
REPETITIVE_VARIANCE | NUMBER | Yes | Cumulative variance between the suggested and current aggregate repetitive schedules above or below which planning will generate an exception message | |
SHORTAGE_TYPE | NUMBER | Yes | Period of time within which to calculate material shortages | |
EXCESS_TYPE | NUMBER | Yes | Period of time within which to calculate excess inventory | |
REP_VARIANCE_TYPE | NUMBER | Yes | Period of time within which to calculate repetitive variance | |
OVERPROMISED_TYPE | NUMBER | Yes | Period of time within which to calculate over-promised ATP | |
OVER_UTILIZED_PERCENT | NUMBER | Resource overutilization tolerance(%) | ||
UNDER_UTILIZED_PERCENT | NUMBER | Resource underutilization tolerance(%) | ||
RESOURCE_SHORTAGE_TYPE | NUMBER | Period of time within which to calculate resource underutilization | ||
RESOURCE_EXCESS_TYPE | NUMBER | Period of time within which to calculate resource overutilization | ||
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 | |
SETUP_TIME | NUMBER | Setup time threshold value | ||
UTILIZATION_CHANGE_PERCENT | NUMBER | Utilization change threshold value | ||
SETUP_TIME_TYPE | NUMBER | Display item for setup text | ||
UTILIZATION_CHANGE_TYPE | NUMBER | Display item for utilization text |
Cut, paste (and edit) the following text to query this object:
SELECT EXCEPTION_SET_NAME
, ORGANIZATION_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, EXCESS_QUANTITY
, USER_TIME_FENCE
, REPETITIVE_VARIANCE
, SHORTAGE_TYPE
, EXCESS_TYPE
, REP_VARIANCE_TYPE
, OVERPROMISED_TYPE
, OVER_UTILIZED_PERCENT
, UNDER_UTILIZED_PERCENT
, RESOURCE_SHORTAGE_TYPE
, RESOURCE_EXCESS_TYPE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, SETUP_TIME
, UTILIZATION_CHANGE_PERCENT
, SETUP_TIME_TYPE
, UTILIZATION_CHANGE_TYPE
FROM MRP.MRP_PLANNING_EXCEPTION_SETS;
MRP.MRP_PLANNING_EXCEPTION_SETS does not reference any database object
MRP.MRP_PLANNING_EXCEPTION_SETS is referenced by following:
|
|
|