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