[Home] [Help]
View: BIS_HR_SEMIYEARS_V
Product: | BIS - Applications BIS |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT 'HR SEMIYEAR'||'+'||TO_CHAR(ADD_MONTHS (SYSDATE
, -12)
, 'MON-YYYY') ID
, TO_CHAR(ADD_MONTHS (SYSDATE
, -12)
, 'MON-YYYY') VALUE
, 'HR SEMIYEAR'
, TO_CHAR(ADD_MONTHS (SYSDATE
, -12)
, 'MON-YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, -12)
, 'MON')
, TRUNC(ADD_MONTHS (SYSDATE
, -6)
, 'MON')-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 SEMIYEAR'||'+'||TO_CHAR(ADD_MONTHS (SYSDATE
, -6)
, 'MON-YYYY') ID
, TO_CHAR(ADD_MONTHS (SYSDATE
, -6)
, 'MON-YYYY') VALUE
, 'HR SEMIYEAR'
, TO_CHAR(ADD_MONTHS (SYSDATE
, -6)
, 'MON-YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, -6)
, 'MON')
, TRUNC(SYSDATE
, 'MON')-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 SEMIYEAR'||'+'||TO_CHAR(SYSDATE
, 'MON-YYYY') ID
, TO_CHAR(SYSDATE
, 'MON-YYYY') VALUE
, 'HR SEMIYEAR'
, TO_CHAR(SYSDATE
, 'MON-YYYY')
, TRUNC(SYSDATE
, 'MON')
, ADD_MONTHS(LAST_DAY(SYSDATE)
, 6)
, TO_NUMBER(TO_CHAR(SYSDATE
, 'YYYY'))
, TO_CHAR(NULL) ORGANIZAZTION_ID
, TO_CHAR(NULL) ORGANIZATION_TYPE
FROM DUAL UNION SELECT 'HR SEMIYEAR'||'+'||TO_CHAR(ADD_MONTHS (SYSDATE
, 6)
, 'MON-YYYY') ID
, TO_CHAR(ADD_MONTHS (SYSDATE
, 6)
, 'MON-YYYY') VALUE
, 'HR SEMIYEAR'
, TO_CHAR(ADD_MONTHS (SYSDATE
, 6)
, 'MON-YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 6 )
, 'MON')
, TRUNC(ADD_MONTHS (SYSDATE
, 12)
, 'MON')-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 SEMIYEAR'||'+'||TO_CHAR(ADD_MONTHS (SYSDATE
, 12)
, 'MON-YYYY') ID
, TO_CHAR(ADD_MONTHS (SYSDATE
, 12)
, 'MON-YYYY') VALUE
, 'HR SEMIYEAR'
, TO_CHAR(ADD_MONTHS (SYSDATE
, 12)
, 'MON-YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 12 )
, 'MON')
, TRUNC(ADD_MONTHS (SYSDATE
, 18)
, 'MON')-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 SEMIYEAR'||'+'||TO_CHAR(ADD_MONTHS (SYSDATE
, 18)
, 'MON-YYYY') ID
, TO_CHAR(ADD_MONTHS (SYSDATE
, 18)
, 'MON-YYYY') VALUE
, 'HR SEMIYEAR'
, TO_CHAR(ADD_MONTHS (SYSDATE
, 18)
, 'MON-YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 18 )
, 'MON')
, TRUNC(ADD_MONTHS (SYSDATE
, 24)
, 'MON')-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 SEMIYEAR'||'+'||TO_CHAR(ADD_MONTHS (SYSDATE
, 24)
, 'MON-YYYY') ID
, TO_CHAR(ADD_MONTHS (SYSDATE
, 24)
, 'MON-YYYY') VALUE
, 'HR SEMIYEAR'
, TO_CHAR(ADD_MONTHS (SYSDATE
, 24)
, 'MON-YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 24 )
, 'MON')
, TRUNC(ADD_MONTHS (SYSDATE
, 30)
, 'MON')-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 SEMIYEAR'||'+'||TO_CHAR(ADD_MONTHS (SYSDATE
, 30)
, 'MON-YYYY') ID
, TO_CHAR(ADD_MONTHS (SYSDATE
, 30)
, 'MON-YYYY') VALUE
, 'HR SEMIYEAR'
, TO_CHAR(ADD_MONTHS (SYSDATE
, 30)
, 'MON-YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 30 )
, 'MON')
, TRUNC(ADD_MONTHS (SYSDATE
, 36)
, 'MON')-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 SEMIYEAR'||'+'||TO_CHAR(ADD_MONTHS (SYSDATE
, 36)
, 'MON-YYYY') ID
, TO_CHAR(ADD_MONTHS (SYSDATE
, 36)
, 'MON-YYYY') VALUE
, 'HR SEMIYEAR'
, TO_CHAR(ADD_MONTHS (SYSDATE
, 36)
, 'MON-YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 36 )
, 'MON')
, TRUNC(ADD_MONTHS (SYSDATE
, 42)
, 'MON')-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 SEMIYEAR'||'+'||TO_CHAR(ADD_MONTHS (SYSDATE
, 42)
, 'MON-YYYY') ID
, TO_CHAR(ADD_MONTHS (SYSDATE
, 42)
, 'MON-YYYY') VALUE
, 'HR SEMIYEAR'
, TO_CHAR(ADD_MONTHS (SYSDATE
, 42)
, 'MON-YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 42 )
, 'MON')
, TRUNC(ADD_MONTHS (SYSDATE
, 48)
, 'MON')-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 SEMIYEAR'||'+'||TO_CHAR(ADD_MONTHS (SYSDATE
, 48)
, 'MON-YYYY') ID
, TO_CHAR(ADD_MONTHS (SYSDATE
, 48)
, 'MON-YYYY') VALUE
, 'HR SEMIYEAR'
, TO_CHAR(ADD_MONTHS (SYSDATE
, 48)
, 'MON-YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 48)
, 'MON')
, TRUNC(ADD_MONTHS (SYSDATE
, 54)
, 'MON')-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 SEMIYEAR'||'+'||TO_CHAR(ADD_MONTHS (SYSDATE
, 54)
, 'MON-YYYY') ID
, TO_CHAR(ADD_MONTHS (SYSDATE
, 54)
, 'MON-YYYY') VALUE
, 'HR SEMIYEAR'
, TO_CHAR(ADD_MONTHS (SYSDATE
, 54)
, 'MON-YYYY')
, TRUNC(ADD_MONTHS (SYSDATE
, 54 )
, 'MON')
, TRUNC(ADD_MONTHS (SYSDATE
, 60)
, 'MON')-1
, TO_NUMBER(TO_CHAR(ADD_MONTHS (SYSDATE
, 54 )
, '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 |