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

VIEW: APPS.MRP_EXCEPTION_DETAILS_V

Object Details
Object Name: MRP_EXCEPTION_DETAILS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMRP.MRP_EXCEPTION_DETAILS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
EXCEPTION_ID NUMBER
Yes Exception Identifier
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 Type of exception message
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
ORGANIZATION_CODE VARCHAR2 (3)
Organization code
ITEM_SEGMENTS VARCHAR2 (4000)
Item segments
EXCEPTION_TYPE_TEXT VARCHAR2 (4000)
Exception type text
PROJECT_ID NUMBER

Project identifier
TASK_ID NUMBER

Task identifier
PLANNING_GROUP_HIDDEN VARCHAR2 (80)
Planning group
PROJECT_NUMBER VARCHAR2 (4000)
Project number
TASK_NUMBER VARCHAR2 (4000)
Task number
PLANNING_GROUP VARCHAR2 (80)
Planning group
TO_PROJECT_NUMBER VARCHAR2 (4000)
To project name
TO_TASK_NUMBER VARCHAR2 (4000)
To task name
DUE_DATE DATE

order date or demand date depends on exception type
FROM_DATE DATE

From Date
TO_DATE DATE

To Date
DAYS_COMPRESSED NUMBER

Number of days compressed
QUANTITY VARCHAR2 (40)
Quantity
LOT_NUMBER VARCHAR2 (30)
Lot number
ORDER_NUMBER VARCHAR2 (4000)
Order number
SUPPLY_TYPE VARCHAR2 (4000)
Supply type
END_ITEM_SEGMENTS VARCHAR2 (4000)
End item name
END_ORDER_NUMBER VARCHAR2 (4000)
End order number
TRANSACTION_ID NUMBER

Transaction id
DEMAND_ID NUMBER

Demand identifier
DEPARTMENT_ID NUMBER

Department identifier
RESOURCE_ID NUMBER

Resource identifier
LINE_ID NUMBER

Line identifier
DEPARTMENT_LINE_CODE VARCHAR2 (10)
Department/Line code
RESOURCE_CODE VARCHAR2 (10)
Resource code
UTILIZATION_RATE NUMBER

Utilization rate
SUPPLIER_ID NUMBER

supplier id (vendor id)
SUPPLIER_NAME VARCHAR2 (4000)
Supplier Name (Vendor Name)
SUPPLIER_SITE_ID NUMBER

supplier site id (vendor site id)
SUPPLIER_SITE VARCHAR2 (4000)
supplier site (vendor site code)
Query Text

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


SELECT EXCEPTION_ID
,      COMPILE_DESIGNATOR
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      EXCEPTION_TYPE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      ORGANIZATION_CODE
,      ITEM_SEGMENTS
,      EXCEPTION_TYPE_TEXT
,      PROJECT_ID
,      TASK_ID
,      PLANNING_GROUP_HIDDEN
,      PROJECT_NUMBER
,      TASK_NUMBER
,      PLANNING_GROUP
,      TO_PROJECT_NUMBER
,      TO_TASK_NUMBER
,      DUE_DATE
,      FROM_DATE
,      TO_DATE
,      DAYS_COMPRESSED
,      QUANTITY
,      LOT_NUMBER
,      ORDER_NUMBER
,      SUPPLY_TYPE
,      END_ITEM_SEGMENTS
,      END_ORDER_NUMBER
,      TRANSACTION_ID
,      DEMAND_ID
,      DEPARTMENT_ID
,      RESOURCE_ID
,      LINE_ID
,      DEPARTMENT_LINE_CODE
,      RESOURCE_CODE
,      UTILIZATION_RATE
,      SUPPLIER_ID
,      SUPPLIER_NAME
,      SUPPLIER_SITE_ID
,      SUPPLIER_SITE
FROM APPS.MRP_EXCEPTION_DETAILS_V;

Dependencies

[top of page]

APPS.MRP_EXCEPTION_DETAILS_V references the following:

SchemaAPPS
SynonymBOM_DEPARTMENTS
SynonymBOM_RESOURCES
SynonymMRP_EXCEPTION_DETAILS
PL/SQL PackageMRP_EXCEPTION_SC - show dependent code
SynonymMRP_FULL_PEGGING
PL/SQL PackageMRP_GET_ORDER - show dependent code
PL/SQL PackageMRP_GET_PROJECT - show dependent code
SynonymMRP_GROSS_REQUIREMENTS
SynonymMRP_INVENTORY_LOTS
SynonymMRP_ONHAND_QUANTITIES
SynonymMRP_RECOMMENDATIONS
SynonymMTL_PARAMETERS
SynonymWIP_LINES
APPS.MRP_EXCEPTION_DETAILS_V is referenced by following:

SchemaAPPS
Package BodyMRP_EXP_WF - show dependent code