Please select appropriate values and click Get Schedule
Service Name
:
RBC - RCL BANGKOK CHINA SERVICE
RBH - RCL BANGKOK HAIPHONG
RBM - RCL BANGKOK MANILA SERVICE
RCC - RCL CHITTAGONG SERVICE
RCH - RCL CALCUTTA HALDIA
RCK - RCL KAMBARA SERVICE
RCM - RCL CHINA MANILA
RCT - RCL CHINA THAILAND
RFC - RCL FAR EAST - CHENNAI SERVICE
RFM - RCL FAR EAST-MADRAS SERVICE
RHS - HO CHI MINH SINGAPORE EXPRESS
RHY - RCL HONGKONG YANGON SERVICE
RIM - RCL ASIA-INDIA-MIDDLE EAST SERVICE
RKE - RCL KEELUNG HONGKONG SERVICE
RKI - RCL KOREA STRAITS INDIA SERVICE
RLM - RCL THAILAND MANILA SERVICE
RMB - RCL MADRAS BANGKOK SERVICE
RME - RCL MIDDLE EAST SERVICE
RML - RCL MADRAS - LAEM CHABANG SERVICE
RMN - MANILA SINGAPORE EXPRESS
RMS - RCL STRAITS OF MALACCA SERVICE
RMV - RCL MADRAS VIZAG SERVICE
RNC - RCL HOCHIMINH NORTH CHINA
RNI - RCL NORTH CHINA STRAITS INDIA SERVICE
RNT - RCL NORTH CHINA-THAILAND SERVICE
RPE - RCL PALEMBANG EXPRESS
RPM - RCL PAKISTAN MIDDLE EAST SERVICE
RPS - SINGAPORE-PASIR GUDANG SERVICE
RPV - RCL PORTKELANG VIETNAM SERVICE
RSI - RCL STRAITS INDONESIA
RSK - RCL SONGKHLA KEELUNG SERVICE
RSP - RCL SOUTH PHILIPPINES SERVICE
RSS - SONGKHLA-SPRC SERVICE
RSU - SURABAYA EXPRESS
RSZ - RCL SIHANOVILLE-SONKHLA SERVICE
RTB - RCL THAILAND BELAWAN SERVICE
RTC - RCL TUTICORIN-COLOMBO
RTI - RCL THAILAND INDONESIA SERVICE
RTM - RCL THAILAND MANILA SERVICE
RTS - RCL THAILAND SINGAPORE SERVICE
RTY - RCL THAILAND YANGON SERVICE
RVC - RCL VIETNAM CHINA SERVICE
Query : SELECT distinct a.portcall, c.LocName FROM tvoymast a(NOLOCK index=A5TVoyMast), tvoymastext b(NOLOCK), tlocmast c(NOLOCK) WHERE a.etddate >= '24 Apr 2018' AND a.etddate < dateadd(month,1,'24 Apr 2018') 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
Your Port::
:
CNNGB - NINGBO
CNSHA - SHANGHAI, CHINA
CNSHK - SHEKOU, CHINA PEO REP OF
KHKOS - SIHANOUKVILLE, CAMBODIA
THLCH - LAEM CHABANG, THAILAND
THPAT - BANGKOK, THAILAND
THTST - TRANG, THAILAND
VNCLI - CAT LAI, VIETNAM
Duration
:
1 month(s)
2 month(s)
3 month(s)
From
:
Terms of Use
|
Privacy Policy
© 2004 Regional Container Lines. All rights reserved.