DBA Data[Home] [Help]

VIEW: APPS.PA_REP_QUARTER_PA_V

Source

View Text - Preformatted

SELECT distinct glper.quarter_num AS QUARTER_NUM, imp.org_id AS org_id from pa_implementations imp, gl_periods glper where imp.period_set_name = glper.period_set_name AND imp.pa_period_type = glper.period_type order by quarter_num
View Text - HTML Formatted

SELECT DISTINCT GLPER.QUARTER_NUM AS QUARTER_NUM
, IMP.ORG_ID AS ORG_ID
FROM PA_IMPLEMENTATIONS IMP
, GL_PERIODS GLPER
WHERE IMP.PERIOD_SET_NAME = GLPER.PERIOD_SET_NAME
AND IMP.PA_PERIOD_TYPE = GLPER.PERIOD_TYPE ORDER BY QUARTER_NUM