VIEW: APPS.PAFV_TASK_RESOURCE_BGT_SUMMARY

Source

View Text - Preformatted

SELECT pah.PROJECT_ACCUM_ID , pab.BUDGET_TYPE_CODE , paps.accum_period , pab.BASE_RAW_COST_ITD , pab.BASE_RAW_COST_YTD , pab.BASE_RAW_COST_PP , pab.BASE_RAW_COST_PTD , pab.BASE_BURDENED_COST_ITD , pab.BASE_BURDENED_COST_YTD , pab.BASE_BURDENED_COST_PP , pab.BASE_BURDENED_COST_PTD , pab.ORIG_RAW_COST_ITD , pab.ORIG_RAW_COST_YTD , pab.ORIG_RAW_COST_PP , pab.ORIG_RAW_COST_PTD , pab.ORIG_BURDENED_COST_ITD , pab.ORIG_BURDENED_COST_YTD , pab.ORIG_BURDENED_COST_PP , pab.ORIG_BURDENED_COST_PTD , pab.BASE_REVENUE_ITD , pab.BASE_REVENUE_YTD , pab.BASE_REVENUE_PP , pab.BASE_REVENUE_PTD , pab.ORIG_REVENUE_ITD , pab.ORIG_REVENUE_YTD , pab.ORIG_REVENUE_PP , pab.ORIG_REVENUE_PTD , pab.ORIG_LABOR_HOURS_ITD , pab.ORIG_LABOR_HOURS_YTD , pab.ORIG_LABOR_HOURS_PP , pab.ORIG_LABOR_HOURS_PTD , pab.BASE_LABOR_HOURS_ITD , pab.BASE_LABOR_HOURS_YTD , pab.BASE_LABOR_HOURS_PP , pab.BASE_LABOR_HOURS_PTD , pab.ORIG_QUANTITY_YTD , pab.ORIG_QUANTITY_ITD , pab.ORIG_QUANTITY_PP , pab.ORIG_QUANTITY_PTD , pab.BASE_QUANTITY_YTD , pab.BASE_QUANTITY_ITD , pab.BASE_QUANTITY_PP , pab.BASE_QUANTITY_PTD , pab.ORIG_LABOR_HOURS_TOT , pab.BASE_LABOR_HOURS_TOT , pab.ORIG_QUANTITY_TOT , pab.BASE_QUANTITY_TOT , pab.BASE_RAW_COST_TOT , pab.BASE_BURDENED_COST_TOT , pab.ORIG_RAW_COST_TOT , pab.ORIG_BURDENED_COST_TOT , pab.BASE_REVENUE_TOT , pab.ORIG_REVENUE_TOT , '_LA:pab.BASE_UNIT_OF_MEASURE:PA_LOOKUPS:UNIT:MEANING' , '_LA:pab.ORIG_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 , pbt.budget_type , pab.LAST_UPDATE_DATE , pab.LAST_UPDATED_BY , pab.CREATION_DATE , pab.CREATED_BY FROM pa_project_accum_budgets pab , pa_project_accum_headers pah , 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 , pa_budget_types pbt WHERE pab.project_accum_id = pah.project_accum_id and pah.task_id <> 0 and pah.project_id = ppa.project_id 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 pab.budget_type_code = pbt.budget_type_code AND pah.project_id = paps.project_id AND '_SEC:ppa.org_id' is not null WITH READ ONLY

View Text - HTML Formatted

SELECT PAH.PROJECT_ACCUM_ID
, PAB.BUDGET_TYPE_CODE
, PAPS.ACCUM_PERIOD
, PAB.BASE_RAW_COST_ITD
, PAB.BASE_RAW_COST_YTD
, PAB.BASE_RAW_COST_PP
, PAB.BASE_RAW_COST_PTD
, PAB.BASE_BURDENED_COST_ITD
, PAB.BASE_BURDENED_COST_YTD
, PAB.BASE_BURDENED_COST_PP
, PAB.BASE_BURDENED_COST_PTD
, PAB.ORIG_RAW_COST_ITD
, PAB.ORIG_RAW_COST_YTD
, PAB.ORIG_RAW_COST_PP
, PAB.ORIG_RAW_COST_PTD
, PAB.ORIG_BURDENED_COST_ITD
, PAB.ORIG_BURDENED_COST_YTD
, PAB.ORIG_BURDENED_COST_PP
, PAB.ORIG_BURDENED_COST_PTD
, PAB.BASE_REVENUE_ITD
, PAB.BASE_REVENUE_YTD
, PAB.BASE_REVENUE_PP
, PAB.BASE_REVENUE_PTD
, PAB.ORIG_REVENUE_ITD
, PAB.ORIG_REVENUE_YTD
, PAB.ORIG_REVENUE_PP
, PAB.ORIG_REVENUE_PTD
, PAB.ORIG_LABOR_HOURS_ITD
, PAB.ORIG_LABOR_HOURS_YTD
, PAB.ORIG_LABOR_HOURS_PP
, PAB.ORIG_LABOR_HOURS_PTD
, PAB.BASE_LABOR_HOURS_ITD
, PAB.BASE_LABOR_HOURS_YTD
, PAB.BASE_LABOR_HOURS_PP
, PAB.BASE_LABOR_HOURS_PTD
, PAB.ORIG_QUANTITY_YTD
, PAB.ORIG_QUANTITY_ITD
, PAB.ORIG_QUANTITY_PP
, PAB.ORIG_QUANTITY_PTD
, PAB.BASE_QUANTITY_YTD
, PAB.BASE_QUANTITY_ITD
, PAB.BASE_QUANTITY_PP
, PAB.BASE_QUANTITY_PTD
, PAB.ORIG_LABOR_HOURS_TOT
, PAB.BASE_LABOR_HOURS_TOT
, PAB.ORIG_QUANTITY_TOT
, PAB.BASE_QUANTITY_TOT
, PAB.BASE_RAW_COST_TOT
, PAB.BASE_BURDENED_COST_TOT
, PAB.ORIG_RAW_COST_TOT
, PAB.ORIG_BURDENED_COST_TOT
, PAB.BASE_REVENUE_TOT
, PAB.ORIG_REVENUE_TOT
, '_LA:PAB.BASE_UNIT_OF_MEASURE:PA_LOOKUPS:UNIT:MEANING'
, '_LA:PAB.ORIG_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
, PBT.BUDGET_TYPE
, PAB.LAST_UPDATE_DATE
, PAB.LAST_UPDATED_BY
, PAB.CREATION_DATE
, PAB.CREATED_BY
FROM PA_PROJECT_ACCUM_BUDGETS PAB
, PA_PROJECT_ACCUM_HEADERS PAH
, 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
, PA_BUDGET_TYPES PBT
WHERE PAB.PROJECT_ACCUM_ID = PAH.PROJECT_ACCUM_ID
AND PAH.TASK_ID <> 0
AND PAH.PROJECT_ID = PPA.PROJECT_ID
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 PAB.BUDGET_TYPE_CODE = PBT.BUDGET_TYPE_CODE
AND PAH.PROJECT_ID = PAPS.PROJECT_ID
AND '_SEC:PPA.ORG_ID' IS NOT NULL WITH READ ONLY