Results for “pa_task_priority_code”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.PA_LAUNCH_PAGE_OBJECTS_TM_V is a read-only Oracle E-Business Suite view owned by the APPS schema and registered under FND Design Data as PA.PA_LAUNCH_PAGE_OBJECTS_TM_V. It supports the Project Management launch page infrastructure, presenting a consolidated, denormalized row per project object (tasks, deliverables, and control items) for display in Oracle Projects dashboards and worklists. The view's status is VALID, and its view type is classified as Internal. Oracle explicitly flags the object with the warning that it is for Oracle Internal Use Only and that direct data access is unsupported except from standard Oracle Applications programs.

The row context centers on the query token "days_until_due," which maps directly to the DAYS_UNTIL_DUE column. This numeric column is a derived scheduling metric that expresses the difference between the record's DUE_DATE and its associated AS_OF_DATE, enabling the launching page to surface overdue or imminently due tasks and deliverables without client-side calculation. Because the view materializes owner, status, priority, progress, and schedule attributes together, it functions as a single integration and reporting source for project object tracking in EBS 12.1.1 and 12.2.2.

Underlying Base Objects

The view is defined over a documented set of base objects spanning project structures, control items, lookups, and PL/SQL utility packages:

• HZ_PARTIES, providing owner party and party identifier data.
• PA_CONTROL_ITEMS, PA_CI_TYPES_B, and PA_CI_TYPES_TL, supplying control item records and their class/type descriptions.
• PA_PROJECTS_ALL and PA_PROJECT_STATUSES, supplying project identity and system status.
• PA_PROJ_ELEMENTS, PA_PROJ_ELEMENT_VERSIONS, and PA_PROJ_ELEM_VER_SCHEDULE, providing structure element versions and their schedule attributes, including due dates.
• PA_PERCENT_COMPLETES and PA_PROJ_ELEMENTS_UTILS, PA_PROJECT_STRUCTURE_UTILS, PA_DELIVERABLE_UTILS, which drive derived progress, hierarchy, and deliverable logic.
• PA_TASK_TYPES and PA_LOOKUPS, resolving descriptive values and icons.

These objects are referenced through APPS synonyms and utility packages, which are invoked to compute denormalized attributes such as progress overview, owner name, and days until due.

Key Columns

The view exposes identity, classification, ownership, status, priority, and schedule columns. Notable items include:

• OBJECT_ID, OBJECT_VERSION_ID, STRUCTURE_VERSION_ID: object and version identifiers.
• CLASS_CODE, CLASS_NAME, TYPE: object classification and type descriptors.
• OBJECT_NAME, OBJECT_NUMBER, SUBJECT: descriptive identification.
• PROJECT_ID, PROJECT_NAME, PROJECT_NUMBER, TASK_ID, TASK_NAME, TASK_NUMBER: project and task context.
• OWNER_NAME, OWNER_PARTY_ID: assignment and ownership.
• STATUS_NAME, SYSTEM_STATUS_CODE, STATUS_ICON, PROGRESS_STATUS_NAME, PROGRESS_STATUS_ICON, PROGRESS_OVERVIEW: workflow and progress state.
• PRIORITY, PRIORITY_SORT: priority label and numeric sort key.
• DUE_DATE, DAYS_UNTIL_DUE, START_DATE, COMPLETION_DATE, AS_OF_DATE: scheduling and the derived days-until-due metric.
• PERCENT_COMPLETE, TASKS_FOR_DELIVERABLES: completion percentage and deliverable association.

Common Use Cases and Queries

Typical usage includes project manager worklists, aging or overdue analysis, and integration feeds requiring combined task and deliverable status. A representative query for overdue items:

• SELECT OBJECT_NAME, PROJECT_NAME, TASK_NAME, DUE_DATE, DAYS_UNTIL_DUE, STATUS_NAME FROM APPS.PA_LAUNCH_PAGE_OBJECTS_TM_V WHERE DAYS_UNTIL_DUE < 0 ORDER BY DAYS_UNTIL_DUE;
• SELECT OBJECT_ID, OBJECT_NAME, PROGRESS_STATUS_NAME, PERCENT_COMPLETE FROM APPS.PA_LAUNCH_PAGE_OBJECTS_TM_V WHERE PROJECT_ID = :p_project_id;
• SELECT * FROM APPS.PA_LAUNCH_PAGE_OBJECTS_TM_V WHERE DAYS_UNTIL_DUE BETWEEN 0 AND 7 ORDER BY PRIORITY_SORT, DAYS_UNTIL_DUE;

Because the object is Internal, such queries should be reserved for diagnostics or supported extension points rather than production customizations.