Search Results bom_cto_order_lines_n2

Overview

BOM.BOM_CTO_ORDER_LINES is a transactional table in the Oracle E-Business Suite Configure-to-Order (CTO) and Assemble-to-Order (ATO) model. It stores the resolved configuration line structure for sales order lines that reference a configured or ATO item, capturing each model, option class, and option component as an individual row along with its parent-child relationship within the configuration hierarchy. The table is populated by the Oracle Order Management and Bills of Material configuration engine during order entry, order import, or model explosion, and it is subsequently consumed by the ATO/CTO workflow, Work in Process, and shipping processes.

The table resides in the APPS_TS_TX_DATA tablespace with PCTFREE 10, and all BOM_CTO_ORDER_LINES indexes are created in APPS_TS_TX_IDX. The primary key is BOM_CTO_ORDER_LINES_PK, defined on LINE_ID. The heuristic Data Vault classification mined from the FK structure is standalone; in Data Vault modeling terms this table is best treated as a link-style structure that resolves hierarchical relationships between configuration lines, with the surrogate LINE_ID acting as the persistent identifier. The unique index BOM_CTO_ORDER_LINES_U1 on LINE_ID confirms LINE_ID as the business-key candidate.

Key Information Stored

BOM_CTO_ORDER_LINES contains 33 documented columns. The most significant are summarized below.

• LINE_ID — Surrogate primary key and the target of unique index BOM_CTO_ORDER_LINES_U1. Uniquely identifies each configuration line row.
• HEADER_ID — Order header identifier linking the configuration line to the sales order header.
• ATO_LINE_ID — Order line identifier for the ATO/CTO line that this configuration row belongs to. Indexed non-uniquely by BOM_CTO_ORDER_LINES_N3.
• TOP_MODEL_LINE_ID — Identifier of the top-level model line in the configuration. Indexed by BOM_CTO_ORDER_LINES_N1.
• PARENT_ATO_LINE_ID — Identifier of the parent ATO line, supporting hierarchical navigation. Indexed by BOM_CTO_ORDER_LINES_N2.
• LINK_TO_LINE_ID — Reference to a related configuration line, used to associate linked components. Indexed by BOM_CTO_ORDER_LINES_N4.
• CONFIG_ITEM_ID — Identifier of the configured item. Indexed non-uniquely by BOM_CTO_ORDER_LINES_N5.
• INVENTORY_ITEM_ID and SHIP_FROM_ORG_ID — Identify the inventory item and the shipping organization. Jointly indexed by BOM_CTO_ORDER_LINES_N6.
• COMPONENT_SEQUENCE_ID — References the bill of material component sequence associated with the line.
• BOM_ITEM_TYPE and ITEM_TYPE_CODE — Classify the line as a model, option class, or option component.
• ORDERED_QUANTITY and ORDER_QUANTITY_UOM — Ordered quantity and unit of measure for the configuration line.
• PLAN_LEVEL and WIP_SUPPLY_TYPE — Planning hierarchy level and supply type used by planning and Work in Process.
• SCHEDULE_SHIP_DATE — Scheduled ship date for the configuration line.
• COMPONENT_CODE, BATCH_ID, PERFORM_MATCH, REUSE_CONFIG, OPTION_SPECIFIC, QTY_PER_PARENT_MODEL, CONFIG_CREATION — Additional configuration metadata controlling matching, reuse, and quantity buildup.
• Standard Who columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, plus REQUEST_ID, PROGRAM_APPLICATION_ID, and PROGRAM_ID concurrent identifiers.

Common Use Cases and Queries

The table is typically queried to reconstruct the configuration hierarchy of an order, to validate model explosion, or to report on option selections for a given model line. A common pattern joins on TOP_MODEL_LINE_ID to return all lines of a configuration:

• SELECT * FROM bom.bom_cto_order_lines WHERE top_model_line_id = :p_top_model_line_id;
• SELECT * FROM bom.bom_cto_order_lines WHERE ato_line_id = :p_ato_line_id ORDER BY plan_level;
• SELECT * FROM bom.bom_cto_order_lines WHERE line_id = :p_line_id;

Additional reporting cases include retrieving all configurations shipped from a given organization via INVENTORY_ITEM_ID and SHIP_FROM_ORG_ID, identifying the parent of a line through PARENT_ATO_LINE_ID to walk the hierarchy, and auditing configuration creation metadata such as CONFIG_CREATION, REUSE_CONFIG, and OPTION_SPECIFIC.

Related Objects

The table participates in the CTO/ATO data model through its identifier columns, which align with the following related objects:

• BOM.BOM_CTO_ORDER_LINES — Self-referencing hierarchy via ATO_LINE_ID, PARENT_ATO_LINE_ID, and TOP_MODEL_LINE_ID.
• OE_ORDER_HEADERS_ALL — Joined on HEADER_ID.
• OE_ORDER_LINES_ALL — Joined on ATO_LINE_ID and its LINE_ID.
• BOM_BILL_OF_MATERIALS / BOM_COMPONENTS_B — Linked via COMPONENT_SEQUENCE_ID.
• MTL_SYSTEM_ITEMS_B — Joined on INVENTORY_ITEM_ID.
• MTL_PARAMETERS / ORG_ORGANIZATION_DEFINITIONS — Joined on SHIP_FROM_ORG_ID.
• WIP_DISCRETE_JOBS / WIP_ENTITIES — Supply source related through WIP_SUPPLY_TYPE and TOP_MODEL_LINE_ID.
• BOM_CONFIG_ITEMS — Related through CONFIG_ITEM_ID for configured item definitions.