eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: APPS.HRI_CS_TIME_GRGRN_CLNDR_V

Source

View Text - Preformatted


SELECT fday.report_date DAY_ID ,fday.start_date DAY_START_DATE ,fday.end_date DAY_END_DATE ,fmnth.month_id MONTH_ID ,fmnth.start_date MONTH_START_DATE ,fmnth.end_date MONTH_END_DATE ,DECODE( MOD(to_number(to_char(fmnth.START_DATE,'mm')),2) ,0, to_number(to_char(fmnth.START_DATE,'mm') / 2) || ',' || fyr.year_id , (to_number(to_char(fmnth.START_DATE,'mm')) + 1) / 2 || ',' || fyr.year_id) BI_MONTH_ID ,DECODE ( MOD(to_number(to_char(fmnth.START_DATE,'mm')),2) ,0, add_months(fmnth.START_DATE,-1) , fmnth.start_date) BI_MONTH_START_DATE ,DECODE( MOD(to_number(to_char(fmnth.START_DATE,'mm')),2) ,0, fmnth.end_date , add_months(fmnth.end_date,1)) BI_MONTH_END_DATE ,fqtr.quarter_id QUARTER_ID ,fqtr.start_date QUARTER_START_DATE ,fqtr.end_date QUARTER_END_DATE , DECODE( SIGN((fday.start_date-1) - (add_months(fyr.end_date ,-6)+1) ) , -1, '1,'||to_char(fyr.start_date,'YYYY') , 0, '2,'||to_char(fyr.start_date,'YYYY') , 1, '2,'||to_char(fyr.start_date,'YYYY') ) SEMI_YEAR_ID , DECODE( SIGN((fday.start_date-1) - (add_months(fyr.end_date ,-6)+1) ) , -1, fyr.start_date , 0, add_months(fyr.end_date,-6)+1 , 1, add_months(fyr.end_date,-6)+1 ) SEMI_YEAR_START_DATE , DECODE( SIGN((fday.start_date-1) - (add_months(fyr.end_date ,-6)+1) ) , -1, add_months(fyr.start_date,6)-1 , 0, fyr.end_date , 1, fyr.end_date ) SEMI_YEAR_START_DATE ,fqtr.year_id YEAR_ID ,fyr.start_date YEAR_START_DATE ,fyr.end_date YEAR_END_DATE ,fday.report_date DAY_START_ID , DECODE(fday.start_date ,fmnth.start_date, fmnth.month_id ,to_number(null)) MONTH_START_ID , DECODE( fday.start_date , fqtr.start_date, fqtr.quarter_id , to_number(null)) QUARTER_START_ID , DECODE( fday.start_date , fyr.start_date, fqtr.year_id , to_number(null)) YEAR_START_ID ,fday.report_date DAY_END_ID , DECODE ( fday.end_date ,fmnth.end_date,fmnth.month_id ,to_number(null)) MONTH_END_ID , DECODE ( fday.end_date , fqtr.end_date, fqtr.quarter_id , to_number(null)) QUARTER_END_ID , DECODE ( fday.end_date , fyr.end_date, fqtr.year_id , to_number(null)) YEAR_END_ID FROM fii_time_day fday ,fii_time_month fmnth ,fii_time_qtr fqtr ,fii_time_year fyr WHERE fday.month_id = fmnth.month_id AND fmnth.quarter_id = fqtr.quarter_id AND fqtr.year_id = fyr.year_id WITH READ ONLY

View Text - HTML Formatted

SELECT FDAY.REPORT_DATE DAY_ID
, FDAY.START_DATE DAY_START_DATE
, FDAY.END_DATE DAY_END_DATE
, FMNTH.MONTH_ID MONTH_ID
, FMNTH.START_DATE MONTH_START_DATE
, FMNTH.END_DATE MONTH_END_DATE
, DECODE( MOD(TO_NUMBER(TO_CHAR(FMNTH.START_DATE
, 'MM'))
, 2)
, 0
, TO_NUMBER(TO_CHAR(FMNTH.START_DATE
, 'MM') / 2) || '
, ' || FYR.YEAR_ID
, (TO_NUMBER(TO_CHAR(FMNTH.START_DATE
, 'MM')) + 1) / 2 || '
, ' || FYR.YEAR_ID) BI_MONTH_ID
, DECODE ( MOD(TO_NUMBER(TO_CHAR(FMNTH.START_DATE
, 'MM'))
, 2)
, 0
, ADD_MONTHS(FMNTH.START_DATE
, -1)
, FMNTH.START_DATE) BI_MONTH_START_DATE
, DECODE( MOD(TO_NUMBER(TO_CHAR(FMNTH.START_DATE
, 'MM'))
, 2)
, 0
, FMNTH.END_DATE
, ADD_MONTHS(FMNTH.END_DATE
, 1)) BI_MONTH_END_DATE
, FQTR.QUARTER_ID QUARTER_ID
, FQTR.START_DATE QUARTER_START_DATE
, FQTR.END_DATE QUARTER_END_DATE
, DECODE( SIGN((FDAY.START_DATE-1) - (ADD_MONTHS(FYR.END_DATE
, -6)+1) )
, -1
, '1
, '||TO_CHAR(FYR.START_DATE
, 'YYYY')
, 0
, '2
, '||TO_CHAR(FYR.START_DATE
, 'YYYY')
, 1
, '2
, '||TO_CHAR(FYR.START_DATE
, 'YYYY') ) SEMI_YEAR_ID
, DECODE( SIGN((FDAY.START_DATE-1) - (ADD_MONTHS(FYR.END_DATE
, -6)+1) )
, -1
, FYR.START_DATE
, 0
, ADD_MONTHS(FYR.END_DATE
, -6)+1
, 1
, ADD_MONTHS(FYR.END_DATE
, -6)+1 ) SEMI_YEAR_START_DATE
, DECODE( SIGN((FDAY.START_DATE-1) - (ADD_MONTHS(FYR.END_DATE
, -6)+1) )
, -1
, ADD_MONTHS(FYR.START_DATE
, 6)-1
, 0
, FYR.END_DATE
, 1
, FYR.END_DATE ) SEMI_YEAR_START_DATE
, FQTR.YEAR_ID YEAR_ID
, FYR.START_DATE YEAR_START_DATE
, FYR.END_DATE YEAR_END_DATE
, FDAY.REPORT_DATE DAY_START_ID
, DECODE(FDAY.START_DATE
, FMNTH.START_DATE
, FMNTH.MONTH_ID
, TO_NUMBER(NULL)) MONTH_START_ID
, DECODE( FDAY.START_DATE
, FQTR.START_DATE
, FQTR.QUARTER_ID
, TO_NUMBER(NULL)) QUARTER_START_ID
, DECODE( FDAY.START_DATE
, FYR.START_DATE
, FQTR.YEAR_ID
, TO_NUMBER(NULL)) YEAR_START_ID
, FDAY.REPORT_DATE DAY_END_ID
, DECODE ( FDAY.END_DATE
, FMNTH.END_DATE
, FMNTH.MONTH_ID
, TO_NUMBER(NULL)) MONTH_END_ID
, DECODE ( FDAY.END_DATE
, FQTR.END_DATE
, FQTR.QUARTER_ID
, TO_NUMBER(NULL)) QUARTER_END_ID
, DECODE ( FDAY.END_DATE
, FYR.END_DATE
, FQTR.YEAR_ID
, TO_NUMBER(NULL)) YEAR_END_ID
FROM FII_TIME_DAY FDAY
, FII_TIME_MONTH FMNTH
, FII_TIME_QTR FQTR
, FII_TIME_YEAR FYR
WHERE FDAY.MONTH_ID = FMNTH.MONTH_ID
AND FMNTH.QUARTER_ID = FQTR.QUARTER_ID
AND FQTR.YEAR_ID = FYR.YEAR_ID WITH READ ONLY