Pa module common table 2

Select * From pa_expenditure_items_all project expenditure

Select * From pa_cost_distribution_lines_all expenditure allocation row

Select L. project_id, H. project_set_id, H. Name, L. project_set_id
From pa_project_set_lines L, pa_project_sets_vl H
Where l. project_set_id = H. project_set_id; project set

Select * From pa_project_types_all project category

Select L. task_id, L. task_number, L. task_name, L .*
From pa_tasks L
Where l. project_id = 157223; -- Project Task

Select L. task_name,
L. task_id,
L. resource_class_code, -- resource category
L. task_number,
L. resource_alias,
L. uom_code,
L. uom_description,
L. planned_cost, -- planned cost
L .*
From pa_tasks_assigns_progress_v L
Where l. project_id = 157223
And l. project_number = '123'
And l. task_id = 246877; -- plan resources

Select * From pa_resource_classes_vl Resource Type

-- Obtain the current approved revenue and budget version
Select L. project_id,
L. fin_plan_type_id,
L. budget_version_id ,--
L. version_number, -- version number
L. budget_status_code, -- State B approval, w Activity
L. current_flag, -- Current
L .*
From pa_budget_versions L
Where l. project_id = 162229
And l. current_flag = 'y' -- Current
And l. budget_status_code = 'B ';

-- Obtain the currently approved useful income and budget amount
Select sum (decode (BV. version_type,
'Org _ forecast ',
Nvl (revenue, 0 ),
Nvl (BV. total_project_revenue, 0) +
Sum (nvl (BV. total_tp_revenue_in, 0) +
Sum (nvl (BV. total_borrowed_revenue, 0) +
Sum (nvl (BV. total_revenue_adj, 0 ))-
Sum (nvl (BV. total_tp_revenue_out, 0) SSS
From pa_fin_plan_types_vl PT,
Pa_budget_versions BV,
Pa_proj_fp_options PFO
Where PFO. project_id = BV. project_id (+)
And PFO. fin_plan_type_id = BV. fin_plan_type_id (+)
And PFO. fin_plan_type_id = pt. fin_plan_type_id
AND Pt. plan_class_code in ('budget ', 'forecast ')
And PFO. fin_plan_option_level_code = 'Plan _ type'
And BV. ci_id is null
And BV. current_flag (+) = 'y'
And nvl (Pt. use_for_workplan_flag, 'n') = 'n'

And BV. fin_plan_type_id = 10020 -- FBS budget
And BV. project_id = 162229;

-- Plan type
Select pt. fin_plan_type_id, Pt. Name, Pt. Description
From pa_fin_plan_types_vl PT
Where Pt. plan_class_code in ('budget ', 'forecast ')
And nvl (Pt. use_for_workplan_flag, 'n') = 'n'; -- FBS budget 10020

Pa module common table 2