Search Results operation_offset

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:

• CSD_BOM_EXPL_TEMP (SYNONYM) — the temporary BOM explosion table that supplies the row-level component, sequence, and quantity data.
• MTL_SYSTEM_ITEMS_KFV (SYNONYM) — the key-flexfield item view supplying concatenated segments, descriptions, and unit-of-measure attributes.
• BOM_BILL_OF_MATERIALS (VIEW) — the bill of materials header view, joined on BILL_SEQUENCE_ID.
• FND_GLOBAL and FND_PROFILE (PACKAGES) — referenced for organizational context and profile access through the CS_STD.GET_ITEM_VALDN_ORGZN_ID function values returned indirectly.

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

• TOP_ALTERNATE_DESIGNATOR — identifies the alternate BOM designator of the top-level assembly, used to distinguish the alternate bill applied to the repair order. This is the column matched by the user's search term and is central to alternate BOM inquiries.
• BILL_SEQUENCE_ID, COMPONENT_SEQUENCE_ID, TOP_BILL_SEQUENCE_ID — the bill, component, and top-level bill sequence identifiers that anchor each row to the BOM structure.
• ORGANIZATION_ID, TOP_ITEM_ID, COMPONENT_ITEM_ID, ASSEMBLY_ITEM_ID — organizational and item keys linking the explosion to inventory items.
• ITEM, DESCRIPTION, PRIMARY_UOM_CODE, PRIMARY_UNIT_OF_MEASURE — concatenated item segments and descriptive attributes from MTL_SYSTEM_ITEMS_KFV.
• COMPONENT_QUANTITY, SELECT_QUANTITY, PLAN_LEVEL, SORT_ORDER — quantity and ordering values defining the exploded bill.
• LIST_PRICE, SELLING_PRICE, ITEM_COST, PRICE_LIST_ID — pricing and cost values used by Depot Repair for repair estimates and billing.
• EFFECTIVITY_DATE, DISABLE_DATE — the effective date range of the component on the bill.

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.