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: ViewMRP.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:

SchemaAPPS
ViewMFG_LOOKUPS
PL/SQL PackageMRP_GET_PROJECT - show dependent code
SynonymMRP_ITEM_PURCHASE_ORDERS
SynonymMRP_PLANS
SynonymMRP_PLAN_ORGANIZATIONS
SynonymMRP_RECOMMENDATIONS
SynonymMRP_SYSTEM_ITEMS
ViewMTL_ITEM_FLEXFIELDS
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL

APPS.MRP_WEB_PLANNED_SUPPLY_V is not referenced by any database object