FND Design Data [Home] [Help]

View: PA_REP_QUARTER_PA_V

Product: PA - Projects
Description: PA_REP_QUARTER_PA_V is a view to get PA quarter numbers
Implementation/DBA Data: ViewAPPS.PA_REP_QUARTER_PA_V
View Text

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

Columns

Name
QUARTER_NUM
ORG_ID