You can get the tables and columns from the sys-views user_tables and user_tab_columns. Use them to populate your LOV's, construct a sql-statement and execute it using dynamic sql. ("execute immediate" or the dbms_sql-package)

Commit;
6502