VIEW: APPS.PA_CALENDAR_OLAP_V

Source

View Text - Preformatted

SELECT a.cal_period_id , a.cal_qtr_id , b.cal_year_id , -1 itd_id from pji_time_cal_period a , pji_time_cal_qtr b WHERE b.cal_qtr_id = a.cal_qtr_id union select a.ent_period_id , a.ent_qtr_id , a.ent_year_id , -1 itd_id from pji_time_ent_period a

View Text - HTML Formatted

SELECT A.CAL_PERIOD_ID
, A.CAL_QTR_ID
, B.CAL_YEAR_ID
, -1 ITD_ID
FROM PJI_TIME_CAL_PERIOD A
, PJI_TIME_CAL_QTR B
WHERE B.CAL_QTR_ID = A.CAL_QTR_ID UNION SELECT A.ENT_PERIOD_ID
, A.ENT_QTR_ID
, A.ENT_YEAR_ID
, -1 ITD_ID
FROM PJI_TIME_ENT_PERIOD A