[Home] [Help]
View: BIS_HR_CALENDARS_V
Product: | BIS - Applications BIS |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT 'HR MONTH'||'+'||TO_CHAR(ADD_MONTHS(SYSDATE
, -13+ROWNUM)
, 'MM-YYYY') ID
, TO_CHAR(ADD_MONTHS(SYSDATE
, -13+ROWNUM)
, 'MM-YYYY') VALUE
, 'HR MONTH' CALENDAR_NAME
, TO_CHAR(ADD_MONTHS(SYSDATE
, -13+ROWNUM)
, 'MM-YYYY') PERIOD_NAME
, TRUNC(ADD_MONTHS(SYSDATE
, -13+ROWNUM)
, 'MM') 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
FROM HR_LOOKUPS
WHERE ROWNUM < 72 UNION SELECT 'HR BIMONTH'||'+'||TO_CHAR(ADD_MONTHS(SYSDATE
, -13+ROWNUM)
, 'MM-YYYY') ID
, TO_CHAR(ADD_MONTHS(SYSDATE
, -13+ROWNUM)
, 'MM-YYYY') VALUE
, 'HR BIMONTH' CALENDAR_NAME
, TO_CHAR(ADD_MONTHS(SYSDATE
, -13+ROWNUM)
, 'MM-YYYY') PERIOD_NAME
, TRUNC(ADD_MONTHS(SYSDATE
, -13+ROWNUM)
, 'MM') START_DATE
, LAST_DAY(ADD_MONTHS(TRUNC(SYSDATE)
, -12+ROWNUM)) END_DATE
, TO_NUMBER(TO_CHAR(ADD_MONTHS(SYSDATE
, -13+ROWNUM)
, 'YYYY')) PERIOD_YEAR
, TO_CHAR(NULL) ORGANIZATION_ID
FROM HR_LOOKUPS
WHERE ROWNUM < 72 UNION SELECT 'HR QUARTER'||'+'||TO_CHAR(ADD_MONTHS(SYSDATE
, -13+ROWNUM)
, 'MM-YYYY') ID
, TO_CHAR(ADD_MONTHS(SYSDATE
, -13+ROWNUM)
, 'MM-YYYY') VALUE
, 'HR QUARTER' CALENDAR_NAME
, TO_CHAR(ADD_MONTHS(SYSDATE
, -13+ROWNUM)
, 'MM-YYYY') PERIOD_NAME
, TRUNC(ADD_MONTHS(SYSDATE
, -13+ROWNUM)
, 'MM') START_DATE
, LAST_DAY(ADD_MONTHS(TRUNC(SYSDATE)
, -11+ROWNUM)) END_DATE
, TO_NUMBER(TO_CHAR(ADD_MONTHS(SYSDATE
, -13+ROWNUM)
, 'YYYY')) PERIOD_YEAR
, TO_CHAR(NULL) ORGANIZATION_ID
FROM HR_LOOKUPS
WHERE ROWNUM < 72 UNION SELECT 'HR SEMIYEAR'||'+'||TO_CHAR(ADD_MONTHS(SYSDATE
, -13+ROWNUM)
, 'MM-YYYY') ID
, TO_CHAR(ADD_MONTHS(SYSDATE
, -13+ROWNUM)
, 'MM-YYYY') VALUE
, 'HR SEMIYEAR' CALENDAR_NAME
, TO_CHAR(ADD_MONTHS(SYSDATE
, -13+ROWNUM)
, 'MM-YYYY') PERIOD_NAME
, TRUNC(ADD_MONTHS(SYSDATE
, -13+ROWNUM)
, 'MM') START_DATE
, LAST_DAY(ADD_MONTHS(TRUNC(SYSDATE)
, -8+ROWNUM)) END_DATE
, TO_NUMBER(TO_CHAR(ADD_MONTHS(SYSDATE
, -13+ROWNUM)
, 'YYYY')) PERIOD_YEAR
, TO_CHAR(NULL) ORGANIZATION_ID
FROM HR_LOOKUPS
WHERE ROWNUM < 72 UNION SELECT 'HR YEAR'||'+'||TO_CHAR(ADD_MONTHS(SYSDATE
, -13+ROWNUM)
, 'MM-YYYY') ID
, TO_CHAR(ADD_MONTHS(SYSDATE
, -13+ROWNUM)
, 'MM-YYYY') VALUE
, 'HR YEAR' CALENDAR_NAME
, TO_CHAR(ADD_MONTHS(SYSDATE
, -13+ROWNUM)
, 'MM-YYYY') PERIOD_NAME
, TRUNC(ADD_MONTHS(SYSDATE
, -13+ROWNUM)
, 'MM') START_DATE
, LAST_DAY(ADD_MONTHS(TRUNC(SYSDATE)
, -2+ROWNUM)) END_DATE
, TO_NUMBER(TO_CHAR(ADD_MONTHS(SYSDATE
, -13+ROWNUM)
, 'YYYY')) PERIOD_YEAR
, TO_CHAR(NULL) ORGANIZATION_ID
FROM HR_LOOKUPS
WHERE ROWNUM < 72
Columns
Name |
ID |
VALUE |
CALENDAR_NAME |
PERIOD_NAME |
START_DATE |
END_DATE |
PERIOD_YEAR |
ORGANIZATION_ID |