Results for “csd_customer_search_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CSD_CUSTOMER_SEARCH_V is a seeded Oracle E-Business Suite view owned by the APPS schema and shipped as part of the CSD (Depot Repair) product family. It is distributed in both the 12.1.1 and 12.2.2 releases and carries a VALID status in the ETRM repository. The view consolidates customer party data, installed base (CSI) instance records, and inventory item attributes into a single flattened result set that supports Depot Repair customer and product search functionality. It exposes customer accounts, contact phone details, serialized item instances, lot and revision information, and item-level serial control flags. Because it joins HZ, CSI, and MTL entities, the view acts as a convenient reporting and integration anchor for queries that need to resolve "who owns which installed unit" within a Depot Repair or field service context. The user search term "mfg_serial_number_flag" maps directly to the MFG_SERIAL_NUMBER_FLAG column exposed by this view, which is sourced from CSI_ITEM_INSTANCES.

Underlying Base Objects

Per the documented ETRM metadata, CSD_CUSTOMER_SEARCH_V references the following objects: AR_LOOKUPS (VIEW), CSI_ITEM_INSTANCES (SYNONYM), CS_STD (PACKAGE), HZ_CONTACT_POINTS (SYNONYM), HZ_CUST_ACCOUNTS (SYNONYM), HZ_PARTIES (SYNONYM), and MTL_SYSTEM_ITEMS_VL (VIEW). The synonyms resolve to the underlying HZ and CSI base tables, while MTL_SYSTEM_ITEMS_VL provides the item master key flexfield concatenated segments and control codes. The CS_STD package is invoked in the WHERE clause via CS_STD.GET_ITEM_VALDN_ORGZN_ID, which supplies the validation inventory organization for item joins. AR_LOOKUPS is outer-joined to translate PHONE_LINE_TYPE into a user-facing lookup meaning.

Key Columns

• PARTY_ID, PARTY_NAME, PARTY_NUMBER, PARTY_TYPE — customer party identity from HZ_PARTIES.
• ACCOUNT_ID, ACCOUNT_NUMBER, ACCOUNT_NAME — customer account context from HZ_CUST_ACCOUNTS.
• SERIAL_NUMBER, INSTANCE_ID, INSTANCE_NUMBER — installed base instance identifiers from CSI_ITEM_INSTANCES.
• ITEM_REVISION, LOT_NUMBER, QTY, UOM — instance-level revision, lot, quantity, and unit of measure.
• MFG_SERIAL_NUMBER_FLAG — indicates whether the item instance carries a manufacturer serial number.
• INVENTORY_ORG_ID, INVENTORY_ITEM_ID, ORGANIZATION_ID — item/inventory keys.
• PRODUCT_NAME (concatenated segments), PRODUCT_DESC, SERIAL_NUMBER_CONTROL_CODE, REVISION_QTY_CONTROL_CODE — item master attributes from MTL_SYSTEM_ITEMS_VL.
• PHONE_NUMBER, PHONE_TYPE, PHONE_TYPE_MEANING — primary active phone contact details.

Common Use Cases and Queries

The view is typically queried to locate a customer's installed products for Depot Repair intake, to reconcile serialized units against their owning accounts, or to filter products by serialization control. A representative query is:

SELECT party_name, account_number, serial_number, mfg_serial_number_flag, concatenated_segments, product_desc FROM apps.csd_customer_search_v WHERE serial_number = :serial;

Analysts also filter by MFG_SERIAL_NUMBER_FLAG to isolate manufacturer-serialized units, or join back to CSI_ITEM_INSTANCES on INSTANCE_ID for repair order enrichment. Additional screening frequently applies PRODUCT_NAME and INVENTORY_ORG_ID to constrain the search to a specific organization. Because the view already enforces SERVICE_ITEM_FLAG = 'N', ENABLED_FLAG = 'Y', SERV_REQ_ENABLED_CODE = 'E', and effective-dated active windows, callers should be aware that results are pre-filtered to depot-serviceable, currently active records.