Search Results assignment_status




Overview
Explore in AI Chat

Overview

The PA_RES_ASGN_TIMELINE_ROWLBL_V view is a reporting and integration object in the Oracle E-Business Suite Projects (PA) module, owned by the APPS schema. Its documented purpose is to provide row labels for the resource assignments and requirements timeline. In practice, the view functions as a filtered, denormalized read interface over the timeline row-label data used by the Project Resource Management timeline UI and related analytics. The view exposes assignment-level and resource-level attributes—including the assignment start date that users frequently search for—so that downstream reports, dashboards, and integrations can retrieve timeline row labels without querying the base table directly. It is a view object with VALID status in the ETRM metadata for both 12.1.1 and 12.2.2, and it is not a table; therefore it cannot be updated directly and reflects the current state of the underlying data at query time.

Underlying Base Objects

The view is defined over a single referenced base object: PA_TIMELINE_ROW_LABEL, accessed through a synonym. The view text applies a restricting predicate on ROW_LABEL_TYPE, returning only rows where ROW_LABEL_TYPE is in ('PROJECT', 'ADMIN', 'AVAILABLE'). This design narrows the base table's full row-label population to the categories relevant to resource assignment and requirement timelines. Because the view does not join additional tables, all columns are projected from PA_TIMELINE_ROW_LABEL, and any data maintained in that base table is immediately visible through the view subject to the ROW_LABEL_TYPE filter. Administrators should note that performance characteristics follow the base table, and the filter predicate on ROW_LABEL_TYPE should be considered when creating supporting indexes or tuning timeline queries.

Key Columns

Common Use Cases and Queries

Typical usage includes timeline reporting, resource assignment dashboards, and data extracts for integration with external scheduling tools. Because ASSIGNMENT_START_DATE is exposed directly, the view is well suited to date-driven queries such as identifying assignments beginning within a period or comparing planned versus actual timelines. A sample query filtering by project and start date follows:

  • SELECT assignment_id, assignment_name, assignment_status, assignment_start_date, assignment_end_date, resource_name FROM apps.pa_res_asgn_timeline_rowlbl_v WHERE project_number = :p_project AND assignment_start_date >= :p_from_date ORDER BY assignment_start_date;
  • SELECT row_label_type, COUNT(*) FROM apps.pa_res_asgn_timeline_rowlbl_v GROUP BY row_label_type;

The view returns only PROJECT, ADMIN, and AVAILABLE row-label types, so consumers should not expect other categories present in the base table. As a read-only view, it supports reporting and integration patterns but not DML.