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.

[Home] [Help]

View: MRP_WEB_ENTERPRISE_V

Product:	MRP - Master Scheduling/MRP
Description:	Enterprise view information for Web Inquiries
Implementation/DBA Data:	APPS.MRP_WEB_ENTERPRISE_V

View Text

SELECT PLANS.PLAN_ID
, PLANS.ORGANIZATION_ID
, PLANS.COMPILE_DESIGNATOR
, PARAM.ORGANIZATION_CODE
, PLANS.PLAN_ORGANIZATION_ID
, PLANS.INVENTORY_ITEM_ID
, PLANS.ITEM_SEGMENTS
, PLANS.QUANTITY1
, PLANS.QUANTITY2
, PLANS.QUANTITY3
, PLANS.QUANTITY6
, PLANS.QUANTITY7
, PLANS.QUANTITY8
, PLANS.QUANTITY9
, PLANS.QUANTITY10
, PLANS.QUANTITY11
, PLANS.QUANTITY12
, PLANS.QUANTITY13
, PLANS.QUANTITY18
, NVL( PRJ.PLANNING_GROUP
, '-')
, NVL( PRJ.PROJECT_ID
, -1)
, NVL( TSK.TASK_ID
, -1)
, PRJ.PROJECT_NUMBER
, TSK.TASK_NUMBER
FROM MRP_MATERIAL_PLANS PLANS
, MTL_PARAMETERS PARAM
, MRP_PROJECT_V PRJ
, MRP_TASK_V TSK
WHERE NVL(TSK.PROJECT_ID
, 1) = NVL(PRJ.PROJECT_ID
, 1)
AND PARAM.ORGANIZATION_ID = PLANS.ORGANIZATION_ID
AND PLANS.PLAN_ID = (SELECT MAX(PLAN_ID)
FROM MRP_MATERIAL_PLANS)
AND HORIZONTAL_PLAN_TYPE = 10

Columns

Name
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