Technology Stack - EBS (MOSC)

MOSC Banner

Utility or function to get lookup values

edited Aug 21, 2015 6:53PM in Technology Stack - EBS (MOSC) 1 commentAnswered

Hello Friends,

Is there any backend utility or function in Oracle EBS Application to get lookup value or meaning if lookup type and code are provided?

I have created a custom function as defined below but am wondering if there is any seeded function or utility?

create or replace function xx_get_lookup_meaning (p_lookup_type VARCHAR2, p_lookup_code VARCHAR2)

RETURN VARCHAR2 is

     l_cMeaning VARCHAR2(60);

BEGIN

      SELECT meaning

     INTO l_cMeaning

     FROM fnd_lookup_values

     WHERE     lookup_type = p_lookup_type

     AND          lookup_code = p_lookup_code

     AND          enabled_flag = 'Y'

    AND           trunc(sysdate) between nvl(start_date_active, sysdate-1) and nvl(end_date_active,'31-DEC-4712');

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center