Oracle Projects Key tables in Oracle Apps R12

The blog provides the main tables to be used for Oracle Projects in Oracle Apps R12. 

Oracle Projects TableOracle Projects Table Description
PA_PROJECTS_ALLProvides the Oracle Projects highest units of work
PA_PROJECT_STATUSESProvides the Oracle Projects Status details
PA_TASKSProvides the Oracle Projects Task classification details
PA_TASK_TYPESProvides the Oracle Projects Task Types
PA_PROJECT_TYPES_ALLProvides the Oracle Projects implemented 
PA_PROJECT_ASSIGNMENTSProvides the Oracle Projects Assignment details
PA_PROJECT_ASSETS_ALLProvides  assets information defined for capital projects.
PA_PROJECT_CLASSESProvides the class codes of class categories to classify projects.
PA_PROJECT_ROLE_TYPESProvides the Implementation-defined responsibilities or positions assigned to employees in oracle projects  
PA_TRANSACTION_INTERFACE_ALLProvides the interface table to import transactions from external sources into Oracle Projects.
PA_TRANSACTION_SOURCESProvides the implementation-defined sources of imported transactions originating in an external system.
PA_IMPLEMENTATIONS_ALLProvides the configuration of an Oracle Projects installation
PA_ACTION_SETSProvides action set templates and belonging to an object like projects, requirements, etc.
PA_ACTION_SET_LINESProvides  action set lines associated  to an action set or an action set template
PA_ACTION_SET_TYPESProvides action set types attributes
PA_AGREEMENTS_ALLProvides customer contracts that serve as the basis for work authorization
PA_AGREEMENT_TYPESProvides  the Implementation-defined classifications of customer agreements.
PA_BILL_RATES_ALLInformation about bill rates and markups of standard bill rate schedules.
PA_BUDGETSProvides budgets information
PA_BUDGET_LINESProvides detail lines of project and task budgets.
PA_BUDGET_TYPESProvides  the implementation-defined classifications for  budgets types used for different business purposes.
PA_CLASS_CATEGORIESProvides the implementation-defined categories for classifying projects.
PA_CLASS_CODESProvides  the implementation-defined values within class categories that can be used to classify projects
PA_EVENTSProvides  the entries assigned to tasks for generating revenue and/or billing though not directly related to expenditure items
PA_EVENT_TYPESProvides the implementation-defined event classifications 
PA_EXPENDITURES_ALLProvides the expenditure items group for an expenditure period
PA_EXPENDITURE_CATEGORIESProvides  the Implementation-defined expenditure types  grouping based on cost type
PA_EXPENDITURE_ITEMS_ALLProvides the smallest units of expenditure charged to projects and tasks
PA_EXPENDITURE_TYPESProvides the Implementation-defined expenditures classifications charged to projects and tasks
PA_PERIODS_ALLProvides the Implementation-defined periods to measure performance
PA_RBS_DENORMProvides the normalized resource breakdown structure details
PA_RBS_ELEMENTSProvides the RBS element  and the parent-child relationship details
PA_RESOURCESProvides the resources used in budgeting and project summary amounts
PA_ROLE_LISTSProvides the lists of roles defined with the system
PA_SCHEDULESProvides the schedule details for requirements and assignments. It also displays calendar schedules
PA_BATCH_SOURCESProvides the Oracle Projects Batch Source details
PA_BC_BALANCESProvides the Oracle Projects Budget Costing Balances
PA_ALLOC_SOURCE_LINES   Provides the Oracle Projects Source Line allocations
PA_ALLOC_TARGET_LINESProvides the Oracle Projects Target Line allocations
PA_ALLOC_TXN_LINESProvides the Oracle Projects Transaction Line allocations
PA_ALLOC_EXCEPTIONSProvides the exceptions related to the Oracle Project allocation 
PA_ALLOC_GL_LINESProvides the Oracle Projects Lines allocated for GL Processing
PA_ALLOC_MISSING_COSTSProvides the Oracle Projects Lines missing the costing 
PA_ALLOC_RESOURCESProvides the resources in Oracle Projects allocation
PA_ALLOC_RULES_ALLProvides the Rules defined for Oracle Projects