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.PJI_TIME_MV

Source

View Text - Preformatted


SELECT period_name, quarter_name, year, period_type, calendar_id, period_id, quarter_id, year_id, ROWNUM SEQUENCE, period_start_date, period_end_date, TO_NUMBER(TO_CHAR(period_start_date,'J')) start_date_time, TO_NUMBER(TO_CHAR(period_end_date,'J')) end_date_time, quarter_start_date, quarter_end_date, year_start_date, year_end_date FROM ( SELECT * FROM ( SELECT yr.name period_name, yr.name quarter_name, yr.name year, 'FII_TIME_ENT_YEAR' period_type, -1 calendar_id, yr.ent_year_id period_id, yr.ent_year_id quarter_id, yr.ent_year_id year_id, yr.start_date period_start_date, yr.end_date period_end_date, yr.start_date quarter_start_date, yr.end_date quarter_end_date, yr.start_date year_start_date, yr.end_date year_end_date FROM PJI_TIME_ENT_YEAR yr UNION ALL SELECT qtr.name period_name, qtr.name quarter_name, yr.name year, 'FII_TIME_ENT_QTR' period_type, -1 calendar_id, qtr.ent_qtr_id period_id, qtr.ent_qtr_id quarter_id, yr.ENT_YEAR_ID year_id, qtr.start_date period_start_date, qtr.end_date period_end_date, qtr.start_date quarter_start_date, qtr.end_date quarter_end_date, yr.start_date year_start_date, yr.end_date year_end_date FROM PJI_TIME_ENT_QTR qtr, PJI_TIME_ENT_YEAR yr WHERE qtr.ent_year_id = yr.ent_year_id UNION ALL SELECT pd.name period_name, qtr.name quarter_name, yr.name year, 'FII_TIME_ENT_PERIOD' period_type, -1 calendar_id, pd.ent_period_id period_id, qtr.ent_qtr_id quarter_id, yr.ent_year_id year_id, pd.start_date period_start_date, pd.end_date period_end_date, qtr.start_date quarter_start_date, qtr.end_date quarter_end_date, yr.start_date year_start_date, yr.end_date year_end_date FROM PJI_TIME_ENT_PERIOD pd, PJI_TIME_ENT_QTR qtr, PJI_TIME_ENT_YEAR yr WHERE pd.ent_qtr_id = qtr.ent_qtr_id AND pd.ent_year_id = yr.ent_year_id UNION ALL SELECT wk.name period_name, NULL quarter_name, NULL year, 'FII_TIME_WEEK' period_type, -1 calendar_id, wk.week_id period_id, -1 quarter_id, -1 year_id, wk.start_date period_start_date, wk.end_date period_end_date, NULL quarter_start_date, NULL quarter_end_date, NULL year_start_date, NULL year_end_date FROM PJI_TIME_WEEK wk UNION ALL SELECT yr.name period_name, yr.name quarter_name, yr.name year, 'FII_TIME_CAL_YEAR' period_type, yr.calendar_id calendar_id, yr.cal_year_id period_id, yr.cal_year_id quarter_id, yr.cal_year_id year_id, yr.start_date period_start_date, yr.end_date period_end_date, yr.start_date quarter_start_date, yr.end_date quarter_end_date, yr.start_date year_start_date, yr.end_date year_end_date FROM PJI_TIME_CAL_YEAR yr WHERE yr.calendar_id in ( select distinct gl_calendar_id from PJI_ORG_EXTR_INFO) UNION ALL SELECT qtr.name period_name, qtr.name quarter_name, yr.name year, 'FII_TIME_CAL_QTR' period_type, qtr.calendar_id calendar_id, qtr.cal_qtr_id period_id, qtr.cal_qtr_id quarter_id, yr.cal_year_id year_id, qtr.start_date period_start_date, qtr.end_date period_end_date, qtr.start_date quarter_start_date, qtr.end_date quarter_end_date, yr.start_date year_start_date, yr.end_date year_end_date FROM PJI_TIME_CAL_QTR qtr, PJI_TIME_CAL_YEAR yr WHERE qtr.cal_year_id = yr.cal_year_id AND qtr.calendar_id in ( select distinct gl_calendar_id from PJI_ORG_EXTR_INFO) UNION ALL SELECT pd.name period_name, qtr.name quarter_name, yr.name year, 'FII_TIME_CAL_PERIOD' period_type, pd.calendar_id calendar_id, pd.cal_period_id period_id, qtr.cal_qtr_id quarter_id, qtr.cal_year_id year_id, pd.start_date period_start_date, pd.end_date period_end_date, qtr.start_date quarter_start_date, qtr.end_date quarter_end_date, yr.start_date year_start_date, yr.end_date year_end_date FROM PJI_TIME_CAL_PERIOD pd, PJI_TIME_CAL_QTR qtr, PJI_TIME_CAL_YEAR yr WHERE pd.cal_qtr_id = qtr.cal_qtr_id AND qtr.cal_year_id = yr.cal_year_id AND pd.calendar_id in ( select distinct gl_calendar_id from PJI_ORG_EXTR_INFO) UNION ALL SELECT pd.name period_name, qtr.name quarter_name, yr.name year, 'FII_TIME_PA_PERIOD' period_type, pd.calendar_id calendar_id, pd.cal_period_id period_id, qtr.cal_qtr_id quarter_id, qtr.cal_year_id year_id, pd.start_date period_start_date, pd.end_date period_end_date, qtr.start_date quarter_start_date, qtr.end_date quarter_end_date, yr.start_date year_start_date, yr.end_date year_end_date FROM PJI_TIME_CAL_PERIOD pd, PJI_TIME_CAL_QTR qtr, PJI_TIME_CAL_YEAR yr WHERE pd.cal_qtr_id = qtr.cal_qtr_id AND qtr.cal_year_id = yr.cal_year_id AND pd.calendar_id in ( select distinct pa_calendar_id from PJI_ORG_EXTR_INFO) ) ORDER BY period_type, period_id)

View Text - HTML Formatted

SELECT PERIOD_NAME
, QUARTER_NAME
, YEAR
, PERIOD_TYPE
, CALENDAR_ID
, PERIOD_ID
, QUARTER_ID
, YEAR_ID
, ROWNUM SEQUENCE
, PERIOD_START_DATE
, PERIOD_END_DATE
, TO_NUMBER(TO_CHAR(PERIOD_START_DATE
, 'J')) START_DATE_TIME
, TO_NUMBER(TO_CHAR(PERIOD_END_DATE
, 'J')) END_DATE_TIME
, QUARTER_START_DATE
, QUARTER_END_DATE
, YEAR_START_DATE
, YEAR_END_DATE
FROM ( SELECT *
FROM ( SELECT YR.NAME PERIOD_NAME
, YR.NAME QUARTER_NAME
, YR.NAME YEAR
, 'FII_TIME_ENT_YEAR' PERIOD_TYPE
, -1 CALENDAR_ID
, YR.ENT_YEAR_ID PERIOD_ID
, YR.ENT_YEAR_ID QUARTER_ID
, YR.ENT_YEAR_ID YEAR_ID
, YR.START_DATE PERIOD_START_DATE
, YR.END_DATE PERIOD_END_DATE
, YR.START_DATE QUARTER_START_DATE
, YR.END_DATE QUARTER_END_DATE
, YR.START_DATE YEAR_START_DATE
, YR.END_DATE YEAR_END_DATE
FROM PJI_TIME_ENT_YEAR YR UNION ALL SELECT QTR.NAME PERIOD_NAME
, QTR.NAME QUARTER_NAME
, YR.NAME YEAR
, 'FII_TIME_ENT_QTR' PERIOD_TYPE
, -1 CALENDAR_ID
, QTR.ENT_QTR_ID PERIOD_ID
, QTR.ENT_QTR_ID QUARTER_ID
, YR.ENT_YEAR_ID YEAR_ID
, QTR.START_DATE PERIOD_START_DATE
, QTR.END_DATE PERIOD_END_DATE
, QTR.START_DATE QUARTER_START_DATE
, QTR.END_DATE QUARTER_END_DATE
, YR.START_DATE YEAR_START_DATE
, YR.END_DATE YEAR_END_DATE
FROM PJI_TIME_ENT_QTR QTR
, PJI_TIME_ENT_YEAR YR
WHERE QTR.ENT_YEAR_ID = YR.ENT_YEAR_ID UNION ALL SELECT PD.NAME PERIOD_NAME
, QTR.NAME QUARTER_NAME
, YR.NAME YEAR
, 'FII_TIME_ENT_PERIOD' PERIOD_TYPE
, -1 CALENDAR_ID
, PD.ENT_PERIOD_ID PERIOD_ID
, QTR.ENT_QTR_ID QUARTER_ID
, YR.ENT_YEAR_ID YEAR_ID
, PD.START_DATE PERIOD_START_DATE
, PD.END_DATE PERIOD_END_DATE
, QTR.START_DATE QUARTER_START_DATE
, QTR.END_DATE QUARTER_END_DATE
, YR.START_DATE YEAR_START_DATE
, YR.END_DATE YEAR_END_DATE
FROM PJI_TIME_ENT_PERIOD PD
, PJI_TIME_ENT_QTR QTR
, PJI_TIME_ENT_YEAR YR
WHERE PD.ENT_QTR_ID = QTR.ENT_QTR_ID
AND PD.ENT_YEAR_ID = YR.ENT_YEAR_ID UNION ALL SELECT WK.NAME PERIOD_NAME
, NULL QUARTER_NAME
, NULL YEAR
, 'FII_TIME_WEEK' PERIOD_TYPE
, -1 CALENDAR_ID
, WK.WEEK_ID PERIOD_ID
, -1 QUARTER_ID
, -1 YEAR_ID
, WK.START_DATE PERIOD_START_DATE
, WK.END_DATE PERIOD_END_DATE
, NULL QUARTER_START_DATE
, NULL QUARTER_END_DATE
, NULL YEAR_START_DATE
, NULL YEAR_END_DATE
FROM PJI_TIME_WEEK WK UNION ALL SELECT YR.NAME PERIOD_NAME
, YR.NAME QUARTER_NAME
, YR.NAME YEAR
, 'FII_TIME_CAL_YEAR' PERIOD_TYPE
, YR.CALENDAR_ID CALENDAR_ID
, YR.CAL_YEAR_ID PERIOD_ID
, YR.CAL_YEAR_ID QUARTER_ID
, YR.CAL_YEAR_ID YEAR_ID
, YR.START_DATE PERIOD_START_DATE
, YR.END_DATE PERIOD_END_DATE
, YR.START_DATE QUARTER_START_DATE
, YR.END_DATE QUARTER_END_DATE
, YR.START_DATE YEAR_START_DATE
, YR.END_DATE YEAR_END_DATE
FROM PJI_TIME_CAL_YEAR YR
WHERE YR.CALENDAR_ID IN ( SELECT DISTINCT GL_CALENDAR_ID
FROM PJI_ORG_EXTR_INFO) UNION ALL SELECT QTR.NAME PERIOD_NAME
, QTR.NAME QUARTER_NAME
, YR.NAME YEAR
, 'FII_TIME_CAL_QTR' PERIOD_TYPE
, QTR.CALENDAR_ID CALENDAR_ID
, QTR.CAL_QTR_ID PERIOD_ID
, QTR.CAL_QTR_ID QUARTER_ID
, YR.CAL_YEAR_ID YEAR_ID
, QTR.START_DATE PERIOD_START_DATE
, QTR.END_DATE PERIOD_END_DATE
, QTR.START_DATE QUARTER_START_DATE
, QTR.END_DATE QUARTER_END_DATE
, YR.START_DATE YEAR_START_DATE
, YR.END_DATE YEAR_END_DATE
FROM PJI_TIME_CAL_QTR QTR
, PJI_TIME_CAL_YEAR YR
WHERE QTR.CAL_YEAR_ID = YR.CAL_YEAR_ID
AND QTR.CALENDAR_ID IN ( SELECT DISTINCT GL_CALENDAR_ID
FROM PJI_ORG_EXTR_INFO) UNION ALL SELECT PD.NAME PERIOD_NAME
, QTR.NAME QUARTER_NAME
, YR.NAME YEAR
, 'FII_TIME_CAL_PERIOD' PERIOD_TYPE
, PD.CALENDAR_ID CALENDAR_ID
, PD.CAL_PERIOD_ID PERIOD_ID
, QTR.CAL_QTR_ID QUARTER_ID
, QTR.CAL_YEAR_ID YEAR_ID
, PD.START_DATE PERIOD_START_DATE
, PD.END_DATE PERIOD_END_DATE
, QTR.START_DATE QUARTER_START_DATE
, QTR.END_DATE QUARTER_END_DATE
, YR.START_DATE YEAR_START_DATE
, YR.END_DATE YEAR_END_DATE
FROM PJI_TIME_CAL_PERIOD PD
, PJI_TIME_CAL_QTR QTR
, PJI_TIME_CAL_YEAR YR
WHERE PD.CAL_QTR_ID = QTR.CAL_QTR_ID
AND QTR.CAL_YEAR_ID = YR.CAL_YEAR_ID
AND PD.CALENDAR_ID IN ( SELECT DISTINCT GL_CALENDAR_ID
FROM PJI_ORG_EXTR_INFO) UNION ALL SELECT PD.NAME PERIOD_NAME
, QTR.NAME QUARTER_NAME
, YR.NAME YEAR
, 'FII_TIME_PA_PERIOD' PERIOD_TYPE
, PD.CALENDAR_ID CALENDAR_ID
, PD.CAL_PERIOD_ID PERIOD_ID
, QTR.CAL_QTR_ID QUARTER_ID
, QTR.CAL_YEAR_ID YEAR_ID
, PD.START_DATE PERIOD_START_DATE
, PD.END_DATE PERIOD_END_DATE
, QTR.START_DATE QUARTER_START_DATE
, QTR.END_DATE QUARTER_END_DATE
, YR.START_DATE YEAR_START_DATE
, YR.END_DATE YEAR_END_DATE
FROM PJI_TIME_CAL_PERIOD PD
, PJI_TIME_CAL_QTR QTR
, PJI_TIME_CAL_YEAR YR
WHERE PD.CAL_QTR_ID = QTR.CAL_QTR_ID
AND QTR.CAL_YEAR_ID = YR.CAL_YEAR_ID
AND PD.CALENDAR_ID IN ( SELECT DISTINCT PA_CALENDAR_ID
FROM PJI_ORG_EXTR_INFO) ) ORDER BY PERIOD_TYPE
, PERIOD_ID)