Search Results cln_item_send_cust_xref_only

Overview

The view APPS.CLN_ITEMMST_ITEMHEADER_V is a custom Oracle E-Business Suite database object that presents a consolidated item master header record for outbound integration and reporting purposes. In Oracle EBS 12.1.1 and 12.2.2, it is owned by the APPS schema and is primarily associated with the CLN (custom) item synchronization framework, as evidenced by its dependency on CLN_SYNCITEM_PKG. The view joins the master item definition from MTL_SYSTEM_ITEMS_VL with customer item cross-references, item revisions, and hazard class translations, producing a single flattened row per inventory item that is enabled for customer orders.

A defining characteristic of this view is its dependence on the profile option CLN_ITEM_SEND_CUST_XREF_ONLY. When this profile is set to Y, the view returns only items that have a populated customer item number in the cross-reference; when the profile is N or unset, all qualifying items are returned regardless of customer cross-reference. This makes the view the principal extraction surface for the specific search term "cln_item_send_cust_xref_only," which controls the filtering behavior of the item transmission process.

Underlying Base Objects

The view is defined over the following documented base objects:

• MTL_SYSTEM_ITEMS_VL — the item master, supplying core item attributes, inventory flags, and descriptive flexfield columns.
• MTL_CUSTOMER_ITEM_XREFS_V — the customer item cross-reference view, joined with the outer (+) operator so items without a cross-reference are still eligible unless the profile restricts them.
• MTL_ITEM_REVISIONS (synonym) — provides revision data; the view restricts to the latest revision via a correlated subquery on MAX(revision).
• PO_HAZARD_CLASSES_TL (synonym) — the hazard class translation table, joined by hazard_class_id and language.
• CLN_SYNCITEM_PKG — supplies get_cust_acct_id(), which binds the cross-reference join to the current customer account.
• FND_PROFILE — returns the runtime value of CLN_ITEM_SEND_CUST_XREF_ONLY used in the WHERE clause.
• ARP_ADDR_PKG — referenced by the dependent packaging for address resolution.

The view inherits filtering from its base: only items with service_item_flag = 'N', inventory_item_flag = 'Y', and customer_order_enabled_flag = 'Y' are exposed.

Key Columns

• inventory_item_id and organization_id — the unique item and organization keys.
• concatenated_segments — the concatenated item segment string (the user-visible item number).
• description (aliased item_description) — the item description.
• primary_uom_code, item_type, bom_item_type, inventory_item_status_code — core inventory classification fields.
• customer_item_number and customer_id — the customer cross-reference, central to the CLN_ITEM_SEND_CUST_XREF_ONLY logic.
• revision and effectivity_date — the latest item revision and its effectivity.
• hazard_class — translated hazard classification.
• unit_weight, unit_volume, unit_length, unit_width, unit_height, and their UOM codes — physical dimensional attributes.
• attribute1 through attribute15 and attribute_category — descriptive flexfield data.

Common Use Cases and Queries

Typical use is validating which items will be transmitted under a given profile setting, or extracting the customer-facing item header payload. To respect the profile behavior, the view may simply be queried directly:

• SELECT inventory_item_id, concatenated_segments, item_description, customer_item_number FROM apps.cln_itemmst_itemheader_v;
• To inspect cross-reference-only behavior explicitly: SELECT concatenated_segments, customer_item_number FROM apps.cln_itemmst_itemheader_v WHERE customer_item_number IS NOT NULL;
• To review dimensional data for logistics integration: SELECT concatenated_segments, unit_weight, weight_uom_code, unit_volume, volume_uom_code FROM apps.cln_itemmst_itemheader_v;
• To audit revisions: SELECT concatenated_segments, revision, effectivity_date FROM apps.cln_itemmst_itemheader_v;

Because the view references FND_PROFILE.VALUE and CLN_SYNCITEM_PKG, results are session- and profile-dependent; the effective row set changes with the CLN_ITEM_SEND_CUST_XREF_ONLY setting and the customer context returned by the package.