Search Results opsm_integrated_flag




Overview
Explore in AI Chat

Overview

APPS.WSH_OPSM_ASN_ITEM_GENEALOGY_V is a reporting and integration view within the Oracle E-Business Suite Warehouse Management (WSH) and Order Processing / Shipping Management (OPSM) modules. It exposes the item genealogy hierarchy associated with Advance Shipping Notice (ASN) delivery details, allowing consumers to traverse parent-child relationships between lots, serial numbers, and inventory items that flow through a shipment. In Oracle EBS 12.1.1 and 12.2.2, this view serves as the presentation layer over the packaged genealogy logic held in WSH_OPSM_ASN_ITEM_GENEALOGY, translating a pipelined table function into a relational result set that can be queried with standard SQL.

The view is particularly relevant to users searching on opsm_integrated_flag, which is exposed here as a renamed alias. The flag communicates whether a given genealogy record has been integrated with the OPSM (Oracle Process / Product Serialization Management) tracking substrate, giving downstream reporting and external integrations a straightforward indicator of consolidation status.

Underlying Base Objects

The documented metadata identifies three base objects on which the view depends:

The view is therefore a lightweight wrapper: it joins the ASN item detail view to the pipelined genealogy function and renames the CROSS_REFERENCE column to OPSM_INTEGRATED_FLAG for clarity in reporting contexts.

Key Columns

Common Use Cases and Queries

Typical scenarios include tracing the full lot/serial ancestry of items shipped on an ASN, auditing which genealogy records have been OPSM-integrated, and feeding serialization or compliance reporting.

Example — list integration status for a delivery:

SELECT delivery_id,
       delivery_detail_id,
       item_number,
       serial_number,
       lot_number,
       rlevel,
       opsm_integrated_flag
FROM   apps.wsh_opsm_asn_item_genealogy_v
WHERE  delivery_id = :p_delivery_id
ORDER  BY rlevel, serial_number;

Example — isolate nodes pending integration:

SELECT delivery_id, serial_number, lot_number
FROM   apps.wsh_opsm_asn_item_genealogy_v
WHERE  opsm_integrated_flag IS NULL
   OR  opsm_integrated_flag = 'N';