Search Results csd_bom_inquiry_expl_v




Overview
Explore in AI Chat

Overview

CSD_BOM_INQUIRY_EXPL_V is an APPS-owned database view within the CSD (Depot Repair) product of Oracle E-Business Suite, documented under ETRM 12.2.2 and valid in 12.1.1 as well. Its purpose is to present a flattened, inquiry-oriented representation of a bill of materials (BOM) explosion, joining a temporary BOM explosion table to the item master and the bill of materials header. It is described in the source metadata as a view based on temporary table, which reflects its role as a reporting and inquiry surface rather than a transactional object. The view is used by Depot Repair inquiry and repair-order screens to display the components, pricing, and quantity data associated with an assembly and its subcomponents.

Underlying Base Objects

The view is defined over the following documented base objects:

Each source row carries an ORG organization context. Component item rows are filtered so that only billable items (MATERIAL_BILLABLE_FLAG = 'M') are returned, and both the temporary table row and the item master row are constrained to the organization ID returned by CS_STD.GET_ITEM_VALDN_ORGZN_ID.

Key Columns

Common Use Cases and Queries

Typical usage centers on BOM inquiry and repair-order component review. A query retrieving alternate-designator components for the current organization might be:

SELECT TOP_ALTERNATE_DESIGNATOR, ITEM, DESCRIPTION, COMPONENT_QUANTITY, ITEM_COST FROM APPS.CSD_BOM_INQUIRY_EXPL_V WHERE ORGANIZATION_ID = :org_id ORDER BY PLAN_LEVEL, SORT_ORDER;

To inspect pricing for a repair estimate:

SELECT ITEM, COMPONENT_QUANTITY, LIST_PRICE, SELLING_PRICE, PRICE_LIST_ID FROM APPS.CSD_BOM_INQUIRY_EXPL_V WHERE TOP_BILL_SEQUENCE_ID = :bill_seq_id AND ITEM_COST IS NOT NULL;

Because the underlying explosion table is temporary, the view is best queried within the same session that populated it, ensuring accuracy of alternate designator and quantity data.