[Home] [Help]
View: BIS_HR_QUARTERS_V
View Text
SELECT 'HR QUARTER'||'+'||TO_CHAR(ADD_MONTHS(SYSDATE
, -12)
, 'Q YYYY') ID
, TO_CHAR (ADD_MONTHS (SYSDATE
, -12)
, 'Q YYYY') VALUE
, 'HR QUARTER'
, TO_CHAR (ADD_MONTHS (SYSDATE
, -12)
, 'Q YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, -12)
, 'Q')
, TRUNC(ADD_MONTHS (SYSDATE
, -9)
, 'Q')-1
, TO_NUMBER(TO_CHAR (ADD_MONTHS (SYSDATE
, -12)
, 'YYYY'))
, TO_CHAR(NULL) ORGANIZATION_ID
, TO_CHAR(NULL) ORGANIZATION_TYPE
FROM DUAL UNION SELECT 'HR QUARTER'||'+'||TO_CHAR(ADD_MONTHS(SYSDATE
, -9)
, 'Q YYYY') ID
, TO_CHAR(ADD_MONTHS(SYSDATE
, -9)
, 'Q YYYY') VALUE
, 'HR QUARTER'
, TO_CHAR (ADD_MONTHS (SYSDATE
, -9)
, 'Q YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, -9)
, 'Q')
, TRUNC(ADD_MONTHS (SYSDATE
, -6)
, 'Q')-1
, TO_NUMBER(TO_CHAR (ADD_MONTHS (SYSDATE
, -9)
, 'YYYY'))
, TO_CHAR(NULL) ORGANIZATION_ID
, TO_CHAR(NULL) ORGANIZATION_TYPE
FROM DUAL UNION SELECT 'HR QUARTER'||'+'||TO_CHAR(ADD_MONTHS(SYSDATE
, -6)
, 'Q YYYY') ID
, TO_CHAR (ADD_MONTHS (SYSDATE
, -6)
, 'Q YYYY') VALUE
, 'HR QUARTER'
, TO_CHAR (ADD_MONTHS (SYSDATE
, -6)
, 'Q YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, -6)
, 'Q')
, TRUNC(ADD_MONTHS (SYSDATE
, -3)
, 'Q')-1
, TO_NUMBER(TO_CHAR (ADD_MONTHS (SYSDATE
, -6)
, 'YYYY'))
, TO_CHAR(NULL) ORGANIZAZTION_ID
, TO_CHAR(NULL) ORGANIZATION_TYPE
FROM DUAL UNION SELECT 'HR QUARTER'||'+'||TO_CHAR(ADD_MONTHS(SYSDATE
, -3)
, 'Q YYYY') ID
, TO_CHAR(ADD_MONTHS(SYSDATE
, -3)
, 'Q YYYY') VALUE
, 'HR QUARTER'
, TO_CHAR (ADD_MONTHS (SYSDATE
, -3)
, 'Q YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, -3)
, 'Q')
, TRUNC(SYSDATE
, 'Q')-1
, TO_NUMBER(TO_CHAR (ADD_MONTHS (SYSDATE
, -3)
, 'YYYY'))
, TO_CHAR(NULL) ORGANIZAZTION_ID
, TO_CHAR(NULL) ORGANIZATION_TYPE
FROM DUAL UNION SELECT 'HR QUARTER'||'+'||TO_CHAR(SYSDATE
, 'Q YYYY') ID
, TO_CHAR(SYSDATE
, 'Q YYYY') VALUE
, 'HR QUARTER'
, TO_CHAR (SYSDATE
, 'Q YYYY')
, TRUNC(SYSDATE
, 'Q')
, TRUNC(ADD_MONTHS (SYSDATE
, 3)
, 'Q')-1
, TO_NUMBER(TO_CHAR (SYSDATE
, 'YYYY'))
, TO_CHAR(NULL) ORGANIZAZTION_ID
, TO_CHAR(NULL) ORGANIZATION_TYPE
FROM DUAL UNION SELECT 'HR QUARTER'||'+'||TO_CHAR(ADD_MONTHS(SYSDATE
, 3)
, 'Q YYYY') ID
, TO_CHAR(ADD_MONTHS(SYSDATE
, 3)
, 'Q YYYY') VALUE
, 'HR QUARTER'
, TO_CHAR (ADD_MONTHS (SYSDATE
, 3)
, 'Q YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 3 )
, 'Q')
, TRUNC(ADD_MONTHS (SYSDATE
, 6 )
, 'Q')-1
, TO_NUMBER(TO_CHAR (ADD_MONTHS (SYSDATE
, 3 )
, 'YYYY'))
, TO_CHAR(NULL) ORGANIZAZTION_ID
, TO_CHAR(NULL) ORGANIZATION_TYPE
FROM DUAL UNION SELECT 'HR QUARTER'||'+'||TO_CHAR(ADD_MONTHS(SYSDATE
, 6)
, 'Q YYYY') ID
, TO_CHAR(ADD_MONTHS(SYSDATE
, 6)
, 'Q YYYY') VALUE
, 'HR QUARTER'
, TO_CHAR (ADD_MONTHS (SYSDATE
, 6)
, 'Q YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 6 )
, 'Q')
, TRUNC(ADD_MONTHS (SYSDATE
, 9 )
, 'Q')-1
, TO_NUMBER(TO_CHAR (ADD_MONTHS (SYSDATE
, 6 )
, 'YYYY'))
, TO_CHAR(NULL) ORGANIZAZTION_ID
, TO_CHAR(NULL) ORGANIZATION_TYPE
FROM DUAL UNION SELECT 'HR QUARTER'||'+'||TO_CHAR(ADD_MONTHS(SYSDATE
, 9)
, 'Q YYYY') ID
, TO_CHAR(ADD_MONTHS(SYSDATE
, 9)
, 'Q YYYY') VALUE
, 'HR QUARTER'
, TO_CHAR (ADD_MONTHS (SYSDATE
, 9)
, 'Q YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 9 )
, 'Q')
, TRUNC(ADD_MONTHS (SYSDATE
, 12 )
, 'Q')-1
, TO_NUMBER(TO_CHAR (ADD_MONTHS (SYSDATE
, 9 )
, 'YYYY'))
, TO_CHAR(NULL) ORGANIZAZTION_ID
, TO_CHAR(NULL) ORGANIZATION_TYPE
FROM DUAL UNION SELECT 'HR QUARTER'||'+'||TO_CHAR(ADD_MONTHS(SYSDATE
, 12)
, 'Q YYYY') ID
, TO_CHAR(ADD_MONTHS(SYSDATE
, 12)
, 'Q YYYY') VALUE
, 'HR QUARTER'
, TO_CHAR (ADD_MONTHS (SYSDATE
, 12)
, 'Q YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 12 )
, 'Q')
, TRUNC(ADD_MONTHS (SYSDATE
, 15 )
, 'Q')-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 QUARTER'||'+'||TO_CHAR(ADD_MONTHS(SYSDATE
, 15)
, 'Q YYYY') ID
, TO_CHAR(ADD_MONTHS(SYSDATE
, 15)
, 'Q YYYY') VALUE
, 'HR QUARTER'
, TO_CHAR (ADD_MONTHS (SYSDATE
, 15)
, 'Q YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 15 )
, 'Q')
, TRUNC(ADD_MONTHS (SYSDATE
, 18 )
, 'Q')-1
, TO_NUMBER(TO_CHAR (ADD_MONTHS (SYSDATE
, 15 )
, 'YYYY'))
, TO_CHAR(NULL) ORGANIZAZTION_ID
, TO_CHAR(NULL) ORGANIZATION_TYPE
FROM DUAL UNION SELECT 'HR QUARTER'||'+'||TO_CHAR(ADD_MONTHS(SYSDATE
, 18)
, 'Q YYYY') ID
, TO_CHAR(ADD_MONTHS(SYSDATE
, 18)
, 'Q YYYY') VALUE
, 'HR QUARTER'
, TO_CHAR (ADD_MONTHS (SYSDATE
, 18)
, 'Q YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 18 )
, 'Q')
, TRUNC(ADD_MONTHS (SYSDATE
, 21 )
, 'Q')-1
, TO_NUMBER(TO_CHAR (ADD_MONTHS (SYSDATE
, 18 )
, 'YYYY'))
, TO_CHAR(NULL) ORGANIZAZTION_ID
, TO_CHAR(NULL) ORGANIZATION_TYPE
FROM DUAL UNION SELECT 'HR QUARTER'||'+'||TO_CHAR(ADD_MONTHS(SYSDATE
, 21)
, 'Q YYYY') ID
, TO_CHAR(ADD_MONTHS(SYSDATE
, 21)
, 'Q YYYY') VALUE
, 'HR QUARTER'
, TO_CHAR (ADD_MONTHS (SYSDATE
, 21)
, 'Q YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 21 )
, 'Q')
, TRUNC(ADD_MONTHS (SYSDATE
, 24 )
, 'Q')-1
, TO_NUMBER(TO_CHAR (ADD_MONTHS (SYSDATE
, 21)
, 'YYYY'))
, TO_CHAR(NULL) ORGANIZAZTION_ID
, TO_CHAR(NULL) ORGANIZATION_TYPE
FROM DUAL UNION SELECT 'HR QUARTER'||'+'||TO_CHAR(ADD_MONTHS(SYSDATE
, 24)
, 'Q YYYY') ID
, TO_CHAR(ADD_MONTHS(SYSDATE
, 24)
, 'Q YYYY') VALUE
, 'HR QUARTER'
, TO_CHAR (ADD_MONTHS (SYSDATE
, 24)
, 'Q YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 24 )
, 'Q')
, TRUNC(ADD_MONTHS (SYSDATE
, 27 )
, 'Q')-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 QUARTER'||'+'||TO_CHAR(ADD_MONTHS(SYSDATE
, 27)
, 'Q YYYY') ID
, TO_CHAR(ADD_MONTHS(SYSDATE
, 24)
, 'Q YYYY') VALUE
, 'HR QUARTER'
, TO_CHAR (ADD_MONTHS (SYSDATE
, 27)
, 'Q YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 27 )
, 'Q')
, TRUNC(ADD_MONTHS (SYSDATE
, 30 )
, 'Q')-1
, TO_NUMBER(TO_CHAR (ADD_MONTHS (SYSDATE
, 27 )
, 'YYYY'))
, TO_CHAR(NULL) ORGANIZAZTION_ID
, TO_CHAR(NULL) ORGANIZATION_TYPE
FROM DUAL UNION SELECT 'HR QUARTER'||'+'||TO_CHAR(ADD_MONTHS(SYSDATE
, 30)
, 'Q YYYY') ID
, TO_CHAR(ADD_MONTHS(SYSDATE
, 30)
, 'Q YYYY') VALUE
, 'HR QUARTER'
, TO_CHAR (ADD_MONTHS (SYSDATE
, 30)
, 'Q YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 30 )
, 'Q')
, TRUNC(ADD_MONTHS (SYSDATE
, 33 )
, 'Q')-1
, TO_NUMBER(TO_CHAR (ADD_MONTHS (SYSDATE
, 30 )
, 'YYYY'))
, TO_CHAR(NULL) ORGANIZAZTION_ID
, TO_CHAR(NULL) ORGANIZATION_TYPE
FROM DUAL UNION SELECT 'HR QUARTER'||'+'||TO_CHAR(ADD_MONTHS(SYSDATE
, 33)
, 'Q YYYY') ID
, TO_CHAR(ADD_MONTHS(SYSDATE
, 33)
, 'Q YYYY') VALUE
, 'HR QUARTER'
, TO_CHAR (ADD_MONTHS (SYSDATE
, 33)
, 'Q YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 33 )
, 'Q')
, TRUNC(ADD_MONTHS (SYSDATE
, 36 )
, 'Q')-1
, TO_NUMBER(TO_CHAR (ADD_MONTHS (SYSDATE
, 33 )
, 'YYYY'))
, TO_CHAR(NULL) ORGANIZAZTION_ID
, TO_CHAR(NULL) ORGANIZATION_TYPE
FROM DUAL UNION SELECT 'HR QUARTER'||'+'||TO_CHAR(ADD_MONTHS(SYSDATE
, 36)
, 'Q YYYY') ID
, TO_CHAR(ADD_MONTHS(SYSDATE
, 36)
, 'Q YYYY') VALUE
, 'HR QUARTER'
, TO_CHAR (ADD_MONTHS (SYSDATE
, 36)
, 'Q YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 36)
, 'Q')
, TRUNC(ADD_MONTHS (SYSDATE
, 39)
, 'Q')-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 QUARTER'||'+'||TO_CHAR(ADD_MONTHS(SYSDATE
, 39)
, 'Q YYYY') ID
, TO_CHAR(ADD_MONTHS(SYSDATE
, 39)
, 'Q YYYY') VALUE
, 'HR QUARTER'
, TO_CHAR (ADD_MONTHS (SYSDATE
, 39)
, 'Q YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 39 )
, 'Q')
, TRUNC(ADD_MONTHS (SYSDATE
, 42 )
, 'Q')-1
, TO_NUMBER(TO_CHAR (ADD_MONTHS (SYSDATE
, 39)
, 'YYYY'))
, TO_CHAR(NULL) ORGANIZAZTION_ID
, TO_CHAR(NULL) ORGANIZATION_TYPE
FROM DUAL UNION SELECT 'HR QUARTER'||'+'||TO_CHAR(ADD_MONTHS(SYSDATE
, 42)
, 'Q YYYY') ID
, TO_CHAR(ADD_MONTHS(SYSDATE
, 42)
, 'Q YYYY') VALUE
, 'HR QUARTER'
, TO_CHAR (ADD_MONTHS (SYSDATE
, 42)
, 'Q YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 42 )
, 'Q')
, TRUNC(ADD_MONTHS (SYSDATE
, 45 )
, 'Q')-1
, TO_NUMBER(TO_CHAR (ADD_MONTHS (SYSDATE
, 42)
, 'YYYY'))
, TO_CHAR(NULL) ORGANIZAZTION_ID
, TO_CHAR(NULL) ORGANIZATION_TYPE
FROM DUAL UNION SELECT 'HR QUARTER'||'+'||TO_CHAR(ADD_MONTHS(SYSDATE
, 45)
, 'Q YYYY') ID
, TO_CHAR(ADD_MONTHS(SYSDATE
, 45)
, 'Q YYYY') VALUE
, 'HR QUARTER'
, TO_CHAR (ADD_MONTHS (SYSDATE
, 45)
, 'Q YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 45 )
, 'Q')
, TRUNC(ADD_MONTHS (SYSDATE
, 48 )
, 'Q')-1
, TO_NUMBER(TO_CHAR (ADD_MONTHS (SYSDATE
, 45)
, 'YYYY'))
, TO_CHAR(NULL) ORGANIZAZTION_ID
, TO_CHAR(NULL) ORGANIZATION_TYPE
FROM DUAL UNION SELECT 'HR QUARTER'||'+'||TO_CHAR(ADD_MONTHS(SYSDATE
, 48)
, 'Q YYYY') ID
, TO_CHAR(ADD_MONTHS(SYSDATE
, 48)
, 'Q YYYY') VALUE
, 'HR QUARTER'
, TO_CHAR (ADD_MONTHS (SYSDATE
, 48)
, 'Q YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 48 )
, 'Q')
, TRUNC(ADD_MONTHS (SYSDATE
, 51 )
, 'Q')-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 QUARTER'||'+'||TO_CHAR(ADD_MONTHS(SYSDATE
, 51)
, 'Q YYYY') ID
, TO_CHAR(ADD_MONTHS(SYSDATE
, 51)
, 'Q YYYY') VALUE
, 'HR QUARTER'
, TO_CHAR (ADD_MONTHS (SYSDATE
, 51)
, 'Q YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 51 )
, 'Q')
, TRUNC(ADD_MONTHS (SYSDATE
, 54 )
, 'Q')-1
, TO_NUMBER(TO_CHAR (ADD_MONTHS (SYSDATE
, 51)
, 'YYYY'))
, TO_CHAR(NULL) ORGANIZAZTION_ID
, TO_CHAR(NULL) ORGANIZATION_TYPE
FROM DUAL UNION SELECT 'HR QUARTER'||'+'||TO_CHAR(ADD_MONTHS(SYSDATE
, 54)
, 'Q YYYY') ID
, TO_CHAR(ADD_MONTHS(SYSDATE
, 54)
, 'Q YYYY') VALUE
, 'HR QUARTER'
, TO_CHAR (ADD_MONTHS (SYSDATE
, 54)
, 'Q YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 54)
, 'Q')
, TRUNC(ADD_MONTHS (SYSDATE
, 57)
, 'Q')-1
, TO_NUMBER(TO_CHAR (ADD_MONTHS (SYSDATE
, 54)
, 'YYYY'))
, TO_CHAR(NULL) ORGANIZAZTION_ID
, TO_CHAR(NULL) ORGANIZATION_TYPE
FROM DUAL UNION SELECT 'HR QUARTER'||'+'||TO_CHAR(ADD_MONTHS(SYSDATE
, 57)
, 'Q YYYY') ID
, TO_CHAR(ADD_MONTHS(SYSDATE
, 57)
, 'Q YYYY') VALUE
, 'HR QUARTER'
, TO_CHAR (ADD_MONTHS (SYSDATE
, 57)
, 'Q YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 57)
, 'Q')
, TRUNC(ADD_MONTHS (SYSDATE
, 60 )
, 'Q')-1
, TO_NUMBER(TO_CHAR (ADD_MONTHS (SYSDATE
, 57)
, 'YYYY'))
, TO_CHAR(NULL) ORGANIZAZTION_ID
, TO_CHAR(NULL) ORGANIZATION_TYPE
FROM DUAL UNION SELECT 'HR QUARTER'||'+'||TO_CHAR(ADD_MONTHS(SYSDATE
, 60)
, 'Q YYYY') ID
, TO_CHAR(ADD_MONTHS(SYSDATE
, 60)
, 'Q YYYY') VALUE
, 'HR QUARTER'
, TO_CHAR (ADD_MONTHS (SYSDATE
, 60)
, 'Q YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 60 )
, 'Q')
, TRUNC(ADD_MONTHS (SYSDATE
, 63 )
, 'Q')-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 |