[Home] [Help]
View: PA_RPT_PRJ_CMT_SUMMARY
Product: | PA - Projects |
Description: | Reporting view which displays project level commitments. |
Implementation/DBA Data: |
APPS.PA_RPT_PRJ_CMT_SUMMARY
|
View Text
SELECT PAH.PROJECT_ACCUM_ID
, PAH.ACCUM_PERIOD
, PAC.CMT_RAW_COST_PTD
, PAC.CMT_BURDENED_COST_PTD
, PAH.PROJECT_ID
FROM PA_PROJECT_ACCUM_HEADERS PAH
, PA_PROJECT_ACCUM_COMMITMENTS PAC
, PA_PROJECTS PPA
WHERE PAC.PROJECT_ACCUM_ID = PAH.PROJECT_ACCUM_ID
AND PAH.PROJECT_ID = PPA.PROJECT_ID
AND PAH.TASK_ID = 0
AND PAH.RESOURCE_LIST_MEMBER_ID = 0
Columns
Name |
PROJECT_ACCUM_ID |
ACCUM_PERIOD |
CMT_RAW_COST |
CMT_BURDENED_COST |
PROJECT_ID |