eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: MRP.MRP_RELIEF_INTERFACE

Object Details

Object Name:	MRP_RELIEF_INTERFACE
Object Type:	TABLE
Owner:	MRP
FND Design Data:	MRP.MRP_RELIEF_INTERFACE
Subobject Name:
Status:	VALID

MRP_RELIEF_INTERFACE is a table which stores information used for
master schedule relief. Each entry represents a transaction that
affects either a master production or master demand schedule.
.
Entries are created by WIP and PO via database triggers on the tables
WIP_DISCRETE_JOBS and MTL_SUPPLY, respectively. A row is created
everytime a discrete job, purchase order or purchase requisition is
created, closed, or modified.
.
When rows are inserted to MRP_RELIEF_INTERFACE the process_status is
set to 2 (waiting to be processed). Relief is performed by MRLSCC, a
subroutine of the Planning Manger Worker. This program looks for all
rows with a PROCESS_STATUS of 2, a null ERROR_MESSAGE and a null
REQUEST_ID. It changes the PROCESS_STATUS of these rows to 3 (in
process). The appropriate routine is then called to consume the rows
flagged. If schedule consumption fails for a row the PROCESS_STATUS
will be changed to 4 (processing error) and an error message will be
written to the ERROR_MESSAGE field of the row. If schedule
consumption succeeds for a row, the PROCESS_STATUS will be changed to
5.
.
The SOURCE_CODE column can be used to identify third party software
for loading the MRP_RELIEF_INTERFACE table. The SOURCE_LINE_ID can be
used to show where the imported data came from within the third party
software (for example, table_name, field_name).
.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MRP_RELIEF_INTERFACE_U1	NORMAL	UNIQUE	APPS_TS_INTERFACE	TRANSACTION_ID
MRP_RELIEF_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	REQUEST_ID PROCESS_STATUS
MRP_RELIEF_INTERFACE_N2	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	PROCESS_STATUS INVENTORY_ITEM_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_ID	NUMBER		Yes	Unique 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
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
NEW_ORDER_QUANTITY	NUMBER		Yes	Quantity to be relieved
OLD_ORDER_QUANTITY	NUMBER			Original quantity if already existed
NEW_ORDER_DATE	DATE		Yes	Date to be relieved
OLD_ORDER_DATE	DATE			Original date if already existed
DISPOSITION_ID	NUMBER		Yes	Disposition id
PLANNED_ORDER_ID	NUMBER			Planned order identifier
RELIEF_TYPE	NUMBER		Yes	Relief type
DISPOSITION_TYPE	NUMBER		Yes	Disposition type
DEMAND_CLASS	VARCHAR2	(30)		Demand class identifier
OLD_DEMAND_CLASS	VARCHAR2	(30)		Old demand class identifier
LINE_NUM	VARCHAR2	(30)		Line number on po's and sales orders
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
PROCESS_STATUS	NUMBER		Yes	Identifies the stage of processing the row is in
SOURCE_CODE	VARCHAR2	(10)		Source code of the application software which imported rows into the table
SOURCE_LINE_ID	NUMBER			Identifier of the data in the source application
ERROR_MESSAGE	VARCHAR2	(240)		Error message if processing failed
PROJECT_ID	NUMBER	(22)		Project identifier
TASK_ID	NUMBER	(22)		Task identifier
OLD_PROJECT_ID	NUMBER			Old Project identifier
OLD_TASK_ID	NUMBER			Old task identifier

Query Text

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


SELECT TRANSACTION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      NEW_ORDER_QUANTITY
,      OLD_ORDER_QUANTITY
,      NEW_ORDER_DATE
,      OLD_ORDER_DATE
,      DISPOSITION_ID
,      PLANNED_ORDER_ID
,      RELIEF_TYPE
,      DISPOSITION_TYPE
,      DEMAND_CLASS
,      OLD_DEMAND_CLASS
,      LINE_NUM
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PROCESS_STATUS
,      SOURCE_CODE
,      SOURCE_LINE_ID
,      ERROR_MESSAGE
,      PROJECT_ID
,      TASK_ID
,      OLD_PROJECT_ID
,      OLD_TASK_ID
FROM MRP.MRP_RELIEF_INTERFACE;

Dependencies

[top of page]

MRP.MRP_RELIEF_INTERFACE does not reference any database object

MRP.MRP_RELIEF_INTERFACE is referenced by following:

APPS: MRP_RELIEF_INTERFACE