psi_mmobile

Untitled

Feb 24th, 2025
45
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 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 = ?
Add Comment
Please, Sign In to add comment