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

VIEW: APPS.MRP_WEB_PLAN_ITEMS_V

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

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.


This view is used by the Planning Web Inquiries to display
information for all items in a plan and is based
on MRP_RECOMMENDATIONS and MRP_SYSTEM_ITEMS_SC_V.


[View Source]

Columns
Name Datatype Length Mandatory Comments
INVENTORY_ITEM_ID NUMBER

Inventory item identifier
ITEM_SEGMENTS VARCHAR2 (40)
Item segments
ORGANIZATION_ID NUMBER

Organization identifier
ORGANIZATION_CODE VARCHAR2 (3)
Organization code
COMPILE_DESIGNATOR VARCHAR2 (10)
MPS, MRP or DRP plan identifier
PLANNING_GROUP VARCHAR2 (30)
Planning group
PROJECT_ID NUMBER

Project identifier
TASK_ID NUMBER

Task identifier
PROJECT_NUMBER VARCHAR2 (4000)
Project number
TASK_NUMBER VARCHAR2 (4000)
Task number
HORIZONTAL_PLAN NUMBER

Horizontal plan identifier
ENTERPRISE_VIEW NUMBER

Enterprise view identifier
KEY NUMBER

Not currently used
PLANNING_GROUP_TEXT VARCHAR2 (30)
Planning group
Query Text

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


SELECT INVENTORY_ITEM_ID
,      ITEM_SEGMENTS
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      COMPILE_DESIGNATOR
,      PLANNING_GROUP
,      PROJECT_ID
,      TASK_ID
,      PROJECT_NUMBER
,      TASK_NUMBER
,      HORIZONTAL_PLAN
,      ENTERPRISE_VIEW
,      KEY
,      PLANNING_GROUP_TEXT
FROM APPS.MRP_WEB_PLAN_ITEMS_V;

Dependencies

[top of page]

APPS.MRP_WEB_PLAN_ITEMS_V references the following:

SchemaAPPS
PL/SQL PackageMRP_GET_PROJECT - show dependent code
SynonymMRP_GROSS_REQUIREMENTS
SynonymMRP_PLANS
SynonymMRP_RECOMMENDATIONS
ViewMRP_SYSTEM_ITEMS_SC_V

APPS.MRP_WEB_PLAN_ITEMS_V is not referenced by any database object