VIEW: APPS.PABV_TASK_CMT_SUMMARY

Source

View Text - Preformatted

SELECT pah.PROJECT_ACCUM_ID , paps.accum_period , pac.CMT_RAW_COST_ITD , pac.CMT_RAW_COST_YTD , pac.CMT_RAW_COST_PP , pac.CMT_RAW_COST_PTD , pac.CMT_BURDENED_COST_ITD , pac.CMT_BURDENED_COST_YTD , pac.CMT_BURDENED_COST_PP , pac.CMT_BURDENED_COST_PTD , pac.CMT_QUANTITY_ITD , pac.CMT_QUANTITY_YTD , pac.CMT_QUANTITY_PP , pac.CMT_QUANTITY_PTD , '_LA:pac.CMT_UNIT_OF_MEASURE:PA_LOOKUPS:UNIT:meaning' , pah.project_id , pah.task_id , pac.LAST_UPDATE_DATE , pac.LAST_UPDATED_BY , pac.CREATION_DATE , pac.CREATED_BY FROM pa_project_accum_headers pah , pa_project_accum_commitments pac , pa_prj_accum_periods_v paps , pa_projects_all ppa WHERE pac.project_accum_id = pah.project_accum_id AND pah.resource_id = 0 AND pah.resource_list_id = 0 AND pah.resource_list_member_id = 0 AND pah.resource_list_assignment_id = 0 and pah.task_id <> 0 AND pah.project_id = paps.project_id AND pah.project_id = ppa.project_id AND '_SEC:ppa.org_id' is not null WITH READ ONLY

View Text - HTML Formatted

SELECT PAH.PROJECT_ACCUM_ID
, PAPS.ACCUM_PERIOD
, PAC.CMT_RAW_COST_ITD
, PAC.CMT_RAW_COST_YTD
, PAC.CMT_RAW_COST_PP
, PAC.CMT_RAW_COST_PTD
, PAC.CMT_BURDENED_COST_ITD
, PAC.CMT_BURDENED_COST_YTD
, PAC.CMT_BURDENED_COST_PP
, PAC.CMT_BURDENED_COST_PTD
, PAC.CMT_QUANTITY_ITD
, PAC.CMT_QUANTITY_YTD
, PAC.CMT_QUANTITY_PP
, PAC.CMT_QUANTITY_PTD
, '_LA:PAC.CMT_UNIT_OF_MEASURE:PA_LOOKUPS:UNIT:MEANING'
, PAH.PROJECT_ID
, PAH.TASK_ID
, PAC.LAST_UPDATE_DATE
, PAC.LAST_UPDATED_BY
, PAC.CREATION_DATE
, PAC.CREATED_BY
FROM PA_PROJECT_ACCUM_HEADERS PAH
, PA_PROJECT_ACCUM_COMMITMENTS PAC
, PA_PRJ_ACCUM_PERIODS_V PAPS
, PA_PROJECTS_ALL PPA
WHERE PAC.PROJECT_ACCUM_ID = PAH.PROJECT_ACCUM_ID
AND PAH.RESOURCE_ID = 0
AND PAH.RESOURCE_LIST_ID = 0
AND PAH.RESOURCE_LIST_MEMBER_ID = 0
AND PAH.RESOURCE_LIST_ASSIGNMENT_ID = 0
AND PAH.TASK_ID <> 0
AND PAH.PROJECT_ID = PAPS.PROJECT_ID
AND PAH.PROJECT_ID = PPA.PROJECT_ID
AND '_SEC:PPA.ORG_ID' IS NOT NULL WITH READ ONLY