This discussion is archived
2 Replies Latest reply: Nov 12, 2013 4:11 AM by indra budiantho RSS

Lov logic in oracle forms 10g R2

Ade2 Newbie
Currently Being Moderated

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 

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points