SELECT *
FROM fnd_lookup_values
WHERE 1 = 1
AND lookup_type = 'PO APPROVAL'
AND enabled_flag = 'Y'
AND language = USERENV('LANG')
AND SYSDATE BETWEEN NVL(start_date_active, SYSDATE) AND NVL(end_date_active, SYSDATE)
Here lookup_code is APPROVED_FLAG in PO_HEADERS_ALL.
No comments:
Post a Comment