To identify the lookup value based on lookup name query in oracle apps

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