psi_mmobile

Untitled

Oct 19th, 2021
683
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  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. FROM OC_POI_CATEGORY OcPoiCategory, V_GUI_USER_OC_POI_CATEGORY VGuiUserOcPoiCategory, OPERATION_CENTER OperationCenter
  23. WHERE OcPoiCategory.OPERATION_CENTER_ID = OperationCenter.OPERATION_CENTER_ID
  24. AND OcPoiCategory.OC_POI_CATEGORY_ID = VGuiUserOcPoiCategory.OC_POI_CATEGORY_ID
  25. --and not exists (select vo_person_category_id from VO_PERSON_CATEGORY where HOME_POI_CATEGORY_ID=VGuiUserOcPoiCategory.OC_POI_CATEGORY_ID)
  26. AND VGuiUserOcPoiCategory.GUI_USER_ID = 123299
  27. AND NVL(OcPoiCategory.is_active, 'Y') ='Y'
  28. ORDER BY OcPoiCategory.NAME;
  29.  
  30.  
  31. SELECT vo_person_category_id FROM VO_PERSON_CATEGORY WHERE HOME_POI_CATEGORY_ID IN (102073);
RAW Paste Data