Advertisement
psi_mmobile

Untitled

Feb 24th, 2025
155
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.63 KB | None | 0 0
  1. SELECT VoVehicleCategory.NAME,
  2.        VoVehicleCategory.VO_VEHICLE_CATEGORY_ID,
  3.        VoVehicleCategory.VEHICLE_OWNER_ID,
  4.        VoVehicleCategory.GRAPHICAL_SYMBOL,
  5.        GuVehicleOwner.GU_VEHICLE_OWNER_ID,
  6.        GuVehicleOwner.GUI_USER_ID
  7. FROM VO_VEHICLE_CATEGORY VoVehicleCategory,  
  8.       (SELECT *  FROM gu_vehicle_owner
  9.                      WHERE gui_user_id = ?
  10.                        AND vehicle_owner_id = ?) GuVehicleOwner
  11. WHERE VoVehicleCategory.VO_VEHICLE_CATEGORY_ID = GuVehicleOwner.VO_VEHICLE_CATEGORY_ID(+)
  12. AND VoVehicleCategory.vehicle_owner_id = ?
  13. AND NVL(VoVehicleCategory.is_object,'N') = 'N'
  14. ORDER BY 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement