Search Results task_unpub_ver_status_code




Overview
Explore in AI Chat

Overview

PA_STRUCT_TASKS_LITE_V is an APPS-owned database view in the Oracle E-Business Suite Projects (PA) module, valid in both 12.1.1 and 12.2.2. It exposes a flattened, consolidated projection of project structures and their constituent tasks, joining structure versions and task versions into a single rowset so that callers do not need to navigate the multi-table PA_PROJ_ELEMENTS / PA_PROJ_ELEMENT_VERSIONS model directly. The view is "lite" in the sense that it returns only the columns required by structural navigation and progress-entry clients, omitting the heavier descriptive and attribute columns carried by the base entity tables.

The object is primarily consumed by Oracle's own Projects forms, Tree/Navigator components, and web services that render a project's WBS tree and determine whether a given task node accepts progress or expenditure entry. The TASK_UNPUB_VER_STATUS_CODE column the user searched for is one of its distinguishing attributes: it surfaces the publication status of an unpublished task version, allowing a caller to distinguish drafts or unapproved task revisions from those already published to the structure version. The view preserves the display ordering of the tree through DISPLAY_SEQUENCE and WBS_LEVEL, and is therefore well suited to ordered report output and to integration extracts that must reproduce the on-screen project hierarchy.

Underlying Base Objects

The documented base objects referenced by the view are PA_LOOKUPS (view), PA_OBJECT_RELATIONSHIPS, PA_PROJ_ELEMENTS, PA_PROJ_ELEMENT_VERSIONS, and PA_TASK_TYPES. The definition is a UNION ALL of two branches:

Both branches filter LINK_TASK_FLAG <> 'Y', excluding linked (borrowed) tasks so that only native structure and task elements appear. Only PA_TASK_TYPES rows with OBJECT_TYPE = 'PA_TASKS' qualify. PA_LOOKUPS is included as a reference object for decoded lookup values used by the view's consumers.

Key Columns

  • ELEMENT_NUMBER — user-visible element identifier (alias of the structure/task number).
  • ELEMENT_VERSION_ID — version surrogate key; the principal join key to relationships and child objects.
  • OBJECT_TYPE — discriminates rows: PA_TASKS for task rows, PA_STRUCTURES for structure rows.
  • DISPLAY_PARENT_VERSION_ID / PARENT_STRUCTURE_VERSION_ID — parent version pointers; the latter locates the row within its structure version. OBJECT_ID_FROM1 carries the structural parent from PA_OBJECT_RELATIONSHIPS for task rows and NULL for structure rows.
  • PROJECT_ID, PROJ_ELEMENT_ID, ELEMENT_NAME — project context and element identity.
  • DISPLAY_SEQUENCE, WBS_NUMBER, WBS_LEVEL — ordering and hierarchy depth used to render the tree.
  • FINANCIAL_TASK_FLAG — indicates whether the task is a financial (chargeable) task.
  • TASK_UNPUB_VER_STATUS_CODE — status code of the unpublished task version, used to identify tasks with pending/draft revisions.
  • PROG_ENTRY_ENABLE_FLAG — derived from PA_TASK_TYPES; indicates whether progress entry is permitted for the task ('Y' for all structure rows).
  • TASK_STATUS_CODE — the element's STATUS_CODE (e.g. approved, unapproved, cancelled).

Common Use Cases and Queries

Typical consumers retrieve the ordered WBS for a project, filter to chargeable tasks, or audit unpublished task versions. A representative query:

  • Select PROJECT_ID, ELEMENT_VERSION_ID, WBS_NUMBER, TASK_UNPUB_VER_STATUS_CODE, TASK_STATUS_CODE from PA_STRUCT_TASKS_LITE_V where PROJECT_ID = :p_project_id order by DISPLAY_SEQUENCE.
  • Isolate chargeable tasks: add AND FINANCIAL_TASK_FLAG = 'Y' AND OBJECT_TYPE = 'PA_TASKS'.
  • Find tasks pending publication: WHERE TASK_UNPUB_VER_STATUS_CODE IS NOT NULL.
  • Scope progress-entry eligibility: WHERE PROG_ENTRY_ENABLE_FLAG = 'Y'.

Because the view is owned by APPS, callers should query it as APPS or via a synonym with appropriate grants. Its UNION ALL design means structure rows and task rows are both returned; consumers should branch on OBJECT_TYPE when parent or task-type attributes are required.