SELECT PA.ORGANIZATION_CODE , AL.NAME , SI.SIMULATION_SET , SI.DESCRIPTION , LKUP.MEANING , SI.ORGANIZATION_ID , SI.LAST_UPDATE_DATE , SI.LAST_UPDATED_BY , SI.CREATION_DATE , SI.CREATED_BY FROM MFG_LOOKUPS LKUP , MTL_PARAMETERS PA , HR_ALL_ORGANIZATION_UNITS AL , CRP_SIMULATION_SETS SI WHERE SI.ORGANIZATION_ID = PA.ORGANIZATION_ID AND SI.ORGANIZATION_ID = AL.ORGANIZATION_ID AND LKUP.LOOKUP_CODE = SI.USE_IN_WIP_FLAG AND LKUP.LOOKUP_TYPE = 'SYS_YES_NO' AND '_SEC:SI.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY