VIEW: APPS.PA_FP_WORKING_COST_V

Source

View Text - Preformatted

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.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 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.version_type = 'COST' and bv.budget_status_code in ('W','S') and bv.budget_status_code = pl.lookup_code and pl.lookup_type = 'BUDGET STATUS'

View Text - HTML Formatted

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.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 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.VERSION_TYPE = 'COST'
AND BV.BUDGET_STATUS_CODE IN ('W'
, 'S')
AND BV.BUDGET_STATUS_CODE = PL.LOOKUP_CODE
AND PL.LOOKUP_TYPE = 'BUDGET STATUS'