VIEW: APPS.PA_REP_MONTH_V

Source

View Text - Preformatted

SELECT to_number(lookup_code) as month_num, description as month_name from pa_lookups WHERE lookup_type = 'CALENDAR_MONTH'

View Text - HTML Formatted

SELECT TO_NUMBER(LOOKUP_CODE) AS MONTH_NUM
, DESCRIPTION AS MONTH_NAME
FROM PA_LOOKUPS
WHERE LOOKUP_TYPE = 'CALENDAR_MONTH'