Advertisement
psi_mmobile

Untitled

Aug 25th, 2022
1,751
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.49 KB | None | 0 0
  1. SELECT OcPoiCategory.OC_POI_CATEGORY_ID,
  2.        OcPoiCategory.NAME
  3. FROM OC_POI_CATEGORY OcPoiCategory, V_GUI_USER_OC_POI_CATEGORY VGuiUserOcPoiCategory, oc_day_aggreg OcDayAggreg
  4. WHERE VGuiUserOcPoiCategory.OC_POI_CATEGORY_ID = OcPoiCategory.OC_POI_CATEGORY_ID
  5. AND OcPoiCategory.OC_POI_CATEGORY_ID = OcDayAggreg.OC_POI_CATEGORY_ID
  6. AND OcDayAggreg.VO_PERSON_CATEGORY_ID = ? -- current person category that you are editting
  7. AND VGuiUserOcPoiCategory.GUI_USER_ID = ? -- current user
  8. ORDER BY 2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement