Projects tables in oracle apps r12

Projects tables in oracle apps r12

Here we are going to Discuss Projects tables in oracle apps r12. I will share all the key projects tables which holds all the Oracle Projects related information's in r12. You are use these Tables to write the SQL queries to extract the Project specific Data from the system. I am mentioning each and every table of oracle projects but I will those tables which Most commonly uses in the Oracle System. Here below is the complete information's about  Projects tables in oracle apps r12.

 

 

10 Most Important Projects tables in oracle apps r12

1.PA_PROJECTS_ALL

2.PA_TASKS

3.PA_PROJECT_TYPES

4.PA_PROJECT_PLAYERS

5.PA_AGREEMENTS_ALL

6.PA_CUSTOMERS_ALL

7.PA_BUDGET_VESIONS

8.PA_BUDGET_LINES

9.PA_DRAFT_REVENUES_ALL

10.PA_DRAFT_REVENUE_ITEMS

 

 

PA_PROJECTS_ALL:-  This table is the Header Table of the Oracle Projects. You can get Project related information from there.

 

PA_TAKS:- All the different -2 tasks of the projects stores in this Table

 

PA_PROJECT_TYPES :- This Stores the Project Type information like Contract or etc.

 

PA_PROJECT_PLAYERS : This stores the resources information's who is working in this project.

 

PA_AGREEMENTS_ALL:- This Table Stores the Project Agreement created with the Customer with the Funding amount too.

 

PA_CUSTOMERS_ALL:- This Table Stores the Project customers Information's.

 

PA_BUDGET_VESIONS:-  This Table Stores the funding Budget for the given project in Oracle apps r12. Budget is not mandatory in Projects. This is the Header table of the Projects Budgets.

 

PA_BUDGET_LINES :- This is the Line table of the Projects Budgets.

 

PA_DRAFT_REVENUES_ALL :-When we run the process “PRC: Generate Draft Revenue for a single Project” for the Project it generates the Draft revenue of the Project. This Table stores the Project draft Revenue Header Information's.

 

PA_DRAFT_REVENUE_ITEMS :- This Table stores the Project draft Revenue Line level Information's.