title: Populating values to null column based on value of some another column from another row
body: <p>My requirement is pick <code>HIST_START</code> value where <code>status="CANCELLED" AND table="OUTCOME_STATUS"</code>. 
  Put this value in <code>HIST_END</code> column where <code>table=("DOC_STATUS" OR "ENTRY_STATUS") AND HIST_END is NULL</code>
  Eg. The first and second rows should have <code>HIST_END</code> as <code>12/06/2012</code> (which is <code>HIST_START</code> of last row.</p>
  
  <pre><code>ID          HIST_START   HIST_END    Appl Number    code    version STATUS   TABLE
  10298337    4/06/2012                 1             I45     1   PENDING      DOC_STATUS
  10298337    4/06/2012                 1             I45     1   PENDING      ENTRY_STATUS
  10298337    4/06/2012    5/06/2012    1             I45     1   PENDING      OUTCOME_STATUS
  10298337    5/06/2012    11/06/2012   1             I45     1   ADM_REV      OUTCOME_STATUS
  10298337    11/06/2012   11/06/2012   1             I45     1   BAMERROR     OUTCOME_STATUS
  10298337    11/06/2012   12/06/2012   1             I45     1   AWAIT_DOCS   OUTCOME_STATUS
  10298337    12/06/2012                1             I45     1   CANCELLED    OUTCOME_STATUS
  </code></pre>
  
  <p>Thanks in advance..</p>