Search Results dlvr_completed

Overview

APPS.PA_DLVR_ACTIONS_AMG_V is a Projects (PA) module view that presents deliverable-linked project actions — records stored in PA_PROJ_ELEMENTS with OBJECT_TYPE = 'PA_ACTIONS' — together with the deliverable to which each action is related. Its principal purpose is to denormalize the association between a project action and its parent deliverable by joining through PA_OBJECT_RELATIONSHIPS using the relationship subtype 'DELIVERABLE_TO_ACTION'. This makes the view suitable for reporting and integration scenarios where the consumer needs, in a single row, the action's identifying attributes, its scheduling dates, its assigned manager, its functional classification, and the deliverable it serves.

The user search term "dlvr_completed" corresponds directly to a documented element of this view. The STATUS_CODE of the action element is evaluated with a DECODE expression that returns 'Y' when the status code equals 'DLVR_COMPLETED' and 'N' otherwise. This derived flag allows report authors and interfaces to test whether a deliverable action has reached its completed state without hard-coding the underlying lookup value in downstream queries. The view is defined in the APPS schema and is available in both Oracle EBS 12.1.1 and 12.2.2.

Underlying Base Objects

The view is defined over six documented base objects. The driving table is PA_PROJ_ELEMENTS, aliased PPE, whose rows are restricted to actions via OBJECT_TYPE = 'PA_ACTIONS'. PA_PROJ_ELEMENTS is joined to PA_PROJ_ELEMENT_VERSIONS (PPV) on both PROJ_ELEMENT_ID and PROJECT_ID, and PPV is joined to PA_PROJ_ELEM_VER_SCHEDULE (PSC) on ELEMENT_VERSION_ID to obtain scheduled and actual finish dates. PA_OBJECT_RELATIONSHIPS (OBJ) supplies the linkage between the action and its deliverable through OBJECT_ID_TO2 and the relationship constraints TYPE = 'A' and SUBTYPE = 'DELIVERABLE_TO_ACTION'. PER_ALL_PEOPLE_F (PPF) is outer-joined on MANAGER_PERSON_ID, with an effective-date range test against SYSDATE, so actions without a valid manager record are still returned. A second instance of PA_PROJ_ELEMENTS, aliased DLV, is joined on OBJECT_ID_FROM2 and PROJECT_ID with OBJECT_TYPE = 'PA_DELIVERABLES' to expose the deliverable's name and element number. The package PA_PROJ_ELEMENTS_UTILS is invoked to translate FUNCTION_CODE into its lookup meaning.

Key Columns

• PROJ_ELEMENT_ID, NAME, DESCRIPTION — the action's primary identifier and descriptive attributes.
• STATUS_CODE derived flag — DECODE(STATUS_CODE,'DLVR_COMPLETED','Y','N'), the completion indicator associated with the user's search term.
• FULL_NAME, MANAGER_PERSON_ID — the action's responsible manager, sourced from PER_ALL_PEOPLE_F.
• SCHEDULED_FINISH_DATE, ACTUAL_FINISH_DATE — schedule milestone dates from PA_PROJ_ELEM_VER_SCHEDULE.
• FUNCTION_CODE and its lookup meaning — the action's functional classification via the PA_DLVR_ACTION_FUNCTION lookup.
• OBJECT_ID_FROM2 — the deliverable identifier linked through PA_OBJECT_RELATIONSHIPS.
• DLV.NAME, DLV.ELEMENT_NUMBER — the deliverable's name and number.
• RECORD_VERSION_NUMBER, PM_SOURCE_CODE, PM_SOURCE_REFERENCE, PROJECT_ID — concurrency control and source/project context.

Common Use Cases and Queries

Typical uses include deliverable action worklists, completion tracking, and status extracts feeding integrations. To list completed actions with their deliverable, the derived flag is queried directly:

• SELECT name, dlv_name, actual_finish_date FROM apps.pa_dlvr_actions_amg_v WHERE status_flag = 'Y';

More precisely, filtering by the decode expression: SELECT proj_element_id, name, dlv_name FROM apps.pa_dlvr_actions_amg_v WHERE decode(status_code,'DLVR_COMPLETED','Y','N') = 'Y'. Because the view does not alias every projected expression, report authors should reference the underlying column names (STATUS_CODE, DLV.NAME) or wrap the view in an inline query with explicit aliases to avoid ambiguity. The view is also suited to project-level rollups by grouping on PROJECT_ID and FUNCTION_CODE, and to integration extracts that require action-to-deliverable mappings through DELIVERABLE_TO_ACTION.