The Flame Nebula region as seen with APEX and VISTA