PA Views (700)

PA - Projects — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

ViewDescription
PABV_ACCOUNTING_PERIODS - Retrofitted
PABV_ASSETS - Retrofitted
PABV_ASSET_LINES - Retrofitted
PABV_ASSET_LINE_DETAILS - Retrofitted
PABV_BUDGET_LINES - Retrofitted
PABV_BUDGET_TYPES - Retrofitted
PABV_BUDGET_VERSIONS - Retrofitted
PABV_CLASSES - Retrofitted
PABV_CLASS_CATEGORIES - Retrofitted
PABV_CLASS_CODES - Retrofitted
PABV_COMMITMENTS - Retrofitted
PABV_COST_DISTRIBUTIONS - Retrofitted
PABV_CUSTOMERS - Retrofitted
PABV_CUSTOMER_AGREEMENTS - Retrofitted
PABV_CUSTOMER_AGREEMENT_TYPES - Retrofitted
PABV_CUSTOMER_CONTACTS - Retrofitted
PABV_CUSTOMER_INVOICES - Retrofitted
PABV_EVENTS - Retrofitted
PABV_EVENT_TYPES - Retrofitted
PABV_EXPENDITURES - Retrofitted
PABV_EXPENDITURE_CATEGORIES - Retrofitted
PABV_EXPENDITURE_GROUPS - Retrofitted
PABV_EXPENDITURE_ITEMS - Retrofitted
PABV_EXPENDITURE_TYPES - Retrofitted
PABV_FUNDINGS - Retrofitted
PABV_INVOICE_LINES - Retrofitted
PABV_INVOICE_LINE_DETAILS - Retrofitted
PABV_KEY_MEMBERS - Retrofitted
PABV_NON_LABOR_RESOURCES - Retrofitted
PABV_ORGANIZATIONS
PABV_PRJ_ACT_SUMMARY
PABV_PRJ_BGT_SUMMARY
PABV_PRJ_CMT_SUMMARY
PABV_PRJ_RESOURCE_ACT_SUMMARY
PABV_PRJ_RESOURCE_BGT_SUMMARY
PABV_PRJ_RESOURCE_CMT_SUMMARY
PABV_PROJECTS - Retrofitted
PABV_PROJECT_TYPES - Retrofitted
PABV_RESOURCES - Retrofitted
PABV_RESOURCE_LISTS - Retrofitted
PABV_RESOURCE_LIST_ASGN - Retrofitted
PABV_RESOURCE_LIST_RESOURCES - Retrofitted
PABV_REVENUE_CATEGORIES - Retrofitted
PABV_REVENUE_DISTRIBUTIONS - Retrofitted
PABV_TASKS - Retrofitted
PABV_TASK_ACT_SUMMARY - Retrofitted
PABV_TASK_BGT_SUMMARY - Retrofitted
PABV_TASK_CMT_SUMMARY
PABV_TASK_RESOURCE_ACT_SUMMARY - Retrofitted
PABV_TASK_RESOURCE_BGT_SUMMARY - Retrofitted
PABV_TASK_RESOURCE_CMT_SUMMARY
PABV_TRANSACTION_SOURCES - Retrofitted
PAFV_ACCOUNTING_PERIODS Business view to show information about PA periods.
PAFV_ASSETS Business view to show information about the classification of expenditure types.
PAFV_ASSET_LINES Business view to show information about asset lines to be transferred to Oracle Assets.
PAFV_ASSET_LINE_DETAILS Business view to show details about asset lines to be transferred to Oracle Assets.
PAFV_BUDGET_LINES Business view to show information on the budget lines.
PAFV_BUDGET_TYPES Business view to show information on different budget types used to define budgets.
PAFV_BUDGET_VERSIONS Business view to show information about versions of budgets.
PAFV_CLASSES Business view to show information about project classifications.
PAFV_CLASS_CATEGORIES Business view to show information about class categories used to classify projects.
PAFV_CLASS_CODES Business view to show information on the class codes used to classify projects.
PAFV_COMMITMENTS Business view to show commitments for a project. Business view to show commitments for a project.
PAFV_COMMITMENTS_OBSOLETE Business view to show commitments for a project.
PAFV_COST_DISTRIBUTIONS Business view to show information about cost distribution lines.
PAFV_CUSTOMERS This shows information about customers related to a project.
PAFV_CUSTOMER_AGREEMENTS Business view to show information about the customer agreements.
PAFV_CUSTOMER_AGREEMENT_TYPES Business view to show information about the various customer agreements possible
PAFV_CUSTOMER_CONTACTS Business view to show information about the customer contacts for the projects.
PAFV_CUSTOMER_INVOICES Business view to show information about the draft invoices generated by the projects.
PAFV_EVENTS Business view to show information about the events used to generate revenue and invoice for the projects. Business view to show information
PAFV_EVENTS_OBSOLETE Business view to show information about the events used to generate revenue and invoice for the projects.
PAFV_EVENT_TYPES Business view to show information about the event types possible.
PAFV_EXPENDITURES Business view to show information about the expenditures entered. Business view to show information about the expenditures entered.
PAFV_EXPENDITURES_OLD Business view to show information about the expenditures entered.
PAFV_EXPENDITURE_CATEGORIES Business view to show information about the classification of expenditure types.
PAFV_EXPENDITURE_GROUPS Business view to show information about the expenditure batches entered.
PAFV_EXPENDITURE_ITEMS Business view to show information about the expenditure items entered.
PAFV_EXPENDITURE_TYPES Business view to show the classification of the expenditures charged.
PAFV_FUNDINGS Business view to show information about the incremental allocation of agreement funds to projects.
PAFV_INVOICE_LINES Business view to show information about the lines of a draft invoice.
PAFV_INVOICE_LINE_DETAILS Business view to show the details of the invoice lines.
PAFV_KEY_MEMBERS Business view to show information about the employees involved with the project.
PAFV_NON_LABOR_RESOURCES Business view to show information about the non-labor assets used for the projects for which charges are incurred.
PAFV_ORGANIZATIONS This shows information about project organizations, project expenditure organizations, and event organizations.
PAFV_PRJ_ACT_SUMMARY Business view to show information about the project actuals summary.
PAFV_PRJ_BGT_SUMMARY Business view to show information about the project budgets summary.
PAFV_PRJ_CMT_SUMMARY This shows information about commitments at the project level.
PAFV_PRJ_RESOURCE_ACT_SUMMARY Business view to show information about the project actuals at resource level.
PAFV_PRJ_RESOURCE_BGT_SUMMARY Business view to show information about the project budgets at resource level.
PAFV_PRJ_RESOURCE_CMT_SUMMARY This shows information about commitments at the project resource level.
PAFV_PROJECTS Business view to show information about the projects.
PAFV_PROJECT_TYPES Business view to show information about the types of projects.
PAFV_RESOURCES Business view to show information about the resources used in projects.
PAFV_RESOURCE_LISTS Business view to show information about the resource lists.
PAFV_RESOURCE_LIST_ASGN Business view to show information about the resource lists assigned to the projects.
PAFV_RESOURCE_LIST_RESOURCES Business view to show information about the resources used in the resource lists.
PAFV_REVENUE_CATEGORIES Business view to show information about the revenue categories available.
PAFV_REVENUE_DISTRIBUTIONS This shows information about revenue distribution lines.
PAFV_TASKS Business view to show information on the tasks defined for a project. Business view to show information on the tasks defined for a project.
PAFV_TASKS_OBSOLETE Business view to show information on the tasks defined for a project.
PAFV_TASK_ACT_SUMMARY Business view to show information about the actuals at task level.
PAFV_TASK_BGT_SUMMARY Business view to show information about the budgets at task level.
PAFV_TASK_CMT_SUMMARY This shows information about commitments at the project/task level.
PAFV_TASK_RESOURCE_ACT_SUMMARY Business view to show information about the actuals at task and resource level.
PAFV_TASK_RESOURCE_BGT_SUMMARY Business view to show information about the budgets at task and resource level.
PAFV_TASK_RESOURCE_CMT_SUMMARY This shows information about commitments at the project/task/resourcelevel.
PAFV_TRANSACTION_SOURCES Business view to show information about the transaction sources that can be used to import transactions into Oracle projects.
PA_ACCUM_CATEGORIES_V 10Sc Only
PA_ACCUM_CMT_TXNS_V This view retrieves project, task and resource related commitments, including commitment-line attribute
PA_ACCUM_COLUMNS_V 10Sc Only
PA_ACCUM_COLUMN_VALUES_V 10Sc Only
PA_ACCUM_PERIOD_EXCEPTIONS_V PA_ACCUM_PERIOD_EXCEPTIONS_V is a view that identifies the projects which may be affected by a chang - Retrofitted
PA_ACCUM_PROJ_CMT_TXNS_BASE_V This view retrieves project level commitments, including commitment-line attributes like commitment - Retrofitted
PA_ACCUM_RSRC_ACT_BASE_V A base view that shows project level and task level resource actuals
PA_ACCUM_RSRC_ACT_V A summary view based on PA_ACCUM_RSRC_ACT_BASE_V, that shows project and task level resource actuals.
PA_ACCUM_RSRC_CMT_BASE_V A base view that shows project and task level resource commitments
PA_ACCUM_RSRC_CMT_TXNS_BASE_V This view retrieves project-task-resource level commitments, including commitment-line attributes l - Retrofitted
PA_ACCUM_RSRC_CMT_V A summary view based on PA_ACCUM_RSRC_CMT_BASE_V, that shows project and task.
PA_ACCUM_RSRC_COST_BGT_BASE_V A base view that shows project and task level resource amounts
PA_ACCUM_RSRC_COST_BGT_V
PA_ACCUM_RSRC_REV_BGT_BASE_V A base view that shows project and task level resource amounts
PA_ACCUM_RSRC_REV_BGT_V A summary view based on PA_ACCUM_RSRC_REV_BGT_BASE_V, that shows project and task level revenue budgets.
PA_ACCUM_TASK_CMT_TXNS_BASE_V This view retrieves project-task level commitments, including commitment-line attributes like commi - Retrofitted
PA_ACCUM_VIEW 10SC Only
PA_ACCUM_WBS_ACT_V A reporting view that shows actual cost and revenue totals for projects and tasks
PA_ACCUM_WBS_CMT_V
PA_ACCUM_WBS_COST_BGT_V A reporting view that shows original and baseline budget totals by cost budget type
PA_ACCUM_WBS_REV_BGT_V A reporting view that shows original and baseline budget totals by revenue budget type
PA_ACTION_FUNCTIONS_AMG_V PA_ACTION_FUNCTIONS_AMG_V selects all functions allowed for deliverable action.
PA_ACT_BY_GL_PERIOD_V Actual cost and revenue totals for lowest level tasks and resources by GL period.
PA_ACT_BY_PA_PERIOD_V Actual cost and revenue totals for lowest level tasks and resources by PA period.
PA_ADJUST_TYPE_V
PA_ADVERTISED_OPEN_REQ_V
PA_ADV_RULE_OBJECTS_V
PA_ADW_ACT_CMT_B_V - Retrofitted
PA_ADW_ACT_CMT_V
PA_ADW_BGT_LINES_B_V - Retrofitted
PA_ADW_BGT_LINES_V
PA_ADW_BGT_TYPES_B_V - Retrofitted
PA_ADW_BGT_TYPES_V
PA_ADW_CLASS_CATGS_B_V - Retrofitted
PA_ADW_CLASS_CATGS_V
PA_ADW_CLASS_CODES_B_V - Retrofitted
PA_ADW_CLASS_CODES_V
PA_ADW_CURRENT_TASKS
PA_ADW_EXP_TYPES_B_V - Retrofitted
PA_ADW_EXP_TYPES_V Values for expenditure types on the expenditure type dimension
PA_ADW_INTERFACED_TASKS
PA_ADW_LOWEST_RLMEM_B_V - Retrofitted
PA_ADW_LOWEST_RLMEM_V Values for the lowest level of resources on the resource dimension
PA_ADW_LOWEST_TASKS_B_V
PA_ADW_LOWEST_TASKS_V Values for the lowest level tasks on the project dimension.
PA_ADW_LOWTSK_ACT_CMT_V PA_ADW_LOWTSK_ACT_CMT_V view selects actual cost and revenue transaction amounts as well as commitments
PA_ADW_LOWTSK_BGT_LINES_V PA_ADW_LOWTSK_BGT_LINES_V view selects cost and revenue budget amounts
PA_ADW_OPER_UNITS_B_V - Retrofitted
PA_ADW_OPER_UNITS_V Values for the operating unit dimension
PA_ADW_ORGS_B_V - Retrofitted
PA_ADW_ORGS_V Values for organizations on the expenditure/projects organizations dimension
PA_ADW_PERIODS_B_V - Retrofitted
PA_ADW_PERIODS_V - Retrofitted
PA_ADW_PRJ_CLASSES_B_V - Retrofitted
PA_ADW_PRJ_CLASSES_V Values for project classes for the class category hierarchy on the project dimension
PA_ADW_PRJ_TYPES_B_V - Retrofitted
PA_ADW_PRJ_TYPES_V Values for project types on the project dimension
PA_ADW_PROJECTS_B_V - Retrofitted
PA_ADW_PROJECTS_V Values for projects on the project dimension
PA_ADW_RES_LISTS_B_V - Retrofitted
PA_ADW_RES_LISTS_V Values for resource lists on the resource dimension
PA_ADW_R_ACT_CMT_B_V - Retrofitted
PA_ADW_R_ACT_CMT_V Values for actuals and commitments when they are refreshed
PA_ADW_R_BGT_LINES_B_V - Retrofitted
PA_ADW_R_BGT_LINES_V Values for budgets when new versions of the budgets are baselined
PA_ADW_R_ST_ACT_CMT_B_V - Retrofitted
PA_ADW_R_ST_ACT_CMT_V Values for actuals and commitments when the service types on tasks are changed
PA_ADW_SRVC_TYPES_B_V - Retrofitted
PA_ADW_SRVC_TYPES_V Values for service types on the service dimension
PA_ADW_TOPTSK_ACT_CMT_V PA_ADW_TOPTSK_ACT_CMT_V view selects actual cost and revenue transaction amounts as well as commitments.
PA_ADW_TOPTSK_BGT_LINES_V PA_ADW_TOPTSK_BGT_LINES_V view selects cost and revenue budget amounts.
PA_ADW_TOP_RLMEM_B_V - Retrofitted
PA_ADW_TOP_RLMEM_V Values for group levels of resources on the resource dimension
PA_ADW_TOP_TASKS_B_V - Retrofitted
PA_ADW_TOP_TASKS_V Values for the top level of tasks on the project dimension
PA_AEL_GL_EI_V
PA_AGREEMENTS Single-Org
PA_AGREEMENTS_AMG_V This Single-Org view based on PA_AGREEMENTS_ALL table, stores information about legally binding documents from customers that serve as the b
PA_AGREEMENTS_O Single-Org
PA_AGREEMENTS_V 10SC Only
PA_AGREEMENT_TYPE_LOV_V
PA_AGR_ADM_DET_V This view shows members having project administrator responsibility.
PA_ALLOC_AUDIT_BASIS_V
PA_ALLOC_AUDIT_GL_V
PA_ALLOC_AUDIT_SOURCES_V
PA_ALLOC_BUDGET_ENTRY_METHOD_V
PA_ALLOC_BUDGET_TYPES_V
PA_ALLOC_EXCEPTIONS_V
PA_ALLOC_GL_AMOUNT_TYPE_V
PA_ALLOC_MISSING_COSTS_V
PA_ALLOC_OFFSET_PROJECTS_V
PA_ALLOC_PA_AMOUNT_TYPE_V
PA_ALLOC_PERIODS_V
PA_ALLOC_RESOURCES_V
PA_ALLOC_RULES
PA_ALLOC_RULES_V
PA_ALLOC_RUNS
PA_ALLOC_RUNS_V
PA_ALLOC_RUN_RULES_V
PA_ALLOC_SOURCE_LINES_V
PA_ALLOC_SRC_PROJECTS_V
PA_ALLOC_SRC_TASKS_V
PA_ALLOC_TARGET_LINES_V
PA_ALLOC_TARGET_PROJ_V
PA_ALLOC_TGT_TASKS_V
PA_ALLOC_TRANSACTIONS_V
PA_ALLOC_TXN_ACCUM_RBS_V
PA_ALLOC_TXN_ACCUM_V
PA_ALL_COMPETENCES_LOV_V This view returns all competences
PA_ALL_ORG_V PA_ALL_ORG_V is a view that shows organizations across business broups for searching projects in SSWA
PA_AMG_RESOURCE_INFO_BASE_V
PA_AMG_RESOURCE_INFO_V AMG view for accessing resource information
PA_AMOUNT_TYPES_VL Displays information on implementation-defined types of amount being carried out in Projects
PA_AP_INV_EXCEPTIONS_DET_V Details of Oracle Payables invoices that prevent a period from being cloded.
PA_AP_INV_EXCEPTIONS_SUM_V PA_AP_INV_EXCEPTIONS_SUM_V is a view that identifies the Payables invoices that prevent a period from being closed.
PA_ASSET_ALLOC_EXCEPTIONS_V
PA_ASSET_BOOKS_LOV_V This view retrieves valid asset books for the current set of books.
PA_ASSET_LINE_DETAILS_MRC_V Release 10SC Only
PA_ASSET_LINE_DETAILS_V Release 10SC Only
PA_ASSGN_COST_EFFORT_V
PA_ASSIGNMENT_PROGRESS_V
PA_ASSIGNMENT_PROG_HIST_V
PA_AS_ORG_ROLES_V
PA_AS_PERSON_ROLES_V
PA_AS_PROBABILITIES_V
PA_AUTOACCOUNTING_LOOKUPS_VIEW AutoAccounting lookup set values.
PA_AUTOALLOC_RULES_V
PA_BACK_PROJ_TASK_PROG_V
PA_BASE_BUDGET_BY_GL_PERIOD_V This view displays budget lines by GL period,for a baselined budget
PA_BASE_BUDGET_BY_PA_PERIOD_V This view displays budget lines by PA period, for a baselined budget
PA_BASE_BUDGET_BY_RESOURCE_V 10Sc Only
PA_BASE_FINPLAN_BY_GL_PERIOD_V This view displays budget lines by GL period, for a baselined financial plan
PA_BASE_FINPLAN_BY_PA_PERIOD_V This view displays budget lines by PA period, for a baselined financial plan
PA_BC_COMMITMENTS Single-Org
PA_BC_PROJECT_V Base View for Budgetary Controls Form - Project Block
PA_BGT_ACCT_LINES_V PA_BGT_ACCT_LINES_V stores the information of a project or task budget, including GL period, code combination identifier, budget amounts and
PA_BILLING_ASSIGNMENTS Single-Org
PA_BILLING_ASSIGNMENTS_O Single-Org
PA_BILLING_EXTN_PARAMS_V View of events for a MCB for a specific bill assignment id for use with billing extensions. Full Description: is a runtime view for use in
PA_BILLING_INV_DELETION_V Returns information about draft invoices that may be deleted in current run.
PA_BILLING_INV_PROCESSED_V PA_BILLING_INV_PROCESSED_V returns information about invoices processed in the current run, for use with billing extensions.
PA_BILLING_INV_TRANSACTIONS_V Returns detail information for amount processed in the current run
PA_BILLING_ORIG_EVENTS_V PA_BILLING_ORIG_EVENTS_V is a run time view for use in billing extensions that shows event info.
PA_BILLING_REV_DELETION_V Returns information about draft revenues that are eligible for deletion in current run for use in billing extensions.
PA_BILLING_REV_INV_DELETION_V Returns information about draft invoices that will be deleted in the current run of revenue generation.
PA_BILLING_REV_TRANSACTIONS_V Returns detail information for amounts processed in the current run of revenue generation.
PA_BILL_RATES Single-Org
PA_BILL_RATES_EMP 10SC Only
PA_BILL_RATES_JOB 10SC Only
PA_BILL_RATES_NL 10SC Only
PA_BILL_RATES_RC 10SC Only
PA_BILL_RATES_V 10SC Only
PA_BIS_AMOUNT_TYPES_V
PA_BIS_CLASS_PRJ_BY_PERIOD_V
PA_BIS_CLASS_PRJ_TO_DATE_V
PA_BIS_CLASS_TO_DATE_V
PA_BIS_ORG_PRJ_BY_PERIOD_V
PA_BIS_ORG_PRJ_TO_DATE_V
PA_BIS_ORG_TO_DATE_V
PA_BIS_PATH_NAME_LIST_V
PA_BIS_PRJ_BY_PRD_DRILLS
PA_BIS_PRJ_TO_DATE_DRILLS
PA_BIS_TOTALS_BY_PERIOD_V
PA_BIS_TOTALS_BY_PRD
PA_BIS_TOTALS_TO_DATE
PA_BIS_TOTALS_TO_DATE_V
PA_BIS_TO_DATE_DRILLS
PA_BOM_EQUIPMENT_RES_V
PA_BOM_LABOR_RES_V
PA_BUDGETARY_CONTROL_OPTIONS_V
PA_BUDGETARY_CONTROL_PROJ_V View used for processing in Budgetary Controls form and Budget Funds Check Form
PA_BUDGETARY_CONTROL_TASK_V Base View for Budgetary Controls Form - Task Block
PA_BUDGET_BY_PA_PERIOD_V 10Sc Only
PA_BUDGET_BY_RESOURCE_V 10Sc Only
PA_BUDGET_CHANGE_REASON_V This view displays all the valid reason codes that can be specified when a budget is changed
PA_BUDGET_ENTRY_METHODS_V This view displays the valid budget entry methods which control how a budget is entered
PA_BUDGET_LINES_DIST_V PA_BUDGET_LINES_DIST_V stores the information of a project or task budget by budget line, including the task number and sort order; the reso
PA_BUDGET_LINES_MRC_V Single currency view for pa_budget_lines
PA_BUDGET_LINES_V 10SC Only
PA_BUDGET_MATRIX_V - Retrofitted
PA_BUDGET_PERIODS_V R10SC Only - A view of all the periods used in time-phased budget entry
PA_BUDGET_PERIODS_V2
PA_BUDGET_RESOURCES_V 10Sc Only
PA_BUDGET_RESOURCE_LISTS_V 10Sc Only
PA_BUDGET_RES_ALL_V PA_BUDGET_RES_ALL_V returns all enabled resource list members, including unclassified resource list members, for a given resource lis
PA_BUDGET_STATUS_CODES_V This view displays the valid status codes for budgets
PA_BUDGET_TYPES_V This view displays all the valid budget types which are used for different business purposes -
PA_BUDGET_VERSIONS_BASELINED_V 10SC Only
PA_BUDGET_VERSIONS_DRAFT_V 10SC Only - Retrofitted
PA_BUDG_CONTROL_RES_GRP_V Base View for Budgetary Controls Form - Resource Group and Resource Block
PA_BURDEN_COMPONENT_CMT_V This view displays commitment burden components for each transaction
PA_BURDEN_COMPONENT_COST_V This view displays actual burden components for each transaction
PA_BURDEN_DETAILS_BASE_V View of burden cost components for a given compiled set ID, expenditure type, and expenditure organization.
PA_BURDEN_EXP_ITEM_CDL_V All summarized burden expenditure items and their cost distribution lines
PA_CANDIDATES_V This view stores information of candidate nomination.
PA_CANDIDATE_DETAILS_V This view stores detailed information of candidates.
PA_CANDIDATE_LOG_AMG_V This view shows all candidate reviews.
PA_CANDIDATE_REVIEWS_V This view stores information of candidate reviews.
PA_CAPITAL_COMMON_TASKS_V 10SC Only
PA_CAPITAL_EVENTS_V
PA_CAPITAL_EVENT_COSTS_V
PA_CAPITAL_EXCEPTIONS Capital Reporting Exceptions View
PA_CAPITAL_PROJECTS_BASE_V R10SC Only -Base view that shows summary capital amounts for a project
PA_CAPITAL_PROJECTS_V R10SC Only - View of summary expensed, CIP, capitalizable, capitalized, and total project costs for capital projects
PA_CAPITAL_PROJECTS_WBS_V
PA_CAP_EVENTS_CDL_COST_V
PA_CAP_EVENT_CREATION_V
PA_CC_BL_CUR_SEL_V
PA_CC_DIST_LINES Single-Org
PA_CC_DIST_LINES_ALL_MRC_V Multi-org, single currency view for pa_cc_dist_lines_all
PA_CC_DIST_LINES_ALL_MRC_V2 Multi-org, single currency view for pa_cc_dist_lines_all
PA_CC_DIST_LINES_MRC_V Single-org, single currency view for pa_cc_dist_lines_all
PA_CC_DIST_LINES_SUMMARIZE_V
PA_CC_DIST_SUM_REP_MRC_V This will select data from pa_draft_invoices, pa_cc_dist_lines_all, pa_mc_cc_dist_lines_all
PA_CC_EXCEPTIONS_DET_MRC_V MRC cross charge distributions that prevent a period from being closed. This view in period close reports.
PA_CC_EXCEPTIONS_DET_V This view is in period close reports. It shows the details of all cross charge distribution lines that prevent closing a period
PA_CC_EXCEPTIONS_SUM_MRC_V This view is used in period close reports. It shows all cross charge distribution lines that prevent closing a period
PA_CC_EXCEPTIONS_SUM_V Cross charge distributions that prevent a period from being closed.This view is used in period close reports.
PA_CC_GL_COST_AUDIT_REP_MRC_V View for Cross Charge Audit by GL Account showing the Cross Charge Distribution Lines and the corresponding entries in Oracle General Ledger
PA_CC_GL_COST_XFER_AUDIT_V View for Cross Charge Audit by GL Account showing the Cross Charge Distribution Lines and the corresponding entries in Oracle General Ledger
PA_CC_TP_BILL_SCH_ORGZN_V PA_CC_TP_BILL_SCH_ORGZN_V provides bill schedule and organization information within a business group
PA_CC_TP_BILL_SCH_ORG_V PA_CC_TP_BILL_SCH_ORG_V provides bill schedule operating unit information within a business group
PA_CC_TP_RULES
PA_CC_TP_RULES_V PA_CC_TP_RULES_V stores the rules that define how transfer price is calculated.
PA_CC_TP_SCHEDULES
PA_CC_TP_SCHEDULE_LINES_V PA_CC_TP_SCHEDULES_LINES_V holds the transfer price schedule lines which make up a trans fer price schedule. You specify the transfer price
PA_CDL_BURDEN_DETAIL_V_R Summarization criteria for burden summarization of expenditure items.This view is based on PA_CDL_BURDEN_DETAIL_V. It is a User customizable
PA_CDL_BURDEN_SUMMARY_V Summarization criteria for burden summarization of expenditure items.
PA_CDL_BURDEN_SUM_ERROR_V Cost distribution lines that are in exception for burden summarization
PA_CE_BILLING_EVENTS_V
PA_CE_EXP_REPORTS_V
PA_CE_INTEGRATION_BUDGETS_V PA_CE_INTEGRATION_BUDGETS_V is a cash forecasting view that shows project and task level resource budgets by period name for raw cost, burde
PA_CE_INVOICES_V
PA_CE_PROJECTS_SEC_V View of all projects across operating units
PA_CE_PROJECTS_V View of all projects across operating units
PA_CE_TRANSACTIONS_V
PA_CHILD_RESOURCES_V 10Sc Only
PA_CINT_EXP_TYPE_EXCL This is a single org view created for Form
PA_CINT_RATE_INFO This is a single org view created for Form
PA_CINT_RUNS_V
PA_CINT_TXN_DETAILS_V This is an Internal view created for Generate Capitalized interest Transaction process
PA_CIP_COST_CLEARING_V
PA_CI_ACTIONS_CHRO_V This view lists the action log in the chronological format. In the view, the requests and the responses will have separate entries.
PA_CI_ACTIONS_QA_V This view lists the action log on the Question/Answer format
PA_CI_ACTIONS_V This view provides the atrribute values for Action Lists
PA_CI_BASIC_CTL_V
PA_CI_CLASS_DESC_V
PA_CI_COMMENTS_V This view provides the attribute values from all comments from the table PA_CI_COMMENTS.
PA_CI_CRPRJ_LIST_V
PA_CI_IMPACTS_V
PA_CI_LIST_V
PA_CI_SECURED_V
PA_CI_STATUSES_V PA_CI_STATUSES_V lists all the allowable statuses for a given control item type.
PA_CI_SUPPLIER_DETAILS_V Pa_ci_supplier_details_v is view used to desgin UI screen
PA_CI_TYPES_V This view is used to display the details of the control item type, in the Update Control Item Type page.
PA_CI_TYPES_VL This view is used to display the list of existing control item types.
PA_CI_TYPES_W_FINPLAN_V
PA_CLASS_CATEGORIES_LOV_V This view displays all the implementation-defined values for class categories and class codes
PA_CLASS_CATEGORIES_V
PA_CMT_BURDEN_DETAIL_V This view displays the indirect cost components of all the non-summarized Commitment transactions of a project using the proper indirect rat
PA_CMT_BURDEN_SUMMARY_V This user customizable view defines the summarization criteria for burden summarization of commitment transactions.
PA_CMT_BURDEN_SUM_ERROR_V This View lists all the Commitment transactions which are in error during burden summarization.
PA_CMT_BURDEN_TXN_V This View lists all the summarized burden Commitment transactions.
PA_CMT_BY_GL_PERIOD_V This view displays current commitment totals for lowest level tasks and resources by GL periods.
PA_CMT_BY_PA_PERIOD_V This view displays current commitment totals for lowest level tasks and resources by PA periods.
PA_COMMITMENT_TXNS_V A view of all oustanding project-related commitment costs.
PA_COMPENSATION_DETAILS_R Single-Org
PA_COMPETENCES_AMG_V This view shows all competences that can be added to project requirements
PA_COMPETENCES_V
PA_CONFIG_LISTS_DISPLAY_V
PA_CONFIG_LISTS_PROJECT_V Displays all list elements
PA_CONFIG_LISTS_V Configurable list
PA_CONFIG_LIST_ELEMENTS_V Displays all list elements
PA_CONTROL_ITEMS_V This view provides the atrribute values for Control Items.
PA_CONVERSION_TYPES_V
PA_COST_BASE_V R10SC Only - Base view for cost bases used in a burden structure.
PA_COST_BURDEN_DETAILS_V View of individual burden cost components of the burdened cost of each expenditure item that is burdened.
PA_COST_DISTRIBUTION_LINES
PA_COST_DIST_LINES_ALL_MRC_V Multi-org, single currency view
PA_COST_DIST_LINES_ALL_MRC_V2 Multi-org, single currency view
PA_COST_DIST_LINES_ALL_MRC_V2R Multi-org, single currency view
PA_COST_DIST_LINES_FORMS_MRC_V
PA_COST_DIST_LINES_MRC_V Single-org, single currency view
PA_COST_DIST_LINES_MRC_V2 Single-org, single currency view
PA_COST_DIST_LINES_V
PA_COST_DIST_OVERRIDES_V 10Sc Only
PA_COST_EXCEPTIONS_DET_MRC_V pa_cost_exceptions_det_mrc_v is a view that identifies the Cost Distribution Lines that prevent a period - Retrofitted
PA_COST_EXCEPTIONS_DET_V Identifies the details Cost Distribution Lines that prevent a period from being closed.
PA_COST_EXCEPTIONS_SUM_MRC_V pa_cost_exceptions_sum_mrc_v is a view that identifies the Cost Distribution Lines that prevent a period - Retrofitted
PA_COST_EXCEPTIONS_SUM_V Identifies the details Cost Distribution Lines that prevent a period from being closed.
PA_COUNTRY_V
PA_CP_ASSET_NAMES_V 10SC Only
PA_CP_GENERATE_ASSET_BASE_V 10SC Only
PA_CP_GENERATE_ASSET_V 10SC Only
PA_CRDL_REVERSAL_RATE_V
PA_CREATE_TEAM_ROLES_V
PA_CROSS_CHARGEABLE_OU_BASE_V View of operating units that are Cross chargeable from the current operating unit
PA_CROSS_CHARGEABLE_OU_V View of operating units that are Cross chargeable from the current operating unit
PA_CURRENCY_UOM_V View used to configure currency unit of measure
PA_CURR_PROJ_TASK_PROG_V
PA_CUR_EMP_V For Online Expenditure Entry Form
PA_CUSTOMERS_LOV_V This view displays all the valid customers for a given project or template
PA_CUSTOMERS_V 10SC Only
PA_CUSTOMER_AGREEMENTS_V 10SC Only
PA_CUSTOMER_CONTACT_NAMES_V
PA_CUSTOMER_LOV_V
PA_CUSTOMER_NAME_V
PA_CUSTOMER_RECEIVER_PRJECTS_V
PA_CUSTOMER_RELATIONSHIPS_V 10SC Only
PA_CUSTOMER_SITES_V
PA_CUST_EVENT_RDL_ALL_MRC_V Multi-org, single currency MRC view
PA_CUST_EVENT_RDL_ALL_MRC_V2 Multi-org, single currency view
PA_CUST_EVENT_RDL_FORMS_MRC_V Single-Org
PA_CUST_EVENT_RDL_MRC_V Single-org, single currency view
PA_CUST_EVENT_REV_DIST_LINES Single-Org
PA_CUST_EVENT_REV_DIST_LINES_V Single-Org
PA_CUST_RDL_ALL_MRC_V Multi-org, single currency view
PA_CUST_RDL_ALL_MRC_V2 Multi-org, single currency view
PA_CUST_RDL_FORM_MRC_V This will select data from pa_cust_rev_dist_lines, pa_mc_cust_rdl_all, pa_expend_items_adjust_mrc_v
PA_CUST_RDL_MRC_V Single-org, single currency MRC view
PA_CUST_REV_DIST_LINES Single-Org
PA_CUST_REV_DIST_LINES_EI_V
PA_CUST_REV_DIST_LINES_MRC_V
PA_CUST_REV_DIST_LINES_V 10SC Only
PA_C_ELIG_RESOURCE_V PA_C_ELIG_RESOURCE_V is a view that identifies all resources that are available for use at this time or in the future.
PA_C_ELIG_RESOURCE_V_R PA_C_ELIG_RESOURCE_V is a view that identifies all resources that are available for use at this time or in the future.
PA_C_JOBLEVEL_RES_V PA_C_JOBLEVEL_RES_V shows the job level and historical, current and future primary assignment information for all resources.
PA_C_RESOURCE_V PA_C_RESOURCE_V is a view that identifies all resources that are av available for use at this time or in the future.
PA_C_RES_ASGN_V PA_C_RES_ASGN_V is a view that identifies all resources that are available for use at this time or in the future.
PA_C_RES_DENORM_V PA_C_RES_DENORM_V is a view that identifies all resources that are available for use at this time or in the future based on resources availa
PA_C_RES_DETAILS_V
PA_DEDUCTION_SUMMARY_BASE_V
PA_DEDUCTION_SUMMARY_V
PA_DEFAULT_PROFILES_V
PA_DELIVERABLES_AMG_V PA_DELIVERABLES_AMG_V selects all the attributes of a Deliverable.
PA_DELIVERABLES_TASKS_V PA_DELIVERABLES_TASKS_V selects all tasks and the deliverables associated to it.
PA_DELIVERABLES_V PA_DELIVERABLES_V selects all the attributes of a Deliverable.
PA_DELIVERABLE_PROGRESS_V
PA_DELIVERABLE_PROG_HIST_V
PA_DELIVERABLE_STATUSES_AMG_V PA_DELIVERABLE_STATUSES_AMG_V selects all the project statuses for deliverables.
PA_DELIVERABLE_TYPES_AMG_V PA_DELIVERABLE_TYPES_AMG_V selects all the attributes of a Deliverable Types.
PA_DELIV_ONLY_PROG_HIST_V
PA_DEPENDENCIES_V
PA_DISCOUNT_CODES_LOV_V This view displays all the defined discount codes.
PA_DISTRIBUTION_RULES_LOV_V This view displays all the relevant Distribution Rules for a template
PA_DLVR_ACTIONS_AMG_V PA_DLVR_ACTIONS_AMG_V selects all the attributes of a Deliverable Action.
PA_DLVR_ACTIONS_V PA_DLVR_ACTIONS_V selects all the attributes of a Deliverable Action
PA_DLVR_TYPE_ACTIONS_V PA_DLVR_TYPE_ACTIONS_V selects all the attributes of a Deliverable Type Action
PA_DLV_ASSCN_TASKS_V PA_DLV_ASSCN_TASKS_V selects all the attributes of a Deliverable
PA_DRAFT_INVOICES Single-Org
PA_DRAFT_INVOICES_ALL_V 10SC Only
PA_DRAFT_INVOICES_FORM_MRC_V This will select data from pa_draft_invoices, pa_mc_draft_inv_items, pa_draft_invoice_items
PA_DRAFT_INVOICES_V 10SC Only
PA_DRAFT_INVOICE_DETAILS
PA_DRAFT_INVOICE_ITEMS_MRC_V Single currency view
PA_DRAFT_INVOICE_LINES_ALL_V 10SC Only
PA_DRAFT_INVOICE_LINES_V 10SC Only
PA_DRAFT_INV_DTLS_ALL_MRC_V Single-org, single currency view
PA_DRAFT_INV_DTLS_MRC_V
PA_DRAFT_INV_LINES_FORM_MRC_V This will select data from pa_draft_invoices, pa_mc_draft_inv_items, pa_draft_invoice_items
PA_DRAFT_INV_LINE_DETAILS_V 10SC Only
PA_DRAFT_REVENUES_ALL_MRC_V Multi-org, single currency MRC view
PA_DRAFT_REVENUES_ALL_MRC_V2 Multi-org, single currency view
PA_DRAFT_REVENUES_FORM_MRC_V This will select data from pa_draft_revenues, pa_mc_draft_revs_all, pa_draft_revenue_items, pa_agreements_all
PA_DRAFT_REVENUES_MRC_V Single-org, single currency MRC view
PA_DRAFT_REVENUES_O Single-Org
PA_DRAFT_REVENUES_V This View has been modified to Include Reporting Project Functional columns whose values will be defaulted to NULL values
PA_DRAFT_REVENUE_ITEMS_MRC_V Single currency MRC view
PA_DRAFT_REVENUE_ITEMS_V 10SC Only
PA_DRAFT_REV_ITEMS_FORM_MRC_V This will select data from pa_draft_revenue_items, pa_cust_event_rev_dist_lines
PA_DR_EXCEPTIONS_DET_MRC_V Is a view that identifies the Draft Revenues that prevent a period from being - Retrofitted
PA_DR_EXCEPTIONS_DET_V Is a view that identifies the Draft Revenues that prevent a period from being closed.
PA_DR_EXCEPTIONS_SUM_MRC_V Is a view that identifies the Draft Revenues that prevent a period from being - Retrofitted
PA_DR_EXCEPTIONS_SUM_V Is a view that identifies the Draft Revenues that prevent a period from being closed
PA_EGO_LC_PHASES_V - Retrofitted
PA_EGO_LIFECYCLES_PHASES_V Only - Retrofitted
PA_EGO_LIFECYCLES_V Only - Retrofitted
PA_EGO_PHASES_V Only - Retrofitted
PA_EI_DENORM_MRC_V Expenditure Item Info along with Denorm data in vertical fashion
PA_EI_DENORM_V Expenditure Item Info along with Denorm data in vertical fashion
PA_EMPLOYEES Brief Description : View to display the current PER_PEOPLE_F record for employees. Comprehensive Description : PA_EMPLOYEES is a view that s
PA_EMPLOYEES_ADMIN_V For Online Expenditure Entry Form
PA_EMPLOYEES_RES_V 10Sc Only
PA_EMPLOYEE_ACCUM Single-Org
PA_EMPLOYEE_ORG_ACCUM Single-Org
PA_EMPLOYEE_SCHEDULES_LOV_V This view displays all the defined employee schedule values.
PA_EVENTS_AMG_V This view is based on pa_events table, and stores events assigned to a task that generate revenue and/or billing activities that are not dir
PA_EVENTS_DELIVERABLE_V 10 Sc only
PA_EVENTS_FORMS_MRC_V 10 Sc only
PA_EVENTS_MRC_V Single currency view
PA_EVENTS_MRC_V2 Single currency view
PA_EVENTS_V 10 Sc only
PA_EVENT_OUTPUT_TAX
PA_EVENT_TYPES_LOV_V
PA_EVENT_TYPES_RES_V 10Sc Only
PA_EVENT_TYPES_V 10SC Only
PA_EVENT_TYPE_CLASSES_RES_V 10Sc Only
PA_EVENT_TYPE_CLASSES_V 10SC Only
PA_EVENT_TYPE_OUS
PA_EVENT_TYPE_OUS_V
PA_EXPENDITURES Single-Org
PA_EXPENDITURES_MRC_V Single-org, single MRC currency view
PA_EXPENDITURES_MRC_V2 Single-org, single currency view
PA_EXPENDITURES_ROUTINGS_V
PA_EXPENDITURES_V 10SC Only
PA_EXPENDITURE_BATCHES Single-Org
PA_EXPENDITURE_COST_RATES Single-Org
PA_EXPENDITURE_COST_RATES_V 10SC Only
PA_EXPENDITURE_GROUPS Single-Org
PA_EXPENDITURE_GROUPS_V 10SC Only
PA_EXPENDITURE_HISTORY_V For Online Expenditure Entry Form
PA_EXPENDITURE_ITEMS Single-Org
PA_EXPENDITURE_ITEMS_ALL_MRC_V Multi-Org, single currency view
PA_EXPENDITURE_ITEMS_MRC_V Single-org, single currency view
PA_EXPENDITURE_ITEMS_MRC_V2 Single-org, single currency view
PA_EXPENDITURE_ITEMS_ONLINE_V This view shows all expenditure items
PA_EXPENDITURE_ITEMS_V 10SC Only
PA_EXPENDITURE_TYPES_DESC_V - Retrofitted
PA_EXPENDITURE_TYPES_EXPEND_V 10SC Only
PA_EXPENDITURE_TYPES_RES_V 10Sc Only
PA_EXPENDITURE_TYPES_V 10SC Only
PA_EXPENDITURE_TYPE_OUS
PA_EXPEND_ALIASES_V The view was not picking up the system_linkage_function for expenditure types that do not have a default system linkage_function defined in
PA_EXPEND_CATEGORIES_RES_V 10Sc Only
PA_EXPEND_ITEMS_ADJUST2_MRC_V
PA_EXPEND_ITEMS_ADJUST2_V 11i Only
PA_EXPEND_ITEMS_ADJUST_ALL_V
PA_EXPEND_ITEMS_ADJUST_MRC_V
PA_EXPEND_ITEMS_ADJUST_V 10SC Only
PA_EXPEND_ITEMS_ALL_MRC_V2 Multi-Org, single currency view
PA_EXPEND_OUTPUT_TAX
PA_EXPEND_TYP_SYS_LINKS_V View of pa_expend_typ_sys_links - Retrofitted
PA_EXPND_ITEMS_REVIEW_V 10SC Only
PA_EXP_CAT_GL_VIEW R10SC Only - Actual cost and revenue totals for projects and tasks by GL Period and expenditure category
PA_EXP_CAT_PA_VIEW R10SC Only - Actual cost and revenue totals for projects and tasks by PA Period and expenditure category
PA_EXP_ORG_GL_VIEW R10SC Only - Actual cost and revenue totals for projects and tasks by GL Period and expenditure organization
PA_EXP_ORG_HIERARCHIES_V
PA_EXP_ORG_PA_VIEW R10SC Only - Actual cost and revenue totals for projects and tasks by PA Period and expenditure organization
PA_EXP_OVRRDE_APPROVER_LOV_V
PA_EXP_OVRRDE_APPROVER_V Customizable view used to display overriding approver in Self Service Time application.
PA_EXP_START_ORGS_V
PA_EXP_TYPE_GL_VIEW R10SC Only - Actual cost and revenue totals for projects and tasks by GL Period and expenditure type
PA_EXP_TYPE_PA_VIEW R10SC Only - Actual cost and revenue totals for projects and tasks by PA Period and expenditure type
PA_EXT_DRIVERS_V Extensible Context View
PA_EXT_MAINT_AG_RESULTS_V Extensible drivers with associated attribute groups
PA_FCST_FI_STATUS_V PA_FCST_FI_STATUS_V is a view that shows forecast item status
PA_FCST_PERIODIC_DTL_V PA_PROJ_FCST_HDR_V is a view that shows project forecasting
PA_FCST_PERIODIC_HDR_V PA_PROJ_FCST_DTL_V is a view that shows project detail forecasting
PA_FCST_PERIODIC_SUM_V PA_PROJ_FCST_DTL_V is a view that shows project detail forecasting
PA_FCST_PERIODS_TMP_V The PA_FCST_PERIODS_TMP_V view displays information about period types such as the name of the period and the start and end dates.
PA_FCST_PERIODS_V PA_FCST_PERIODS_V is a view that shows the periods
PA_FCST_PROJECT_DTL_V PA_FCST_PROJECT_DTL_V is a view that shows project forecasting
PA_FCST_PROJECT_HDR_V PA_FCST_PROJECT_HDR_V is a view that shows project forecasting
PA_FCST_PROJECT_LIST_V PA_FCST_PROJECT_LIST_V is a view that shows forecasting periods
PA_FCST_PROJECT_SUM_V PA_PROJ_FCST_HDR_V is a view that shows project forecasting
PA_FCST_PROJ_DTL_V PA_PROJ_FCST_DTL_V is a view that shows project detail forecasting
PA_FCST_PROJ_ERR_V PA_PROJ_FCST_ERR_V is a view that shows project forecasting error information
PA_FCST_PROJ_HDR_V PA_FCST_PROJ_HDR_V is a view that shows project forecasting
PA_FCST_PROJ_INFO_V PA_FCST_PROJ_INFO_V is a view that shows project information
PA_FCST_PROJ_PERIODIC_V PA_PROJ_FCST_PERIODIC_V is a view that shows project periodic forecasting
PA_FCST_PROJ_SHOW_AMT_V PA_FCST_PROJ_SHOW_AMT_V is a view that shows project forecasting amount type
PA_FCST_PROJ_START_PERIOD_V PA_PROJ_FCST_PROJ_START_PERIOD_V is a view that shows project forecasting start period name
PA_FINANCIAL_OPTIONS_V
PA_FINPLAN_TYPES_V This view displays all the valid budget types and plan types which are used for different business purposes of a project.
PA_FINPLAN_VIEW_BY_COMP_V The pa_finplan_view_by_comp_v view store the forecast amounts by period for one amount types.
PA_FIN_LATEST_PUB_TASKS_V PA_FIN_LATEST_PUB_TASKS_V selects the tasks in the latest published structure version and the financial structure version.
PA_FIN_PERCENT_COMPLETES_V
PA_FIN_PERCENT_COMP_HIST_V
PA_FIN_PLAN_ADJ_TOTAL_V The pa_fin_plan_adj_total_v view store the total adjusted amounts by period for one adjustment reason.
PA_FIN_PLAN_CREATE_PLAN_BV_V Used in Create/View/Edit Versions OA page. This view retrieves information about a budget version given a budget version id. It relies on th
PA_FIN_PLAN_CREATE_PLAN_NOBV_V Used in Create/View/Edit Versions OA page This view retrieves information about a budget version when a budget version id is not supplied. I
PA_FIN_PLAN_TYPES_B_V This view is used by the Plan Types page. It displays all baselined plan types for a given project id.
PA_FIN_PLAN_TYPES_VL
PA_FIN_PLAN_TYPES_VL_R
PA_FIN_PLAN_TYPES_W_V This view is used for the Plan Types page. It retrieves information for all plan types that are current working for a given project id.
PA_FIN_STRUCTURES_LINKS_V
PA_FIN_STRUCTURES_TASKS_V PA_FIN_STRUCTURES_TASKS_V selects all the attributes of a structure version and a task version.
PA_FIN_STRUCTURE_VERSIONS_V PA_FIN_STRUCTURE_VERSIONS_V selects all structure-related attributes.
PA_FIN_WP_TASKS_V PA_FIN_WP_TASKS_V selects the tasks in the workplan structure, financial structure, or a shared structure.
PA_FORECASTING_OPTIONS This view is based on the table pa_forecasting_options_all and stores the parameters and defaults that define the various options for foreca
PA_FORECASTING_OPTIONS_V This view is based on the table PA_FORECASTING_OPTIONS_ALL and stores the parameters and defaults that define the various options for foreca
PA_FP_BASELINED_COSTREV_V Used in Maintain Versions OA page. This view retrieves baselined budget versions, regardless of version type
PA_FP_BASELINED_COST_V Used in Maintain Versions OA page. This view retrieves all baselined budget versions whose version type is COST
PA_FP_BASELINED_REVENUE_V Used in Maintain Versions OA page. This view retrieves budget versions whose version type is Revenue
PA_FP_BUDGET_LINE_REJECTIONS_V Resource Assignment level and Task assignment level rejection details for self service budgets and workplan.
PA_FP_CI_AMOUNTS_V This view is used for the Control Item pages. It returns financial amounts from budget versions grouped by ci_id and project_id.
PA_FP_ELIGIBLE_CI_V This view shall contain the details of all control orders having a financial impact
PA_FP_ENTER_ADJ_LINES_V The pa_fp_enter_adj_lines_v view store the adjusted amounts by period for one adjustment reason.
PA_FP_OF_WEBADI_V
PA_FP_OPTIONS_RESLISTS_V
PA_FP_OPTIONS_RESLISTS_V_R
PA_FP_PD_STARTDATES_V The pa_fp_pd_startdates_v view is created for the start period poplist.
PA_FP_PERIODS_PL_V The pa_fp_periods_pl_v view is created for the start period poplist.
PA_FP_PERIODS_TMP_V The PA_FP_PERIODS_TMP_V view displays information about period types such as the name of the period and the start and end dates.
PA_FP_PERIODS_V This view is used in Financial Planning webadi download to get all the planning periods detail.
PA_FP_PERIOD_INFO_V The pa_fp_period_info_v view store the period information plan versions.
PA_FP_SUM_PV_V
PA_FP_VERSION_STATUSES_V This view is used for the Plan Types page. It retrieves values used to populate a poplist.
PA_FP_VERSION_STATUS_DISP_V Used for Plan Types page. The values retrieved from this view are used as a column heading for the displayed table.
PA_FP_VIEW_ADJ_V The pa_fp_view_adj_v view store the adjusted amounts by period for all adjustment reasons.
PA_FP_VIEW_BY_COMP_V The pa_fp_view_by_comp_v view store the forecast amounts by period for one amount types.
PA_FP_VP_PERIOD_NAMES_V The pa_fp_vp_period_names_v view store the names of forecasting periods to be displayed.
PA_FP_VP_TXNCURRENCY_V This view is used for the View Plans page. It retrieves user-entered budget lines
PA_FP_WEBADI_CONTENTS_V This view is used for data to be downloaded to excel sheet for Financial Planning.
PA_FP_WEBADI_CUSTOM_V This view is used in Financial Planning to customize the download to Excel Spreadsheet.
PA_FP_WEBADI_NON_PERIODIC_V This view is used in Financial Planning to download non-periodic budget/forecast data into Excel Spreadsheet.
PA_FP_WEBADI_NP_CUSTOM_V This view is used in Financial Planning to customize the non-periodic budget/forecast download to Excel Spreadsheet.
PA_FP_WEBADI_PERIODIC_V This view is used in Financial Planning to download the periodic budget/forecast data into Excel Spreadsheet.
PA_FP_WEBADI_PRD_V This view is used in Financial Planning webadi download to get start date and end date for each periods based on period masks.
PA_FP_WEBADI_P_CUSTOM_V This view is used in Financial Planning to customize the periodic budget/forecast download to Excel Spreadsheet.
PA_FP_WORKING_COSTREV_V Used in Maintain Versions OA page. This view retrieves working budget versions, regardless of version type.
PA_FP_WORKING_COST_V Used in Maintain Versions OA page. This view retrieves all working budget versions whose version type is COST.
PA_FP_WORKING_REVENUE_V Used in Maintain Versions OA page. This view retrieves working budget versions whose version type is Revenue.
PA_FUNCTION_TRANSACTIONS Single-Org
PA_FUNCTION_TRANSACTIONS_R Single-Org
PA_FUND_REVAL_AUDITS_REP_MRC_V
PA_FUND_REVAL_AUDITS_V To list the funding revaluation components in the audit report
PA_GANTT_BAR_STYLES_VL PA_GANTT_BAR_STYLES_VL gives the bar style details
PA_GANTT_BAR_STYLE_TYPES_V PA_GANTT_BAR_STYLE_TYPES_V gives the details of all the bar types of a style
PA_GANTT_COLUMNS_V PA_GANTT_COLUMNS_V is the view giving the Gantt columns
PA_GANTT_CONFIG_VL PA_GANTT_VIEWS_VL stores the information about the customized Gantt View
PA_GANTT_VIEWS_VL
PA_GLOBAL_COMPETENCES_LOV_V This view returns all the global competences
PA_GL_CC_EXCEPT_DET_MRC_V MRC cross charge distributions that prevent a period from being closed. This view is used in period close reports. It shows the details of
PA_GL_CC_EXCEPT_DET_V Cross charge distributions in the primary set of books that prevent a period from being closed. This view is used in period close reports.
PA_GL_CC_EXCEPT_SUM_MRC_V Summary of MRC cross charge distributions that prevent a period from being closed. This view is used in period close reports. It shows a su
PA_GL_CC_EXCEPT_SUM_V Summary of cross charge distributions that prevent a period from being closed. This view is used in period close reports. It shows a summar
PA_GL_COST_AUDIT_REP_MRC_V View for Cost Audit by GL Account showing the Cost Distribution Lines and the corresponding entries in Oracle General Ledger. This view show
PA_GL_COST_EXCEPT_DET_MRC_V pa_gl_cost_except_det_mrc_v is a view that identifies the Cost Distribution Lines that prevent a period from being closed.
PA_GL_COST_EXCEPT_DET_V PA_GL_COST_EXCEPT_DET_V is a view that identifies the Cost Distribution Lines that prevents the PA GL period from being closed.
PA_GL_COST_EXCEPT_SUM_MRC_V pa_gl_cost_except_sum_mrc_v is a view that identifies the Cost Distribution Lines that prevent a period from being closed
PA_GL_COST_EXCEPT_SUM_V PA_GL_COST_EXCEPT_SUM_V is a view that identifies the Cost Distribution Lines that prevent a period
PA_GL_COST_XFER_AUDIT_V View for Cost Audit by GL Account showing the Cost Distribution Lines and the corresponding entries in Oracle General Ledger.
PA_GL_DR_EXCEPT_DET_MRC_V pa_gl_dr_except_det_mrc_v is a view that identifies the Draft Revenues that prevent a period from being closed.
PA_GL_DR_EXCEPT_DET_V PA_GL_DR_EXCEPT_DET_V is a view that identifies the Draft Revenues that prevent a period from being closed. Full Description: returns detail
PA_GL_DR_EXCEPT_SUM_MRC_V pa_gl_dr_except_sum_mrc_v is a view that identifies the Draft Revenues that prevent a period from being closed
PA_GL_DR_EXCEPT_SUM_V PA_GL_DR_EXCEPT_SUM_V is a view that identifies the Draft Revenues that prevent a period from being closed. Full Description: returns summar
PA_GL_PERIODS_V Displays details about GL periods.
PA_GL_REV_XFER_AUDIT_REP_MRC_V
PA_GL_REV_XFER_AUDIT_V View for Revenue Audit by GL Account showing the Revenue Distribution Lines and the corresponding entries in Oracle General Ledger. Full Des
PA_GL_SET_OF_BOOKS_V This view is being used in forms, reports, and concurrent processes to get the primary currency and reporting currency given above attribute
PA_GL_UNCOST_EXCEPT_SUM_V PA_GL_UNCOST_EXCEPT_SUM_V is a view that identifies the Cost Distribution Lines that prevent a period
PA_GL_VIEW R10SC Only - Actual cost and revenue totals for projects and tasks by GL Period.
PA_IMPLEMENTATIONS Single-Org
PA_IMPLEMENTATIONS_ALL_MRC_V
PA_IMPLEMENTATIONS_ALL_MRC_V2 Single currency view
PA_IMPLEMENTATIONS_ALL_MRC_V_O Single currency view
PA_IMPLEMENTATIONS_MRC_V
PA_IMPLEMENTATIONS_MRC_V_O Single-org, single currency view
PA_IMPLEMENTATIONS_O Single-Org
PA_IMP_EXP_HIERARCHY_V Displays information on Expenditure Owning Hierarchy for the Implementation
PA_IND_RATE_SCHEDULES View of all burden schedules owned by the business group
PA_INVOICE_GENERATE_OPTIONS_V
PA_INVOICE_SCHEDULES_LOV_V
PA_INV_BURDEN_DETAILS_LM_V View of individual burden cost components, along with the labor multiplier, of the bill amount.
PA_INV_BURDEN_DETAILS_V View of individual burden cost components of invoice amount of expenditure items.
PA_ITEMS_RES_V
PA_ITEM_CATEGORY_RES_V
PA_ITEM_PROJECT_ASSOCIATION_V View of Items linked with Project or Task
PA_JE_LINES View of GL journal entry lines for Oracle Projects cost and revenue transactions.
PA_JOBS_RES_V 10Sc Only
PA_JOBS_V 10SC Only
PA_JOB_DISCIPLINES_V 10SC Only
PA_JOB_GROUPS_V PA_JOB_GROUPS_V is a view that used all PA form LOVs for choosing job groups.- Retrofitted
PA_JOB_GROUPS_VIEW
PA_JOB_GROUP_COMBOS_V PA_JOB_GROUP_COMBOS_V is a view that identifies the combinations of from and to Job groups that have been defined.- Retrofitted
PA_JOB_LEVELS_V 10SC Only
PA_JOB_RELATIONSHIPS_V PA_JOB_RELATIONSHIPS_V is a view that identifies relationships between jobs that have been defined based on the groups used.- Retrofitted
PA_JOB_RELATIONSHIPS_VIEW PA_JOB_RELATIONSHIPS_VIEW is a view that identifies relationships between jobs via the master group job.
PA_JOB_SCHEDULES_LOV_V This view displays all the defined job schedule.
PA_KEY_MEMBERS_LOV_V This view displays all the key members for a given project or template
PA_LABOR_EXPENDITURES_VIEW View of detail labor transactions for employee activity and utilization. PA_LABOR_EXPENDITURES_VIEW shows detail labor transactions for empl
PA_LATEST_PROJ_TASK_PROG_V
PA_LATEST_PUB_STRUC_TASKS_V PA_LATEST_PUB_STRUC_TASKS_V selects the information of the latest published structure version. - For future use
PA_LAUNCH_PAGE_ACTIONS_V PA_LAUNCH_PAGE_ACTIONS_V gives the consolidated list of actions
PA_LAUNCH_PAGE_OBJECTS_TM_V PA_LAUNCH_PAGE_OBJECTS_TM_V gives the consolidated list of objects
PA_LAUNCH_PAGE_OBJECTS_V PA_LAUNCH_PAGE_OBJECTS_V gives the consolidated list of objects
PA_LEAD_CATEGORIES_V
PA_LEAD_CLASSIFICATIONS_V
PA_LOCATIONS_V
PA_LOCATIONS_V_R
PA_LOOKUPS PA_LOOKUPS is a view of system defined lookup codes and their corresponding meaning for Oracle Projects. This view will display the meani ng
PA_LOOKUP_TYPES PA_LOOKUP_TYPES is a view of system defined application-specific categories of lookup codes for Oracle Projects.
PA_LOWEST_LEVEL_RESOURCES_V This view that displays details about the lowest level resource list members
PA_MANAGERS_V PA_MANAGERS_V is a view that shows manager details for all primary active assignments.
PA_MAP_WP_TO_FIN_TASKS_V
PA_MASS_TXN_ASGMT_SUCCESS_V
PA_MASS_UPDATE_BATCHES Multi-org view for PA_MASS_UPDATE_BATCHES_ALL - Retrofitted
PA_MULTI_CUSTOMERS_V 10SC Only
PA_MU_BATCHES_V View used to display information about the batches created for mass update of a project/task attributes
PA_MU_DETAILS_V View to display detail information for batch created for mass update of a project/task attribute. - Retrofitted
PA_MU_PROJECTS_LOV_V This view displays all the active projects the user is allowed to query. - Retrofitted