SELECT A.VMS_IFSC_ID, A.VMS_IFSC_NM, A.DSPL_STRT_NODE_NM, A.DSPL_END_NODE_NM, A.ROAD_NM, A.SPOT_NM, A.AXIS_YN, A.USE_YN, C.IFSC_ID, C.ORD, E.IFSC_NM, E.STRT_NM, E.END_NM, E.SECT_LNGT, B.PRCN_DT, B.SPED, B.TRVL_HH, B.CMTR_GRAD_CD, D.PRCN_DT, D.SPED, D.TRVL_HH, D.CMTR_GRAD_CD, D.PTRN_SPED FROM TB_VMS_IFSC A, TB_VMS_IFSC_TRAF B, TB_VMS_IFSC_RLTN_IFSC C, TB_IFSC_TRAF D, TB_IFSC E WHERE A.VMS_IFSC_ID = B.VMS_IFSC_ID AND B.VMS_IFSC_ID = C.VMS_IFSC_ID AND C.IFSC_ID = D.IFSC_ID AND D.IFSC_ID = E.IFSC_ID ORDER BY A.VMS_IFSC_ID, C.ORD