-- 
SELECT
    FSS.SET_ID
  , FSS.SET_NAME
  , FLVT.LOOKUP_TYPE
  , FLVT.LOOKUP_CODE
FROM
    FND_LOOKUP_VALUES_TL FLVT
  , FND_SETID_SETS       FSS
WHERE
    FSS.SET_ID = FLVT.SET_ID
    AND LOOKUP_TYPE IN( 'ZX_INPUT_CLASSIFICATIONS'
                     ,'ZX_OUTPUT_CLASSIFICATIONS'
                     ,'ZX_WEB_EXP_TAX_CLASSIFICATIONS'
                     ,'ZX_WHT_TAX_CLASSIFICATION_CODE')
ORDER BY
    FLVT.LOOKUP_TYPE
  , FLVT.LOOKUP_CODE