[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 |