[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: |
APPS.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 |