SELECT OcPoiCategory.OC_POI_CATEGORY_ID,
       OcPoiCategory.OPERATION_CENTER_ID,
       OcPoiCategory.NAME,
       OcPoiCategory.SNAPPING_CIRCLE,
       OcPoiCategory.GRAPHICAL_SYMBOL,
       OcPoiCategory.LM_NAME,
       OcPoiCategory.LM_DATE,
       OcPoiCategory.LM_COMMENT,
       OcPoiCategory.SNAPPING_DURATION,
       OcPoiCategory.SNAPPING_METHOD,
       OcPoiCategory.MAXIMUM_ACTIVITY_DURATION,
       OcPoiCategory.ACTIVITY_OC_ALARM_TYPE_ID,
       OcPoiCategory.SHORT_NAME,
       OcPoiCategory.LINE_COLOR,
       OcPoiCategory.FILL_COLOR,
       OcPoiCategory.FILL_ALPHA,
       OcPoiCategory.FLAG_COLOR,
       OcPoiCategory.WBS_ID,
       OcPoiCategory.MIN_SNAPPING_CIRCLE,
       OperationCenter.NAME AS NAME1,
       OperationCenter.OPERATION_CENTER_ID AS OPERATION_CENTER_ID1
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 not exists (select vo_person_category_id from VO_PERSON_CATEGORY where HOME_POI_CATEGORY_ID=VGuiUserOcPoiCategory.OC_POI_CATEGORY_ID)
AND VGuiUserOcPoiCategory.GUI_USER_ID = 123299
AND NVL(OcPoiCategory.is_active, 'Y') ='Y'
ORDER BY OcPoiCategory.NAME;


SELECT vo_person_category_id FROM VO_PERSON_CATEGORY WHERE HOME_POI_CATEGORY_ID IN (102073);