--
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