DBA Data[Home] [Help]

VIEW: APPS.PA_DISCOUNT_CODES_LOV_V

Source

View Text - Preformatted

SELECT meaning , lookup_code FROM pa_lookups WHERE lookup_type = 'RATE AND DISCOUNT REASON' AND trunc(nvl(end_date_active,sysdate)) >= trunc(sysdate)
View Text - HTML Formatted

SELECT MEANING
, LOOKUP_CODE
FROM PA_LOOKUPS
WHERE LOOKUP_TYPE = 'RATE
AND DISCOUNT REASON'
AND TRUNC(NVL(END_DATE_ACTIVE
, SYSDATE)) >= TRUNC(SYSDATE)