View: MRP_WEB_PLAN_ITEMS_V

Product:	MRP - Master Scheduling/MRP
Description:	Items Information
Implementation/DBA Data:	APPS.MRP_WEB_PLAN_ITEMS_V

View Text

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

Columns