View: PA_FP_BASELINED_COSTREV_V

Product:	PA - Projects
Description:	Used in Maintain Versions OA page. This view retrieves baselined budget versions, regardless of version type
Implementation/DBA Data:	APPS.PA_FP_BASELINED_COSTREV_V

View Text

SELECT BV.ROWID ROW_ID
, BV.PROJECT_ID
, BV.BUDGET_VERSION_ID
, BV.VERSION_NUMBER
, BV.VERSION_NAME
, BV.VERSION_TYPE
, BV.FIN_PLAN_TYPE_ID
, NVL(BV.LABOR_QUANTITY
, 0) AS QUANTITY
, DECODE(BV.VERSION_TYPE
, 'ORG_FORECAST'
, NVL(BV.REVENUE
, 0)
, NVL(BV.TOTAL_PROJECT_REVENUE
, 0)) + NVL(BV.TOTAL_TP_REVENUE_IN
, 0) + NVL(BV.TOTAL_BORROWED_REVENUE
, 0) + NVL(BV.TOTAL_REVENUE_ADJ
, 0) - NVL(BV.TOTAL_TP_REVENUE_OUT
, 0) AS REVENUE
, DECODE(BV.VERSION_TYPE
, 'ORG_FORECAST'
, NVL(BV.RAW_COST
, 0)
, NVL(BV.TOTAL_PROJECT_RAW_COST
, 0)) + NVL(BV.TOTAL_LENT_RESOURCE_COST
, 0) + NVL(BV.TOTAL_UNASSIGNED_TIME_COST
, 0) + NVL(BV.TOTAL_TP_COST_IN
, 0) + NVL(BV.TOTAL_COST_ADJ
, 0) - NVL(BV.TOTAL_TP_COST_OUT
, 0) AS RAW_COST
, DECODE(BV.VERSION_TYPE
, 'ORG_FORECAST'
, NVL(BV.BURDENED_COST
, 0)
, NVL(BV.TOTAL_PROJECT_BURDENED_COST
, 0)) + NVL(BV.TOTAL_LENT_RESOURCE_COST
, 0) + NVL(BV.TOTAL_UNASSIGNED_TIME_COST
, 0) + NVL(BV.TOTAL_TP_COST_IN
, 0) + NVL(BV.TOTAL_COST_ADJ
, 0) - NVL(BV.TOTAL_TP_COST_OUT
, 0) AS BURDENED_COST
, NVL(BV.TOTAL_UTILIZATION_PERCENT
, 0) + NVL(BV.TOTAL_UTILIZATION_ADJ
, 0) AS TOTAL_UTILIZATION_PERCENT
, NVL(BV.TOTAL_UTILIZATION_HOURS
, 0) AS TOTAL_UTILIZATION_HOURS
, NVL(BV.TOTAL_HEAD_COUNT
, 0) + NVL(BV.TOTAL_HEAD_COUNT_ADJ
, 0) AS TOTAL_HEAD_COUNT
, BV.BASELINED_DATE
, BV.CURRENT_FLAG
, BV.CURRENT_ORIGINAL_FLAG
, BV.RECORD_VERSION_NUMBER
, BV.PLAN_PROCESSING_CODE
, BV.REQUEST_ID
, BV.WF_STATUS_CODE
, NVL(BV.EQUIPMENT_QUANTITY
, 0) AS EQUIPMENT_QUANTITY
, NVL(BV.LABOR_QUANTITY
, 0) AS PEOPLE_QUANTITY
, BV.PROJECT_STRUCTURE_VERSION_ID
, DECODE( PA_FIN_PLAN_UTILS.GET_PERSON_NAME(BV.BASELINED_BY_PERSON_ID)
, NULL
, PA_FIN_PLAN_UTILS.GET_PERSON_NAME(PA_UTILS.GETEMPIDFROMUSER(BV.BASELINED_BY_PERSON_ID))
, PA_FIN_PLAN_UTILS.GET_PERSON_NAME(BV.BASELINED_BY_PERSON_ID)) AS BASELINED_BY_PERSON_NAME
FROM PA_BUDGET_VERSIONS BV
WHERE BV.PROJECT_ID = PA_FIN_PLAN_MAINT_VER_GLOBAL.GET_PROJECT_ID
AND BV.FIN_PLAN_TYPE_ID = PA_FIN_PLAN_MAINT_VER_GLOBAL.GET_FIN_PLAN_TYPE_ID
AND BV.CI_ID IS NULL
AND BV.BUDGET_STATUS_CODE = 'B'
AND NVL(BV.PURGED_FLAG
, 'N') <> 'Y'

Columns