View: PA_FP_WORKING_COSTREV_V

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

View Text

SELECT BV.ROWID ROW_ID
, BV.PROJECT_ID
, BV.BUDGET_VERSION_ID
, BV.LOCKED_BY_PERSON_ID
, PA_FIN_PLAN_UTILS.GET_PERSON_NAME(LOCKED_BY_PERSON_ID) AS LOCKED_BY_PERSON_NAME
, 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.BUDGET_STATUS_CODE
, PL.MEANING AS STATUS_MEANING
, BV.CURRENT_WORKING_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
FROM PA_PROJECTS_ALL P
, PA_BUDGET_VERSIONS BV
, PA_LOOKUPS PL
WHERE P.PROJECT_ID = PA_FIN_PLAN_MAINT_VER_GLOBAL.GET_PROJECT_ID
AND NOT (P.BASELINE_FUNDING_FLAG = 'Y'
AND BV.APPROVED_REV_PLAN_TYPE_FLAG = 'Y')
AND BV.PROJECT_ID = P.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 IN ('W'
, 'S')
AND BV.BUDGET_STATUS_CODE = PL.LOOKUP_CODE
AND PL.LOOKUP_TYPE = 'BUDGET STATUS'

Columns