Search Results site_use_meaning




Overview
Explore in AI Chat

Overview

RLM_CUM_SITE_USES_V is a reporting and integration view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the RLM (Release Management) product family. Its purpose is to expose the relationship between customer site uses and the cumulative organization levels configured in RLM shipping terms. Specifically, the view returns active ship-to, bill-to, and deliver-to site uses for customer addresses that have been associated with a ship-from organization through RLM_CUST_SHIPTO_TERMS. It is valid in both Oracle EBS 12.1.1 and 12.2.2.

This view is principally consumed by Release Management logic and by reporting that needs to resolve the "site_use_meaning" for a customer site in the context of cumulative shipping terms. Rather than requiring report authors to join AR_LOOKUPS, RA_SITE_USES, and RLM_CUST_SHIPTO_TERMS manually, the view pre-joins these and restricts results to the three cumulative organization level codes relevant to RLM: SHIP_TO_SHIP_FROM, BILL_TO_SHIP_FROM, and DELIVER_TO_SHIP_FROM.

Underlying Base Objects

The documented base objects referenced by this view in ETRM 12.2.2 are AR_LOOKUPS (VIEW), HZ_CUST_ACCT_SITES_ALL (SYNONYM), HZ_CUST_SITE_USES_ALL (SYNONYM), HZ_LOCATIONS (SYNONYM), HZ_PARTY_SITES (SYNONYM), and RLM_CUST_SHIPTO_TERMS (SYNONYM). The view text itself resolves to AR_LOOKUPS, RA_ADDRESSES, AR_LOOKUPS, and RA_SITE_USES plus RLM_CUST_SHIPTO_TERMS, which are the TCA/AR public synonyms over the HZ tables.

  • RLM_CUST_SHIPTO_TERMS – Stores the cumulative organization level mapping (customer address to ship-from organization) that drives the view's filter.
  • RA_SITE_USES (HZ_CUST_SITE_USES_ALL) – Supplies the active site uses, including SITE_USE_ID, SITE_USE_CODE, ADDRESS_ID, and STATUS.
  • RA_ADDRESSES / HZ_LOCATIONS – Supplies LOCATION, CITY, and STATE fields for the address.
  • AR_LOOKUPS – Resolves SITE_USE_CODE into the human-readable SITE_USE_MEANING.

Key Columns

  • ROW_ID – The ROWID of the underlying RA_SITE_USES row; useful for uniquely identifying a site use.
  • SITE_USE_ID – Primary key identifier of the site use; this is the join key to other customer-site-based objects.
  • CUSTOMER_ID – The customer (party) associated with the site use.
  • ADDRESS_ID – Identifier of the customer address record.
  • LOCATION – The free-form address line (location) description of the site.
  • CITY, STATE – Geographic attributes of the address.
  • SITE_USE_CODE – The lookup code for the site use (for example SHIP_TO, BILL_TO, DELIVER_TO).
  • SITE_USE_MEANING – The translated meaning of the site use code retrieved from AR_LOOKUPS for LOOKUP_TYPE = 'SITE_USE_CODE'. This is the column most frequently searched by users (site_use_meaning).
  • CUM_ORG_LEVEL_CODE – The RLM cumulative organization level code, constrained to SHIP_TO_SHIP_FROM, BILL_TO_SHIP_FROM, or DELIVER_TO_SHIP_FROM.

Common Use Cases and Queries

A typical reporting use is to list all active site uses for a given customer address together with the meaning and cumulative level.

SELECT site_use_id, customer_id, address_id,
       city, state, site_use_code, site_use_meaning,
       cum_org_level_code
FROM   apps.rlm_cum_site_uses_v
WHERE  customer_id = :p_customer_id
ORDER  BY cum_org_level_code, site_use_meaning;

Another common pattern is to drive RLM shipping documentation by filtering on cumulative level:

SELECT customer_id, address_id, site_use_meaning
FROM   apps.rlm_cum_site_uses_v
WHERE  cum_org_level_code = 'SHIP_TO_SHIP_FROM'
AND    site_use_code = 'SHIP_TO';

Because the view already restricts rows to active (STATUS = 'A') site uses and to the three RLM cumulative levels, it is safe to use directly in concurrent programs, BI Publisher data templates, and integration extracts without additional status filtering. Note that the synonyms resolve to the HZ/AR base tables under the TCA model in 12.2.2, so the view returns the current, multi-org-aware customer site data used by Release Management.