Searching FND Lookup Type for a given set of Lookup Codes

Few times we see the LOOKUP CODE being used in Oracle tables and we can see few distinct values but we do not know the the lookup type for those values. eTRM is not very helpful. In such case, following query can help.

This query returns the list of lookup types that have two lookup code 'M' and 'F'. This query can be modified to check existence of few other lookup codes

select * from fnd_lookup_types flt where exists ( select 1 from fnd_lookup_values flv1 where flv1.lookup_type = flt.lookup_type and flv1.lookup_code = 'F' ) and exists ( select 1 from fnd_lookup_values flv2 where flv2.lookup_type = flt.lookup_type and flv2.lookup_code = 'M' ) order by lookup_type ;