VIEW: APPS.PJI_ACCUM_RL_ACT_V

Source

View Text - Preformatted

SELECT act.project_id,act.task_id task_id , act.resource_list_member_id res_list_mem_id, act.raw_cost_itd raw_cost, act.burdened_cost_itd burdened_cost , act.revenue_itd revenue, act.actuals_labor_hours_itd labor_hrs FROM pa_accum_rsrc_act_v act, pa_projects_all prj WHERE act.project_id = prj.project_id AND pji_source_flag IS NULL UNION ALL SELECT tmp.project_id, tmp.project_element_id task_id, tmp.res_list_member_id res_list_mem_id, tmp.pou_raw_cost raw_cost, tmp.pou_brdn_cost burdened_cost , tmp.pou_revenue revenue, tmp.labor_hours labor_hrs FROM pji_fm_xbs_accum_tmp1 tmp , pa_projects_all prj WHERE tmp.project_id=prj.project_id AND pji_source_flag = 'Y'

View Text - HTML Formatted

SELECT ACT.PROJECT_ID
, ACT.TASK_ID TASK_ID
, ACT.RESOURCE_LIST_MEMBER_ID RES_LIST_MEM_ID
, ACT.RAW_COST_ITD RAW_COST
, ACT.BURDENED_COST_ITD BURDENED_COST
, ACT.REVENUE_ITD REVENUE
, ACT.ACTUALS_LABOR_HOURS_ITD LABOR_HRS
FROM PA_ACCUM_RSRC_ACT_V ACT
, PA_PROJECTS_ALL PRJ
WHERE ACT.PROJECT_ID = PRJ.PROJECT_ID
AND PJI_SOURCE_FLAG IS NULL UNION ALL SELECT TMP.PROJECT_ID
, TMP.PROJECT_ELEMENT_ID TASK_ID
, TMP.RES_LIST_MEMBER_ID RES_LIST_MEM_ID
, TMP.POU_RAW_COST RAW_COST
, TMP.POU_BRDN_COST BURDENED_COST
, TMP.POU_REVENUE REVENUE
, TMP.LABOR_HOURS LABOR_HRS
FROM PJI_FM_XBS_ACCUM_TMP1 TMP
, PA_PROJECTS_ALL PRJ
WHERE TMP.PROJECT_ID=PRJ.PROJECT_ID
AND PJI_SOURCE_FLAG = 'Y'