Hi Venu
Was the custom object completely deleted from the system with this same lookup attribute and it's no longer in use anywhere?
If yes, you can go ahead and drop the view after taking a backup of the DDL. Then try running the Load DWH - Full again.
If the lookup is also used on other objects, then try compiling the view
CLARPRD.DWH_LKP_XXXXX_BROWSE__00_V
and see what are the exact Oracle errors thrown.
You could also try unchecking the attribute and running the Load DWH job (provided it's in use on another object).
Hope this helps -Nika