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.

VIEW: APPS.QPR_SR_FISCAL_TIME_V

Source

View Text - Preformatted


SELECT gp1.period_set_name, gp3.period_name, gp3.period_name , gp3.start_date , gp3.end_date , gp2.period_name , gp2.period_name , gp2.start_date , gp2.end_date , gp1.period_name , gp1.period_name , gp1.start_date , gp1.end_date FROM gl_periods gp3, gl_periods gp2, gl_periods gp1 WHERE gp1.period_type = 'Month' AND gp2.period_set_name = gp1.period_set_name AND gp2.period_type = 'Quarter' AND gp1.start_date BETWEEN gp2.start_date AND gp2.end_date AND gp3.period_set_name = gp1.period_set_name AND gp3.period_type = 'Year' AND gp1.start_date BETWEEN gp3.start_date AND gp3.end_date AND gp1.start_date != gp1.end_date

View Text - HTML Formatted

SELECT GP1.PERIOD_SET_NAME
, GP3.PERIOD_NAME
, GP3.PERIOD_NAME
, GP3.START_DATE
, GP3.END_DATE
, GP2.PERIOD_NAME
, GP2.PERIOD_NAME
, GP2.START_DATE
, GP2.END_DATE
, GP1.PERIOD_NAME
, GP1.PERIOD_NAME
, GP1.START_DATE
, GP1.END_DATE
FROM GL_PERIODS GP3
, GL_PERIODS GP2
, GL_PERIODS GP1
WHERE GP1.PERIOD_TYPE = 'MONTH'
AND GP2.PERIOD_SET_NAME = GP1.PERIOD_SET_NAME
AND GP2.PERIOD_TYPE = 'QUARTER'
AND GP1.START_DATE BETWEEN GP2.START_DATE
AND GP2.END_DATE
AND GP3.PERIOD_SET_NAME = GP1.PERIOD_SET_NAME
AND GP3.PERIOD_TYPE = 'YEAR'
AND GP1.START_DATE BETWEEN GP3.START_DATE
AND GP3.END_DATE
AND GP1.START_DATE != GP1.END_DATE