Queries related to Lookup in Oracle EBS

Scripts:

Lookup Information:

select *

  from apps.fnd_lookup_types_vl

 Where lookup_type = '&lookup_type';

Values of  lookup:

select *

  from apps.fnd_lookup_values

 Where lookup_type = '&lookup_type';

 select disticnt a2.lookup_type,

  a2.meaning "Lookup Type Meaning",

  a2.description "Lookup Type Description",

  a1.LOOKUP_CODE,

  a1.meaning "Lookup Value Meaning",

  a1.description "Lookup Value Description"

  from apps.fnd_lookup_values a1,apps.fnd_lookup_types_VL a2

  where a1.lookup_type='&name_of_lookup'

  and a1.lookup_type=a2.lookup_type