Search Results cum_key_id




Overview
Explore in AI Chat

Overview

RLM_CUM_SHIP_DETAILS_V is an APPS-owned reporting and integration view in the Oracle E-Business Suite Release Management (RLM) module. It presents cumulative shipment detail records associated with customer item cumulative keys, joining shipment line information from Order Management with the cumulative key header and user audit data. The view is a denormalized projection intended for consumption by downstream Release Management processes, custom reports, and interface programs that require shipment-level quantities and destination/organization context keyed by a customer item cumulative key.

The view exposes both transactional shipment metrics — quantity, unit of measure, transaction date, and shipment number — and the full set of DFF attribute columns carried from the underlying order line. It is typically queried by planners, shipping analysts, and integration routines reconciling cumulative shipped quantities against customer item cumulative agreements.

Underlying Base Objects

The view is defined over three documented base objects:

The join condition is CKEYS.CUM_KEY_ID = LINES.VEH_CUS_ITEM_CUM_KEY_ID AND FUSER.USER_ID = LINES.LAST_UPDATED_BY, so only order lines carrying a cumulative key reference are returned. Because the view references OE_ORDER_LINES_ALL, it inherits the multi-org (operating unit) nature of that table; the *_ORG_ID columns identify the shipping, receiving, invoicing, and intermediate ship-to organizations.

Key Columns

Common Use Cases and Queries

Typical uses include reconciling shipped quantities per cumulative key, reporting shipments by intermediate ship-to organization, and feeding interfaces that need audit and DFF context alongside shipment facts.

Query cumulative shipments for a specific cumulative key:

SELECT cum_key_id, shipment_number, txn_date, txn_quantity,
       quantity_uom, ship_from_org_id, ship_to_org_id
FROM   apps.rlm_cum_ship_details_v
WHERE  cum_key_id = :p_cum_key_id
ORDER BY txn_date;

Query by intermediate ship-to organization (matching the user's search on intmed_ship_to_org_id):

SELECT cum_key_id, shipment_number, txn_date, txn_quantity,
       ship_to_org_id, intmed_ship_to_org_id, last_shipped_by
FROM   apps.rlm_cum_ship_details_v
WHERE  intmed_ship_to_org_id = :p_intmed_ship_to_org_id;

Aggregate shipped quantity by cumulative key and item:

SELECT cum_key_id, inventory_item_id, quantity_uom,
       SUM(txn_quantity) total_shipped, MAX(txn_date) last_ship_date
FROM   apps.rlm_cum_ship_details_v
GROUP BY cum_key_id, inventory_item_id, quantity_uom;