Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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,
- (select count(poi_id) from oc_poi poi where poi.oc_poi_category_id = OcPoiCategory.OC_POI_CATEGORY_ID and poi.oc_poi_status_id not in (1,2)) AS VIEW_ATTR
- 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 = ?
- and 'Y' = nvl (OcPoiCategory.is_active, 'Y')
- ORDER BY name
Advertisement
Add Comment
Please, Sign In to add comment