Search Results actual_work_quantity




Overview
Explore in AI Chat

Overview

APPS.PA_LATEST_PROJ_TASK_PROG_V is an Oracle E-Business Suite internal database view owned by the APPS schema. It presents the latest published project and task progress information, joining project and task structure data with percent-complete records, progress rollup attributes, task statuses, and scheduling dates. Within the Projects (PA) module, the view is primarily intended to support the progress and performance reporting features of Oracle Projects, including the delivery of project, task, and progress status information to external interfaces and self-service pages. Oracle classifies this object as Internal and explicitly warns that it is for Oracle Internal Use Only; customer or third-party access is not supported except from standard Oracle Applications programs. The view is therefore not a supported integration surface, and any custom reporting built against it should be treated as subject to change across releases.

Underlying Base Objects

This view is defined over both synonyms and packaged code. The documented base objects include PA_PROJECTS_ALL (via synonym PA_PROJECTS), PA_PROJ_ELEMENTS, PA_PROJ_ELEMENT_VERSIONS, PA_PROJ_ELEM_VER_SCHEDULE, PA_PROJ_ELEM_VER_STRUCTURE, PA_PROJ_STRUCTURE_TYPES, PA_PROJ_PROGRESS_ATTR, PA_PROGRESS_ROLLUP, PA_PERCENT_COMPLETES, PA_PROJECT_STATUSES, and PA_TASK_TYPES, together with a PJI_FM_XBS_ACCUM_TMP1 synonym. Supporting PL/SQL packages referenced in the definition are PA_CURRENCY, PA_PROGRESS_UTILS, PA_PROJ_ELEMENTS_UTILS, and PA_RELATIONSHIP_UTILS. The progress and structure data derive mainly from the percent-complete and progress-rollup objects, while WBS hierarchy, task attributes, and scheduling dates are supplied by the project element and element-version objects. The join across PA_PROJ_ELEMENT_VERSIONS and PA_PROJ_ELEM_VER_STRUCTURE allows the view to navigate parent and child tasks and to return the element version that is current at the time of the row.

Key Columns

The view exposes a broad set of project, task, structure, and progress columns. Identifying columns include PROJECT_ID, PROJECT_NAME, PROJECT_NUMBER, LONG_NAME, TASK_ID, PROJ_ELEMENT_ID, PARENT_TASK_ID, ELEMENT_VERSION_ID, and PARENT_ELEMENT_VERSION_ID. Structure-oriented columns include TASK_NAME, TASK_NUMBER, WBS_LEVEL, WBS_NUMBER, OBJECT_TYPE, STRUCTURE_TYPE, SUMMARY_ELEMENT_FLAG, and the flags MILESTONE_FLAG, CRITICAL_FLAG, CURRENT_FLAG, PUBLISHED_FLAG, and LATEST_EFF_PUBLISHED_FLAG. Progress columns include PERCENT_COMPLETE_ID, AS_OF_DATE, PROGRESS_OVERVIEW, PROGRESS_COMMENT, PROGRESS_STATUS_CODE/NAME, SYSTEM_PROGRESS_STAT_CODE, STATUS_ICON_IND, COMPLETED_PERCENTAGE, and RECORD_VERSION_NUMBER. Scheduling columns include SCHEDULED_START_DATE, SCHEDULED_FINISH_DATE, ACTUAL_START_DATE, ACTUAL_FINISH_DATE, ESTIMATED_START_DATE, and ESTIMATED_FINISH_DATE. Quantity and effort measures exposed are PLANNED_WORK_QUANTITY, INCREMENTAL_WORK_QUANTITY, CUMULATIVE_WORK_QUANTITY, PLANNED_EFFORT, and ESTIMATED_REMAINING_EFFORT. The user search term "actual_work_quantity" does not map directly to a documented column name; the closest documented measures are the planned, incremental, and cumulative work quantity columns, with any actual work quantity being derived from cumulative work or percent-complete data rather than exposed under that exact name.

Common Use Cases and Queries

Typical reporting scenarios include listing the latest published progress for each project task, tracking WBS rollups, and retrieving completion percentages and status codes for a project as of a given date. The following queries illustrate typical access patterns.

  • Latest progress for a project's tasks:
    SELECT TASK_NUMBER, TASK_NAME, WBS_LEVEL, COMPLETED_PERCENTAGE, PROGRESS_STATUS_NAME
    FROM APPS.PA_LATEST_PROJ_TASK_PROG_V
    WHERE PROJECT_NUMBER = :project_number
    AND CURRENT_FLAG = 'Y'
    ORDER BY WBS_NUMBER;
  • Work and effort quantities for a task:
    SELECT TASK_NUMBER, PLANNED_WORK_QUANTITY, CUMULATIVE_WORK_QUANTITY, PLANNED_EFFORT, ESTIMATED_REMAINING_EFFORT
    FROM APPS.PA_LATEST_PROJ_TASK_PROG_V
    WHERE TASK_ID = :task_id;
  • Schedule variance view by task:
    SELECT TASK_NUMBER, SCHEDULED_START_DATE, SCHEDULED_FINISH_DATE, ESTIMATED_START_DATE, ESTIMATED_FINISH_DATE
    FROM APPS.PA_LATEST_PROJ_TASK_PROG_V
    WHERE PROJECT_ID = :project_id;

Because the view is documented as Oracle Internal Use Only, these queries should be used for diagnostic or reference purposes only; supported interface development should rely on published PL/SQL APIs and standard Oracle Applications programs.