abstracted on_hold check into separate WITH clause. added ship date highlighting control to the view.
created view
created function
Created table