[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: |
APPS.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 |