IF v_language_code = 'fr' THEN
   BEGIN
     v_query6_select := v_query6_select || 'STA.KSTA_TXTCODE || '' - '' || STA.KSTA_TXTDESCRIPTION STACODE,' ;
   END;
 ELSE
   BEGIN
     v_query6_select := v_query6_select || 'STA.KSTA_TXTCODE || '' - '' || STA.KSTA_TXTDESCRIPTIONEN STACODE,' ;
   END;
 END IF;
 v_query6_select                     := v_query6_select || 'FLT.KFLT_TXTLABEL KFLTTXTLABEL,      
ROU.KROU_TXTCODE KROUTXTCODE,      
ROU.KROU_TXTLABEL KROUTXTLABEL,      
SHP.KSHP_NUMORDERCOUNT KSHPNUMORDERCOUNT,        
SHP.KSHP_NUMLOADINGCOUNT KSHPNUMLOADINGCOUNT,      
SHP.KSHP_DATLOADINGREQUESTED loadingRequestDate,      
SHP.KSHP_DATLOADINGPLANNEDSTART KSHPDATLOADINGPLANNEDSTART,' ;