SELECT OcPoiCategory.OC_POI_CATEGORY_ID,
       OcPoiCategory.NAME
FROM OC_POI_CATEGORY OcPoiCategory, V_GUI_USER_OC_POI_CATEGORY VGuiUserOcPoiCategory, OPERATION_CENTER OperationCenter
WHERE OcPoiCategory.OPERATION_CENTER_ID = OperationCenter.OPERATION_CENTER_ID
AND OcPoiCategory.OC_POI_CATEGORY_ID = VGuiUserOcPoiCategory.OC_POI_CATEGORY_ID
AND VGuiUserOcPoiCategory.OC_POI_CATEGORY_ID NOT IN (SELECT home_poi_category_id FROM vo_person_category)
AND VGuiUserOcPoiCategory.GUI_USER_ID = :gui_user_id
AND 'Y' = NVL (OcPoiCategory.is_active, 'Y')
ORDER BY 2