sql

   SELECT wmsys.wm_concat(O.MEANING)
       FROM BAS_LOOKUPS O, CLM_GFS_SALESREPS_CITY CITY
      WHERE 1 = 1
        AND O.ENABLED_FLAG = 'Y'
        AND (O.START_DATE_ACTIVE IS NULL OR (O.START_DATE_ACTIVE < SYSDATE))
        AND (O.END_DATE_ACTIVE IS NULL OR O.END_DATE_ACTIVE > SYSDATE)
        AND O.LOOKUP_TYPE = 'CAR_HK_CITYNAME'
        AND O.LOOKUP_CODE = CITY.LOOKUP_CODE
       
  
  select DETERMINER_VALUE
 from  CLM_DEPTVALUES_SALESREPS a,
     CLM_DEPTVALUES_SALESREPS b
     where a.DETERMINER_VALUE=b
       
        SELECT s.SALESNAME,
               (SELECT wmsys.wm_concat(O.MEANING)
                  FROM BAS_LOOKUPS O, CLM_GFS_SALESREPS_CITY CITY
                 WHERE 1 = 1
                   AND O.ENABLED_FLAG = 'Y'
                   AND (O.START_DATE_ACTIVE IS NULL OR
                       (O.START_DATE_ACTIVE < SYSDATE))
                   AND (O.END_DATE_ACTIVE IS NULL OR
                       O.END_DATE_ACTIVE > SYSDATE)
                   AND O.LOOKUP_TYPE = 'CAR_HK_CITYNAME'
                   AND O.LOOKUP_CODE = CITY.LOOKUP_CODE)
          from CLM_GFS_SALESREPS_CITY CITY, CLM_DEPTVALUES_SALESREPS s
         WHERE 1 = 1
           AND CITY.DETERMINER_VALUE_ID = s.DETERMINER_VALUE_ID