Results for “so_transactions_flag”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
SO_INCLUDED_ITEMS_OEXORRSO_V is an APPS-owned database view within the Oracle Order Entry (OE) module, exposed for the Oracle Order Management (OM) and Bills of Material (BOM) integration layer. In Oracle EBS 12.1.1 and 12.2.2, the view presents a modeled, exploded picture of included (configuration) items on a sales order line. It combines the raw configuration explosion records held in BOM_CONFIG_EXPLOSIONS with descriptive item attributes and derived order-line quantities so that order entry, shipping, and fulfillment logic can evaluate component-level availability, reservations, scheduling, and revenue requirements without repeatedly joining the underlying tables.
The view's most prominent role is as the source of the EXTENDED_QUANTITY value — the searched term — together with related component quantities. Because the view also resolves item descriptions, ATP flags, reservable flags, and schedule status, it is a convenient reporting and integration surface for ATO/PTO (Assemble-to-Order / Pick-to-Order) configurations.
Underlying Base Objects
Per the documented ETRM metadata, the view is defined over the following referenced objects:
- BOM_CONFIG_EXPLOSIONS (SYNONYM) — the driving table, aliased
EXP; supplies the exploded component rows, extended quantity, plan level, select flags, and line/header identifiers. - MTL_SYSTEM_ITEMS_VL (VIEW) — aliased
MSI; outer-joined on COMPONENT_ITEM_ID and ORGANIZATION_ID to provide item description, reservable type, and ATP flag. When ORGANIZATION_ID is null, the view substitutes the profile value fromFND_PROFILE.VALUE('SO_ORGANIZATION_ID'). - BOM_INVENTORY_COMPONENTS (VIEW) — aliased
BIC; outer-joined on COMPONENT_SEQUENCE_ID to supply the CHECK_ATP attribute. - SO_LOOKUPS (SYNONYM) — aliased
SOL; outer-joined on LOOKUP_TYPE = 'SCHEDULE STATUS' to translate the schedule status code into a meaning. - OE_QUERY (PACKAGE) — invoked for II_RESERVED_QUANTITY, II_RELEASED_QUANTITY, and II_SCHEDULE_STATUS_CODE per (LINE_ID, COMPONENT_CODE).
- FND_PROFILE and FND_GLOBAL (PACKAGES) — used for profile value derivation and session context.
Key Columns
The view exposes the ROW_ID plus the full set of explosion and order-context columns. Notable entries include:
- EXTENDED_QUANTITY — the total component quantity for the exploded line, accounting for the configured item's usage and order quantity. This is the primary searched attribute.
- COMPONENT_QUANTITY — the per-unit component quantity from the bill.
- SELECT_QUANTITY and SELECT_FLAG — user-selected optional component quantities and inclusion indicator.
- COMPONENT_ITEM_ID / COMPONENT_SEQUENCE_ID — linkage to the item master and bill component definition.
- TOP_ITEM_ID, TOP_BILL_SEQUENCE_ID, BILL_SEQUENCE_ID, PLAN_LEVEL, SORT_ORDER — structure and hierarchy of the configuration.
- ITEM_DESCRIPTION, PRIMARY_UOM_CODE, ATP_FLAG, RESERVABLE_FLAG, REQUIRED_FOR_REVENUE_FLAG — derived descriptive and control flags.
- RESERVED_QUANTITY, RELEASED_QUANTITY, SCHEDULE_STATUS_CODE, SCHEDULE_STATUS — fulfillment-related values computed via OE_QUERY.
- HEADER_ID, LINE_ID, COMPONENT_CODE, SO_TRANSACTIONS_FLAG — order line context and transaction eligibility.
Common Use Cases and Queries
Typical uses include reporting on configured order lines, validating component availability, and feeding fulfillment workflows. A representative query lists exploded components with their extended quantity:
- SELECT line_id, component_item_id, item_description, extended_quantity, primary_uom_code FROM so_included_items_oexorrso_v WHERE header_id = :p_header_id;
- Filter by
RESERVABLE_FLAG = 'Y'to identify reservable components for reservation processing. - Filter by
ATP_FLAG = 'Y'to identify components requiring availability checks. - Use
SCHEDULE_STATUSandRELEASED_QUANTITYto monitor shipment readiness.
Because the view resolves profile and package logic at runtime, it should be queried with the correct operating unit context so that SO_ORGANIZATION_ID and OE_QUERY functions return valid results.
-
APPS.SO_INCLUDED_ITEMS_OEXORRSO_V·↳ BOM_CONFIG_EXPLOSIONS·↳ BOM_INVENTORY_COMPONENTS·↳ FND_GLOBAL·Explore OE module →
-
APPS.SO_PICKING_LINE_DET_OEXORRSO_V·↳ FND_GLOBAL·↳ FND_PROFILE·↳ MTL_PARAMETERS·Explore OE module →
-
View: OE_MTL_SYSTEM_ITEMS_V 12.1.1
No longer used
APPS.OE_MTL_SYSTEM_ITEMS_V·↳ MTL_SYSTEM_ITEMS·Explore ONT module →
-
View: GMF_XLA_ITEMS_V 12.1.1
View for SLA ADR sources from Item Definition
APPS.GMF_XLA_ITEMS_V·↳ MTL_PARAMETERS·↳ MTL_SYSTEM_ITEMS_B·Explore GMF module →
-
View: MTL_ITEM_FLEXFIELDS 12.2.2
This view is based on the key flexfield view MTL_SYSTEM_ITEMS_B_KFV. It contains columns with padded and unpadded concatenated segments of an item number.
APPS.MTL_ITEM_FLEXFIELDS·↳ MTL_SYSTEM_ITEMS_B_KFV·Explore INV module →
-
APPS.SO_INCLUDED_ITEMS_OEXORRSO_V·↳ BOM_CONFIG_EXPLOSIONS·↳ BOM_INVENTORY_COMPONENTS·↳ FND_GLOBAL·Explore OE module →
-
View: BOM_EXPLOSION_VIEW 12.1.1
Indented bill of material for report
APPS.BOM_EXPLOSION_VIEW·↳ BOM_EXPLOSION_TEMP·↳ BOM_STRUCTURES_B·↳ MFG_LOOKUPS·Explore BOM module →
-
View: OE_MTL_SYSTEM_ITEMS_V 12.2.2
No longer used
APPS.OE_MTL_SYSTEM_ITEMS_V·↳ MTL_SYSTEM_ITEMS·Explore ONT module →
-
View: BOM_EXPLOSION_VIEW 12.2.2
Indented bill of material for report
APPS.BOM_EXPLOSION_VIEW·↳ BOM_EXPLOSION_TEMP·↳ BOM_STRUCTURES_B·↳ MFG_LOOKUPS·Explore BOM module →
-
APPS.SO_PICKING_LINE_DET_OEXORRSO_V·↳ FND_GLOBAL·↳ FND_PROFILE·↳ MTL_PARAMETERS·Explore OE module →
-
APPS.CST_XLA_INV_SYSTEM_ITEMS_REF_V·↳ CST_ITEM_COSTS·↳ MTL_PARAMETERS·↳ MTL_SYSTEM_ITEMS·Explore BOM module →
-
This view stores the pending changes information for item operational attributes
APPS.EGO_MTL_SY_ITEMS_CHG_VL·↳ EGO_MTL_SY_ITEMS_CHG_B·↳ EGO_MTL_SY_ITEMS_CHG_TL·Explore EGO module →
-
View: SO_CONFIG_COMPONENTS_V 12.2.2
APPS.SO_CONFIG_COMPONENTS_V·↳ BOM_EXPLOSIONS·↳ BOM_INVENTORY_COMPONENTS·↳ MTL_SYSTEM_ITEMS_KFV·Explore OE module →
-
View: BOM_EXPL_INQUIRY_VIEW 12.2.2
Indented bill of material for window
APPS.BOM_EXPL_INQUIRY_VIEW·↳ BOM_BILL_OF_MATERIALS·↳ BOM_GLOBALS·↳ BOM_SMALL_EXPL_TEMP·Explore BOM module →
-
View: GMF_XLA_ITEMS_V 12.2.2
View for SLA ADR sources from Item Definition
APPS.GMF_XLA_ITEMS_V·↳ MTL_PARAMETERS·↳ MTL_SYSTEM_ITEMS_B·Explore GMF module →
-
Table: CSD_BOM_EXPL_TEMP 12.1.1
-
Table: CSD_BOM_EXPL_TEMP 12.2.2
-
View: MTL_SYSTEM_ITEMS_B_KFV 12.2.2
System Items Key Flexfield View
APPS.MTL_SYSTEM_ITEMS_B_KFV·↳ MTL_SYSTEM_ITEMS_B·Explore INV module →
-
Pre-exploded model bills for use by Order Entry
-
This view stores the pending changes information for item operational attributes
APPS.EGO_MTL_SY_ITEMS_CHG_VL·↳ EGO_MTL_SY_ITEMS_CHG_B·↳ EGO_MTL_SY_ITEMS_CHG_TL·Explore EGO module →
-
View: MTL_SYSTEM_ITEMS_ER1_V 12.2.2
ERES : View to support ERES framework for Items
APPS.MTL_SYSTEM_ITEMS_ER1_V·↳ FA_CATEGORIES_B_KFV·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_GENERAL·Explore INV module →
-
APPS.BOM_ODI_WS_COMPONENTS_V·↳ BOM_EXPLOSIONS_ALL·↳ BOM_INVENTORY_COMPONENTS·↳ BOM_ODI_WS_ENTITIES·Explore BOM module →
-
View: BOM_EXPL_INQUIRY_VIEW 12.1.1
Indented bill of material for window
APPS.BOM_EXPL_INQUIRY_VIEW·↳ BOM_BILL_OF_MATERIALS·↳ BOM_GLOBALS·↳ BOM_SMALL_EXPL_TEMP·Explore BOM module →
-
View: MTL_ITEM_FLEXFIELDS 12.1.1
This view is based on the key flexfield view MTL_SYSTEM_ITEMS_B_KFV. It contains columns with padded and unpadded concatenated segments of an item number.
APPS.MTL_ITEM_FLEXFIELDS·↳ MTL_SYSTEM_ITEMS_B_KFV·Explore INV module →
-
APPS.CST_XLA_INV_SYSTEM_ITEMS_REF_V·↳ CST_ITEM_COSTS·↳ MTL_PARAMETERS·↳ MTL_SYSTEM_ITEMS·Explore BOM module →
-
Pre-exploded model bills for use by Order Entry
-
Temporary data for indented bills of material (on-line processes)
-
Table: BOM_CONFIG_EXPLOSIONS 12.2.2
Temporary data for ATO configurator window
-
View: BOM_EXPLOSIONS_ALL_V 12.2.2
View over BOM_EXPLOSIONS_ALL Table
APPS.BOM_EXPLOSIONS_ALL_V·↳ BOM_ALTERNATE_DESIGNATORS_TL·↳ BOM_COMPONENTS_B·↳ BOM_EXPLODER_PUB·Explore BOM module →
-
View: MTL_SYSTEM_ITEMS_ER1_V 12.1.1
ERES : View to support ERES framework for Items
APPS.MTL_SYSTEM_ITEMS_ER1_V·↳ FA_CATEGORIES_B_KFV·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_GENERAL·Explore INV module →
-
View: EGO_ITEM_SYNC_V 12.2.2
This View is used for Item Sync operations with external systems. Currently this is being used for ItemSync with Siebel
APPS.EGO_ITEM_SYNC_V·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_ORGANIZATION_INFORMATION·↳ MTL_PARAMETERS·Explore EGO module →
-
View: EGO_ITEM_SYNC_OP_V 12.2.2
This View is used for Item Sync operations with external systems. Currently this is being used for ItemSync with Siebel OnPremise
APPS.EGO_ITEM_SYNC_OP_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_ORGANIZATION_INFORMATION·↳ MTL_PARAMETERS·Explore EGO module →
-
View: EGO_ITEM_SYNC_OP_V 12.1.1
This View is used for Item Sync operations with external systems. Currently this is being used for ItemSync with Siebel OnPremise
APPS.EGO_ITEM_SYNC_OP_V·↳ HR_ALL_ORGANIZATION_UNITS_TL·↳ HR_ORGANIZATION_INFORMATION·↳ MTL_PARAMETERS·Explore EGO module →
-
Table: BOM_CONFIG_EXPLOSIONS 12.1.1
Temporary data for ATO configurator window
-
View: SO_CONFIG_COMPONENTS_V 12.1.1
APPS.SO_CONFIG_COMPONENTS_V·↳ BOM_EXPLOSIONS·↳ BOM_INVENTORY_COMPONENTS·↳ MTL_SYSTEM_ITEMS_KFV·Explore OE module →
-
Temporary data for indented bills of material (batch processes)
-
View: MTL_SYSTEM_ITEMS_VL 12.1.1
System Items multilingual view with concatenated segments column
APPS.MTL_SYSTEM_ITEMS_VL·↳ MTL_SYSTEM_ITEMS_B_KFV·↳ MTL_SYSTEM_ITEMS_TL·Explore INV module →
-
View: MTL_SYSTEM_ITEMS_FVL 12.1.1
Base view for the Define System Items (INVIDITM) form MTL_SYSTEM_ITEMS block. This view is MLS enabled.
APPS.MTL_SYSTEM_ITEMS_FVL·↳ MTL_SYSTEM_ITEMS_B·↳ MTL_SYSTEM_ITEMS_TL·Explore INV module →
-
View: MTL_SYSTEM_ITEMS_FVL 12.2.2
Base view for the Define System Items (INVIDITM) form MTL_SYSTEM_ITEMS block. This view is MLS enabled.
APPS.MTL_SYSTEM_ITEMS_FVL·↳ MTL_SYSTEM_ITEMS_B·↳ MTL_SYSTEM_ITEMS_TL·Explore INV module →
-
View: EGO_ITEM_SYNC_V 12.1.1
This View is used for Item Sync operations with external systems. Currently this is being used for ItemSync with Siebel
APPS.EGO_ITEM_SYNC_V·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_ORGANIZATION_INFORMATION·↳ MTL_PARAMETERS·Explore EGO module →
-
View: MTL_CLIENT_ITEMS_VL 12.2.2
APPS.MTL_CLIENT_ITEMS_VL·↳ MTL_CLIENT_PARAMETERS_V·↳ MTL_SYSTEM_ITEMS_VL·Explore INV module →
-
Temporary data for indented bills of material (batch processes)
-
Temporary data for indented bills of material (on-line processes)
-
View: BOM_EXPLOSIONS_ALL_V 12.1.1
View over BOM_EXPLOSIONS_ALL Table
APPS.BOM_EXPLOSIONS_ALL_V·↳ BOM_ALTERNATE_DESIGNATORS_TL·↳ BOM_COMPONENTS_B·↳ BOM_EXPLODER_PUB·Explore BOM module →
-
View: MTL_SYSTEM_ITEMS_VL 12.2.2
System Items multilingual view with concatenated segments column
APPS.MTL_SYSTEM_ITEMS_VL·↳ MTL_SYSTEM_ITEMS_B_KFV·↳ MTL_SYSTEM_ITEMS_TL·Explore INV module →
-
View: MTL_SYSTEM_ITEMS_B_KFV 12.1.1
System Items Key Flexfield View
APPS.MTL_SYSTEM_ITEMS_B_KFV·↳ MTL_SYSTEM_ITEMS_B·Explore INV module →