What SQL query can I use to get a list of the values in lists of values (Lookup Types) in Oracle Sales?

Lookup codes are stored in the FND_LOOKUP_VALUES_B table. Here's a sample query that you can use to extract the values from lookup types.

select * from FND_LOOKUP_VALUES_B where LOOKUP_TYPE = 'XXXXX' order by LOOKUP_CODE;
            
            
            
            select FND_LOOKUP_VALUES_B.LOOKUP_CODE, MEANING
            
            from FND_LOOKUP_VALUES_B, FND_LOOKUP_TYPES, FND_LOOKUP_VALUES_TL
            
            where FND_LOOKUP_VALUES_B.LOOKUP_TYPE = FND_LOOKUP_TYPES.LOOKUP_TYPE
            
            and FND_LOOKUP_VALUES_TL.LOOKUP_CODE = FND_LOOKUP_VALUES_B.LOOKUP_CODE
            
            and FND_LOOKUP_TYPES.LOOKUP_TYPE LIKE 'XYZ'
            
            and LANGUAGE = 'US'
            
            order by FND_LOOKUP_VALUES_B.LOOKUP_CODE;