Advertisement
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
- 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);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement