SELECT GuiUsers.GUI_USER_ID,
       GuiUsers.OPERATION_CENTER_ID,
       GuiUsers.LOGINNAME,
       GuiUsers.LOGINPWD,
       GuiUsers.FIRST_NAME,
       GuiUsers.LAST_NAME,
       GuiUsers.GENDER,
       GuiUsers.LANGUAGE,
       GuiUsers.PHONE,
       GuiUsers.MOBILE,
       GuiUsers.EMAIL,
       GuiUsers.ACTION_ALLOWED,
       GuiUsers.ACTION_UNLIMITED,
       GuiUsers.ACTION_CREDIT,
       GuiUsers.USER_ADMIN_RIGHT,
       GuiUsers.CONTRACT_REF,
       GuiUsers.LM_DATE,
       GuiUsers.LM_NAME,
       GuiUsers.LM_COMMENT,
       GuiUsers.FWD_SMS,
       GuiUsers.FWD_EMAIL,
       GuiUsers.PREFERENCES,
       GuiUsers.LAST_CONNECTION_DATE,
       GuiUsers.FWD_LEVEL,
       GuiUsers.POI_ID,
       (SELECT oc.name FROM operation_center oc WHERE oc.operation_center_id = GuiUsers.operation_center_id) AS VIEW_ATTR,
       GuiUsers.PROFILED_PERSON_ID,
       (MfcMobileWorker.IONIC_MF_MOBILE_APP_ID) AS VIEW_ATTR,
       GuiUsers.IS_ACTIVE,
       GuiUsers.IS_SYNC_WITH_KNOWLEDGE_BASE,
       GuiUsers.HIDE_LOGINPWD
FROM GUI_USERS GuiUsers, V_UPDATABLE_PERSON Person, OF_OWNER."MFC_MOBILE_WORKER" MfcMobileWorker
WHERE (GuiUsers.USER_ADMIN_RIGHT != 'MF' OR ? = 'true')
AND (NVL(GuiUsers.IS_ACTIVE,'Y') = 'Y' OR ? = 'true')
AND GuiUsers.PROFILED_PERSON_ID = person.person_id (+)
AND person.person_id = MfcMobileWorker.ERP_ID(+)
AND (person.person_id IS NULL OR person.person_status_id =0)
ORDER BY GuiUsers.LAST_NAME, GuiUsers.FIRST_NAME