Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT VoGroup.NAME,
- VoGroup.VEHICLE_OWNER_ID,
- VoGroup.VO_GROUP_ID,
- VoGroup.Parent_Vo_Group_Id,
- VoGroup.COMPANY_NR,
- gu.gui_user_id
- from (SELECT VoGroup.vo_Group_id,
- VoGroup.name,
- VoGroup.Vehicle_Owner_Id,
- VoGroup.Parent_Vo_Group_Id,
- VoGroup.COMPANY_NR
- FROM VO_GROUP VoGroup
- START WITH VoGroup.Parent_Vo_Group_Id IS NULL
- CONNECT BY VoGroup.Parent_Vo_Group_Id = PRIOR VoGroup.Vo_Group_Id
- order SIBLINGS by VoGroup.name) VoGroup,
- (select * from gu_vehicle_owner
- where gui_user_id = ?
- and vehicle_owner_id = ?) gu
- where VoGroup.vo_group_id = gu.vo_group_id(+)
- and VoGroup.vehicle_owner_id = ?
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement