SELECT DISTINCT A.TRAV_SEQ_NUM, A.TRAV_OPEN_WHO, A.TRAV_ID, A.TRAV_REVISION, A.TRAV_COMPLETE, A.NCRID, B.TRAV_MAX_PAGE, C.SN FROM #application.schema#.TRAV_OWNERS A ,#application.schema#.TRAV_HEADER B, #NCRTRAV# C WHERE A.TRAV_ID=B.TRAV_ID AND A.TRAV_REVISION=B.TRAV_REVISION AND A.TRAV_SEQ_NUM=C.TRAV_SEQ_NUM AND C.obs is NULL AND A.obs is NULL AND A.NCRID = '#NCRIDCK#' ORDER BY A.TRAV_SEQ_NUM

Select NCR #aTRAV_SEQ_NUM[ndx]#    #LEFT(URLDecode(aSN[ndx]),20)# #URLDecode(aSN[ndx])#