SELECT TY.CHANGE_ORDER_TYPE CHANGE_TYPE_CODE , RU.ENG_CHANGE_PRIORITY_CODE PRIORITY_CODE , PA.ORGANIZATION_CODE , AL.NAME ORGANIZATION_NAME , RU.PROCESS_NAME WORKFLOW_PROCESS_NAME , RU.CHANGE_ORDER_TYPE_ID , RU.ORGANIZATION_ID , RU.LAST_UPDATE_DATE , RU.LAST_UPDATED_BY , RU.CREATION_DATE , RU.CREATED_BY FROM MTL_PARAMETERS PA , ENG_CHANGE_ORDER_TYPES TY , HR_ALL_ORGANIZATION_UNITS AL , ENG_CHANGE_TYPE_PROCESSES RU WHERE RU.CHANGE_ORDER_TYPE_ID = TY.CHANGE_ORDER_TYPE_ID AND RU.ORGANIZATION_ID = PA.ORGANIZATION_ID AND RU.ORGANIZATION_ID = AL.ORGANIZATION_ID AND '_SEC:RU.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY