Search Results task_completion_date




Overview
Explore in AI Chat

Overview

AP_WEB_PA_PROJECTS_TASKS_V is a view owned by the APPS schema within the Oracle Payables (AP) product family. In Oracle Internet Expenses, both the Projects and Tasks function and the Task Number list of values are based on this view, making it the primary data source through which expense-line project and task validation is performed. The view joins project, task, organization, and grant-award data into a single denormalized result set, exposing the identifiers, descriptive attributes, and date ranges that Internet Expenses requires when an employee charges an expense to a project and task combination.

The object carries a VALID status in ETRM and is documented for Oracle EBS 12.1.1 and 12.2.2. Because it filters tasks on CHARGEABLE_FLAG = 'Y', the view returns only those project/task combinations that are eligible to receive charges, which is the behavioral foundation of both the Projects and Tasks function and the Task Number list of values in Internet Expenses.

Underlying Base Objects

The view text selects from four primary sources: PA_TASKS_EXPEND_V (aliased T), PA_PROJECTS_EXPEND_V (aliased P), HR_ORGANIZATION_UNITS (aliased O), and GMS_SSA_AWARDS_V (aliased GMS). The joins are defined as T.PROJECT_ID = P.PROJECT_ID, P.CARRYING_OUT_ORGANIZATION_ID = O.ORGANIZATION_ID, and GMS.PROJECT_ID(+) = P.PROJECT_ID. The task filter T.CHARGEABLE_FLAG = 'Y' restricts output, and the DISTINCT operator eliminates duplicate combinations.

Documented referenced objects include the packages AP_WEB_FND_LOOKUPS_PKG, FND_PROFILE, HR_GENERAL, HR_SECURITY, PA_CROSS_BUSINESS_GRP, PA_PROJECT_UTILS, PA_TASK_UTILS, and PA_UTILS4, in addition to the views GMS_SSA_AWARDS_V, HR_ORGANIZATION_UNITS, PA_PROJECTS_EXPEND_V, and PA_TASKS_EXPEND_V. The security packages (HR_SECURITY, PA_CROSS_BUSINESS_GRP) are significant because the underlying expend views enforce operating-unit and cross-business-group access rules, so results are inherently filtered by the responsibility's security profile. AP_WEB_FND_LOOKUPS_PKG.GETYESNOMEANING supplies the decoded ALLOW_CHARGES value.

Key Columns

Common Use Cases and Queries

The principal use case is supplying the Projects and Tasks function and the Task Number list of values in Internet Expenses. Reporting queries commonly join the view to expense distributions, or filter by task completion date to identify tasks approaching or past their end date.

SELECT project_number,
       project_name,
       task_number,
       task_name,
       task_start_date,
       task_completion_date
  FROM apps.ap_web_pa_projects_tasks_v
 WHERE task_completion_date IS NOT NULL
   AND task_completion_date < SYSDATE
 ORDER BY task_completion_date;

To retrieve the valid charge combinations for a given project:

SELECT t.task_number,
       t.task_name,
       t.allow_charges,
       t.project_organization_name,
       t.award_number
  FROM apps.ap_web_pa_projects_tasks_v t
 WHERE t.project_number = :project_number
 ORDER BY t.task_number;

Because HR_SECURITY and cross-business-group logic are applied within the underlying expend views, query results depend on the operating unit and security profile of the session, and direct SQL against the view should account for that filtering. Regardless of the query pattern, CHARGEABLE_FLAG = 'Y' means only chargeable tasks are ever returned.