Where did you learn to use PL/SQL assignment operators to alias column names???
Code:select id, description, NVL(prog_flag, 'N') prog_flag, NVL(movie_flag, 'N') movie_flag, NVL(prod_co_flag, 'N') prod_co_flag, NVL(common_flag, 'N') common_flag, app_seq, prog_seq, movie_seq from billings_contrib_types order by app_seq;