View: HRICV_HR_DAY

Product:	HRI - Human Resources Intelligence (Obsolete)
Description:
Implementation/DBA Data:	APPS.HRICV_HR_DAY

View Text

SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ TO_CHAR(CALC.THIS_DATE
, 'YYYY-MM-DD') ID
, CALC.THIS_DATE VALUE
, 'HR_DAY' PERIOD_SET_NAME /*COULD USER DEFINED THIS PERIOD NAME STYLE*/
, TO_CHAR(CALC.THIS_DATE
, 'YYYY-MON-DD')|| ' (D'|| TO_CHAR(CALC.PERIOD_NO)|| ')' PERIOD_NAME
, CALC.THIS_DATE START_DATE
, CALC.THIS_DATE END_DATE /*COULD USER DEFINE FIRST DAY OF THE YEAR HERE*/
, CALC.PERIOD_NO PERIOD_NO_IN_YEAR
, TRUNC(CALC.THIS_DATE
, 'YYYY') PERIOD_YEAR
, TO_CHAR(NULL) ORGANIZATION_ID
, TO_CHAR(NULL) ORGANIZATION_TYPE
FROM ( SELECT CALC1.THIS_DATE THIS_DATE
, CALC1.THIS_DATE - TRUNC(CALC1.THIS_DATE
, 'YYYY') + 1 PERIOD_NO
FROM ( SELECT TRUNC(ADD_MONTHS(SYSDATE
, -600) + ROWNUM) THIS_DATE /* 50 YEAR OFFSET*/
FROM FND_NEW_MESSAGES) CALC1 /* USING FND NEW MESSAGES BECAUSE NEED > 36500 ROWS*/ ) CALC
WHERE ROWNUM <= 36500 /*+/- 50 YEARS 100*365 */ WITH READ ONLY

Columns