Search Results get_customer_attr




Overview
Explore in AI Chat

Overview

MSD_SR_UTIL is a utility package in the Oracle EBS Applications (APPS) schema, classified under the ETRM metadata as an API of type UTIL. It exists to provide shared, reusable helper logic across the MSD (Enterprise Data / Service) product family, particularly for the Service Request, Service Repair, and field service data flows. The package is declared with AUTHID CURRENT_USER, meaning its unqualified references resolve against the invoking schema while database objects are typically reached through APPS synonyms. The header comment ($Header: msdutils.pls 120.7 ... ship $) confirms it is a shipped, supported database object rather than a one-off customization.

The recurring theme throughout the 60 documented functions is translation and lookup: converting internal surrogate keys (item, customer, schedule, service representative identifiers) into human-readable values, and returning standardized numeric or descriptive constants used by dependent components. Because the user searched for "is_item_optional_for_lvl," it is worth noting that MSD_SR_UTIL is the package that hosts item- and level-related utility logic; functions such as ITEM, ITEM_ORGANIZATION, and GET_ITEM_COST are the closest documented siblings of any item-optionality check, and callers typically inspect this package when resolving whether an item attribute is required at a given configuration level.

Key Procedures and Functions

The documented public functions fall into several functional groups:

  • Key-to-description converters: ITEM, CUST, SCHN, SREP, and LOCATION return display values for item, customer, schedule, service representative, and location identifiers, respectively. These drive list-of-values and descriptive columns in service screens.
  • Cost and unit conversion: UOM_CONV performs unit-of-measure conversion for a given item, and GET_ITEM_COST returns the item cost for an item/organization combination.
  • Currency and date helpers: CONVERT_GLOBAL_AMT converts an amount using a global currency code and effective date; SHIPPED_DATE and BOOKED_DATE derive shipment and booking dates from departure and order header identifiers.
  • Organization context: MASTER_ORGANIZATION and ITEM_ORGANIZATION return the master and item-level organization identifiers used to scope inventory queries (the latter added under Bug# 4157588).
  • Category set and setup lookups: GET_CATEGORY_SET_ID, GET_EOL_CATEGORY_SET_ID, GET_CONVERSION_TYPE, and GET_CUSTOMER_ATTR expose configured flexfield and setup parameter values.
  • Sentinel/null constants: GET_NULL_PK, GET_NULL_DESC, and the GET_ALL_* family (SCS, GEO, ORG, PRD, REP, DCS) return standard "null," "all," or descriptive placeholder values for pickers and filters.
  • Miscellaneous: GET_DIMENSION_DESC resolves a dimension description from type and code, and ON_HOLD determines hold status for an order header and line.

Tables Accessed

The package reads from a defined set of APPS synonyms. Item and inventory logic touches MTL_SYSTEM_ITEMS and MTL_PARAMETERS. Customer resolution reads HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES_ALL, HZ_CUST_SITE_USES_ALL, HZ_PARTIES, and HZ_PARTY_SITES. Service and repair data comes from CSD_REPAIRS, CSD_REPAIR_JOB_XREF, and CS_INCIDENTS_ALL_B. Setup and configuration values are drawn from FND_LOOKUP_VALUES, FND_DESCR_FLEX_COLUMN_USAGES, FND_PRODUCT_GROUPS, MSD_APP_INSTANCE_ORGS, and MSD_SETUP_PARAMETERS.

Usage Notes

MSD_SR_UTIL is a backend utility, not a user-facing form. It is most commonly invoked from other PL/SQL packages — the metadata records it as referenced by 70 other packages — as well as from service-related forms, concurrent programs, and custom extensions that need consistent key-to-description conversion or organization scoping. Because it is AUTHID CURRENT_USER, custom code should grant the necessary privileges on the underlying tables or rely on APPS synonyms, and callers should treat the GET_ALL_* and GET_NULL_* functions as the sanctioned way to populate pickers rather than hard-coding sentinel values.