FND Design Data [Home] [Help]

View: PA_FP_PERIOD_INFO_V

Product: PA - Projects
Description: The pa_fp_period_info_v view store the period information plan versions.
Implementation/DBA Data: ViewAPPS.PA_FP_PERIOD_INFO_V
View Text

SELECT PPPP.PLAN_PERIOD_TYPE
, PPPP.PERIOD_PROFILE_ID
, PPPP.GL_PERIOD_TYPE
, PPPP.NUMBER_OF_PERIODS
, PPPP.PERIOD_SET_NAME
FROM PA_PROJ_PERIOD_PROFILES PPPP
, PA_BUDGET_VERSIONS PBV
WHERE PBV.BUDGET_VERSION_ID = PA_FIN_PLAN_VIEW_GLOBAL.GET_VERSION_ID()
AND PPPP.PERIOD_PROFILE_ID = PBV.PERIOD_PROFILE_ID

Columns

Name
PLAN_PERIOD_TYPE
PERIOD_PROFILE_ID
GL_PERIOD_TYPE
NUMBER_OF_PERIODS
PERIOD_SET_NAME