VIEW: APPS.HRICV_HR_DAY

Source

View Text - Preformatted

SELECT to_char(calc.this_date,'YYYY-MM-DD') ID , calc.this_date Value , 'HR_DAY' Period_Set_Name , to_char(calc.this_date,'YYYY-MM-DD') Period_Name /*Should be user defined*/ , calc.this_date Start_Date , calc.this_date End_Date , calc.this_date - trunc(calc.this_date,'YYYY') Period_No_In_Year , trunc(calc.this_date,'YYYY') Period_Year , to_char(NULL) Organization_ID , to_char(NULL) Organization_TYPE FROM ( SELECT trunc(add_months(sysdate,-600) + rownum) this_date /* 50 year offset*/ FROM fnd_new_messages) calc WHERE rownum <= 36500 /*+/- 50 years 100*365 */ WITH READ ONLY

View Text - HTML Formatted

SELECT TO_CHAR(CALC.THIS_DATE
, 'YYYY-MM-DD') ID
, CALC.THIS_DATE VALUE
, 'HR_DAY' PERIOD_SET_NAME
, TO_CHAR(CALC.THIS_DATE
, 'YYYY-MM-DD') PERIOD_NAME /*SHOULD BE USER DEFINED*/
, CALC.THIS_DATE START_DATE
, CALC.THIS_DATE END_DATE
, CALC.THIS_DATE - TRUNC(CALC.THIS_DATE
, 'YYYY') PERIOD_NO_IN_YEAR
, TRUNC(CALC.THIS_DATE
, 'YYYY') PERIOD_YEAR
, TO_CHAR(NULL) ORGANIZATION_ID
, TO_CHAR(NULL) ORGANIZATION_TYPE
FROM ( SELECT TRUNC(ADD_MONTHS(SYSDATE
, -600) + ROWNUM) THIS_DATE /* 50 YEAR OFFSET*/
FROM FND_NEW_MESSAGES) CALC
WHERE ROWNUM <= 36500 /*+/- 50 YEARS 100*365 */ WITH READ ONLY