We find translations and texts that are not in the Language Tables from the Lookup tables. After clicking on the user icon, I go to Setup and Maintenance.
I Pressed Search Button.
We searched for ‘Manage Common Lookups.’ (If you are unsure which lookup to search for, you should consult with a functional consultant)
I can use % at the beginning and end of searches to find values containing the specified text. (Similar to the asterisk (*) in SAP.)
I received the gender data that I needed
Here, we can view gender data based on country codes.
We will write an SQL query using LookUp Type and Lookup Codes here. We will use the PER_ALL_PEOPLE_F table for personnel data, the PER_PEOPLE_LEGISLATIVE_F table for gender data, and the FND_LOOKUP_VALUES table to retrieve the text of gender data.
In the example below, I entered the text from the Lookup into the select part and the data from the gender table. Then, in the Where condition:
To retrieve the gender data of the relevant personnel, I linked the unique IDs of the personnel table to the gender table.
I set the language settings in both the gender table and the lookup table to Turkish.
For tables with the validity date of EFFECTIVE_START_DATE, I use TRUNC SYSDATE to fetch the data and check its validity.
After matching the Lookup code in the lookup table with the value stored in the gender table, I determine which data to retrieve from the lookup table using Lookup type
SELECT FLVG.MEANING AS GENDER , PPLF.SEX
FROM PER_ALL_PEOPLE_f PAPF,
PER_PEOPLE_LEGISLATIVE_F PPLF,
FND_LOOKUP_VALUES FLVG
WHERE PAPF.PERSON_ID = PPLF.PERSON_ID
AND PPLF.LEGISLATION_CODE = 'TR'
AND FLVG.LANGUAGE = 'TR'
AND TRUNC (SYSDATE) BETWEEN PPLF.EFFECTIVE_START_DATE
AND PPLF.EFFECTIVE_END_DATE
AND TRUNC (SYSDATE) BETWEEN PAPF.EFFECTIVE_START_DATE
AND PAPF.EFFECTIVE_END_DATE
AND PPLF.SEX = FLVG.LOOKUP_CODE
AND FLVG.LOOKUP_TYPE = 'SEX'
In summary, I matched the Lookup Types and Codes from the FND_LOOKUP_VALUES table with the data in the Guid. My query returned results in this way.
No Comments