Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT NVL(Str.STR_VALUE,VoOpStatus.NAME) STATUS_NAME, VoOpStatus.COLOR, VoOpStatus.VO_OP_STATUS_ID, VoOpStatus.ORDER_NUM
- FROM VO_OP_STATUS VoOpStatus, VO_VEHICLE_CATEGORY VoVehicleCategory, STR Str, GUI_USERS GuiUsers
- WHERE VoOpStatus.NAME_STR_ID = Str.STR_ID (+)
- AND GuiUsers.LANGUAGE = Str.LANGUAGE (+)
- AND GuiUsers.GUI_USER_ID = ?
- AND VoOpStatus.VO_NAMED_OP_STATUS_LIST_ID = VoVehicleCategory.VO_NAMED_OP_STATUS_LIST_ID
- AND VoVehicleCategory.VO_VEHICLE_CATEGORY_ID = ?
- ORDER BY 4
Advertisement
Add Comment
Please, Sign In to add comment