ORA-56905
Pivot or unpivot operations are not supported on lateral views.
Cause
An attempt was made to do a pivot or unpivot operation on a lateral view.
Action
Remove the pivot or unpivot operation or the lateral view and then retry the query.