View Object on the fly in VORowImpl class

    public String xxfield()
    {
    Number HeaderId = getReportHeaderId();
    String s2= null;

OAApplicationModuleImpl localOAApplicationModuleImpl = (OAApplicationModuleImpl)getApplicationModule();

OADBTransactionImpl localOADBTransactionImpl = (OADBTransactionImpl)localOAApplicationModuleImpl.getOADBTransaction();

     String s1= " select attribute11 from ap_expense_report_headers_all where report_header_id = :1 ";
   
        if (localOAApplicationModuleImpl.findViewObject("xxProjectVO") != null)
{
    oracle.jbo.ViewObject viewobject =  localOAApplicationModuleImpl.findViewObject("xxProjectVO");
            viewobject.remove();
        }
     
        oracle.jbo.ViewObject viewobject = localOAApplicationModuleImpl.createViewObjectFromQueryStmt("xxProjectVO", s1);

        viewobject.setWhereClauseParam(0, HeaderId);
        Object obj = null;
        viewobject.executeQuery();
        if (viewobject.hasNext())
        {
            oracle.jbo.Row row = viewobject.next();
            if (row.getAttribute(0) != null) {
                try {
                    s2 = row.getAttribute(0).toString();
                } catch (Exception E2) {
                }
            }
        }
        viewobject.remove();
        return s2;
    }