execute immediate 'insert into ABC(distinct_val) ' ||
' select distinct '||c_column_name_rec.column_name||' from yyy.'||c_table_name_rec.table_name;

ERROR

ORA-00904: "SHORT_DISPLAY": invalid identifier
ORA-06512: at line 22

I'm not using SHORT_DISPLAY ANYWHERE IN THE CODE.