Search Results icx_edm_key_member_proj_v




Overview
Explore in AI Chat

Overview

The APPS.ICX_EDM_KEY_MEMBER_PROJ_V view is a reporting object within the Oracle iProcurement (ICX) module of Oracle E-Business Suite. It presents a consolidated "Project Information Summary by Key Member," joining project master data with the persons designated as project players and the organizations that carry out the project. The view is part of the EDM (Enterprise Data Management) family of views used by iProcurement to surface descriptive and status information about projects during requisition entry, shopping, and related purchasing flows. It is documented as VALID and owned by the APPS schema in both EBS 12.1.1 and 12.2.2.

The view is primarily a descriptive lookup rather than a transactional object. It exposes project identity, organization, type, status, dates, and key member identity so that iProcurement screens and downstream integrations can render meaningful project context without querying the underlying PA and HR tables directly. Because project and member data change frequently, the view is queried at runtime rather than being materialized.

Underlying Base Objects

The view is defined over several base objects across the Projects (PA), Human Resources (HR), and PeopleSoft-derived (PER) schemas:

The join condition couples PROJ.PROJECT_ID to PLAYER.PROJECT_ID and PLAYER.PERSON_ID to KMEM.PERSON_ID, with DISTINCT applied to collapse duplicate player rows.

Key Columns

Several columns in the view SELECT list, such as PROJECT_CATEGORY and LAST_ACCUMULATED_PERIOD, are output as NULL placeholders, indicating they are reserved for display columns but not populated by the current join.

Common Use Cases and Queries

Typical usage centers on presenting project and status information to iProcurement users and to integrations that need project status and owner context. A representative query filtering on the display status is:

  • SELECT project_number, project_name, key_member_name, status_dsp, project_start_date FROM apps.icx_edm_key_member_proj_v WHERE status_dsp = 'Approved';
  • Restricting to a single key member: ... WHERE key_member_id = :person_id;
  • Restricting to an organization: ... WHERE project_organization_id = :org_id;

Because the view already applies DISTINCT and filters template projects, callers do not need to repeat those predicates. It is most valuable where a concise, member-oriented project status lookup is required rather than full project accounting detail.