Got to Love Cascading LOVs in ADF
By Shay Shmeltzer on Oct 21, 2010
This is indeed one of many areas where you can clearly see the advantages that ADF gives you with a declarative development approach.
Check out this little demo that shows how you build this type of cascading lists with JDeveloper and ADF. The interesting point to note is that a single SQL statement is the only manual line of code you end up writing.
This is why we believe that visual and declarative is good.