Results for “completion_date”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PA_ONLINE_PROJECTS_V is a customizable view owned by the APPS schema within the Oracle E-Business Suite Projects (PA) module. It is validated and available in both EBS 12.1.1 and 12.2.2. Its purpose is to expose a curated, security-filtered list of projects for consumption by the Self Service Time application, allowing employees to select chargeable projects when entering time and expense information. Because the view is explicitly described as customizable, Oracle permits implementers to modify its definition without invalidating standard functionality, which makes it a frequent extension point in Projects and Time implementations. Note that the actual runtime behavior of the view depends on referenced base objects such as FND_PROFILE, HR_GENERAL, HR_SECURITY, and PA_CROSS_BUSINESS_GRP, which supply profile option values, HR organizational context, and cross-business-group security rules respectively.
Underlying Base Objects
The view is defined primarily over PA_PROJECTS_EXPEND_V, itself a view in the Projects schema that resolves expenditure-related project attributes. PA_ONLINE_PROJECTS_V selects a DISTINCT projection of that source, and additionally resolves the carrying-out organization name via a correlated subquery against HR_ORGANIZATION_UNITS. The documented referenced base objects also include the packages FND_PROFILE, HR_GENERAL, HR_SECURITY, PA_CROSS_BUSINESS_GRP, and PA_PROJECT_UTILS. These are not directly present in the view text excerpt but are invoked indirectly through PA_PROJECTS_EXPEND_V, which uses them to enforce security and derive profile-driven behavior. HR_SECURITY, for example, applies organization-based security so that a user only sees projects belonging to organizations they are authorized to access. FND_PROFILE supplies values for relevant profile options, PA_CROSS_BUSINESS_GRP enforces cross-business-group filtering, and PA_PROJECT_UTILS provides project-related utility logic.
Key Columns
- PROJECT_ID — Unique numeric identifier for the project; used as the primary key in downstream joins and pickers.
- PROJECT_NUMBER — The user-facing project number, typically displayed first in Self Service Time project lists.
- PROJECT_NAME — Descriptive name of the project.
- PROJECT_TYPE — Classification of the project (for example, billable or internal), useful for grouping and defaulting behavior.
- START_DATE and COMPLETION_DATE — Effective date range of the project; used to filter selectable projects to those active during the entered time period.
- CARRYING_OUT_ORGANIZATION_ID — Identifier of the organization responsible for carrying out the project.
- CARRYING_OUT_ORGANIZATION_NAME — Resolved name of that organization, obtained via the correlated subquery against HR_ORGANIZATION_UNITS.
Common Use Cases and Queries
Typical uses include driving project LOVs in Self Service Time, validating chargeable project selections, and building custom time-entry validations or reports. Because the view is expected to be customized, many implementations add attributes such as project manager, customer, or task references. A basic query to retrieve visible projects is:
SELECT project_number, project_name, project_id, project_type,
start_date, completion_date, carrying_out_organization_name
FROM apps.pa_online_projects_v
WHERE sysdate BETWEEN start_date AND NVL(completion_date, sysdate);
A query filtering by organization is:
SELECT project_number, project_name
FROM apps.pa_online_projects_v
WHERE carrying_out_organization_id = :org_id;
Because HR_SECURITY and profile-driven logic are applied within the underlying views and packages, results are automatically restricted to projects the querying user is authorized to see, so the view is generally safe to expose in custom self-service pages without additional security predicates.
-
View: PA_ONLINE_PROJECTS_V 12.1.1
Customizable view for projects used in Self Service Time application. PA_ONLINE_PROJECTS_V is a customizable view for Self Service Time application
APPS.PA_ONLINE_PROJECTS_V·↳ FND_PROFILE·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·Explore PA module →
-
View: PA_ONLINE_TASKS_V 12.1.1
Customizable view for tasks used in Self Service Time, Oracle Time Capture, and Sel f Service Expense applications. PA_ONLINE_TASKS_V is a customizable view for Self Service Time application , Oracle Time Capture, and Self Service Expense.
APPS.PA_ONLINE_TASKS_V·↳ FND_PROFILE·↳ PA_IMPLEMENTATIONS·↳ PA_LOOKUPS·Explore PA module →
-
View: PABV_TASKS 12.1.1
- Retrofitted
APPS.PABV_TASKS·↳ PA_PROJECTS_ALL·↳ PA_TASKS·Explore PA module →
-
View: PA_STRUCT_TASK_WBS_V 12.2.2
APPS.PA_STRUCT_TASK_WBS_V·↳ PA_PROJECTS_ALL·↳ PA_PROJ_ELEMENTS·↳ PA_PROJ_ELEMENTS_UTILS·Explore PA module →
-
View of events included on project invoices. Full Description: is a view that displays detailed information for events included on a project invoices. You can use this view to easily report event details for a project invoice backup r
APPS.PA_PROJ_INVOICE_EVENTS_VIEW·↳ HR_ALL_ORGANIZATION_UNITS·↳ PA_DRAFT_INVOICE_ITEMS·↳ PA_EVENTS·Explore PA module →
-
View: PA_ONLINE_PROJECTS_V 12.2.2
Customizable view for projects used in Self Service Time application. PA_ONLINE_PROJECTS_V is a customizable view for Self Service Time application
APPS.PA_ONLINE_PROJECTS_V·↳ FND_PROFILE·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·Explore PA module →
-
View: PA_DLVR_ACTIONS_AMG_V 12.2.2
PA_DLVR_ACTIONS_AMG_V selects all the attributes of a Deliverable Action.
APPS.PA_DLVR_ACTIONS_AMG_V·↳ PA_OBJECT_RELATIONSHIPS·↳ PA_PROJ_ELEMENTS·↳ PA_PROJ_ELEMENTS_UTILS·Explore PA module →
-
View: PA_TASKS_EXPEND_V 12.1.1
View of the tasks for a given project to which you can charge expenditures
APPS.PA_TASKS_EXPEND_V·↳ FND_PROFILE·↳ PA_IMPLEMENTATIONS·↳ PA_LOOKUPS·Explore PA module →
-
View: PA_ALLOC_TARGET_PROJ_V 12.2.2
APPS.PA_ALLOC_TARGET_PROJ_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore PA module →
-
View: PA_PROJ_MEMBERS_VIEW 12.1.1
View of project information for projects for use in reporting projects by project member
APPS.PA_PROJ_MEMBERS_VIEW·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HR_GENERAL·Explore PA module →
-
View of the projects to which you can do search. (For subledgers LOV)
APPS.PA_PROJ_ALL_BASIC_UN_SEC_V·↳ FND_PROFILE·↳ HR_ALL_ORGANIZATION_UNITS·↳ PA_CROSS_BUSINESS_GRP·Explore PA module →
-
View: PA_DELIVERABLES_AMG_V 12.1.1
PA_DELIVERABLES_AMG_V selects all the attributes of a Deliverable.
APPS.PA_DELIVERABLES_AMG_V·↳ PA_LOOKUPS·↳ PA_PERCENT_COMPLETES·↳ PA_PROGRESS_ROLLUP·Explore PA module →
-
View: PABV_PROJECTS 12.2.2
- Retrofitted
APPS.PABV_PROJECTS·↳ PA_DISTRIBUTION_RULES·↳ PA_PROJECTS_ALL·↳ PA_PROJECT_STATUSES·Explore PA module →
-
View of the projects to which you can do search. (For subledgers LOV)
APPS.PA_PROJECTS_ALL_EXPEND_V·↳ FND_PROFILE·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_ORGANIZATION_INFORMATION·Explore PA module →
-
View: PA_TASKS_ALL_EXPEND_V 12.2.2
View of the tasks for a given project to which you can charge expenditures
APPS.PA_TASKS_ALL_EXPEND_V·↳ FND_PROFILE·↳ HR_ALL_ORGANIZATION_UNITS·↳ PA_ALTERNATE_TASKS·Explore PA module →
-
View of the projects to which you can do search. (For subledgers LOV)
APPS.PA_PROJECTS_ALL_EXPEND_V·↳ FND_PROFILE·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_ORGANIZATION_INFORMATION·Explore PA module →
-
View: PA_FCST_PROJECT_LIST_V 12.1.1
PA_FCST_PROJECT_LIST_V is a view that shows forecasting periods
APPS.PA_FCST_PROJECT_LIST_V·↳ FND_GLOBAL·↳ FND_GRANTS·↳ FND_MENUS·Explore PA module →
-
View: PAFV_TASKS 12.1.1
Business view to show information on the tasks defined for a project. Business view to show information on the tasks defined for a project.
APPS.PAFV_TASKS·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore PA module →
-
View of the projects to which you can do search. (For subledgers LOV)
APPS.PA_PROJECTS_ALL_BASIC_V·↳ FND_PROFILE·↳ HR_ALL_ORGANIZATION_UNITS·↳ PA_CROSS_BUSINESS_GRP·Explore PA module →
-
View: PA_ONLINE_TASKS_V 12.2.2
Customizable view for tasks used in Self Service Time, Oracle Time Capture, and Sel f Service Expense applications. PA_ONLINE_TASKS_V is a customizable view for Self Service Time application , Oracle Time Capture, and Self Service Expense.
APPS.PA_ONLINE_TASKS_V·↳ FND_PROFILE·↳ PA_ALTERNATE_TASKS·↳ PA_IMPLEMENTATIONS·Explore PA module →
-
View: PA_DLVR_ACTIONS_AMG_V 12.1.1
PA_DLVR_ACTIONS_AMG_V selects all the attributes of a Deliverable Action.
APPS.PA_DLVR_ACTIONS_AMG_V·↳ PA_OBJECT_RELATIONSHIPS·↳ PA_PROJ_ELEMENTS·↳ PA_PROJ_ELEMENTS_UTILS·Explore PA module →
-
Reporting view which displays information about projects.
APPS.PA_RPT_PROJECT_ATTRIBUTES·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·Explore PA module →
-
View: PA_PROJ_MEMBERS_VIEW 12.2.2
View of project information for projects for use in reporting projects by project member
APPS.PA_PROJ_MEMBERS_VIEW·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HR_GENERAL·Explore PA module →
-
View: PA_FCST_PROJECT_LIST_V 12.2.2
PA_FCST_PROJECT_LIST_V is a view that shows forecasting periods
APPS.PA_FCST_PROJECT_LIST_V·↳ FND_GLOBAL·↳ FND_GRANTS·↳ FND_MENUS·Explore PA module →
-
View: PABV_TASKS 12.2.2
- Retrofitted
APPS.PABV_TASKS·↳ PA_PROJECTS_ALL·↳ PA_TASKS·Explore PA module →
-
View of events included on project invoices. Full Description: is a view that displays detailed information for events included on a project invoices. You can use this view to easily report event details for a project invoice backup r
APPS.PA_PROJ_INVOICE_EVENTS_VIEW·↳ HR_ALL_ORGANIZATION_UNITS·↳ PA_DRAFT_INVOICE_ITEMS·↳ PA_EVENTS·Explore PA module →
-
View: PA_PROJ_EVENTS_VIEW 12.1.1
The view displays all relevant information for project events
APPS.PA_PROJ_EVENTS_VIEW·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore PA module →
-
PA_LAUNCH_PAGE_OBJECTS_TM_V gives the consolidated list of objects
APPS.PA_LAUNCH_PAGE_OBJECTS_TM_V·↳ HZ_PARTIES·↳ PA_CI_TYPES_B·↳ PA_CI_TYPES_TL·Explore PA module →
-
View: PA_PROJECTS_EXPEND_V 12.1.1
View of the projects to which you can charge expenditures
APPS.PA_PROJECTS_EXPEND_V·↳ FND_PROFILE·↳ HR_ORGANIZATION_INFORMATION·↳ PA_BUDGETARY_CONTROL_OPTIONS·Explore PA module →
-
PA_PO_PROJECTS_EXPEND_V shows the projects included in the list of values for expenditure entry from PO.
APPS.PA_PO_PROJECTS_EXPEND_V·↳ FND_GLOBAL·↳ FND_PROFILE·↳ PA_CROSS_BUSINESS_GRP·Explore PA module →
-
View: PA_PROJECTS_EXPEND_V 12.2.2
View of the projects to which you can charge expenditures
APPS.PA_PROJECTS_EXPEND_V·↳ FND_PROFILE·↳ HR_ORGANIZATION_INFORMATION·↳ PA_BUDGETARY_CONTROL_OPTIONS·Explore PA module →
-
View: PA_PROJECTS_LOV_V 12.2.2
Single-Org
APPS.PA_PROJECTS_LOV_V·↳ FND_TERRITORIES_VL·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ JTF_CALENDARS_VL·Explore PA module →
-
PA_LAUNCH_PAGE_OBJECTS_V gives the consolidated list of objects
APPS.PA_LAUNCH_PAGE_OBJECTS_V·↳ HZ_PARTIES·↳ PA_CI_TYPES_B·↳ PA_CI_TYPES_TL·Explore PA module →
-
View: PA_TASKS_ALL_EXPEND_V 12.1.1
View of the tasks for a given project to which you can charge expenditures
APPS.PA_TASKS_ALL_EXPEND_V·↳ FND_PROFILE·↳ HR_ALL_ORGANIZATION_UNITS·↳ PA_IMPLEMENTATIONS_ALL·Explore PA module →
-
View: PABV_PROJECTS 12.1.1
- Retrofitted
APPS.PABV_PROJECTS·↳ PA_DISTRIBUTION_RULES·↳ PA_PROJECTS_ALL·↳ PA_PROJECT_STATUSES·Explore PA module →
-
View: PA_ALLOC_TARGET_PROJ_V 12.1.1
APPS.PA_ALLOC_TARGET_PROJ_V·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore PA module →
-
PA_BILLING_ORIG_EVENTS_V is a run time view for use in billing extensions that shows event info.
APPS.PA_BILLING_ORIG_EVENTS_V·↳ PA_BILLING·↳ PA_DRAFT_INVOICES·↳ PA_DRAFT_INVOICE_ITEMS·Explore PA module →
-
PA_BILLING_ORIG_EVENTS_V is a run time view for use in billing extensions that shows event info.
APPS.PA_BILLING_ORIG_EVENTS_V·↳ PA_BILLING·↳ PA_DRAFT_INVOICES·↳ PA_DRAFT_INVOICE_ITEMS·Explore PA module →
-
View: PA_PROJ_EVENTS_VIEW 12.2.2
The view displays all relevant information for project events
APPS.PA_PROJ_EVENTS_VIEW·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore PA module →
-
View: PAFV_EVENTS 12.1.1
Business view to show information about the events used to generate revenue and invoice for the projects. Business view to show information about the events used to generate revenue and invoice for the projects.
APPS.PAFV_EVENTS·↳ HR_ALL_ORGANIZATION_UNITS·↳ PA_BUDGET_TYPES·↳ PA_EVENTS·Explore PA module →
-
View of the projects to which you can do search. (For subledgers LOV)
APPS.PA_PROJECTS_ALL_BASIC_V·↳ FND_PROFILE·↳ HR_ALL_ORGANIZATION_UNITS·↳ PA_CROSS_BUSINESS_GRP·Explore PA module →
-
View: PAFV_TASKS 12.2.2
Business view to show information on the tasks defined for a project. Business view to show information on the tasks defined for a project.
APPS.PAFV_TASKS·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·↳ HR_SECURITY·Explore PA module →
-
View: PAFV_PROJECTS 12.1.1
Business view to show information about the projects.
APPS.PAFV_PROJECTS·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ PA_DISTRIBUTION_RULES·Explore PA module →
-
View: PA_STRUCT_TASK_WBS_V 12.1.1
APPS.PA_STRUCT_TASK_WBS_V·↳ PA_PROJECTS_ALL·↳ PA_PROJ_ELEMENTS·↳ PA_PROJ_ELEMENTS_UTILS·Explore PA module →
-
View: PA_PROJECTS_LOV_V 12.1.1
Single-Org
APPS.PA_PROJECTS_LOV_V·↳ FND_TERRITORIES_VL·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ JTF_CALENDARS_VL·Explore PA module →
-
View: PA_PROJ_INFO_VIEW 12.1.1
Basic project information for projects
APPS.PA_PROJ_INFO_VIEW·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HR_GENERAL·Explore PA module →
-
View: PA_PROJ_INFO_VIEW 12.2.2
Basic project information for projects
APPS.PA_PROJ_INFO_VIEW·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HR_GENERAL·Explore PA module →
-
Reporting view which displays information about projects.
APPS.PA_RPT_PROJECT_ATTRIBUTES·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_GENERAL·↳ HR_ORGANIZATION_UNITS·Explore PA module →
-
View: PA_DLV_ASSCN_TASKS_V 12.2.2
PA_DLV_ASSCN_TASKS_V selects all the attributes of a Deliverable
APPS.PA_DLV_ASSCN_TASKS_V·↳ PA_OBJECT_RELATIONSHIPS·↳ PA_PERCENT_COMPLETES·↳ PA_PROGRESS_ROLLUP·Explore PA module →
-
View: PA_DLV_ASSCN_TASKS_V 12.1.1
PA_DLV_ASSCN_TASKS_V selects all the attributes of a Deliverable
APPS.PA_DLV_ASSCN_TASKS_V·↳ PA_OBJECT_RELATIONSHIPS·↳ PA_PERCENT_COMPLETES·↳ PA_PROGRESS_ROLLUP·Explore PA module →