Got to Love Cascading LOVs in ADF
By Shay Shmeltzer-Oracle 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.