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

VIEW: APPS.MRP_WORKBENCH_MESSAGES_SC_V

Object Details
Object Name: MRP_WORKBENCH_MESSAGES_SC_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMRP.MRP_WORKBENCH_MESSAGES_SC_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
ROW_ID ROWID (10)
Row identifier
QUERY_ID NUMBER

Row set identifier
EXCEPTION_TYPE NUMBER

Exception type code
NUM_ITEMS NUMBER

Number of items
EXCEPTION_TYPE_TEXT VARCHAR2 (80)
Exception type text
NUM_ORDERS NUMBER

Number of orders
ORGANIZATION_ID NUMBER

Organization identifier
COMPILE_DESIGNATOR VARCHAR2 (80)
MPS, MRP or DRP plan identifier
PLAN_ORGANIZATION_ID NUMBER

Planned organization identifier
INVENTORY_ITEM_ID NUMBER

Inventory item identifier
ITEM_SEGMENTS VARCHAR2 (289)
Item segments
DISPLAY_TYPE NUMBER

Display type
PLANNER_CODE VARCHAR2 (10)
Planner code
DISPLAY NUMBER

Display meaning
Query Text

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


SELECT ROW_ID
,      QUERY_ID
,      EXCEPTION_TYPE
,      NUM_ITEMS
,      EXCEPTION_TYPE_TEXT
,      NUM_ORDERS
,      ORGANIZATION_ID
,      COMPILE_DESIGNATOR
,      PLAN_ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      ITEM_SEGMENTS
,      DISPLAY_TYPE
,      PLANNER_CODE
,      DISPLAY
FROM APPS.MRP_WORKBENCH_MESSAGES_SC_V;

Dependencies

[top of page]

APPS.MRP_WORKBENCH_MESSAGES_SC_V references the following:

SchemaAPPS
ViewMFG_LOOKUPS
SynonymMRP_FORM_QUERY
SynonymMRP_ITEM_EXCEPTIONS
ViewMRP_PLAN_ORGANIZATIONS_V
SynonymMRP_SYSTEM_ITEMS
ViewMTL_ITEM_FLEXFIELDS
SynonymMTL_PARAMETERS

APPS.MRP_WORKBENCH_MESSAGES_SC_V is not referenced by any database object