SELECT PA.ORGANIZATION_CODE , AL.NAME , SC.SCHEDULE_DESIGNATOR , SC.DESCRIPTION , SC.DEMAND_CLASS , LKUP.MEANING , SC.DISABLE_DATE , SC.ORGANIZATION_ID , SC.LAST_UPDATE_DATE , SC.LAST_UPDATED_BY , SC.CREATION_DATE , SC.CREATED_BY FROM MFG_LOOKUPS LKUP , MTL_PARAMETERS PA , HR_ALL_ORGANIZATION_UNITS AL , MRP_SCHEDULE_DESIGNATORS SC WHERE SC.SCHEDULE_TYPE = 1 AND SC.ORGANIZATION_ID = PA.ORGANIZATION_ID AND SC.ORGANIZATION_ID = AL.ORGANIZATION_ID AND LKUP.LOOKUP_CODE = SC.MPS_RELIEF AND LKUP.LOOKUP_TYPE = 'SYS_YES_NO' AND '_SEC:SC.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY