SELECT PLANS.ORGANIZATION_ID , PLANS.COMPILE_DESIGNATOR , NVL(MPO.PLANNED_ORGANIZATION, PLANS.ORGANIZATION_ID) , PLANS.curr_cutoff_date , plans.plan_completion_date FROM MRP_PLAN_ORGANIZATIONS MPO, MRP_PLANS PLANS WHERE MPO.ORGANIZATION_ID (+) = PLANS.ORGANIZATION_ID AND MPO.COMPILE_DESIGNATOR(+) = PLANS.COMPILE_DESIGNATOR AND MPO.PLAN_LEVEL (+) = 2 UNION SELECT PLANS.ORGANIZATION_ID, PLANS.COMPILE_DESIGNATOR, PLANS.ORGANIZATION_ID, plans.curr_cutoff_date, plans.plan_completion_date FROM MRP_PLANS PLANS
SELECT PLANS.ORGANIZATION_ID
, PLANS.COMPILE_DESIGNATOR
, NVL(MPO.PLANNED_ORGANIZATION
, PLANS.ORGANIZATION_ID)
, PLANS.CURR_CUTOFF_DATE
, PLANS.PLAN_COMPLETION_DATE
FROM MRP_PLAN_ORGANIZATIONS MPO
, MRP_PLANS PLANS
WHERE MPO.ORGANIZATION_ID (+) = PLANS.ORGANIZATION_ID
AND MPO.COMPILE_DESIGNATOR(+) = PLANS.COMPILE_DESIGNATOR
AND MPO.PLAN_LEVEL (+) = 2 UNION SELECT PLANS.ORGANIZATION_ID
, PLANS.COMPILE_DESIGNATOR
, PLANS.ORGANIZATION_ID
, PLANS.CURR_CUTOFF_DATE
, PLANS.PLAN_COMPLETION_DATE
FROM MRP_PLANS PLANS
|
|
|