VIEW: APPS.MRP_WEB_ENTERPRISE_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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