psi_mmobile

Untitled

Feb 15th, 2026
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. SELECT NVL(Str.STR_VALUE,VoOpStatus.NAME) STATUS_NAME, VoOpStatus.COLOR, VoOpStatus.VO_OP_STATUS_ID, VoOpStatus.ORDER_NUM
  2. FROM VO_OP_STATUS VoOpStatus, VO_VEHICLE_CATEGORY VoVehicleCategory, STR Str, GUI_USERS GuiUsers
  3. WHERE VoOpStatus.NAME_STR_ID = Str.STR_ID (+)
  4. AND GuiUsers.LANGUAGE = Str.LANGUAGE (+)
  5. AND GuiUsers.GUI_USER_ID = ?
  6. AND VoOpStatus.VO_NAMED_OP_STATUS_LIST_ID = VoVehicleCategory.VO_NAMED_OP_STATUS_LIST_ID
  7. AND VoVehicleCategory.VO_VEHICLE_CATEGORY_ID = ?
  8. ORDER BY 4
Advertisement
Add Comment
Please, Sign In to add comment