Search Results item_org_item_id

Overview

The view RHX_DP_R_ITEM_ITEMORG_V is a custom reporting object associated with the Oracle E-Business Suite MRP – Master Scheduling/MRP product family. According to the ETRM documentation for release 12.2.2, it is classified as "Retrofitted," indicating that it was introduced or carried forward as part of a retrofitting exercise rather than delivered as standard Oracle functionality. The documentation further notes that the object is "Not implemented in this database," meaning the view exists in the metadata registry but was not instantiated in the environment from which the documentation was generated. This status is common for custom or site-specific reporting artifacts that are created on demand in target instances.

Functionally, the view flattens the association between a stocked inventory item and the inventory organization in which it is defined. This item–organization relationship (commonly referred to in Oracle EBS as the "item/org" assignment) is central to supply chain planning, since master scheduling and MRP processes operate on items only within the organizations where they are enabled. The view therefore serves as a lightweight reporting and integration surface for retrieving the concatenated item identifier alongside its organization context.

Underlying Base Objects

The documented view text is defined over two sources:

• MTL_SYSTEM_ITEMS_KFV — the key flexfield view over MTL_SYSTEM_ITEMS_B, which exposes the item's CONCATENATED_SEGMENTS (the user-facing item number assembled from the item key flexfield).
• RHX_DP_L_ITEMORG_V — a custom companion view (the "L" variant in the same naming family) supplying the item–organization linkage columns.

The join is performed on both INVENTORY_ITEM_ID and ORGANIZATION_ID, ensuring that only valid item/org combinations are returned. ETRM lists no documented referenced base tables beyond these, and the owner field is blank, consistent with a non-seeded, custom object.

Key Columns

• ITEM — the concatenated item flexfield segments from MTL_SYSTEM_ITEMS_KFV, i.e., the descriptive item number.
• ITEM_ORG — the organization identifier associated with the item/org assignment, supplied by RHX_DP_L_ITEMORG_V. This is the column most directly related to the user's search term item_org_organization_id.
• ITEM_ORG_ITEM_ID — the inventory item identifier for the assignment row (internally the surrogate INVENTORY_ITEM_ID).
• ITEM_ORG_ORGANIZATION_ID — the organization identifier for the assignment, mapping to ORGANIZATION_ID.

Note that the projected view text aliases the underlying INVENTORY_ITEM_ID and ORGANIZATION_ID into the ITEM_ORG_* naming convention, which aligns the output with the item/org assignment terminology used in planning and inventory reporting.

Common Use Cases and Queries

Typical applications include MRP data extracts, item/org validation reports, and integration staging into planning or warehouse systems. A representative query joining item master details and filtering by organization is:

• SELECT item, item_org, item_org_item_id, item_org_organization_id FROM rhx_dp_r_item_itemorg_v WHERE item_org_organization_id = :org_id;
• SELECT v.item, v.item_org FROM rhx_dp_r_item_itemorg_v v WHERE v.item = :item_number;

Because the view is documented as not implemented, DBAs should verify its existence in each target instance before referencing it in reports or interfaces.