View: PAFV_TASK_RESOURCE_CMT_SUMMARY

Product:	PA - Projects
Description:	This shows information about commitments at the project/task/resourcelevel.
Implementation/DBA Data:	APPS.PAFV_TASK_RESOURCE_CMT_SUMMARY

View Text

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
, PPA.NAME
, PPA.SEGMENT1
, PAH.TASK_ID
, PT.TASK_NAME
, PT.TASK_NUMBER
, PAH.RESOURCE_LIST_ID
, PRL.NAME
, PAH.RESOURCE_LIST_ASSIGNMENT_ID
, PAH.RESOURCE_LIST_MEMBER_ID
, PRLM.ALIAS
, PAH.RESOURCE_ID
, PR.NAME
, 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
, PA_TASKS PT
, PA_RESOURCE_LISTS_ALL_BG PRL
, PA_RESOURCE_LIST_MEMBERS PRLM
, PA_RESOURCES PR
WHERE PAC.PROJECT_ACCUM_ID = PAH.PROJECT_ACCUM_ID
AND PAH.PROJECT_ID = PPA.PROJECT_ID
AND PAH.TASK_ID <> 0
AND PAH.TASK_ID = PT.TASK_ID
AND PAH.RESOURCE_LIST_ID = PRL.RESOURCE_LIST_ID
AND PAH.RESOURCE_LIST_MEMBER_ID = PRLM.RESOURCE_LIST_MEMBER_ID
AND PAH.RESOURCE_ID = PR.RESOURCE_ID
AND PAH.PROJECT_ID = PAPS.PROJECT_ID
AND '_SEC:PPA.ORG_ID' IS NOT NULL WITH READ ONLY

Columns