Search Results cst_item_cost_type_v
DeepSeek eTRM - INV Tables and Views in Oracle EBS 12.1.1/12.2.2
Overview
The DeepSeek Enterprise Technical Reference Manual (eTRM) for Oracle E-Business Suite (EBS) provides a comprehensive documentation of Inventory (INV) module tables and views in releases 12.1.1 and 12.2.2. These database objects form the foundation for inventory management, item master, material transactions, and warehouse operations.Key Inventory Tables
1. Core Item Master Tables
- MTL_SYSTEM_ITEMS_B: Primary table storing item definitions with attributes like description, UOM, and item status.
- MTL_ITEM_REVISIONS_B: Tracks revision-controlled items with effectivity dates.
- MTL_ITEM_CATEGORIES: Stores category assignments for items.
2. Inventory Organization Structure
- MTL_PARAMETERS: Organization-level inventory parameters.
- MTL_SECONDARY_INVENTORIES: Sub-inventory definitions within organizations.
- MTL_ITEM_LOCATIONS: Locator master data for warehouse management.
3. Transaction Processing
- MTL_MATERIAL_TRANSACTIONS: Core transaction table recording all inventory movements.
- MTL_TRANSACTION_TYPES: Definition of transaction types used in the system.
- MTL_TRANSACTION_LOTS: Lot number tracking for lot-controlled items.
4. On-Hand Quantities
- MTL_ONHAND_QUANTITIES: Current inventory balances by subinventory/locator.
- MTL_ONHAND_QUANTITIES_DETAIL: Detailed breakdown of on-hand quantities.
Key Inventory Views
1. Reporting Views
- MTL_ITEMS_V: Comprehensive item master view combining multiple base tables.
- MTL_ITEM_REVISIONS_V: Enhanced revision information view.
- MTL_STOCK_LOCATORS_V: Locator information with organization context.
2. Transaction Views
- MTL_MATERIAL_TRANSACTIONS_V: Transaction data with descriptive information.
- MTL_TRANSACTION_LOTS_V: Lot information view for transactions.
3. On-Hand Views
- MTL_ONHAND_QUANTITIES_V: Current inventory view with item details.
- MTL_ONHAND_QUANTITIES_DETAIL_V: Detailed on-hand quantities view.
Technical Considerations
- The eTRM provides complete data dictionary information including column definitions, constraints, and indexes.
- Views typically join base tables with descriptive flexfields and reference data.
- Key relationships are maintained through foreign key constraints like ORGANIZATION_ID and INVENTORY_ITEM_ID.
- Partitioning strategies differ between 12.1.1 and 12.2.2, with 12.2.2 offering more partitioning options.
Integration Points
- Strong integration with WMS tables in advanced warehouse implementations.
- Interfaces with Cost Management (CST) for inventory valuation.
- Connections to Order Management (OE) for shipping transactions.
- Integration with Purchasing (PO) for receipt processing.
Customization Guidance
- Direct DML on base tables is generally discouraged.
- Public APIs should be used for data modifications.
- Custom extensions should leverage descriptive flexfields where possible.
- New indexes should be carefully evaluated for performance impact.
Version Differences
- 12.2.2 introduces additional columns for cloud-specific features.
- New views were added in 12.2.2 to support REST services.
- Partitioning enhancements in 12.2.2 improve performance for large implementations.
-
View: CST_ITEM_COST_TYPE_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:BOM.CST_ITEM_COST_TYPE_V, object_name:CST_ITEM_COST_TYPE_V, status:VALID, product: BOM - Bills of Material , description: Item cost information for a cost type in an organization : SINGLE-ORG view , implementation_dba_data: APPS.CST_ITEM_COST_TYPE_V ,
-
View: CST_ITEM_COST_TYPE_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:BOM.CST_ITEM_COST_TYPE_V, object_name:CST_ITEM_COST_TYPE_V, status:VALID, product: BOM - Bills of Material , description: Item cost information for a cost type in an organization : SINGLE-ORG view , implementation_dba_data: APPS.CST_ITEM_COST_TYPE_V ,
-
APPS.BOMPXINQ dependencies on CST_ITEM_COST_TYPE_V
12.2.2
-
APPS.BOMPXINQ dependencies on CST_ITEM_COST_TYPE_V
12.1.1
-
PACKAGE BODY: APPS.BOMPXINQ
12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:BOMPXINQ, status:VALID,
-
PACKAGE BODY: APPS.BOMPXINQ
12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:BOMPXINQ, status:VALID,
-
12.1.1 DBA Data
12.1.1
-
12.2.2 DBA Data
12.2.2
-
SYNONYM: APPS.CST_ITEM_COSTS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:CST_ITEM_COSTS, status:VALID,
-
SYNONYM: APPS.CST_ITEM_COSTS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:CST_ITEM_COSTS, status:VALID,
-
SYNONYM: APPS.CST_COST_TYPES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:CST_COST_TYPES, status:VALID,
-
SYNONYM: APPS.CST_COST_TYPES
12.2.2
owner:APPS, object_type:SYNONYM, object_name:CST_COST_TYPES, status:VALID,
-
SYNONYM: APPS.MTL_DEFAULT_CATEGORY_SETS
12.1.1
owner:APPS, object_type:SYNONYM, object_name:MTL_DEFAULT_CATEGORY_SETS, status:VALID,
-
12.1.1 FND Design Data
12.1.1
-
SYNONYM: APPS.MTL_DEFAULT_CATEGORY_SETS
12.2.2
owner:APPS, object_type:SYNONYM, object_name:MTL_DEFAULT_CATEGORY_SETS, status:VALID,
-
VIEW: APPS.CST_ITEM_COST_TYPE_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:BOM.CST_ITEM_COST_TYPE_V, object_name:CST_ITEM_COST_TYPE_V, status:VALID,
-
12.2.2 FND Design Data
12.2.2
-
VIEW: APPS.CST_ITEM_COST_TYPE_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:BOM.CST_ITEM_COST_TYPE_V, object_name:CST_ITEM_COST_TYPE_V, status:VALID,
-
SYNONYM: APPS.MTL_ITEM_CATEGORIES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:MTL_ITEM_CATEGORIES, status:VALID,
-
APPS.BOMPXINQ SQL Statements
12.1.1
-
SYNONYM: APPS.MTL_ITEM_CATEGORIES
12.2.2
owner:APPS, object_type:SYNONYM, object_name:MTL_ITEM_CATEGORIES, status:VALID,
-
APPS.BOMPXINQ SQL Statements
12.2.2
-
VIEW: APPS.MFG_LOOKUPS
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:INV.MFG_LOOKUPS, object_name:MFG_LOOKUPS, status:VALID,
-
VIEW: APPS.MFG_LOOKUPS
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:INV.MFG_LOOKUPS, object_name:MFG_LOOKUPS, status:VALID,
-
VIEW: APPS.MTL_SYSTEM_ITEMS_VL
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:INV.MTL_SYSTEM_ITEMS_VL, object_name:MTL_SYSTEM_ITEMS_VL, status:VALID,
-
VIEW: APPS.MTL_SYSTEM_ITEMS_VL
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:INV.MTL_SYSTEM_ITEMS_VL, object_name:MTL_SYSTEM_ITEMS_VL, status:VALID,
-
PACKAGE BODY: APPS.BOMPXINQ
12.2.2
-
PACKAGE BODY: APPS.BOMPXINQ
12.1.1
-
eTRM - INV Tables and Views
12.1.1
-
12.2.2 DBA Data
12.2.2
-
12.1.1 DBA Data
12.1.1
-
eTRM - BOM Tables and Views
12.2.2
description: Table to map wip transactions to their corresponding event types. ,
-
eTRM - BOM Tables and Views
12.1.1
description: Table to map wip transactions to their corresponding event types. ,
-
eTRM - INV Tables and Views
12.1.1
-
eTRM - BOM Tables and Views
12.2.2
description: Table to map wip transactions to their corresponding event types. ,
-
eTRM - BOM Tables and Views
12.1.1
description: Table to map wip transactions to their corresponding event types. ,