Query To Get Project Budget Lines Details In Oracle Apps R12 - Orapoint

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;