Query to check lookup values

Query to check lookup values

In this post , We will be discuss about Query to check lookup values. This SQL Query will help to extract the oracle lookup details with complete lookup values. We will be able to extract the list of lookup values using this sql query in oracle. This is one of the important query regarding oracle lookup details. Here below is the complete details about Query to check lookup values.

Query to check lookup values

2 Important Table used by Query to check lookup values

1.apps.fnd_lookup_values

2.apps.fnd_lookup_types_VL

Detail SQL Query to check lookup values

  select 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='PA_DEPEND_DISP_TYPE'

  and a1.lookup_type=a2.lookup_type

Query to check lookup values

Query to check lookup values