In this post we will discuss on Project PA module table details in Oracle Apps R12, listed tables are important and most useful in project module, listed table described briefly so that you can construct SQL and extract the project module data with less effort from Oracle database as per your requirements.
List of Important Project Module Table’s
PA_PROJECTS_ALL: This table stores project header level details
PA_PROJECT_ASSETS_ALL: This table stores project assets related information
PA_PROJECT_ASSIGNMENTS: This table stores assignments of projects
PA_TASKS: This table stores user-defined subdivisions of project work.
PA_PROJECT_TYPES: This table stores implementation-defined project classifications that supply default information and drive some project processing.
PA_PROJECT_PLAYERS: This table stores resources information’s who is working in this project.
PA_AGREEMENTS_ALL: This table stores project agreement created with the customer with the funding amount.
PA_PROJECT_CLASSES: This table stores class codes of class categories that are used to classify projects.
PA_CUSTOMERS_ALL: This table stores project customer related information.
PA_PROJECT_ROLE_TYPES: This table stores implementation-defined responsibilities or positions assigned to employees on projects stored.
PA_PROJECT_STATUSES: This table stores valid project status codes.
PA_BUDGETS: This table stores project budgets information.
PA_EVENTS: This table stores entries assigned to tasks that generate revenue and/or billing but are not directly related to expenditure items.
PA_EVENT_TYPES: This table stores implementation-defined classifications of events.