Search Results project_description




Overview
Explore in AI Chat

Overview

ICX_EDM_CUSTOMER_PROJ_V is a reporting view shipped within the Oracle iProcurement (ICX) product family in Oracle EBS 12.1.1 and 12.2.2. Its documented purpose is to present a "Project Information Summary View by Customer," exposing a denormalized, customer-centric projection of Oracle Projects data alongside related receivables and sales information. The view is intended for use by iProcurement and related EDM (Enterprise Data Management) reporting components that require a flat, query-friendly list of projects associated with customers.

The ETRM metadata notes that the object is "Not implemented in this database," meaning the view definition ships with the product but may not be instantiated in every deployment. Administrators verifying its presence should query ALL_VIEWS or DBA_VIEWS before relying on it. The user's search term "so_headers" is relevant because the second branch of the view's UNION references SO_HEADERS directly.

Underlying Base Objects

The view is defined over the following base tables, as documented in the view text:

The view is a UNION of two SELECT statements. The first joins PA_PROJECT_CUSTOMERS to PA_PROJECTS_ALL, filtering out templates (TEMPLATE_FLAG != 'Y'). The second joins SO_LINES to SO_HEADERS via HEADER_ID and then to projects, so projects reachable only through sales orders are also returned. Outer joins (+) on HR_ORGANIZATION_UNITS, RA_SALESREPS, and the second branch's organization indicate the view tolerates missing organization or salesperson data. Note the SO_HEADERS branch is the reason a search for "so_headers" surfaces this object.

Key Columns

The view exposes a consistent column list across both UNION branches. Principal columns include:

A literal NULL column appears after ORGANIZATION_NAME, and the second branch supplies TO_NUMBER(NULL) for the billing split, preserving column parity across the UNION.

Common Use Cases and Queries

Typical uses include iProcurement project selection by customer, cross-referencing sales orders to projects, and reporting on projects by salesperson or organization. A simple query:

SELECT project_number, project_name, customer_name, salesperson FROM icx_edm_customer_proj_v WHERE customer_name = :cust;

To find projects linked via sales orders, join SO_HEADERS separately on CUSTOMER_ID, since the view collapses that linkage. Always validate existence with DBA_VIEWS given the "not implemented" note.