This Query will help you to get Project Budget line level data with columns like Project number, project name, task number, alias, period name, burdened cost in Oracle R12 Application
select distinct c.segment1 project_num, c.name project_name, pt.task_number, pt.TASK_NAME, d.ALIAS, a.PERIOD_NAME, a.BURDENED_COST -- ,a.* from pa_projects_all c, PA_BUDGET_LINES a, PA_RESOURCE_ASSIGNMENTS b, PA_RESOURCE_LIST_MEMBERS d, pa_tasks pt where c.project_id = b.PROJECT_ID and a.RESOURCE_ASSIGNMENT_ID = b.RESOURCE_ASSIGNMENT_ID and b.RESOURCE_LIST_MEMBER_ID = d.RESOURCE_LIST_MEMBER_ID and b.TASK_ID = pt.TASK_ID --and pt.task_number = '4' --and c.segment1='01000005' order by c.segment1,pt.task_number, a.PERIOD_NAME;