Search Results get_end_customer_id

Overview

OE_ITORD_UTIL is a utility package in the APPS schema of Oracle E-Business Suite that supports item orderability validation and the maintenance of order-related data used by the Oracle Order Management (OM) module. The package is classified as a UTIL API and is documented as VALID in the ETRM repository for both 12.1.1 and 12.2.2. Its primary responsibility is to evaluate whether a given item may be ordered under a specific set of sales, customer, and organizational conditions, and to retrieve the various identifiers and attribute values required to perform that evaluation. In this capacity it serves as a shared internal library consumed by other Order Management packages and by materialized view definitions rather than as a standalone user-facing API.

The package depends on OE_ORDER_PUB, the canonical public API for order creation and maintenance, and on the SYS.STANDARD package. It is referenced by six other packages and objects, including OE_BULK_PROCESS_LINE, OE_ITORD_PUB, OE_LINE_UTIL, OE_VALIDATE_LINE, and the materialized views OE_ITEMS_ORD_MV and OE_RELATED_ITEMS_MV. This dependency profile confirms that it occupies a lower tier in the Order Management code stack — called by line validation, bulk processing, and item-orderability publication logic.

Key Procedures and Functions

The ETRM metadata documents 32 procedures and functions within the package. Among the data-maintenance routines are INSERT_ROW and UPDATE_ROW, which manage records in the package's supporting structures, and REFRESH_MATERIALIZED_VIEW, which triggers a refresh of the item-orderability related materialized views. CHECK_DUPLICATE_RULES and SET_GLOBALS provide rule de-duplication checking and session-level global initialization respectively.

A substantial group of functions is dedicated to resolving identifiers and codes from the surrounding order context. These include GET_CUSTOMER_ID, GET_CUSTOMER_CLASS_ID, GET_CUSTOMER_CATEGORY_CODE, GET_REGION_IDS, GET_ORDER_TYPE_ID, GET_SHIP_TO_ORG_ID, GET_SALES_CHANNEL_CODE, GET_SALESREP_ID, GET_END_CUSTOMER_ID, GET_INVOICE_TO_ORG_ID, GET_DELIVER_TO_ORG_ID, GET_OPERATING_UNIT_ID, GET_ITEM_VALIDATION_ORG_ID, and GET_ITEM_CATEGORY_ID. Collectively, these accessors assemble the qualification attributes that item-orderability rules are evaluated against.

The validation entry point is VALIDATE_ITEM_ORDERABILITY, which applies the retrieved context against the configured orderability rules. INSERT_ROW and UPDATE_ROW handle persistence of rule or configuration records, while SET_GLOBALS and CHECK_DUPLICATE_RULES support consistent session behavior and rule integrity.

Tables Accessed

The package reads and writes through APPS synonyms. Item-orderability logic touches OE_ITEM_ORDERABILITY and OE_ITEM_ORDERABILITY_RULES, the core rule storage, along with MTL_SYSTEM_ITEMS_KFV, MTL_CATEGORIES_KFV, MTL_ITEM_CATEGORIES, and MTL_DEFAULT_CATEGORY_SETS for item and category context. Customer and party context is drawn from HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES_ALL, HZ_CUST_SITE_USES_ALL, HZ_CUST_PROFILES, HZ_CUST_PROFILE_CLASSES, HZ_PARTIES, HZ_PARTY_SITES, and HZ_LOCATIONS. Order header data is read from OE_ORDER_HEADERS_ALL. These accesses supply the customer, site, organization, category, and order-type attributes required for orderability evaluation.

Usage Notes

OE_ITORD_UTIL is an internal utility and is not intended for direct invocation by end users or by general customizations. It is normally called by higher-level Order Management packages such as OE_VALIDATE_LINE, OE_BULK_PROCESS_LINE, OE_LINE_UTIL, and OE_ITORD_PUB during line validation and bulk order import. Its procedures also back the refresh and definition of the OE_ITEMS_ORD_MV and OE_RELATED_ITEMS_MV materialized views. Custom code should avoid calling this package directly and instead use the supported public APIs in OE_ORDER_PUB or the orderability publication interfaces, since the internal signatures and behavior of OE_ITORD_UTIL are subject to change between releases.