Results for “invoiceable_item_flag”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
OKE_SYSTEM_ITEMS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It is shipped as part of the OKE – Project Contracts product family and is documented as a "View of Inventory Items." The view presents a curated, language-aware projection of Oracle Inventory master item data, exposing item identifiers, descriptive text, transactional enablement flags, and effectivity attributes in a single denormalized structure. Its principal purpose is to give Project Contracts and related OKE functionality — and any custom reporting or integration layer built alongside it — a stable, restricted interface to inventory item definitions without requiring direct joins against the base Inventory tables.
Because the view selects only a defined subset of columns and applies an internal filter, it behaves as a purpose-built access path rather than a general-purpose item query facility. This design shields downstream consumers from schema changes in the underlying Inventory objects and centralizes the join between the base item table and its translation table.
Underlying Base Objects
The view is defined over two documented base objects: MTL_SYSTEM_ITEMS_B_KFV (a key flexfield view over MTL_SYSTEM_ITEMS_B) and MTL_SYSTEM_ITEMS_TL (referenced through a synonym). MTL_SYSTEM_ITEMS_B_KFV supplies the key-flexfield-concatenated item identifier, organization context, and the majority of flag and effectivity columns. MTL_SYSTEM_ITEMS_TL supplies the language-specific item DESCRIPTION.
The two sources are joined on INVENTORY_ITEM_ID and ORGANIZATION_ID. A language predicate restricts the translation row returned to the session language via USERENV('LANG'), ensuring each item appears once with the appropriate localized description. A BOM_ITEM_TYPE = 4 filter restricts the result set to a specific item type classification, so the view does not expose the entire item master — only the subset relevant to the OKE contract context. The definition also repeats INVENTORY_ITEM_ID and ORGANIZATION_ID in the select list.
Key Columns
- NAME / CONCATENATED_SEGMENTS — The key flexfield concatenated item identifier derived from MTL_SYSTEM_ITEMS_B_KFV.
- DESCRIPTION — Language-specific item description from MTL_SYSTEM_ITEMS_TL.
- SHIPPABLE_ITEM_FLAG — Indicates whether the item may be shipped; relevant to the user search that surfaced this view.
- CUSTOMER_ORDER_ENABLED_FLAG — Whether the item may be placed on customer orders.
- PURCHASING_ENABLED_FLAG — Whether the item may be purchased.
- INVOICEABLE_ITEM_FLAG — Whether the item may be invoiced.
- INVENTORY_ITEM_FLAG — Whether the item is stocked and inventory-tracked.
- EFFECTIVITY_CONTROL / START_DATE_ACTIVE / END_DATE_ACTIVE — Date-range control governing when the item is active.
- ITEM_TYPE, ENABLED_FLAG, B_STATUS, STATUS — Item classification and status indicators; STATUS is a decode of ENABLED_FLAG ('Y'→'A', 'N'→'I').
- PRIMARY_UOM_CODE — The item's primary unit of measure.
- INVENTORY_ITEM_ID / ORGANIZATION_ID — The item and organization keys.
Common Use Cases and Queries
The most common use case is retrieving shippable, invoiceable item attributes for project contract lines and related reporting, particularly filtering on SHIPPABLE_ITEM_FLAG during fulfillment or billing analysis.
SELECT inventory_item_id,
organization_id,
concatenated_segments,
description,
primary_uom_code
FROM apps.oke_system_items_v
WHERE shippable_item_flag = 'Y'
AND enabled_flag = 'Y';
Additional scenarios include validating whether items are customer-order enabled, determining effectivity windows for a given organization, and joining the view to contract or order tables on INVENTORY_ITEM_ID and ORGANIZATION_ID. Because the view is already language-filtered, no additional translation join is required by callers.
-
View: OKE_SYSTEM_ITEMS_V 12.2.2
View of Inventory Items
APPS.OKE_SYSTEM_ITEMS_V·↳ MTL_SYSTEM_ITEMS_B_KFV·↳ MTL_SYSTEM_ITEMS_TL·Explore OKE 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: OKE_SYSTEM_ITEMS_V 12.1.1
View of Inventory Items
APPS.OKE_SYSTEM_ITEMS_V·↳ MTL_SYSTEM_ITEMS_B_KFV·↳ MTL_SYSTEM_ITEMS_TL·Explore OKE 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: 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: 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 →
-
View: AMS_PRODUCT_MAPPING_V 12.2.2
Product view for import.
APPS.AMS_PRODUCT_MAPPING_V·↳ AMS_IMP_LIST_HEADERS_ALL·↳ AMS_IMP_SOURCE_LINES·Explore AMS module →
-
APPS.CST_XLA_INV_SYSTEM_ITEMS_REF_V·↳ CST_ITEM_COSTS·↳ MTL_PARAMETERS·↳ MTL_SYSTEM_ITEMS·Explore BOM module →
-
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 →
-
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: AMS_PRODUCT_MAPPING_V 12.1.1
Product view for import.
APPS.AMS_PRODUCT_MAPPING_V·↳ AMS_IMP_LIST_HEADERS_ALL·↳ AMS_IMP_SOURCE_LINES·Explore AMS 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: OKX_SYSTEM_ITEMS_V 12.1.1
Inventory item definitions
APPS.OKX_SYSTEM_ITEMS_V·↳ MTL_SYSTEM_ITEMS_B_KFV·↳ MTL_SYSTEM_ITEMS_TL·Explore OKX module →
-
View: OKX_SYSTEM_ITEMS_V 12.2.2
Inventory item definitions
APPS.OKX_SYSTEM_ITEMS_V·↳ MTL_SYSTEM_ITEMS_B_KFV·↳ MTL_SYSTEM_ITEMS_TL·Explore OKX 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 →
-
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 →
-
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 →
-
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: 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 →
-
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_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: 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 →
-
This table is used to store Pending Changes information for the Items
-
Inventory item definitions
-
Inventory item definitions
-
This table is used to store Pending Changes information for the Items
-
Inventory Items Open Interface table
-
Inventory Items Open Interface table
-
PACKAGE BODY: APPS.INVATTR 12.1.1
-
PACKAGE BODY: APPS.INVATTR 12.2.2
-
PACKAGE: APPS.INVATTR 12.2.2
-
APPS.INVATTR SQL Statements 12.2.2
-
PACKAGE: APPS.INVATTR 12.1.1
-
APPS.INVATTR SQL Statements 12.1.1
-
View: XNC_PRODUCTS_V 12.2.2
This view is to display products
Not implemented in this database·Explore XNC module →
-
View: XNC_PRODUCTS_V 12.1.1
This view is to display products
Not implemented in this database·Explore XNC module →
-
VIEW: INV.INV_ITEM_TEMP# 12.2.2
-
APPS.INVPUPI2 SQL Statements 12.2.2