Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | Enterprise view information for Web Inquiries |
Implementation/DBA Data: | APPS.MRP_WEB_ENTERPRISE_V |
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