SELECT MEANING FOB , LOOKUP_CODE FOB_CODE , START_DATE_ACTIVE , END_DATE_ACTIVE FROM AR_LOOKUPS WHERE LOOKUP_TYPE = 'FOB' AND ENABLED_FLAG = 'Y' AND TRUNC(SYSDATE) BETWEEN NVL(START_DATE_ACTIVE, TRUNC(SYSDATE)) AND NVL(END_DATE_ACTIVE, TRUNC(SYSDATE))
SELECT MEANING FOB
, LOOKUP_CODE FOB_CODE
, START_DATE_ACTIVE
, END_DATE_ACTIVE
FROM AR_LOOKUPS
WHERE LOOKUP_TYPE = 'FOB'
AND ENABLED_FLAG = 'Y'
AND TRUNC(SYSDATE) BETWEEN NVL(START_DATE_ACTIVE
, TRUNC(SYSDATE))
AND NVL(END_DATE_ACTIVE
, TRUNC(SYSDATE))
|
|
|