[Home] [Help] [Dependency Information]
Object Name: | MRP_SCHEDULE_CONSUMPTIONS |
---|---|
Object Type: | TABLE |
Owner: | MRP |
FND Design Data: | MRP.MRP_SCHEDULE_CONSUMPTIONS |
Subobject Name: | |
Status: | VALID |
MRP_SCHEDULE_CONSUMPTIONS tracks master schedule relief. Each entry
represents a relief that took place for a particular schedule entry,
as a result of the shipment of a sales order for a master demand
schedule, or the creation of a discrete job, purchase order, purchase
order in receiving, intransit shipment, intransit receipt, or purchase
requisitions for a master production schedule.
.
TRANSACTION_ID identifies the specific entry in MRP_SCHEDULE_DATES
that was relieved. The DISPOSITION_ID stores the id of the sales
order that generated the relief of an MDS, or the appropriate
identifier for the discrete job, repetitive schedule, purchase order,
purchase order in receiving, intransit shipment, intransit receipt, or
purchase requisition that generated the relief of an MPS.
.
The ORDER_DATE and ORDER_QUANTITY hold the date and quantity of the
sales order or discrete job, while the SCHEDULE_DATE and
RELIEF_QUANTITY store the date of the schedule that was relieved and
the quantity of the sales order or discrete job that was actually
applied to relieve this schedule entry.
.
This table is populated during schedule relief, which is performed by
the Planning Manager.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MRP_SCHEDULE_CONSUMPTIONS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
TRANSACTION_ID
RELIEF_TYPE DISPOSITION_TYPE DISPOSITION_ID LINE_NUM |
MRP_SCHEDULE_CONSUMPTIONS_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
DISPOSITION_ID
DISPOSITION_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TRANSACTION_ID | NUMBER | Yes | Schedule identifier | |
RELIEF_TYPE | NUMBER | Yes | Relief type | |
DISPOSITION_TYPE | NUMBER | Yes | Disposition type | |
DISPOSITION_ID | NUMBER | Disposition id | ||
LINE_NUM | VARCHAR2 | (30) | Order line number | |
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 | ||
ORDER_DATE | DATE | Yes | Date of order | |
ORDER_QUANTITY | NUMBER | Yes | Quantity of the order | |
RELIEF_QUANTITY | NUMBER | Yes | Quantity of order applied towards relief | |
SCHEDULE_DATE | DATE | Yes | Date of schedule entry | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT TRANSACTION_ID
, RELIEF_TYPE
, DISPOSITION_TYPE
, DISPOSITION_ID
, LINE_NUM
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, ORDER_DATE
, ORDER_QUANTITY
, RELIEF_QUANTITY
, SCHEDULE_DATE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM MRP.MRP_SCHEDULE_CONSUMPTIONS;
MRP.MRP_SCHEDULE_CONSUMPTIONS does not reference any database object
MRP.MRP_SCHEDULE_CONSUMPTIONS is referenced by following:
|
|
|