Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT VoVehicleCategory.NAME,
- VoVehicleCategory.VO_VEHICLE_CATEGORY_ID,
- VoVehicleCategory.VEHICLE_OWNER_ID,
- VoVehicleCategory.GRAPHICAL_SYMBOL,
- GuVehicleOwner.GU_VEHICLE_OWNER_ID,
- GuVehicleOwner.GUI_USER_ID
- FROM VO_VEHICLE_CATEGORY VoVehicleCategory,
- (SELECT * FROM gu_vehicle_owner
- WHERE gui_user_id = ?
- AND vehicle_owner_id = ?) GuVehicleOwner
- WHERE VoVehicleCategory.VO_VEHICLE_CATEGORY_ID = GuVehicleOwner.VO_VEHICLE_CATEGORY_ID(+)
- AND VoVehicleCategory.vehicle_owner_id = ?
- AND NVL(VoVehicleCategory.is_object,'N') = 'N'
- ORDER BY 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement