PA Project Tasks and Budgets

Description
Categories: Enginatics
Repository: Github Columns: Operating Unit, Organization Code, Project Number, Project Name, Project Description, Project Type, Project Status Code, Project Start Date, Project Completion Date, Project Closed Date ...
select
haouv.name operating_unit,
ood.organization_code,
ppa.segment1 project_number,
ppa.name project_name,
ppa.description project_description,
ppa.project_type,
ppa.project_status_code,
ppa.start_date project_start_date,
ppa.completion_date project_completion_date,
ppa.closed_date project_closed_date,
pt.task_number,
pt.task_name,
pt.description task_description,
pt.service_type_code,
pt.start_date task_start_date,
pt.completion_date task_completion_date,
pt.wbs_level,
pbvdv.burdened_cost budget_cost,
xxen_util.user_name(ppa.created_by) project_created_by,
ppa.creation_date poject_creation_date,
(select ppx.full_name from pa_project_players ppp, per_people_x ppx where ppx.person_id=ppp.person_id and ppa.project_id=ppp.project_id and ppp.project_role_type='PROJECT MANAGER' and rownum=1) key_member,
pbvdv.cur_base_date approval_date,
(select sum(pbl.burdened_cost) from pafv_budget_lines pbl where pt.task_id=pbl.task_id and pbvdv.budget_version_id=pbl.budget_version_id and rownum=1) task_budget,
pod.destination_type_code,
-- pod.po_distribution_id,
(select item_id from po_lines_all where rcv1.po_line_id=pod.po_line_id and rownum=1) item,
(select description from mtl_system_items_kfv k where inventory_item_id = (select item_id from po_lines_all where rcv1.po_line_id=pod.po_line_id and rownum=1)
and organization_id = ppa.carrying_out_organization_id and rownum=1) item_desc,
(select concatenated_segments