Search Results priority_sort




Overview
Explore in AI Chat

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:

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:

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.