VIEW: APPS.PA_FP_BASELINED_COST_V

Source

View Text - Preformatted

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.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.version_type = 'COST' and bv.budget_status_code = 'B' and nvl(bv.purged_flag,'N') <> 'Y'

View Text - HTML Formatted

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.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.VERSION_TYPE = 'COST'
AND BV.BUDGET_STATUS_CODE = 'B'
AND NVL(BV.PURGED_FLAG
, 'N') <> 'Y'