VIEW: APPS.MSC_PLAN_ORGANIZATIONS_V

Source

View Text - Preformatted

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 ,PLANS.FORECAST_ASSIGNMENT_SET_ID ,MPO.curr_ds_enabled_flag ds_enabled_flag ,MPO.curr_frozen_horizon_days frozen_horizon_days ,MPO.curr_respect_max_accept_days respect_max_acceptable_days ,MPO.curr_min_supply_lead_time minimize_supply_lead_time ,MPO.NET_ON_HAND ,PLANS.EXPLODE_FORECAST ,MPO.PRODUCTION_SCHEDULE_ID ,MPO.FIRM_HORIZON_DAYS ,MPO.INCLUDE_PRODUCTION_SCHEDULE ,MPO.FORECAST_CALENDAR FROM MSC_PLAN_ORGANIZATIONS MPO, MSC_PLANS PLANS WHERE MPO.PLAN_ID = PLANS.PLAN_ID

View Text - HTML Formatted

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
, PLANS.FORECAST_ASSIGNMENT_SET_ID
, MPO.CURR_DS_ENABLED_FLAG DS_ENABLED_FLAG
, MPO.CURR_FROZEN_HORIZON_DAYS FROZEN_HORIZON_DAYS
, MPO.CURR_RESPECT_MAX_ACCEPT_DAYS RESPECT_MAX_ACCEPTABLE_DAYS
, MPO.CURR_MIN_SUPPLY_LEAD_TIME MINIMIZE_SUPPLY_LEAD_TIME
, MPO.NET_ON_HAND
, PLANS.EXPLODE_FORECAST
, MPO.PRODUCTION_SCHEDULE_ID
, MPO.FIRM_HORIZON_DAYS
, MPO.INCLUDE_PRODUCTION_SCHEDULE
, MPO.FORECAST_CALENDAR
FROM MSC_PLAN_ORGANIZATIONS MPO
, MSC_PLANS PLANS
WHERE MPO.PLAN_ID = PLANS.PLAN_ID