Tha's an odd mix of SQL and PL/SQL. I assume you are trying to alias the NVL'ed columns. If so you need to do it like:

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
HTH
John