Advertisement
Guest User

Untitled

a guest
Apr 27th, 2015
192
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.70 KB | None | 0 0
  1. SELECT VoGroup.NAME,
  2. VoGroup.VEHICLE_OWNER_ID,
  3. VoGroup.VO_GROUP_ID,
  4. VoGroup.Parent_Vo_Group_Id,
  5. VoGroup.COMPANY_NR,
  6. gu.gui_user_id
  7. from (SELECT VoGroup.vo_Group_id,
  8. VoGroup.name,
  9. VoGroup.Vehicle_Owner_Id,
  10. VoGroup.Parent_Vo_Group_Id,
  11. VoGroup.COMPANY_NR
  12. FROM VO_GROUP VoGroup
  13. START WITH VoGroup.Parent_Vo_Group_Id IS NULL
  14. CONNECT BY VoGroup.Parent_Vo_Group_Id = PRIOR VoGroup.Vo_Group_Id
  15. order SIBLINGS by VoGroup.name) VoGroup,
  16. (select * from gu_vehicle_owner
  17. where gui_user_id = ?
  18. and vehicle_owner_id = ?) gu
  19. where VoGroup.vo_group_id = gu.vo_group_id(+)
  20. and VoGroup.vehicle_owner_id = ?
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement