I am trying to insert records from different tables into a temp table. I am using variables for the table names. for ex. v_Table_Name is equal to a table called entity.
v_Rec_Type_Code is equal to a column named record_type_code in the entity table. I keep getting this error:

ORA-00904:"ENTITY"."RECORD_TYPE_CODE":invalid indentifier
ORA-06512: AT "PSU.PSU_B_R_PERFMMONITOR", line 18
ORA-06512: at line 3

The line that the error is giving me is where it is executed. So, that is not helping me. However, I have the same select statement without the insert on top and it works. I substitute the variables for the table name and column.
Can someone help me. I have been on this for days!!
Thanks in advance!

You already wrote 25 posts, you should know you have to format them.
please read and follow OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code.
Use the "Preview Message" button to verify.
Always post your Oracle version (4 decimals).

The statement you posted can't give the error you posted (as far I can see in an unformated post).
Check where you call PSU.PSU_B_R_PERFMMONITOR.

Thanks for the help. Sorry about the formatting. I haven't been in here for awhile. I ran my output from the my_output procedure and it gave me that an advance table called entity.record_type_code was an invalid identifier. So I will have to figure out why. Maybe it needs to have advance.entity.record_type_code. I will have to play around with it some more.

I know for myself that I learned how to deal with this type of problem through scott's example. The next time, I will know what to do thanks to scott. Thanks to everyone else for their input also. For myself, I disagree with that last comment.

I think that is what a forum is for to get answers on what you might be struggling with for days in the first place. It is not a class room. That is why I disagree with not putting the answer out there. The first two comments did not help me at all. I had no clue. I would have been where I was before, stuck.