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!

project report

Discussion in 'Oracle HRMS & Payroll' started by rachid.elmaazouz, May 16, 2014.

  1. rachid.elmaazouz

    rachid.elmaazouz Active Member

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    75
    Hi all,
    I am in charge of developing a report for project reporting in oracle R12,
    I need to get the initial budget and the most recent budget of the project.
    I made search on the PA tables and found tables that (may be ) related to my objective:
    PA_PROJECTS_ALL, PA_PROJECT_BUDGET_VERSION, PA_PROJECT.
    I suspect the version_number of the PA_PROJECT_BUDGET_VERSION table to be the right information but when I run the query I get more column that I got from form in the oracle apps web app.
    how can I get the needed information? any suggestion, critic, opinion is welcome.
    I will do further search and post back result if found anything useful.
    Thanks for help.
    Best Regards.