SELECT ARLKP.LOOKUP_CODE , ARLKP.MEANING , ARLKP.DESCRIPTION FROM AR_LOOKUPS ARLKP WHERE LOOKUP_TYPE = 'CUSTOMER_CATEGORY' AND ENABLED_FLAG = 'Y' AND TRUNC(SYSDATE) BETWEEN TRUNC(START_DATE_ACTIVE) AND NVL(TRUNC(END_DATE_ACTIVE),SYSDATE)
SELECT ARLKP.LOOKUP_CODE
, ARLKP.MEANING
, ARLKP.DESCRIPTION
FROM AR_LOOKUPS ARLKP
WHERE LOOKUP_TYPE = 'CUSTOMER_CATEGORY'
AND ENABLED_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN TRUNC(START_DATE_ACTIVE)
AND NVL(TRUNC(END_DATE_ACTIVE)
, SYSDATE)
|
|
|