Home Recommend Us Contact Us Chinese

About Us Investor Offices Equipments Vessel Info Service Pattern Career Bill of Lading Terms and Conditions
 
Query : SELECT distinct a.portcall, c.LocName FROM tvoymast a(NOLOCK index=A5TVoyMast), tvoymastext b(NOLOCK), tlocmast c(NOLOCK) WHERE a.etddate >= '14 Dec 2017' AND a.etddate < dateadd(month,1,'14 Dec 2017') AND a.portcall = b.portcall AND a.vslcode = b.vslcode AND a.outvoyno = b.outvoyno AND substring(b.svccode,1,3) = 'RBC' AND a.portcall = c.LocCode and a.portcall not like 'IR%' Order By a.portcall
Please select appropriate values and click Get Schedule
Service Name :
Your Port:: :
Duration : 1 month(s)       2 month(s)       3 month(s)
From :

Terms of Use  |  Privacy Policy
2004 Regional Container Lines. All rights reserved.