Product: | MSC - Advanced Supply Chain Planning |
---|---|
Description: | MPS/MRP/DRP plan organizations view |
Implementation/DBA Data: | APPS.MSC_PLAN_ORGANIZATIONS_V |
SELECT PLANS.PLAN_ID
, PLANS.ORGANIZATION_ID
, PLANS.SR_INSTANCE_ID
, PLANS.COMPILE_DESIGNATOR
, MPO.ORGANIZATION_ID
, MPO.SR_INSTANCE_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.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)
, MPO. INCLUDE_SALESORDER
FROM MSC_PLAN_ORGANIZATIONS MPO
, MSC_PLANS PLANS
WHERE MPO.PLAN_ID = PLANS.PLAN_ID