added new retail customer sql statements for Third Party