1 person found this helpful
by using Independent value set, the requirement is addressed.
Its too late, but you just need to keep the following in where condition
WHERE lookup_type = 'WIP_EAM_WORK_ORDER_TYPE'
AND enabled_flag = 'Y'
AND language = USERENV ('LANG')
AND SYSDATE >= start_date_active
AND meaning = 'Breakdown'
AND SYSDATE <= NVL (end_date_active, SYSDATE)