Create VO Programmatically | Dynamic VO | OAF

ViewObject dynamicViewObject = appModule.findViewObject("XXDynamicVO"); 

 if(dynamicViewObject == null) 

 { 

  String voQuery = " SELECT USER_NAME " + 

                                " FROM fnd_users FU " + 

                                " WHERE FU.user_id = :1 "; 

  customViewObject = appModule.createViewObjectFromQueryStmt("XXDynamicVO",voQuery); 

 } 

 if(customViewObject != null) 

 { 

  customViewObject.setWhereClause(null); 

  customViewObject.setWhereClauseParams(null); 

  customViewObject.setWhereClauseParam(0,userID); 

  customViewObject.executeQuery(); 

  Row customViewObjectRow = customViewObject.first(); 

  if(customViewObjectRow != null) 

  { 

       String userName = (String)customViewObjectRow.getAttribute(0); 

  } 

 }