2 Replies Latest reply: Nov 12, 2013 6:11 AM by indra budiantho RSS

    Lov logic in oracle forms 10g R2

    Ade2

      Hi Friends,
        I need your help in solving this Forms 10gR2 LOV Issue.  I have an lov record_group that is based on a complex view
         lov_view. The record_group is

                          select lv_seq_no, lv_wh_code,lv_bin_loc,lv_inv_qty
                            from lov_view

                           where 1 = 1 etc
         lv_int_qty in the view is a calculated field (rcpt_qty - issue_qty)
      When the LOV is first invoked let say
      lv_seq_no,  lv_wh_code,  lv_bin_loc,  lv_inv_qty
          1               001               DEFAULT    100   

        

      In the form field, I have a database column issue_qty, out of the 100 lv_inv_qty, I issued 20 in the first record,
      the next lov for lv_seq_no 1 lv_inv_qty should be 80, however since, the first record has not been posted, the Lov is showing the
      exact list for subsequent records

      lv_seq_no,  lv_wh_code,  lv_bin_loc,  lv_inv_qty

          1               001               DEFAULT    100  

       

       

      Since, I can not use post in when-validate-record or post_change or any of the validation trigger, I am at a lost on how to go about this.

      In a nutshell, the lv_inv_qty should decrease from subsequent lov based on the issue_qty from the form


      Thanks all