VIEW: APPS.PA_REP_PERIOD_YEARS_V

Source

View Text - Preformatted

SELECT 'GL', period_year FROM pa_rep_year_gl_v UNION SELECT 'PA', period_year FROM pa_rep_year_pa_v UNION SELECT 'QR', period_year FROM pa_rep_year_gl_v UNION SELECT 'YR', period_year FROM pa_rep_year_gl_v UNION SELECT 'GE', period_year FROM pa_rep_year_cal_v

View Text - HTML Formatted

SELECT 'GL'
, PERIOD_YEAR
FROM PA_REP_YEAR_GL_V UNION SELECT 'PA'
, PERIOD_YEAR
FROM PA_REP_YEAR_PA_V UNION SELECT 'QR'
, PERIOD_YEAR
FROM PA_REP_YEAR_GL_V UNION SELECT 'YR'
, PERIOD_YEAR
FROM PA_REP_YEAR_GL_V UNION SELECT 'GE'
, PERIOD_YEAR
FROM PA_REP_YEAR_CAL_V