eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.PJI_ACCUM_WBS_ACT_V

Source

View Text - Preformatted


SELECT act.project_id, act.task_id task_id, act.raw_cost_itd raw_cost, act.burdened_cost_itd burdened_cost, act.revenue_itd revenue FROM pa_accum_wbs_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.pou_raw_cost raw_cost, tmp.pou_brdn_cost burdened_cost, tmp.pou_revenue revenue 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.RAW_COST_ITD RAW_COST
, ACT.BURDENED_COST_ITD BURDENED_COST
, ACT.REVENUE_ITD REVENUE
FROM PA_ACCUM_WBS_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.POU_RAW_COST RAW_COST
, TMP.POU_BRDN_COST BURDENED_COST
, TMP.POU_REVENUE REVENUE
FROM PJI_FM_XBS_ACCUM_TMP1 TMP
, PA_PROJECTS_ALL PRJ
WHERE TMP.PROJECT_ID=PRJ.PROJECT_ID
AND PJI_SOURCE_FLAG = 'Y'