View: PA_FIN_PLAN_CREATE_PLAN_NOBV_V

Product:	PA - Projects
Description:	Used in Create/View/Edit Versions OA page This view retrieves information about a budget version when a budget version id is not supplied. It relies on the following packages: pa_fin_plan_create_ver_global.
Implementation/DBA Data:	APPS.PA_FIN_PLAN_CREATE_PLAN_NOBV_V

View Text

SELECT PO.PROJECT_ID
, PT.FIN_PLAN_TYPE_CODE
, PT.NAME AS PLAN_TYPE_NAME
, PO.FIN_PLAN_PREFERENCE_CODE
, DECODE(PO.FIN_PLAN_PREFERENCE_CODE
, 'COST_AND_REV_SEP'
, PO.COST_FIN_PLAN_LEVEL_CODE
, NULL) AS COST_PLAN_LEVEL_CODE
, DECODE(PO.FIN_PLAN_PREFERENCE_CODE
, 'COST_AND_REV_SEP'
, PO.REVENUE_FIN_PLAN_LEVEL_CODE
, NULL) AS REVENUE_PLAN_LEVEL_CODE
, DECODE(PO.FIN_PLAN_PREFERENCE_CODE
, 'COST_ONLY'
, PO.COST_FIN_PLAN_LEVEL_CODE
, 'REVENUE_ONLY'
, PO.REVENUE_FIN_PLAN_LEVEL_CODE
, 'COST_AND_REV_SAME'
, PO.ALL_FIN_PLAN_LEVEL_CODE
, NULL) AS PLAN_LEVEL_CODE
, DECODE(PO.FIN_PLAN_PREFERENCE_CODE
, 'COST_AND_REV_SEP'
, PO.COST_TIME_PHASED_CODE
, NULL) AS COST_TIME_PHASED_CODE
, DECODE(PO.FIN_PLAN_PREFERENCE_CODE
, 'COST_AND_REV_SEP'
, PO.REVENUE_TIME_PHASED_CODE
, NULL) AS REVENUE_TIME_PHASED_CODE
, DECODE(PO.FIN_PLAN_PREFERENCE_CODE
, 'COST_ONLY'
, PO.COST_TIME_PHASED_CODE
, 'REVENUE_ONLY'
, PO.REVENUE_TIME_PHASED_CODE
, 'COST_AND_REV_SAME'
, PO.ALL_TIME_PHASED_CODE
, NULL) AS TIME_PHASED_CODE
, DECODE(PO.FIN_PLAN_PREFERENCE_CODE
, 'COST_AND_REV_SEP'
, PO.COST_RESOURCE_LIST_ID
, NULL) AS COST_RESOURCE_LIST_ID
, DECODE(PO.FIN_PLAN_PREFERENCE_CODE
, 'COST_AND_REV_SEP'
, PO.REVENUE_RESOURCE_LIST_ID
, NULL) AS REVENUE_RESOURCE_LIST_ID
, DECODE(PO.FIN_PLAN_PREFERENCE_CODE
, 'COST_ONLY'
, PO.COST_RESOURCE_LIST_ID
, 'REVENUE_ONLY'
, PO.REVENUE_RESOURCE_LIST_ID
, 'COST_AND_REV_SAME'
, PO.ALL_RESOURCE_LIST_ID
, NULL) AS RESOURCE_LIST_ID
, DECODE(PO.FIN_PLAN_PREFERENCE_CODE
, 'COST_AND_REV_SEP'
, DECODE(PO.COST_TIME_PHASED_CODE
, 'P'
, PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_PA_CURRENT_START_PERIOD (PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_PROJECT_ID)
, 'G'
, PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_GL_CURRENT_START_PERIOD (PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_PROJECT_ID)
, NULL)
, NULL) AS COST_START_PERIOD_NAME
, DECODE(PO.FIN_PLAN_PREFERENCE_CODE
, 'COST_AND_REV_SEP'
, DECODE(PO.REVENUE_TIME_PHASED_CODE
, 'P'
, PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_PA_CURRENT_START_PERIOD (PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_PROJECT_ID)
, 'G'
, PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_GL_CURRENT_START_PERIOD (PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_PROJECT_ID)
, NULL)
, NULL) AS REVENUE_START_PERIOD_NAME
, DECODE(PO.FIN_PLAN_PREFERENCE_CODE
, 'COST_ONLY'
, DECODE(PO.COST_TIME_PHASED_CODE
, 'P'
, PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_PA_CURRENT_START_PERIOD (PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_PROJECT_ID)
, 'G'
, PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_GL_CURRENT_START_PERIOD (PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_PROJECT_ID)
, NULL)
, 'REVENUE_ONLY'
, DECODE(PO.REVENUE_TIME_PHASED_CODE
, 'P'
, PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_PA_CURRENT_START_PERIOD (PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_PROJECT_ID)
, 'G'
, PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_GL_CURRENT_START_PERIOD (PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_PROJECT_ID)
, NULL)
, 'COST_AND_REV_SAME'
, DECODE(PO.ALL_TIME_PHASED_CODE
, 'P'
, PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_PA_CURRENT_START_PERIOD (PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_PROJECT_ID)
, 'G'
, PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_GL_CURRENT_START_PERIOD (PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_PROJECT_ID)
, NULL)
, NULL) AS START_PERIOD_NAME
, DECODE(PO.FIN_PLAN_PREFERENCE_CODE
, 'COST_AND_REV_SEP'
, DECODE(PO.COST_TIME_PHASED_CODE
, 'P'
, PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_PA_CURRENT_END_PERIOD (PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_PROJECT_ID)
, 'G'
, PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_GL_CURRENT_END_PERIOD (PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_PROJECT_ID)
, NULL)
, NULL) AS COST_END_PERIOD_NAME
, DECODE(PO.FIN_PLAN_PREFERENCE_CODE
, 'COST_AND_REV_SEP'
, DECODE(PO.REVENUE_TIME_PHASED_CODE
, 'P'
, PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_PA_CURRENT_END_PERIOD (PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_PROJECT_ID)
, 'G'
, PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_GL_CURRENT_END_PERIOD (PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_PROJECT_ID)
, NULL)
, NULL) AS REVENUE_END_PERIOD_NAME
, DECODE(PO.FIN_PLAN_PREFERENCE_CODE
, 'COST_ONLY'
, DECODE(PO.COST_TIME_PHASED_CODE
, 'P'
, PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_PA_CURRENT_END_PERIOD (PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_PROJECT_ID)
, 'G'
, PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_GL_CURRENT_END_PERIOD (PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_PROJECT_ID)
, NULL)
, 'REVENUE_ONLY'
, DECODE(PO.REVENUE_TIME_PHASED_CODE
, 'P'
, PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_PA_CURRENT_END_PERIOD (PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_PROJECT_ID)
, 'G'
, PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_GL_CURRENT_END_PERIOD (PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_PROJECT_ID)
, NULL)
, 'COST_AND_REV_SAME'
, DECODE(PO.ALL_TIME_PHASED_CODE
, 'P'
, PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_PA_CURRENT_END_PERIOD (PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_PROJECT_ID)
, 'G'
, PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_GL_CURRENT_END_PERIOD (PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_PROJECT_ID)
, NULL)
, NULL) AS END_PERIOD_NAME
, NULL AS ATTRIBUTE_CATEGORY
, NULL AS ATTRIBUTE1
, NULL AS ATTRIBUTE2
, NULL AS ATTRIBUTE3
, NULL AS ATTRIBUTE4
, NULL AS ATTRIBUTE5
, NULL AS ATTRIBUTE6
, NULL AS ATTRIBUTE7
, NULL AS ATTRIBUTE8
, NULL AS ATTRIBUTE9
, NULL AS ATTRIBUTE10
, NULL AS ATTRIBUTE11
, NULL AS ATTRIBUTE12
, NULL AS ATTRIBUTE13
, NULL AS ATTRIBUTE14
, NULL AS ATTRIBUTE15
FROM PA_PROJ_FP_OPTIONS PO
, PA_FIN_PLAN_TYPES_VL PT
WHERE PO.PROJECT_ID = PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_PROJECT_ID
AND PO.FIN_PLAN_OPTION_LEVEL_CODE = 'PLAN_TYPE'
AND PO.FIN_PLAN_TYPE_ID = PT.FIN_PLAN_TYPE_ID
AND PT.FIN_PLAN_TYPE_ID = PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_FIN_PLAN_TYPE_ID

Columns