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_PLANNED_SUPPLY_V

Object Details

Object Name:	MRP_WEB_PLANNED_SUPPLY_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MRP.MRP_WEB_PLANNED_SUPPLY_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
supply information for items in a plan and is based
on MRP_RECOMMENDATIONS.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
TRANSACTION_ID	NUMBER		Yes	Transaction identifier
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
ORGANIZATION_ID	NUMBER		Yes	Organization identifier
ORGANIZATION_CODE	VARCHAR2	(3)		Organization code
PLAN_ORGANIZATION_ID	NUMBER		Yes	Organization identifier of the plan
COMPILE_DESIGNATOR	VARCHAR2	(10)	Yes	MPS, MRP or DRP plan identifier
NEW_DUE_DATE	DATE		Yes	New schedule completion date
ORDER_NUMBER	VARCHAR2	(60)		Order number
DISPOSITION_STATUS_TYPE	NUMBER		Yes	Disposition type code
ORDER_TYPE	NUMBER		Yes	Order type code
ORDER_TYPE_TEXT	VARCHAR2	(80)	Yes	Order type text
VENDOR_ID	NUMBER			Supplier identifier
QUANTITY_RATE	NUMBER		Yes	Order quantity
NEW_ORDER_DATE	DATE			Suggested order date
NEW_DOCK_DATE	DATE			Suggested dock date
ITEM_SEGMENTS	VARCHAR2	(40)		Item segments
FIRM_PLANNED_TYPE	NUMBER		Yes	Firm flag
FIRM_PLANNED_TYPE_TEXT	VARCHAR2	(80)	Yes	Firm planned type text
SUGGESTED_ACTION	VARCHAR2	(80)		Suggested action on the order
SOURCE_VENDOR_ID	NUMBER			Source supplier identifier
SOURCE_VENDOR_NAME	VARCHAR2	(240)		Source supplier name
SOURCE_VENDOR_SITE_ID	NUMBER			Source supplier site identifier
SOURCE_VENDOR_SITE_CODE	VARCHAR2	(15)		Source supplier site code
PROJECT_ID	NUMBER			Project identifier
TASK_ID	NUMBER			Task identifier
PROJECT_NUMBER	VARCHAR2	(4000)		Project number
TASK_NUMBER	VARCHAR2	(4000)		Task number
PLANNING_GROUP	VARCHAR2	(30)		Planning group
HORIZONTAL_PLAN	NUMBER			Horizontal plan identifier
ENTERPRISE_VIEW	NUMBER			Enterprise view identifier
PLANNING_GROUP_TEXT	VARCHAR2	(30)		Planning group

Query Text

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


SELECT TRANSACTION_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      ORGANIZATION_CODE
,      PLAN_ORGANIZATION_ID
,      COMPILE_DESIGNATOR
,      NEW_DUE_DATE
,      ORDER_NUMBER
,      DISPOSITION_STATUS_TYPE
,      ORDER_TYPE
,      ORDER_TYPE_TEXT
,      VENDOR_ID
,      QUANTITY_RATE
,      NEW_ORDER_DATE
,      NEW_DOCK_DATE
,      ITEM_SEGMENTS
,      FIRM_PLANNED_TYPE
,      FIRM_PLANNED_TYPE_TEXT
,      SUGGESTED_ACTION
,      SOURCE_VENDOR_ID
,      SOURCE_VENDOR_NAME
,      SOURCE_VENDOR_SITE_ID
,      SOURCE_VENDOR_SITE_CODE
,      PROJECT_ID
,      TASK_ID
,      PROJECT_NUMBER
,      TASK_NUMBER
,      PLANNING_GROUP
,      HORIZONTAL_PLAN
,      ENTERPRISE_VIEW
,      PLANNING_GROUP_TEXT
FROM APPS.MRP_WEB_PLANNED_SUPPLY_V;

Dependencies

[top of page]

APPS.MRP_WEB_PLANNED_SUPPLY_V references the following:

APPS: MFG_LOOKUPS; MRP_GET_PROJECT - show dependent code; MRP_ITEM_PURCHASE_ORDERS; MRP_PLANS; MRP_PLAN_ORGANIZATIONS; MRP_RECOMMENDATIONS; MRP_SYSTEM_ITEMS; MTL_ITEM_FLEXFIELDS; PO_VENDORS; PO_VENDOR_SITES_ALL

APPS.MRP_WEB_PLANNED_SUPPLY_V is not referenced by any database object