Advertisement
psi_mmobile

Untitled

Jul 14th, 2017
238
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.45 KB | None | 0 0
  1. --QUERY FOR WBS LIST
  2. SELECT Wbs.NAME, Wbs.REF_NUMBER, Wbs.POI_TIN, Wbs.FROM_DATE, Wbs.TO_DATE, Wbs.DESCRIPTION, OcPoiWbs.NAME poi_name
  3. FROM GUI_USERS GuiUsers, V_GUI_USER_OC_POI VGuiUserOcPoi, WBS Wbs, OC_POI OcPoi, OC_POI OcPoiWbs
  4. WHERE GuiUsers.GUI_USER_ID = VGuiUserOcPoi.GUI_USER_ID
  5. AND VGuiUserOcPoi.POI_ID = OcPoi.POI_ID
  6. AND OcPoi.WBS_ID = Wbs.WBS_ID
  7. AND Wbs.POI_ID = OcPoiWbs.POI_ID(+)
  8. AND Wbs.PARENT_WBS_ID IS NULL
  9. AND GuiUsers.GUI_USER_ID = ?;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement