List of all Organizations from plan along with additional entry for All as organization. When All is selected, Planning Detail Report will consider all the organizations defined in the plan.
SELECT ORGANIZATION_ID , ORGANIZATION_CODE , SR_INSTANCE_ID , PLAN_ID FROM MSC_PLAN_ORGANIZATIONS UNION ALL SELECT LOOKUP_CODE ORGANIZATION_ID , MEANING ORGANIZATION_CODE , TO_NUMBER(NULL) SR_INSTANCE_ID , TO_NUMBER(NULL) PLAN_ID FROM MFG_LOOKUPS WHERE LOOKUP_TYPE='MSC_ALL_ORGANIZATIONS'