I have a scenario
where i need to fetch the data from fnd_lookup_values_vl table
I have to fetch the data from four different lookup_types like 'Country_lookup', 'country_zone_lookup','Target_plan_lookup','Target_Code_lookup'
How to fetch all the data from different lookup_types through a single query.
Any suggestions please
Thanks in advance
Well, don't kow exactly which information you are looking for but you can use query below.
Just replace the LOOKUP_TYPE with the ones you need.
WHERE LOOKUP_TYPE IN ('ADDRESS_STYLE', 'AUDIT_STATE')
WHERE LOOKUP_TYPE IN ('ADDRESS_STYLE', 'AUDIT_STATE','AUDIT_COUNTRY')
As each lookup_type will have different lookup_codes,meaning and description columns
suppose LOOKUP_TYPE 'ADDRESS_STYLE' may have meaning like street name,'AUDIT_STATE' may have state names AND 'AUDIT_COUNTRY' holds country information
When I am writing my query I want to get the columns street name from 'ADDRESS_STYLE',state name from 'AUDIT_STATE' lookup_type, country name from 'AUDIT_COUNTRY' in the same record.
How can I do that
Can someone please guide me how to find which column in specific table corresponds to the lookup_code in lookups table
As in the below stated example for 'HR_BONUS_PLAN' lookup_type the lookup_code joins to segment2 column in PER_JOB_DEFINITIONS table
Same way how to find the join for the other lookup_types
|SELECT * FROM FND_LOOKUP_VALUES FLV,PER_JOB_DEFINITIONS PJD|
|WHERE FLV.LOOKUP_TYPE LIKE 'HR_BONUS_PLAN'|
When Lookup tables are used is this the only way to follow
or any column can be picked from lookup tables can be joined to be destination table