Is there a function to get lookup meanings
Summary:
I am creating a report and the users require the displayed values for the lookups, I know I can do multiple links to the fnd_lookup_values_vl view (see code snippet) but is there a neater way to do this? Is there a function that will return the translated meaning of a lookup codes?
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
SELECT psv.vendor_name supplier_name, psv.segment1 supplier_number, pss.vendor_site_Code supplier_site_code, pay_flag.meaning site_purchasing_flag, pay_flag.meaning site_pay_flagFROM poz_suppliers_v psv, poz_supplier_sites_v pss, fnd_lookup_values_vl pay_flag, fnd_lookup_values_vl pur_flagWHERE psv.vendor_id = pss.vendor_idAND pss.purchasing_site_flag = pur_flag.lookup_codeAND pur_flag.lookup_type = 'YES_NO'AND pss.pay_site_flag = pay_flag.lookup_codeAND pay_flag.lookup_type = 'YES_NO'