PA Views (700)
PA - Projects — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.
| View | Description |
|---|---|
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 |