[Home] [Help] [Dependency Information]
Object Name: | MRP_WEB_ENTERPRISE_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | MRP.MRP_WEB_ENTERPRISE_V |
Subobject Name: | |
Status: | VALID |
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.
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 |
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;
APPS.MRP_WEB_ENTERPRISE_V is not referenced by any database object
|
|
|