View: MRP_PLAN_ORGANIZATIONS_V

Product:	MRP - Master Scheduling/MRP
Description:	MPS/MRP plan organizations view
Implementation/DBA Data:	APPS.MRP_PLAN_ORGANIZATIONS_V

View Text

SELECT /* INDEX(MPO MRP_PLAN_ORGANIZATIONS_U1) */ PLANS.ORGANIZATION_ID
, PLANS.COMPILE_DESIGNATOR
, NVL(MPO.PLANNED_ORGANIZATION
, PLANS.ORGANIZATION_ID)
, PLANS.CURR_OPERATION_SCHEDULE_TYPE
, PLANS.CURR_PLAN_TYPE
, PLANS.CURR_OVERWRITE_OPTION
, PLANS.CURR_APPEND_PLANNED_ORDERS
, PLANS.CURR_CUTOFF_DATE
, PLANS.CURR_PART_INCLUDE_TYPE
, PLANS.CURR_PLANNING_TIME_FENCE_FLAG
, PLANS.CURR_DEMAND_TIME_FENCE_FLAG
, NVL(MPO.NET_RESERVATIONS
, PLANS.CURR_CONSIDER_RESERVATIONS)
, NVL(MPO.PLAN_SAFETY_STOCK
, PLANS.CURR_PLAN_SAFETY_STOCK)
, NVL(MPO.NET_WIP
, PLANS.CURR_CONSIDER_WIP)
, NVL(MPO.NET_PURCHASING
, PLANS.CURR_CONSIDER_PO)
, PLANS.CURR_ASSIGNMENT_SET_ID
, NVL(PLANS.ORGANIZATION_SELECTION
, 1)
, PLANS.PLAN_COMPLETION_DATE
, PLANS.PLAN_START_DATE
, PLANS.CURR_SCHEDULE_TYPE
, PLANS.USE_NEW_PLANNER
, PLANS.CURR_PLAN_CAPACITY_FLAG
, NVL (MPO.SIMULATION_SET
, PLANS.CURR_SIMULATION_SET)
, NVL(MPO.BILL_OF_RESOURCES
, PLANS.CURR_BILL_OF_RESOURCES)
, NVL(PLANS.CURR_RESERVATION_LEVEL
, 4)
FROM MRP_PLAN_ORGANIZATIONS MPO
, MRP_PLANS PLANS
WHERE MPO.PLAN_LEVEL(+) = 2
AND MPO.COMPILE_DESIGNATOR(+) = PLANS.COMPILE_DESIGNATOR
AND MPO.ORGANIZATION_ID(+) = PLANS.ORGANIZATION_ID

Columns