--QUERY FOR WBS LIST
SELECT Wbs.NAME, Wbs.REF_NUMBER, Wbs.POI_TIN, Wbs.FROM_DATE, Wbs.TO_DATE, Wbs.DESCRIPTION, OcPoiWbs.NAME poi_name
FROM GUI_USERS GuiUsers, V_GUI_USER_OC_POI VGuiUserOcPoi, WBS Wbs, OC_POI OcPoi, OC_POI OcPoiWbs
WHERE GuiUsers.GUI_USER_ID = VGuiUserOcPoi.GUI_USER_ID
AND VGuiUserOcPoi.POI_ID = OcPoi.POI_ID
AND OcPoi.WBS_ID = Wbs.WBS_ID
AND Wbs.POI_ID = OcPoiWbs.POI_ID(+)
AND Wbs.PARENT_WBS_ID IS NULL
AND GuiUsers.GUI_USER_ID = ?;