SELECT LK.LOOKUP_CODE , LK.MEANING FROM FND_LOOKUPS LK WHERE LK.LOOKUP_TYPE = 'ZX_EXEMPTION_REASON_CODE' AND LK.ENABLED_FLAG = 'Y' AND trunc(SYSDATE) BETWEEN trunc(nvl(LK.START_DATE_ACTIVE,sysdate)) AND trunc(NVL(LK.END_DATE_ACTIVE,SYSDATE)) ORDER BY meaning
SELECT LK.LOOKUP_CODE
, LK.MEANING
FROM FND_LOOKUPS LK
WHERE LK.LOOKUP_TYPE = 'ZX_EXEMPTION_REASON_CODE'
AND LK.ENABLED_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN TRUNC(NVL(LK.START_DATE_ACTIVE
, SYSDATE))
AND TRUNC(NVL(LK.END_DATE_ACTIVE
, SYSDATE)) ORDER BY MEANING
|
|
|