psi_mmobile

Untitled

Oct 30th, 2025
141
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.45 KB | None | 0 0
  1. SELECT OcPoiCategory.OC_POI_CATEGORY_ID,
  2. OcPoiCategory.OPERATION_CENTER_ID,
  3. OcPoiCategory.NAME,
  4. OcPoiCategory.SNAPPING_CIRCLE,
  5. OcPoiCategory.GRAPHICAL_SYMBOL,
  6. OcPoiCategory.LM_NAME,
  7. OcPoiCategory.LM_DATE,
  8. OcPoiCategory.LM_COMMENT,
  9. OcPoiCategory.SNAPPING_DURATION,
  10. OcPoiCategory.SNAPPING_METHOD,
  11. OcPoiCategory.MAXIMUM_ACTIVITY_DURATION,
  12. OcPoiCategory.ACTIVITY_OC_ALARM_TYPE_ID,
  13. OcPoiCategory.SHORT_NAME,
  14. OcPoiCategory.LINE_COLOR,
  15. OcPoiCategory.FILL_COLOR,
  16. OcPoiCategory.FILL_ALPHA,
  17. OcPoiCategory.FLAG_COLOR,
  18. OcPoiCategory.WBS_ID,
  19. OcPoiCategory.MIN_SNAPPING_CIRCLE,
  20. OperationCenter.NAME AS NAME1,
  21. OperationCenter.OPERATION_CENTER_ID AS OPERATION_CENTER_ID1,
  22. (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
  23. FROM OC_POI_CATEGORY OcPoiCategory, V_GUI_USER_OC_POI_CATEGORY VGuiUserOcPoiCategory, OPERATION_CENTER OperationCenter
  24. WHERE OcPoiCategory.OPERATION_CENTER_ID = OperationCenter.OPERATION_CENTER_ID
  25. and OcPoiCategory.OC_POI_CATEGORY_ID = VGuiUserOcPoiCategory.OC_POI_CATEGORY_ID
  26. and VGuiUserOcPoiCategory.OC_POI_CATEGORY_ID not in (select home_poi_category_id from vo_person_category)
  27. and VGuiUserOcPoiCategory.GUI_USER_ID = ?
  28. and 'Y' = nvl (OcPoiCategory.is_active, 'Y')
  29. ORDER BY name
Advertisement
Add Comment
Please, Sign In to add comment