Hi All,
I have followed the article for dependent LOV and this is further to this.
Sagar Katrat's Oracle Apps Knowledge Sharing Blog: Dependent LOV(List of Values) in Oracle Web ADI with steps and source…
I have two LOV. First has the source of Table. The second LOV is not directly dependent on First. The values in the First LOV actually decides which query to be executed. So no bind parameters for the actual query but instead complete Dynamic Query.
for eg: First LOV has values like Customer,People,Order Number,etc. Based on the selection. if user selects Customer than all the customer and if people then all employees.
I am able to generate the query through PL/SQL. Also I can manage it to bring in any of the Java class..
The question is where to actually wirte the code and how to manage those 3 class files..
Its a bit urgent requirement. Appreciatte if you could help out sooner.