Search Results award_organization_name




Overview
Explore in AI Chat

Overview

APPS.AP_WEB_PA_PROJECTS_TASKS_V is a reporting view used by Oracle Payables (and the associated Oracle Internet Expenses / AP Web functionality) to present a consolidated, payable-oriented list of project and task combinations from Oracle Projects, enriched with Oracle Grants Management award attributes. The view is owned by the APPS schema and is a key reference object whenever an application needs to prompt a user to select a valid, chargeable project/task, in particular for expense reports, invoices, and other workflows originating in the AP Web modules.

Its functional role is to expose, in a single row, the identity and descriptive attributes of a project, a task within that project, the carrying-out organization, and (where applicable) the linked grant award. Because the view joins Projects, HR organizations, and Grants awards while filtering on chargeable tasks, it is intended primarily for selection lists and validation logic rather than transaction storage.

Practically, the view answers the user's question of locating the award terminal date by exposing AWARD_END_DATE, which corresponds to GMS_SSA_AWARDS_V.END_DATE. This allows AP Web screens and any dependent reports to display, filter, or validate against the award end date alongside the project and task completion dates.

Underlying Base Objects

The view is defined over four principal objects, with several packaged functions invoked in the select list:

  • PA_PROJECTS_EXPEND_V (P) — the Oracle Projects project-level view, supplying project identifiers, names, descriptions, type, and start/completion dates.
  • PA_TASKS_EXPEND_V (T) — the corresponding task-level view, supplying task identity, dates, and the chargeable flag.
  • HR_ORGANIZATION_UNITS (O) — the HR organization view, providing the carrying-out organization name.
  • GMS_SSA_AWARDS_V (GMS) — the Grants Management award view, joined with an outer join (GMS.PROJECT_ID(+) = P.PROJECT_ID) so that non-grant projects are still returned with null award columns.

Additional documented references include AP_WEB_FND_LOOKUPS_PKG and FND_PROFILE, used to resolve the Yes/No meaning of the chargeable flag via GETYESNOMEANING, together with HR_GENERAL, HR_SECURITY, PA_CROSS_BUSINESS_GRP, PA_PROJECT_UTILS, PA_TASK_UTILS, PA_UTILS4 and PA_UTILS packages that govern the security and expenditure rules applied within the underlying Projects views.

Key Columns

The view exposes a distinct set of project, task, organization, and award attributes. Representative columns include:

Because the join to GMS_SSA_AWARDS_V is outer, award columns return null when a project is not associated with a grant, and a SELECT DISTINCT is applied to eliminate duplicates arising from the underlying expenditure views.

Common Use Cases and Queries

Typical uses include populating project/task LOVs, validating chargeable combinations on expense entry, and reporting award end dates. A basic query retrieving chargeable project/task pairs and their award end date is shown below:

  • List chargeable tasks with award end dates: SELECT project_number, task_number, award_number, award_end_date FROM ap_web_pa_projects_tasks_v WHERE award_end_date IS NOT NULL;
  • Filter by project: SELECT task_number, task_name, allow_charges FROM ap_web_pa_projects_tasks_v WHERE project_id = :p_project_id;
  • Locate awards expiring within a range: SELECT project_number, award_number, award_end_date FROM ap_web_pa_projects_tasks_v WHERE award_end_date BETWEEN :p_from AND :p_to ORDER BY award_end_date;

All queries are subject to Oracle Projects security and profile options inherited through the underlying expenditure views, so results may be restricted by the operating unit and responsibility of the querying user.