VIEW: APPS.MRP_PLAN_ORGANIZATIONS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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