[Home] [Help] [Dependency Information]
Object Name: | MTL_SHORT_CHK_PARAM |
---|---|
Object Type: | TABLE |
Owner: | INV |
FND Design Data: | INV.MTL_SHORT_CHK_PARAM |
Subobject Name: | |
Status: | VALID |
MTL_SHORT_CHK_PARAM holds the material shortage message parameters for each Inventory organization. These parameters are populated from the Shortage Parameters form.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MTL_SHORT_CHK_PARAM_U1 | NORMAL | UNIQUE | APPS_TS_SEED | ORGANIZATION_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
CHECK_WIP_FLAG | NUMBER | Flag for specifying whether demand from WIP jobs and schedules should be considered when determining material shortages | ||
CHECK_OE_FLAG | NUMBER | Flag for specifying whether demand from backorders should be considered when determining material shortages | ||
WIP_REL_JOBS_FLAG | NUMBER | Flag indicating that released WIP jobs should be considered as demand when determining material shortages | ||
WIP_DAYS_OVERDUE_REL_JOBS | NUMBER | Number of days overdue that a released job must be before it is considered demand | ||
WIP_UNREL_JOBS_FLAG | NUMBER | Flag indicating that unreleased WIP jobs should be considered as demand when determining material shortages | ||
WIP_DAYS_OVERDUE_UNREL_JOBS | NUMBER | Number of days overdue that an unreleased job must be before it is considered demand | ||
WIP_HOLD_JOBS_FLAG | NUMBER | Flag indicating whether WIP jobs which are on hold should be considered as demand when determining material shortages | ||
WIP_REL_REP_FLAG | NUMBER | Flag indicating that released WIP schedules should be considered as demand when determining material shortages | ||
WIP_DAYS_OVERDUE_REL_REP | NUMBER | Number of days overdue that a released schedule must be before it is considered demand | ||
WIP_UNREL_REP_FLAG | NUMBER | Flag indicating that unreleased WIP schedules should be considered as demand when determining material shortages | ||
WIP_DAYS_OVERDUE_UNREL_REP | NUMBER | Number of days overdue that an unreleased schedule must be before it is considered demand | ||
WIP_HOLD_REP_FLAG | NUMBER | Flag indicating whether WIP schedules which are on hold should be considered as demand when determining material shortages | ||
WIP_REQ_DATE_JOBS_FLAG | NUMBER | Flag indicating that a WIP job is considered overdue if its required date has passed | ||
WIP_CURR_OP_JOBS_FLAG | NUMBER | Flag indicating that a WIP job is considered overdue if its currently assigned operation is due | ||
WIP_PREV_OP_JOBS_FLAG | NUMBER | Flag indicating that a WIP job is considered overdue if the operation before its currently assigned operation is due | ||
WIP_REQ_DATE_REP_FLAG | NUMBER | Flag indicating that a WIP schedule is considered overdue if its required date has passed | ||
WIP_CURR_OP_REP_FLAG | NUMBER | Flag indicating that a WIP schedule is considered overdue if its currently assigned operation is due | ||
WIP_PREV_OP_REP_FLAG | NUMBER | Flag indicating that a WIP schedule is considered overdue if the operation before its currently assigned operation is due | ||
WIP_EXCL_BULK_COMP_FLAG | NUMBER | Flag indicating whether bulk components for WIP jobs and schedules should be excluded when determining material shortages | ||
WIP_EXCL_SUPPLIER_COMP_FLAG | NUMBER | Flag indicating whether supplier components for WIP jobs and schedules should be excluded when determining material shortages | ||
WIP_EXCL_PULL_COMP_FLAG | NUMBER | Flag indicating whether supplier pull and operation pull components for WIP jobs and schedules should be excluded when determining material shortages | ||
WIP_NOTIF_COMP_PLANNER_FLAG | NUMBER | Flag indicating whether the component planner for a short item should be notified if a receipt is performed for that item | ||
WIP_NOTIF_ASS_PLANNER_FLAG | NUMBER | Flag indicating whether the assembly planner for a short item should be notified if a receipt is performed for that item | ||
WIP_NOTIF_COMP_BUYER_FLAG | NUMBER | Flag indicating whether the component buyer for a short item should be notified if a receipt is performed for that item | ||
WIP_NOTIF_JOB_CREATOR_FLAG | NUMBER | Flag indicating whether the job creator for a WIP job which has short items should be notified if a receipt is performed for one of the short items | ||
OE_NOTIF_ITEM_PLANNER_FLAG | NUMBER | Flag indicating whether the item planner for an item which is on a backordered sales order should be notified if a receipt is performed for the item | ||
OE_NOTIF_SO_CREATOR_FLAG | NUMBER | Flag indicating whether the order creator of a backordered sales order should be notified if a receipt is performed for a backordered item | ||
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
CREATED_BY | NUMBER | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who 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 | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
WIP_NOTIFY_LIST | VARCHAR2 | (10) | Not currently used | |
WIP_NOTIFY_LIST_ID | NUMBER | Not currently used | ||
OE_NOTIFY_LIST | VARCHAR2 | (10) | Not currently used | |
OE_NOTIFY_LIST_ID | NUMBER | Not currently used |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, CHECK_WIP_FLAG
, CHECK_OE_FLAG
, WIP_REL_JOBS_FLAG
, WIP_DAYS_OVERDUE_REL_JOBS
, WIP_UNREL_JOBS_FLAG
, WIP_DAYS_OVERDUE_UNREL_JOBS
, WIP_HOLD_JOBS_FLAG
, WIP_REL_REP_FLAG
, WIP_DAYS_OVERDUE_REL_REP
, WIP_UNREL_REP_FLAG
, WIP_DAYS_OVERDUE_UNREL_REP
, WIP_HOLD_REP_FLAG
, WIP_REQ_DATE_JOBS_FLAG
, WIP_CURR_OP_JOBS_FLAG
, WIP_PREV_OP_JOBS_FLAG
, WIP_REQ_DATE_REP_FLAG
, WIP_CURR_OP_REP_FLAG
, WIP_PREV_OP_REP_FLAG
, WIP_EXCL_BULK_COMP_FLAG
, WIP_EXCL_SUPPLIER_COMP_FLAG
, WIP_EXCL_PULL_COMP_FLAG
, WIP_NOTIF_COMP_PLANNER_FLAG
, WIP_NOTIF_ASS_PLANNER_FLAG
, WIP_NOTIF_COMP_BUYER_FLAG
, WIP_NOTIF_JOB_CREATOR_FLAG
, OE_NOTIF_ITEM_PLANNER_FLAG
, OE_NOTIF_SO_CREATOR_FLAG
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, WIP_NOTIFY_LIST
, WIP_NOTIFY_LIST_ID
, OE_NOTIFY_LIST
, OE_NOTIFY_LIST_ID
FROM INV.MTL_SHORT_CHK_PARAM;
INV.MTL_SHORT_CHK_PARAM does not reference any database object
INV.MTL_SHORT_CHK_PARAM is referenced by following:
|
|
|