Query To update the ApplicationInstance to revoked

update OIU set OIU.OST_KEY=(select OST.OST_KEY from OST,OBJ where

OST.OBJ_KEY=OBJ.OBJ_KEY

AND OBJ.OBJ_NAME=(select OBJ_NAME from OBJ where OBJ_KEY =(select app.OBJECT_KEY from APP_INSTANCE app where APP_INSTANCE_DISPLAY_NAME='OUD'))

AND OST_STATUS='Revoked') where OIU.USR_KEY IN(select OIU.USR_KEY from OIU where

OIU.APP_INSTANCE_KEY=(select APP_INSTANCE_KEY from APP_INSTANCE where APP_INSTANCE_DISPLAY_NAME='OUD')

AND OIU.OST_KEY=(select OST.OST_KEY from OST,OBJ where

OST.OBJ_KEY=OBJ.OBJ_KEY

AND OBJ.OBJ_NAME=(select OBJ_NAME from OBJ where OBJ_KEY =(select app.OBJECT_KEY from APP_INSTANCE app where APP_INSTANCE_DISPLAY_NAME='OUD'))

AND OST_STATUS='Provisioned')) and OIU.APP_INSTANCE_KEY=(select APP_INSTANCE_KEY from APP_INSTANCE where APP_INSTANCE_DISPLAY_NAME='OUD');