We all know there are different ways to define WHERE clause on a viewObject at runtime and previously I have posted about it
Check -
ADF Basics: Apply and Change WHERE Clause of ViewObject at runtime programmatically
ADF Baiscs: Define and remove named bind variable in viewObject at runtime programmatically
Setting view object bind variable (Override bindParametersForCollection, prepareRowSetForQuery, executeQueryForCollection )