Advertisement
psi_mmobile

Untitled

Jun 7th, 2022
227
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.55 KB | None | 0 0
  1. SELECT P_WBS.getWbsName(Wbs.WBS_ID, VGuiUserOcPoi.POI_ID) AS NAME,
  2. VGuiUserOcPoi.POI_ID,
  3. Wbs.WBS_ID,
  4. Wbs.REF_NUMBER
  5. FROM V_GUI_USER_OC_POI VGuiUserOcPoi, WBS Wbs
  6. WHERE VGuiUserOcPoi.OC_POI_STATUS_ID = 0
  7. and (VGuiUserOcPoi.oc_poi_category_id = ? or ? = -1)
  8. AND (VGuiUserOcPoi.POI_ID = Wbs.POI_ID(+))
  9. and (Wbs.WBS_LEVEL=1 or (Wbs.WBS_LEVEL=0 and not exists (select w.wbs_id from WBS w where w.wbs_level=1 and w.poi_id=Wbs.poi_id)))
  10. AND VGuiUserOcPoi.GUI_USER_ID = ?
  11. and nvl (VGuiUserOcPoi.is_home_poi_category, 'N') = 'N'
  12. ORDER BY name
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement