Is there a function to get lookup meanings — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Is there a function to get lookup meanings

edited Jan 13, 2025 10:49AM in Reporting and Analytics for ERP 1 comment

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'

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!