[Home] [Help]
View: BIS_HR_MONTHS_V
View Text
SELECT 'HR MONTH'||'+'||TO_CHAR(ADD_MONTHS(SYSDATE
, -13+ROWNUM)
, 'MON-YYYY') ID
, TO_CHAR(ADD_MONTHS(SYSDATE
, -13+ROWNUM)
, 'MON-YYYY') VALUE
, 'HR MONTH' PERIOD_SET_NAME
, TO_CHAR(ADD_MONTHS(SYSDATE
, -13+ROWNUM)
, 'MON-YYYY') PERIOD_NAME
, TRUNC(ADD_MONTHS(SYSDATE
, -13+ROWNUM)
, 'MON') START_DATE
, LAST_DAY(ADD_MONTHS(TRUNC(SYSDATE)
, -13+ROWNUM)) END_DATE
, TO_NUMBER(TO_CHAR(ADD_MONTHS(SYSDATE
, -13+ROWNUM)
, 'YYYY')) PERIOD_YEAR
, TO_CHAR(NULL) ORGANIZATION_ID
, TO_CHAR(NULL) ORGANIZATION_TYPE
FROM HR_LOOKUPS
WHERE ROWNUM < 72
Columns
Name |
ID |
VALUE |
PERIOD_SET_NAME |
PERIOD_NAME |
START_DATE |
END_DATE |
PERIOD_YEAR |
ORGANIZATION_ID |
ORGANIZATION_TYPE |