Utility or function to get lookup values
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');