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]

VIEW: APPS.MRP_WEB_ENTERPRISE_V

Object Details

Object Name:	MRP_WEB_ENTERPRISE_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MRP.MRP_WEB_ENTERPRISE_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 the
enterprise view for a plan and is based on MRP_MATERIAL_PLANS.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PLAN_ID	NUMBER		Yes	Query identifier
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
COMPILE_DESIGNATOR	VARCHAR2	(10)	Yes	MPS, MRP or DRP plan identifier
ORGANIZATION_CODE	VARCHAR2	(3)		Organization code
PLAN_ORGANIZATION_ID	NUMBER			Organization of the plan
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
ITEM_SEGMENTS	VARCHAR2	(255)		Item segments
SALES_ORDERS	NUMBER			Sales order quantity
FORECASTS	NUMBER			Forecast quantity
DEPENDENT_DEMAND	NUMBER			Dependent demand quantity
GROSS_REQUIREMENTS	NUMBER			Gross requirement quantity
WIP	NUMBER			WIP quantity
PURCHASE_ORDERS	NUMBER			Purchase order quantity
PURCHASE_REQUISITIONS	NUMBER			Purchase Requisition quantity
IN_TRANSIT	NUMBER			Quantity in transit
IN_RECEIVING	NUMBER			Quantity in receiving
PLANNED_ORDERS	NUMBER			Planned orders
TOTAL_SUPPLY	NUMBER			Total supply
SCHEDULED_RECEIPTS	NUMBER			Scheduled receipts
PLANNING_GROUP	VARCHAR2	(4000)		Planning group
PROJECT_ID	NUMBER			Project identifier
TASK_ID	NUMBER			Task identifier
PROJECT_NUMBER	VARCHAR2	(25)		Project number
TASK_NUMBER	VARCHAR2	(25)		Task number

Query Text

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


SELECT PLAN_ID
,      ORGANIZATION_ID
,      COMPILE_DESIGNATOR
,      ORGANIZATION_CODE
,      PLAN_ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      ITEM_SEGMENTS
,      SALES_ORDERS
,      FORECASTS
,      DEPENDENT_DEMAND
,      GROSS_REQUIREMENTS
,      WIP
,      PURCHASE_ORDERS
,      PURCHASE_REQUISITIONS
,      IN_TRANSIT
,      IN_RECEIVING
,      PLANNED_ORDERS
,      TOTAL_SUPPLY
,      SCHEDULED_RECEIPTS
,      PLANNING_GROUP
,      PROJECT_ID
,      TASK_ID
,      PROJECT_NUMBER
,      TASK_NUMBER
FROM APPS.MRP_WEB_ENTERPRISE_V;

Dependencies

[top of page]

APPS.MRP_WEB_ENTERPRISE_V references the following:

APPS: FND_PROFILE - show dependent code; MRP_GET_PROJECT - show dependent code; MRP_MATERIAL_PLANS; MRP_PROJECT_V; MRP_TASK_V; MTL_PARAMETERS; PA_CROSS_BUSINESS_GRP - show dependent code; PA_PROJECT_UTILS - show dependent code; PA_SECURITY - show dependent code; PA_TASK_UTILS - show dependent code

APPS.MRP_WEB_ENTERPRISE_V is not referenced by any database object