1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Need help in PA Query

Discussion in 'Oracle Apps Technical' started by Ecor, Feb 28, 2014.

  1. Ecor

    Ecor Active Member

    Messages:
    20
    Likes Received:
    3
    Trophy Points:
    90
    Hi guys

    I have one requirement regarding Project Accounting Module.

    Here am keeping one screen shot... i need to display the values which are highlighted in the screen shot with Project Number and Project name
    Can any one help on this plz......
     

    Attached Files:

  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi Ecor,

    pa_budget_versions has labor_unit_of_measure,raw_cost and quantity and burden cost columns.
     
  3. GSRAWAT

    GSRAWAT Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    SELECT NAME, segment1, ppa.project_id, labor_unit_of_measure, raw_cost,
    burdened_cost, revenue
    FROM pa_budget_versions pbv,
    pa_projects_all ppa
    WHERE 1 = 1
    AND ppa.project_id = pbv.project_id
    AND ppa.segment1 = <p_project>