Yes, you can do that with the Open C call UF_UI_set_cursor_view(), or if you are using .Net, the wrapper method for that call.
It is a good idea to first call the related UF_UI_ask_cursor_view to get the current setting.
From the docs:
|int||new_cursor_view||Input||New cursor view:
0 = Any view
1 = Work view
I think in Drafting, the special view that represents the drawing sheet is the work view. Interactively the only way I can see to change that is to expand one of the member views, and when you do that, you can't see the drawing anymore.
In fact in the Open C kit, we have an old-style function, uc6449(), which is documented to "Change Work View". However, it has this note:
"This function has no effect if a drawing is current."