How to Create Dynamic VO and Dynamic Table in OAF
This tutorial is comprising of Dynamic Table and Dynamic View Object Concepts. I had a requirement of Displaying Records based on certain condition and that condition has to be dynamic ,So whenever that condition met records needs to be displayed in a table and Table also needs to be dynamic. In the Following example i will be guiding you with simple queries for which Dynamic VO's will be created. Below are the queries for which VO will be created. Query 1 : select invoice_num from ap_invoices_all Query 2 : select user_name from fnd_user We will be picking this query to display records on page on certain condition that's like If you Select "I" it will use Invoice Table and if you select "U" it will use FND_USER Table. After entering the condition of page and submitting the GO button, You will be able to see records. Below is the interpretation of the page. Controller code for this /*============================