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

TABLE: MRP.MRP_EXCEPTION_DETAILS

Object Details
Object Name: MRP_EXCEPTION_DETAILS
Object Type: TABLE
Owner: MRP
FND Design Data: TableMRP.MRP_EXCEPTION_DETAILS
Subobject Name:
Status: VALID


MRP_EXCEPTION_DETAILS table stores details about exceptions which are
generated by the planner. The table stores exception details
information for item/org or department/resource combinations depending
on whether it is a material or capacity exception.
The exception attributes and quantities used are dependent on the
nature of exception which is stored in EXCEPTION_TYPE column.
For example, if the exception_type is to reschedule a discrete job,
the transaction_identifier is populated into the number1 column and
the from_date and to_date are populated in the date1 and date2 columns
respectively. Similarly for a Late Sales Order exception, the
transaction_id and end_pegging_id are populated in the number1 and
number2 columns while the order_date is populated in the date1 column.
Data in this table can be viewed in the exception details window of
the Planner's workbench form.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MRP_EXCEPTION_DETAILS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnEXCEPTION_ID
MRP_EXCEPTION_DETAILS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEXCEPTION_TYPE
ColumnCOMPILE_DESIGNATOR
ColumnORGANIZATION_ID
ColumnINVENTORY_ITEM_ID
ColumnDEPARTMENT_ID
ColumnRESOURCE_ID
ColumnLINE_ID
MRP_EXCEPTION_DETAILS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORGANIZATION_ID
ColumnCOMPILE_DESIGNATOR
Columns
Name Datatype Length Mandatory Comments
COMPILE_DESIGNATOR VARCHAR2 (10) Yes MPS, MRP or DRP plan identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
EXCEPTION_TYPE NUMBER
Yes Exception type
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
QUANTITY NUMBER

Exception quantity
DATE1 DATE

Generic date column
DATE2 DATE

Generic date column
DATE3 DATE

Not currently used
DATE4 DATE

Not currently used
NUMBER1 NUMBER

Generic number column
NUMBER2 NUMBER

Generic number column
NUMBER3 NUMBER

Not currently used
NUMBER4 NUMBER

Not currently used
CHAR1 VARCHAR2 (80)
Generic character column
CHAR2 VARCHAR2 (80)
Generic character column
DEPARTMENT_ID NUMBER

Department identifier
RESOURCE_ID NUMBER

Resource identifier
LINE_ID NUMBER

Line identifier
EXCEPTION_ID NUMBER
Yes unique key
SUPPLIER_ID NUMBER

Generic number column
SUPPLIER_SITE_ID NUMBER

Generic number column
Query Text

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


SELECT COMPILE_DESIGNATOR
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      EXCEPTION_TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      QUANTITY
,      DATE1
,      DATE2
,      DATE3
,      DATE4
,      NUMBER1
,      NUMBER2
,      NUMBER3
,      NUMBER4
,      CHAR1
,      CHAR2
,      DEPARTMENT_ID
,      RESOURCE_ID
,      LINE_ID
,      EXCEPTION_ID
,      SUPPLIER_ID
,      SUPPLIER_SITE_ID
FROM MRP.MRP_EXCEPTION_DETAILS;

Dependencies

[top of page]

MRP.MRP_EXCEPTION_DETAILS does not reference any database object

MRP.MRP_EXCEPTION_DETAILS is referenced by following:

SchemaMRP
ViewMRP_EXCEPTION_DETAILS#