Applying a spatial filter on a view created with sdetable in Oracle returns "ORA-00918: column ambiguously defined"

Description

Applying a spatial filter on a view created with sdetable returns the following error:

"ORA-00918: column ambiguously defined".

This may happen when a view is created with sdetable -o create_view when two tables are joined in the view's definition.

Code:
sdetable -o create_view -T land_view -t parcels,land -c parcels.objectid,parc
els.shape,parcels.parid,land.taxyr,land.ltype,land.parid -w "parcels.parid=land.parid(+)"

Cause

Internally, ArcSDE generates a query with an invalid attribute that is not fully qualified to reference one of the two tables defined in the view.

Workaround