Search Results mtl_system_items
The DEEPSEEKAPPS.ENG_COPY_TABLE_ROWS_PKG
package in Oracle E-Business Suite (EBS) versions 12.1.1 or 12.2.2 is a custom PL/SQL utility designed to facilitate the copying of data rows between tables, often used in engineering or manufacturing modules. A critical dependency of this package is its interaction with the MTL_SYSTEM_ITEMS
table, which serves as the master repository for item definitions in Oracle Inventory. Below is a detailed analysis of this dependency:
1. Purpose of ENG_COPY_TABLE_ROWS_PKG
The package typically includes procedures to clone or replicate data, such as copying item attributes, BOM structures, or engineering changes. Its dependency onMTL_SYSTEM_ITEMS
arises when handling item-related operations, as this table stores core item details like:
- Item codes, descriptions, and revision controls
- Inventory attributes (stockable, transactable, etc.)
- Engineering and planning parameters
2. Key Dependencies on MTL_SYSTEM_ITEMS
The package likely referencesMTL_SYSTEM_ITEMS
in the following scenarios:
- Data Validation: Before copying item-related rows, the package may validate source/target items against
MTL_SYSTEM_ITEMS
to ensure they exist and are active. - Attribute Propagation: When copying item attributes (e.g., from a template item), the package reads or updates
MTL_SYSTEM_ITEMS
to maintain consistency. - Referential Integrity: The package may enforce constraints tied to
MTL_SYSTEM_ITEMS.INVENTORY_ITEM_ID
orORGANIZATION_ID
to prevent orphaned records.
3. Technical Integration Points
Specific procedures withinENG_COPY_TABLE_ROWS_PKG
may:
- Query
MTL_SYSTEM_ITEMS
via cursors or direct SQL to fetch item metadata. - Use
MTL_SYSTEM_ITEMS
as a source for INSERT/SELECT statements when replicating data to child tables (e.g.,MTL_ITEM_CATEGORIES
). - Invoke Oracle APIs (e.g.,
INV_ITEM_API
) that internally referenceMTL_SYSTEM_ITEMS
.
4. Impact of MTL_SYSTEM_ITEMS Schema Changes
Modifications toMTL_SYSTEM_ITEMS
(e.g., new columns, constraints) could break the package if:
- Hard-coded SQL assumes a specific column structure.
- Validation logic relies on deprecated fields.
5. Performance Considerations
Frequent access toMTL_SYSTEM_ITEMS
—a high-volume table—may necessitate:
- Indexed lookups on
INVENTORY_ITEM_ID
orSEGMENT1
(item code). - Bulk operations (e.g.,
FORALL
) to minimize context switches.
6. Customization Risks
IfENG_COPY_TABLE_ROWS_PKG
is modified, dependencies on MTL_SYSTEM_ITEMS
must be carefully reviewed to avoid:
- Circular logic (e.g., triggers on
MTL_SYSTEM_ITEMS
calling the package). - Lock contention during mass updates.
Conclusion
TheDEEPSEEKAPPS.ENG_COPY_TABLE_ROWS_PKG
package's reliance on MTL_SYSTEM_ITEMS
underscores its role in item-centric data replication within Oracle EBS. Understanding this dependency is crucial for maintenance, performance tuning, and ensuring data integrity during cloning operations.
-
APPS.INV_INV_LOVS dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.ENG_VALIDATE_CHANGE_LINE dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.GMD_CONC_REPLACE_PKG dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.WIP_FLOW_VALIDATION dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.BOMPPRCB dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.BOMCUMYD dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.OE_CONFIG_PVT dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.JAI_PO_OSP_PKG dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.PA_FAXFACE dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.CST_TPRICE_PVT dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.PO_PDOI_DISTRIBUTIONS_SV3 dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.OE_RESERVE_CONC dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.RCV_SEEDEVENTS_PVT dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.PMI_SALES_PKG dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.JAI_AR_EER1_PKG dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.OE_OE_TOTALS_SUMMARY dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.WIP_MTLPROC_PRIV dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.INV_STATUS_PKG dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.CSTPPCLM dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.INV_MO_LOVS dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.PO_UOM_SV2 dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.BOMPASGB dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.WMS_XDOCK_PEGGING_PUB dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.AR_REVENUE_ADJUSTMENT_PVT dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.FTE_FREIGHT_PRICING dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.GMF_RCV_ACCOUNTING_PKG dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.ENG_COPY_TABLE_ROWS_PKG dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.INVPVLM2 dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.BOM_VALIDATE_BOM_HEADER dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.JL_AR_DOC_NUMBERING_PKG dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.CSI_RMA_RECEIPT_PUB dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.OKE_MDS_RELIEF_PKG dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.WSMPPCPD dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.INV_RESERVATION_AVAIL_PVT dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.WIP_OSP dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.EAM_COMMON_UTILITIES_PVT dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.CTO_OSS_SOURCE_PK dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.CSD_PROCESS_PVT dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.BOM_ROLLUP_PUB dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.JL_ZZ_TAX dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.BOM_VALIDATE_OP_SEQ dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.INV_TRANSACTION_HIDDEN dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.INV_CONSIGNED_VALIDATIONS dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.WSMPLBJI dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.MRP_SOURCING_API_PK dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.CTO_BOM_RTG_PK dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.WMS_UNLOAD_UTILS_PVT dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.INV_SHORTCHECKEXEC_PUB dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.INV_RCV_CACHE dependencies on MTL_SYSTEM_ITEMS
12.1.1
-
APPS.DPP_UTILITY_PVT dependencies on MTL_SYSTEM_ITEMS
12.1.1