Below are not the tables but someÂ useful views for ProjectsÂ
PA_PROJ_INVOICES_VIEW displays all project invoices in Oracle Projects. You can use this view to easily report project invoice information. This view displays one record per project invoice.
PA_PROJ_INVOICE_DETAILS_VIEW displays the detailed expenditure items that make up a project invoice. You can use this view to easily report the expenditure item information for an invoice backup report.
PA_PROJ_INVOICE_EVENTS_VIEW displays detailed event information for events included on a project invoice. You can use this view to easily report event details for a project invoice backup report.
PA_PROJ_INVOICE_SUMMARY_VIEW displays summary totals for a project which include baselined budget revenue amount, total revenue amount, total invoice amounts, and amounts on hold. This view displays one record per project. You can use this information when reviewing project status, particularly when reviewing invoices for a
PA_PROJ_MEMBERS_VIEW displays project members for a project. This view displays one record per project key member. You can use this view when reporting projects by project member. You can easily find all projects to which a project member is assigned.
PA_PROJ_RELEASED_INVOICES_VIEW displays released project
invoices. This view displays one record per project invoice. You can easily use this view when reporting released invoices.
PA_PROJ_REVENUE_VIEW is a view of the draft revenue information for a project that can be used for management reporting and online queries. The view displays one record per project revenue. For optimum performance in your reports and online queries, always
include PROJECT_ID in your selection criteria.
PA_PROJ_UNBILLED_EXPEND_VIEW displays billable expenditure items that are unbilled. You can review the unbilled expenditure items for your projects using this view.
PA_PROJ_UNBILLED_SUMMARY_VIEW shows summary unbilled amounts for a project. These amounts include items that are unbilled, items on hold, and events that are unbilled. You can easily review the unbilled summary status of your project
using this view.
PA_PROJ_WBS_VIEW displays project tasks as part of the project work breakdown structure. The task name and numbers are indented to illustrate the task level and position in the work breakdown structure. The view also displays basic task information, including task start and completion dates, task description, and the task manager.