VIEW: APPS.MRP_WEB_PLAN_ITEMS_V

Source

View Text - Preformatted

SELECT DISTINCT ITEMS.INVENTORY_ITEM_ID ,ITEMS.ITEM_SEGMENTS , ITEMS.ORGANIZATION_ID , ITEMS.ORGANIZATION_CODE , ITEMS.COMPILE_DESIGNATOR ,NVL(ORDERS.PLANNING_GROUP, '-') ,NVL(ORDERS.PROJECT_ID,-1) ,NVL(ORDERS.TASK_ID,-1) ,MRP_GET_PROJECT.PROJECT( ORDERS.PROJECT_ID) ,MRP_GET_PROJECT.TASK(ORDERS.TASK_ID) , 2 , 1 , 1 ,ORDERS.PLANNING_GROUP FROM MRP_RECOMMENDATIONS ORDERS, MRP_SYSTEM_ITEMS_SC_V ITEMS, MRP_PLANS PLANS WHERE ORDERS.ORGANIZATION_ID(+) = ITEMS.ORGANIZATION_ID AND ORDERS.INVENTORY_ITEM_ID(+) = ITEMS.INVENTORY_ITEM_ID AND ORDERS.COMPILE_DESIGNATOR(+) = ITEMS.COMPILE_DESIGNATOR AND ITEMS.COMPILE_DESIGNATOR = PLANS.COMPILE_DESIGNATOR AND PLANS.PLAN_COMPLETION_DATE IS NOT NULL UNION SELECT DISTINCT ITEMS.INVENTORY_ITEM_ID ,ITEMS.ITEM_SEGMENTS , ITEMS.ORGANIZATION_ID , ITEMS.ORGANIZATION_CODE , ITEMS.COMPILE_DESIGNATOR ,NVL(ORDERS.PLANNING_GROUP, '-') ,NVL(ORDERS.PROJECT_ID,-1) ,NVL(ORDERS.TASK_ID,-1) ,MRP_GET_PROJECT.PROJECT( ORDERS.PROJECT_ID) ,MRP_GET_PROJECT.TASK(ORDERS.TASK_ID) , 2 , 1 , 1 ,ORDERS.PLANNING_GROUP FROM MRP_GROSS_REQUIREMENTS ORDERS, MRP_SYSTEM_ITEMS_SC_V ITEMS, MRP_PLANS PLANS WHERE ORDERS.ORGANIZATION_ID(+) = ITEMS.ORGANIZATION_ID AND ORDERS.INVENTORY_ITEM_ID(+) = ITEMS.INVENTORY_ITEM_ID AND ORDERS.COMPILE_DESIGNATOR(+) = ITEMS.COMPILE_DESIGNATOR AND ITEMS.COMPILE_DESIGNATOR = PLANS.COMPILE_DESIGNATOR AND PLANS.PLAN_COMPLETION_DATE IS NOT NULL

View Text - HTML Formatted

SELECT DISTINCT ITEMS.INVENTORY_ITEM_ID
, ITEMS.ITEM_SEGMENTS
, ITEMS.ORGANIZATION_ID
, ITEMS.ORGANIZATION_CODE
, ITEMS.COMPILE_DESIGNATOR
, NVL(ORDERS.PLANNING_GROUP
, '-')
, NVL(ORDERS.PROJECT_ID
, -1)
, NVL(ORDERS.TASK_ID
, -1)
, MRP_GET_PROJECT.PROJECT( ORDERS.PROJECT_ID)
, MRP_GET_PROJECT.TASK(ORDERS.TASK_ID)
, 2
, 1
, 1
, ORDERS.PLANNING_GROUP
FROM MRP_RECOMMENDATIONS ORDERS
, MRP_SYSTEM_ITEMS_SC_V ITEMS
, MRP_PLANS PLANS
WHERE ORDERS.ORGANIZATION_ID(+) = ITEMS.ORGANIZATION_ID
AND ORDERS.INVENTORY_ITEM_ID(+) = ITEMS.INVENTORY_ITEM_ID
AND ORDERS.COMPILE_DESIGNATOR(+) = ITEMS.COMPILE_DESIGNATOR
AND ITEMS.COMPILE_DESIGNATOR = PLANS.COMPILE_DESIGNATOR
AND PLANS.PLAN_COMPLETION_DATE IS NOT NULL UNION SELECT DISTINCT ITEMS.INVENTORY_ITEM_ID
, ITEMS.ITEM_SEGMENTS
, ITEMS.ORGANIZATION_ID
, ITEMS.ORGANIZATION_CODE
, ITEMS.COMPILE_DESIGNATOR
, NVL(ORDERS.PLANNING_GROUP
, '-')
, NVL(ORDERS.PROJECT_ID
, -1)
, NVL(ORDERS.TASK_ID
, -1)
, MRP_GET_PROJECT.PROJECT( ORDERS.PROJECT_ID)
, MRP_GET_PROJECT.TASK(ORDERS.TASK_ID)
, 2
, 1
, 1
, ORDERS.PLANNING_GROUP
FROM MRP_GROSS_REQUIREMENTS ORDERS
, MRP_SYSTEM_ITEMS_SC_V ITEMS
, MRP_PLANS PLANS
WHERE ORDERS.ORGANIZATION_ID(+) = ITEMS.ORGANIZATION_ID
AND ORDERS.INVENTORY_ITEM_ID(+) = ITEMS.INVENTORY_ITEM_ID
AND ORDERS.COMPILE_DESIGNATOR(+) = ITEMS.COMPILE_DESIGNATOR
AND ITEMS.COMPILE_DESIGNATOR = PLANS.COMPILE_DESIGNATOR
AND PLANS.PLAN_COMPLETION_DATE IS NOT NULL