7 Replies Latest reply: Jul 18, 2014 4:10 AM by Great Awo' G' RSS

    Oracle Forms Builder - Dynamic LOV - session based

    user7751421

      Hello,

       

      I have below requirement. Record group created based on a SQL statement like below

       

      SELECT INVOICE_NUM, INVOICE_DATE, AMOUNT

      FROM INVOICES A

      WHERE VENDOR_ID= :REC.VENDOR_ID

      AND NOT EXISTS (SELECT 1

                                      FROM INVOICE_STG B

                                        WHERE B.INVOICE_NUM=A.INVOICE_NUM)

       

      If I have three records 1, 2, 3

       

      record1- if we select Invoice-1 in Invoice# LOV (not saved the record, not committed to d/b)

      record2- Invoice-1 shouldn't show up as it is selected in first row.  but now it is showing in the next record

       

      Without saving, If I select Invoice from LOV in the record, it shouldn't show the Invoices that are already selected in the previous rows

       

      Please suggest.

       

      Thanks,

      Sree