Getting an error invalid Object Name in SAP Business One

It would be easy to guess if you have shared the full query. It seems you have not defined #temp_table. You might need to define temp table as global but it could sum up to other issues.