[Home] [Help]
View: MRP_LAST_PLAN_ORGS_V
View Text
SELECT PLANS.ORGANIZATION_ID
, PLANS.COMPILE_DESIGNATOR
, PLANS.ORGANIZATION_ID
FROM MRP_PLANS PLANS
WHERE NVL( PLANS.ORGANIZATION_SELECTION
, 1) = 1 UNION ALL SELECT /* INDEX(MPO MRP_PLAN_ORGANIZATIONS_U1) */ MPO.ORGANIZATION_ID
, MPO.COMPILE_DESIGNATOR
, MPO.PLANNED_ORGANIZATION
FROM MRP_PLAN_ORGANIZATIONS MPO
WHERE MPO.PLAN_LEVEL IN (3
, 4)
Columns
Name |
ORGANIZATION_ID |
COMPILE_DESIGNATOR |
PLANNED_ORGANIZATION |