 								   OSP_DISTRIBUTION_CODE, STATUS_CODE, BASE_DATE, DUE_DATE, ACTIVITY_DATE, OVERDUE, COMMENTS, 
 								   PREPARER_ID, PREPARER_NAME, SPONSOR_CODE, SPONSOR_AWARD_NUMBER, TITLE, 
 								   LAST_UPDATE_USER, LAST_UPDATE_DATE, UPDATE_TIMESTAMP, UPDATE_USER, VER_NBR, OBJ_ID)
-	VALUES (AWARD_REPORT_TRACKING_S.nextval, (select AWARD_REPORT_TERM_ID from AWARD_REPORT_TERMS where AWARD_NUMBER = '001002-00001' 
+	VALUES (AWARD_REPORT_TRACKING_S.nextval, (select AWARD_REPORT_TERMS_ID from AWARD_REPORT_TERMS where AWARD_NUMBER = '001002-00001' 
 													and SEQUENCE_NUMBER = '3' and REPORT_CLASS_CODE = '3' 
 													and REPORT_CODE = '36' and FREQUENCY_CODE = '30' and FREQUENCY_BASE_CODE = '3'),
 								  '001002-00001', '10000000002', null, 'Joe Tester', 

								   OSP_DISTRIBUTION_CODE, STATUS_CODE, BASE_DATE, DUE_DATE, ACTIVITY_DATE, OVERDUE, COMMENTS, 
								   PREPARER_ID, PREPARER_NAME, SPONSOR_CODE, SPONSOR_AWARD_NUMBER, TITLE, 
								   LAST_UPDATE_USER, LAST_UPDATE_DATE, UPDATE_TIMESTAMP, UPDATE_USER, VER_NBR, OBJ_ID)
	VALUES (AWARD_REPORT_TRACKING_S.nextval, (select AWARD_REPORT_TERM_ID from AWARD_REPORT_TERMS where AWARD_NUMBER = '001002-00001' 
													and SEQUENCE_NUMBER = '3' and REPORT_CLASS_CODE = '3' 
													and REPORT_CODE = '7' and FREQUENCY_CODE = '6' and FREQUENCY_BASE_CODE = '2'),
								  '001002-00001', '10000000002', null, 'Joe Tester', 

								   OSP_DISTRIBUTION_CODE, STATUS_CODE, BASE_DATE, DUE_DATE, ACTIVITY_DATE, OVERDUE, COMMENTS, 
								   PREPARER_ID, PREPARER_NAME, SPONSOR_CODE, SPONSOR_AWARD_NUMBER, TITLE, 
								   LAST_UPDATE_USER, LAST_UPDATE_DATE, UPDATE_TIMESTAMP, UPDATE_USER, VER_NBR, OBJ_ID)
	VALUES (AWARD_REPORT_TRACKING_S.nextval, (select AWARD_REPORT_TERMS_ID from AWARD_REPORT_TERMS where AWARD_NUMBER = '001002-00001' 
													and SEQUENCE_NUMBER = '3' and REPORT_CLASS_CODE = '1' 
													and REPORT_CODE = '33' and FREQUENCY_CODE = '7' and FREQUENCY_BASE_CODE = '3'),
								  '001002-00001', '10000000002', null, 'Joe Tester', 
