View: PA_FIN_PLAN_CREATE_PLAN_BV_V

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

View Text

SELECT PO.PROJECT_ID
, BV.VERSION_NAME
, BV.DESCRIPTION
, BV.CHANGE_REASON_CODE
, PT.FIN_PLAN_TYPE_CODE
, PT.NAME AS PLAN_TYPE_NAME
, PO.FIN_PLAN_PREFERENCE_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_SEP'
, DECODE(BV.VERSION_TYPE
, 'COST'
, PO.COST_FIN_PLAN_LEVEL_CODE
, 'REVENUE'
, PO.REVENUE_FIN_PLAN_LEVEL_CODE
, PO.ALL_FIN_PLAN_LEVEL_CODE)
, 'COST_AND_REV_SAME'
, PO.ALL_FIN_PLAN_LEVEL_CODE
, PO.COST_FIN_PLAN_LEVEL_CODE) AS PLAN_LEVEL_CODE
, DECODE(PO.FIN_PLAN_PREFERENCE_CODE
, 'COST_ONLY'
, PO.COST_TIME_PHASED_CODE
, 'REVENUE_ONLY'
, PO.REVENUE_TIME_PHASED_CODE
, 'COST_AND_REV_SEP'
, DECODE(BV.VERSION_TYPE
, 'COST'
, PO.COST_TIME_PHASED_CODE
, 'REVENUE'
, PO.REVENUE_TIME_PHASED_CODE
, PO.ALL_TIME_PHASED_CODE)
, 'COST_AND_REV_SAME'
, PO.ALL_TIME_PHASED_CODE
, PO.COST_TIME_PHASED_CODE) AS TIME_PHASED_CODE
, DECODE(PO.FIN_PLAN_PREFERENCE_CODE
, 'COST_ONLY'
, PO.COST_RESOURCE_LIST_ID
, 'REVENUE_ONLY'
, PO.REVENUE_RESOURCE_LIST_ID
, 'COST_AND_REV_SEP'
, DECODE(BV.VERSION_TYPE
, 'COST'
, PO.COST_RESOURCE_LIST_ID
, 'REVENUE'
, PO.REVENUE_RESOURCE_LIST_ID
, PO.ALL_RESOURCE_LIST_ID)
, 'COST_AND_REV_SAME'
, PO.ALL_RESOURCE_LIST_ID
, PO.COST_RESOURCE_LIST_ID) AS RESOURCE_LIST_ID
, BV.BUDGET_VERSION_ID
, BV.RECORD_VERSION_NUMBER
, BV.BUDGET_STATUS_CODE
, PA_FIN_PLAN_UTILS.GET_PERIOD_PROFILE_START_DATE(BV.PERIOD_PROFILE_ID) AS START_PERIOD_NAME
, PA_FIN_PLAN_UTILS.GET_PERIOD_PROFILE_END_DATE(BV.PERIOD_PROFILE_ID) AS END_PERIOD_NAME
, BV.ATTRIBUTE_CATEGORY
, BV.ATTRIBUTE1
, BV.ATTRIBUTE2
, BV.ATTRIBUTE3
, BV.ATTRIBUTE4
, BV.ATTRIBUTE5
, BV.ATTRIBUTE6
, BV.ATTRIBUTE7
, BV.ATTRIBUTE8
, BV.ATTRIBUTE9
, BV.ATTRIBUTE10
, BV.ATTRIBUTE11
, BV.ATTRIBUTE12
, BV.ATTRIBUTE13
, BV.ATTRIBUTE14
, BV.ATTRIBUTE15
FROM PA_PROJ_FP_OPTIONS PO
, PA_FIN_PLAN_TYPES_VL PT
, PA_BUDGET_VERSIONS BV
WHERE BV.PROJECT_ID = PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_PROJECT_ID
AND BV.BUDGET_VERSION_ID = PA_FIN_PLAN_CREATE_VER_GLOBAL.GET_BUDGET_VERSION_ID
AND BV.BUDGET_VERSION_ID = PO.FIN_PLAN_VERSION_ID
AND BV.CI_ID IS NULL
AND PO.FIN_PLAN_OPTION_LEVEL_CODE = 'PLAN_VERSION'
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