[Home] [Help]
View: BIS_HR_YEARS_V
Product: | BIS - Applications BIS |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT 'HR YEAR'||'+'||TO_CHAR (ADD_MONTHS (SYSDATE
, -12)
, 'YYYY') ID
, TO_CHAR (ADD_MONTHS (SYSDATE
, -12)
, 'YYYY') VALUE
, 'HR YEAR'
, TO_CHAR (ADD_MONTHS (SYSDATE
, -12)
, 'YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, -12)
, 'YYYY')
, TRUNC(SYSDATE
, 'YYYY')-1
, TO_NUMBER(TO_CHAR (ADD_MONTHS (SYSDATE
, -12)
, 'YYYY'))
, TO_CHAR(NULL) ORGANIZAZTION_ID
, TO_CHAR(NULL) ORGANIZATION_TYPE
FROM DUAL UNION SELECT 'HR YEAR'||'+'||TO_CHAR (SYSDATE
, 'YYYY') ID
, TO_CHAR (SYSDATE
, 'YYYY') VALUE
, 'HR YEAR'
, TO_CHAR (SYSDATE
, 'YYYY')
, TRUNC(SYSDATE
, 'YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 12)
, 'YYYY')-1
, TO_NUMBER(TO_CHAR (SYSDATE
, 'YYYY'))
, TO_CHAR(NULL) ORGANIZAZTION_ID
, TO_CHAR(NULL) ORGANIZATION_TYPE
FROM DUAL UNION SELECT 'HR YEAR'||'+'||TO_CHAR (ADD_MONTHS (SYSDATE
, 12)
, 'YYYY') ID
, TO_CHAR (ADD_MONTHS (SYSDATE
, 12)
, 'YYYY') VALUE
, 'HR YEAR'
, TO_CHAR (ADD_MONTHS (SYSDATE
, 12)
, 'YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 12)
, 'YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 24)
, 'YYYY')-1
, TO_NUMBER(TO_CHAR (ADD_MONTHS (SYSDATE
, 12)
, 'YYYY'))
, TO_CHAR(NULL) ORGANIZAZTION_ID
, TO_CHAR(NULL) ORGANIZATION_TYPE
FROM DUAL UNION SELECT 'HR YEAR'||'+'||TO_CHAR (ADD_MONTHS (SYSDATE
, 24)
, 'YYYY') ID
, TO_CHAR (ADD_MONTHS (SYSDATE
, 24)
, 'YYYY') VALUE
, 'HR YEAR'
, TO_CHAR (ADD_MONTHS (SYSDATE
, 24)
, 'YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 24)
, 'YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 36)
, 'YYYY')-1
, TO_NUMBER(TO_CHAR (ADD_MONTHS (SYSDATE
, 24)
, 'YYYY'))
, TO_CHAR(NULL) ORGANIZAZTION_ID
, TO_CHAR(NULL) ORGANIZATION_TYPE
FROM DUAL UNION SELECT 'HR YEAR'||'+'||TO_CHAR (ADD_MONTHS (SYSDATE
, 36)
, 'YYYY') ID
, TO_CHAR (ADD_MONTHS (SYSDATE
, 36)
, 'YYYY') VALUE
, 'HR YEAR'
, TO_CHAR (ADD_MONTHS (SYSDATE
, 36)
, 'YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 36)
, 'YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 48)
, 'YYYY')-1
, TO_NUMBER(TO_CHAR (ADD_MONTHS (SYSDATE
, 36)
, 'YYYY'))
, TO_CHAR(NULL) ORGANIZAZTION_ID
, TO_CHAR(NULL) ORGANIZATION_TYPE
FROM DUAL UNION SELECT 'HR YEAR'||'+'||TO_CHAR (ADD_MONTHS (SYSDATE
, 48)
, 'YYYY') ID
, TO_CHAR (ADD_MONTHS (SYSDATE
, 48)
, 'YYYY') VALUE
, 'HR YEAR'
, TO_CHAR (ADD_MONTHS (SYSDATE
, 48)
, 'YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 48)
, 'YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 60)
, 'YYYY')-1
, TO_NUMBER(TO_CHAR (ADD_MONTHS (SYSDATE
, 48)
, 'YYYY'))
, TO_CHAR(NULL) ORGANIZAZTION_ID
, TO_CHAR(NULL) ORGANIZATION_TYPE
FROM DUAL UNION SELECT'HR YEAR'||'+'||TO_CHAR (ADD_MONTHS (SYSDATE
, 60)
, 'YYYY') ID
, TO_CHAR (ADD_MONTHS (SYSDATE
, 60)
, 'YYYY') VALUE
, 'HR YEAR'
, TO_CHAR (ADD_MONTHS (SYSDATE
, 60)
, 'YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 60)
, 'YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 72)
, 'YYYY')-1
, TO_NUMBER(TO_CHAR (ADD_MONTHS (SYSDATE
, 60)
, 'YYYY'))
, TO_CHAR(NULL) ORGANIZAZTION_ID
, TO_CHAR(NULL) ORGANIZATION_TYPE
FROM DUAL
Columns
Name |
ID |
VALUE |
PERIOD_SET_NAME |
PERIOD_NAME |
START_DATE |
END_DATE |
PERIOD_YEAR |
ORGANIZATION_ID |
ORGANIZATION_TYPE |