FND Design Data [Home] [Help]

View: PA_REP_MONTH_V

Product: PA - Projects
Description: PA_REP_MONTH_V is a view to get month name and month number
Implementation/DBA Data: ViewAPPS.PA_REP_MONTH_V
View Text

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

Columns

Name
MONTH_NUM
MONTH_NAME