hack oracle apps

SQL> 1 Select * from emp 2 minus 3* select * from emp 2 where 4=(select 3 / EMPNO ENAME JOB ---------- ---------- 7566 JONES MANAGER To Display top N salaries -----------------------------

Select 2  where rownum<10 EMPNO ENAME      JOB ---------- ---------- 7839 KING       PRESIDENT 1234 SHASHI     MANAGER 7788 SCOTT      ANALYST 7902 FORD       ANALYST 7566 JONES      MANAGER 7698 BLAKE      MANAGER 7782 CLARK      MANAGER 7499 ALLEN      SALESMAN 7844 TURNER     SALESMAN

9 rows selected.

To Display Nth lowest -----------------------------

SQL> 2  Where 2=(Select 3  order by sal;

EMPNO ENAME      JOB ---------- ---------- 7900 JAMES      CLERK To display every 4th SQL>Select

EMPNO ENAME      JOB ---------- ---------- 7521 WARD       SALESMAN 7782 CLARK      MANAGER 7876 ADAMS      CLERK To display alternates SQL> where (rowid,0) in EMPNO ENAME      JOB ---------- ---------- 7369 SMITH      CLERK 7521 WARD       SALESMAN 7654 MARTIN     SALESMAN 7782 CLARK      MANAGER 7839 KING       PRESIDENT 7876 ADAMS      CLERK 7902 FORD       ANALYST

7 rows selected.

To display alternate -----------------------------

SQL>select 2* where (rowid,1)

EMPNO ENAME      JOB ---------- ---------- 7499 ALLEN      SALESMAN 7566 JONES      MANAGER 7698 BLAKE      MANAGER 7788 SCOTT      ANALYST 7844 TURNER     SALESMAN 7900 JAMES      CLERK 7934 MILLER     CLERK 1234 SHASHI     MANAGER

8 rows selected.

Code in Controller(co):
==============

 public void processRequest(OAPageContext pageContext, OAWebBean webBean)
  {
    super.processRequest(pageContext, webBean);
    OAApplicationModule am=pageContext.getApplicationModule(webBean);
    
      am.invokeMethod("xxInitPPRRow");
      
      am.invokeMethod("xxHideFields");;
  }

  
  public void processFormRequest(OAPageContext pageContext, OAWebBean webBean)
  {
    super.processFormRequest(pageContext, webBean);
    
      OAApplicationModule am=pageContext.getApplicationModule(webBean);
      
        if("XX_HANDLE_UOM_EVENT".equalsIgnoreCase(pageContext.getParameter(EVENT_PARAM)))
        {
            am.invokeMethod("xxHandlePPR"); 
        }

}

Code in the Application Module(AM):
=======================

    public void xxInitPPRRow() 
      {
          PPRDemoVOImpl vo=getPPRDemoVO1();
        
          Row  row = vo.createRow();
          
          if(!vo.isPreparedForExecution())
          {
              vo.setMaxFetchSize(0);
          }
          vo.insertRow(row);
          
            row.setAttribute("Nou","Sample No of Units");          
            row.setAttribute("Wob","Sample Box");        
            row.setAttribute("Vol","Sample Volume");
            
          row.setNewRowState(Row.STATUS_INITIALIZED);
      }//End of InitPPRRRow Method..

       public void xxHandlePPR()
       {
          
                    PPRDemoVOImpl vo=getPPRDemoVO1();
                    PPRDemoVORowImpl row=(PPRDemoVORowImpl)vo.getCurrentRow();
                    
                                          
                          if(row.getUom()!=null && !"".equals(row.getUom()))
                          {
                                          String uomValue =row.getUom();
                                                                                   
                                           if(uomValue.equals("EA")) //Handle for Number of Units(NOU)
                                                {
                                                  row.setA1(true);
                                                  row.setA2(false);
                                                  row.setA3(false);
                                                  row.setA4("yes");
                                                                                         
                                               }
                                           else if(uomValue.equals("BOX"))  //Handle for weight of Box(WOB)
                                                { 
                                                   row.setA1(false);
                                                   row.setA2(true);
                                                   row.setA3(false);
                                                 }
                                          else //Handle for volume of gallon (VOG)
                                                {
                                                
                                                    row.setA1(false);
                                                    row.setA2(false);
                                                    row.setA3(true);
                                                }                   
                          }
                          else 
                          {
                                    this.xxHideFields();
                                    throw new OAException("Select  atlease one Value",OAException.ERROR);
                           }
          } //End of xxHadlePPR Method    
          


           public void xxHideFields() 
           {
                PPRDemoVOImpl vo=getPPRDemoVO1();
                PPRDemoVORowImpl row=(PPRDemoVORowImpl)vo.getCurrentRow();
                                         
               
               row.setA1(false);
               row.setA2(false);
               row.setA3(false);       
            }//End of xxHideFields method

Query in VO#1:PPRDemoVO:
===================

SELECT PPRDetailsEO.UOM, 
       PPRDetailsEO.NOU, 
       PPRDetailsEO.WOB, 
       PPRDetailsEO.VOL, 
       PPRDetailsEO.CREATED_BY, 
       PPRDetailsEO.CREATION_DATE, 
       PPRDetailsEO.LAST_UPDATED_BY, 
       PPRDetailsEO.LAST_UPDATE_DATE, 
       PPRDetailsEO.LAST_UPDATE_LOGIN, 
       PPRDetailsEO.ROWID
FROM XX_TEST_PPR PPRDetailsEO

Query in VO#2(Poplist VO):
==================

select LOOKUP_CODE,MEANING from fwk_tbx_lookup_codes_vl where lookup_type = 'FWK_TBX_UNIT_OF_MEASURE'

hack oracle apps

20130711

Some important SQL Queries

PPR(Partital Page Rendering) in OAF.

Blog Archive