Lookup Tabls eBS

SELECT FLV.LOOKUP_CODE, FLV.MEANING, FLV.DESCRIPTION
FROM FND_LOOKUP_TYPES FLT
     ,FND_LOOKUP_VALUES FLV
   
WHERE FLT.LOOKUP_TYPE = FLV.LOOKUP_TYPE
AND FLT.LOOKUP_TYPE = 'CHECK STATE'
AND FLT.APPLICATION_ID = 200 -- PAYABLE
AND FLV.LANGUAGE = USERENV('LANG')

AND  FLV.MEANING LIKE '%QC Hold%'