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 |
