Results for “pa_items_res_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.PA_ITEMS_RES_V view is a Projects (PA) module reporting object in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents a denormalized, joined list of inventory items together with the name of the inventory organization that owns each item. The view is defined over MTL_SYSTEM_ITEMS and HR_ALL_ORGANIZATION_UNITS_VL, resolving the raw ORGANIZATION_ID foreign key into a human-readable organization name. Its primary role is to support Projects reporting and integration where an item must be displayed or processed alongside its owning organization description, sparing the caller from performing the join manually. Because the view is stored in the APPS schema and remains VALID, it can be referenced directly by custom reports, concurrent programs, and interface extracts. The documented view text is:

SELECT ITEMS.INVENTORY_ITEM_ID, ITEMS.DESCRIPTION, ITEMS.ORGANIZATION_ID, ORG.NAME FROM MTL_SYSTEM_ITEMS ITEMS, HR_ALL_ORGANIZATION_UNITS_VL ORG WHERE ORG.ORGANIZATION_ID = ITEMS.ORGANIZATION_ID

Notably, the user search term hr_all_organization_units_vl corresponds exactly to the organizational base object underlying this view, confirming that PA_ITEMS_RES_V is the documented consumption point for organization-unit data in the Projects item context.

Underlying Base Objects

The ETRM 12.2.2 metadata identifies two referenced base objects:

• HR_ALL_ORGANIZATION_UNITS_VL (VIEW) — the organization definition view, providing ORGANIZATION_ID and the translated NAME used as ORGANIZATION_NAME in the output.
• MTL_SYSTEM_ITEMS (SYNONYM) — the item master, providing the item key, description, and owning organization identifier.

The join is an equi-join on ORGANIZATION_ID between the item master and the organization unit view. Because HR_ALL_ORGANIZATION_UNITS_VL is a _VL (multi-language) view, the organization name returned is language-dependent and respects the session's NLS language setting. The synonym MTL_SYSTEM_ITEMS resolves to the underlying inventory item master in the INV schema. Only rows where an item's ORGANIZATION_ID matches an existing organization unit are returned, so items referencing invalid or missing organizations are silently excluded.

Key Columns

• ITEM_ID — aliases ITEMS.INVENTORY_ITEM_ID; the surrogate primary key of the inventory item.
• DESCRIPTION — the item description from MTL_SYSTEM_ITEMS.
• ORGANIZATION_ID — the inventory organization identifier from the item master; the join key to the organization view.
• ORGANIZATION_NAME — the translated organization NAME from HR_ALL_ORGANIZATION_UNITS_VL, presented as a readable label.

Common Use Cases and Queries

Typical scenarios include Projects item validation reports, item-to-organization lookup extracts, and LOV-style queries. A representative query returning organization descriptions for a set of items:

SELECT ITEM_ID, DESCRIPTION, ORGANIZATION_ID, ORGANIZATION_NAME FROM APPS.PA_ITEMS_RES_V WHERE ITEM_ID = :p_item_id;

To list all items belonging to a named organization:

SELECT ITEM_ID, DESCRIPTION FROM APPS.PA_ITEMS_RES_V WHERE ORGANIZATION_NAME = :p_org_name ORDER BY DESCRIPTION;

Because the view performs no filtering beyond the inner join, callers should apply their own predicates, and be aware that the name column is subject to NLS language selection through the _VL base object.