I am trying to insert into a remote view (rv-) values from a local view (lv-) and I keep getting syntax error. Does anyone see something wrong with this statement:

				INSERT into rv_udfield (rv_udfield.firstname, rv_udfield.middle , ;
					rv_udfield.lastname, rv_udfield.dateappoint, rv_udfield.division, ;
					rv_udfield.unit, rv_udfield.position, rv_udfield.dob, ;
					rv_udfield.eyes, rv_udfield.ht, rv_udfield.wt, rv_udfield.department, ;
					rv_udfield.issuedate, rv_udfield.extrahelp, rv_udfield.pmt, ;
					rv_udfield.archive) VALUES ( ;
				ALLTRIM(lv_x_emp_itc.firstname), ;
				ALLTRIM(lv_x_emp_itc.mid), ;
				ALLTRIM(lv_x_emp_itc.lastname), ;
				lv_x_emp_itc.dateappoint, ;
				ALLTRIM(lv_x_emp_itc.division), ;
				ALLTRIM(lv_x_emp_itc.unit), ;
				ALLTRIM(lv_x_emp_itc.position), ;
				lv_x_emp_itc.dob, ;
				ALLTRIM(lv_x_emp_itc.eyes), ;
				ALLTRIM(lv_x_emp_itc.ht), ;
				ALLTRIM(lv_x_emp_itc.wt), ;
				ALLTRIM(lv_x_emp_itc.department), ;
				lv_x_emp_itc.issuedate, ;
				ALLTRIM(lv_x_emp_itc.extrahelp), ;
				ALLTRIM(lv_x_emp_itc.pmt), ;                
				ALLTRIM(lv_x_emp_itc.archive))	

Thanks
Nick Patel