Results for “mvt_stat_status”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
IC_TRAN_PND is the staging table for pending inventory transactions within the Oracle Process Manufacturing (OPM) Inventory module, owned by the GMI schema. In Oracle EBS 12.1.1 and 12.2.2, it functions as the holding area where inventory movements await validation, costing, and final posting to the perpetual inventory ledger. Rows are inserted by material transaction entry forms, open interface programs, and batch processing routines, and are subsequently processed by the Inventory Transaction processor, which validates each line and writes the accepted results into the permanent inventory tables.
The table carries a 45-column physical definition and is classified heuristically as satellite-leaning in Data Vault terms. This classification is a modeling suggestion: the table extends core inventory and item hubs with descriptive, transactional context rather than serving as a pure hub or link. Its primary key, IC_TRAN_PND_PK, is defined on the single column TRANS_ID, a system-generated surrogate identifier.
Key Information Stored
Each record represents one pending inventory transaction line. The most significant columns include:
- TRANS_ID — surrogate primary key and unique identifier for the pending transaction line.
- ITEM_ID — the item being moved; participates in the most foreign key relationships in the table.
- WHSE_CODE — warehouse where the transaction is staged.
- LOT_ID and LOT_STATUS — the lot affected and its lot status code, critical for process manufacturing traceability.
- ORGN_CODE and CO_CODE — organization and company context, both resolving to SY_ORGN_MST.
- DOC_TYPE and DOC_ID — source document classification and identifier.
- TRANS_DATE, TRANS_QTY, TRANS_UM, TRANS_QTY2, and TRANS_UM2 — the transaction date, primary and secondary quantities, and their units of measure.
- TRANS_STAT — processing status of the pending line.
- MOVEMENT_ID — link to MTL_MOVEMENT_STATISTICS for movement reporting.
- CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE — standard audit columns.
No additional unique indexes beyond IC_TRAN_PND_PK are documented, so TRANS_ID is the only formal business-key candidate, though combinations of ITEM_ID, WHSE_CODE, LOT_ID, and TRANS_DATE are frequently treated as natural query keys in practice.
Common Use Cases and Queries
The primary operational use case is monitoring and troubleshooting inventory transactions that have not yet posted. A typical query retrieves all pending lines for a given item and warehouse:
SELECT TRANS_ID, ITEM_ID, WHSE_CODE, LOT_ID, TRANS_QTY, TRANS_UM, TRANS_STAT FROM IC_TRAN_PND WHERE ITEM_ID = :item AND WHSE_CODE = :whse;
Reconciliation reports join IC_TRAN_PND to IC_ITEM_MST and IC_LOTS_MST to surface item descriptions and lot expiry data. Interfaces that stage transactions before batch validation are validated by counting rows by TRANS_STAT, and lot-status transition audits compare LOT_STATUS values against IC_LOTS_STS. Posting diagnostics commonly filter on GL_POSTED_IND and COMPLETED_IND to isolate rows stuck in the pipeline.
Related Objects
The following related objects are most significant, based on documented foreign key relationships:
- IC_ITEM_MST / IC_ITEM_MST_B — joined on ITEM_ID for item master validation.
- IC_LOTS_MST — joined on ITEM_ID and LOT_ID for lot control.
- IC_LOTS_STS — joined on LOT_STATUS for lot status codes.
- SY_ORGN_MST / SY_ORGN_MST_B — joined on ORGN_CODE and CO_CODE for company and organization defaults.
- SY_UOMS_MST — joined on TRANS_UM and TRANS_UM2 for unit-of-measure definitions.
- MTL_MOVEMENT_STATISTICS — joined on MOVEMENT_ID for movement statistics reporting.
- IC_STAT_RPT — references IC_TRAN_PND via TRANS_ID as a dependent reporting table.
- GMD_GRADES_B and QC_GRAD_MST — joined on QC_GRADE for quality grade validation.
- SY_REAS_CDS / SY_REAS_CDS_B — joined on REASON_CODE for transaction reason codes.
-
Pending inventory transactions
-
Completed inventory transactions
-
View: WSH_SHIPPING_DETAILS_V 12.1.1
APPS.WSH_SHIPPING_DETAILS_V·↳ HR_LOCATIONS_ALL·↳ OE_INSTALL·↳ OE_ORDER_HEADERS_ALL·Explore OE module →
-
View: WSH_SHIPPING_DETAILS_V 12.2.2
APPS.WSH_SHIPPING_DETAILS_V·↳ HR_LOCATIONS_ALL·↳ OE_INSTALL·↳ OE_ORDER_HEADERS_ALL·Explore OE module →
-
View: RCV_TRANSACTIONS_MRC_V 12.2.2
- Retrofitted
APPS.RCV_TRANSACTIONS_MRC_V·↳ RCV_MC_TRANSACTIONS·↳ RCV_TRANSACTIONS·Explore PO module →
-
View: WSHBV_DELIVERY_DETAILS 12.2.2
APPS.WSHBV_DELIVERY_DETAILS·↳ MTL_CUSTOMER_ITEMS·↳ MTL_ITEM_LOCATIONS·↳ MTL_SYSTEM_ITEMS·Explore WSH module →
-
APPS.WSH_DELIVERY_DETAILS_OB_GRP_V·↳ WSH_DELIVERY_DETAILS·Explore WSH module →
-
- Retrofitted
APPS.POBV_RECEIVING_TRANSACTIONS·↳ MTL_TRANSACTION_REASONS·↳ RCV_TRANSACTIONS·Explore PO module →
-
Completed inventory transactions
-
APPS.WSH_TRIP_DELIVERABLES_V·↳ WSH_DELIVERY_LEGS·↳ WSH_DLVY_DELIVERABLES_V·↳ WSH_TRIPS·Explore WSH module →
-
APPS.WSH_DLVY_DELIVERABLES_V·↳ WSH_DELIVERY_ASSIGNMENTS·↳ WSH_DELIVERY_DETAILS·↳ WSH_LOOKUPS·Explore WSH module →
-
View: WSH_SHIPPING_DETAILS_V 12.2.2
APPS.WSH_SHIPPING_DETAILS_V·↳ HR_LOCATIONS_ALL·↳ OE_INSTALL·↳ OE_ORDER_HEADERS_ALL·Explore WSH module →
-
View: WSH_SHIPPING_DETAILS_V 12.1.1
APPS.WSH_SHIPPING_DETAILS_V·↳ HR_LOCATIONS_ALL·↳ OE_INSTALL·↳ OE_ORDER_HEADERS_ALL·Explore WSH module →
-
Pending inventory transactions
-
View: RCV_TRANSACTIONS_MRC_V 12.1.1
- Retrofitted
APPS.RCV_TRANSACTIONS_MRC_V·↳ RCV_MC_TRANSACTIONS·↳ RCV_TRANSACTIONS·Explore PO module →
-
- Retrofitted
APPS.POBV_RECEIVING_TRANSACTIONS·↳ MTL_TRANSACTION_REASONS·↳ RCV_TRANSACTIONS·Explore PO module →
-
APPS.WSH_DELIVERY_DETAILS_OB_GRP_V·↳ WSH_DELIVERY_DETAILS·Explore WSH module →
-
Delivery Detail interface Table
-
View: WSHBV_DELIVERY_DETAILS 12.1.1
APPS.WSHBV_DELIVERY_DETAILS·↳ MTL_CUSTOMER_ITEMS·↳ MTL_ITEM_LOCATIONS·↳ MTL_SYSTEM_ITEMS·Explore WSH module →
-
APPS.JAI_OM_WSH_DELIVERIES_V·↳ WSH_DELIVERY_ASSIGNMENTS·↳ WSH_DELIVERY_DETAILS·↳ WSH_NEW_DELIVERIES·Explore JA module →
-
View: WSH_DEL_DTL_ASSGN_V 12.1.1
APPS.WSH_DEL_DTL_ASSGN_V·↳ WSH_DEL_ASSGN_INTERFACE·↳ WSH_DEL_DETAILS_INTERFACE·Explore WSH module →
-
- Retrofitted
APPS.POFV_RECEIVING_TRANSACTIONS·↳ AP_INVOICES_ALL·↳ BOM_DEPARTMENTS·↳ BOM_RESOURCES·Explore PO module →
-
Table to store picking line details information during upgrade from 11 to 11i
-
Table to store picking line details information during upgrade from 11 to 11i
-
APPS.WSH_DLVY_DELIVERABLES_V·↳ WSH_DELIVERY_ASSIGNMENTS·↳ WSH_DELIVERY_DETAILS·↳ WSH_LOOKUPS·Explore WSH module →
-
APPS.WSH_STOP_DELIVERABLES_V·↳ WSH_DELIVERY_LEGS·↳ WSH_DLVY_DELIVERABLES_V·↳ WSH_NEW_DELIVERIES·Explore WSH module →
-
View: WSHFV_DELIVERY_DETAILS 12.2.2
Full BIS Business View for Delivery Details.
APPS.WSHFV_DELIVERY_DETAILS·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_SITE_USES_ALL·↳ HZ_PARTIES·Explore WSH module →
-
View: WSH_DELIVERABLES_V 12.1.1
APPS.WSH_DELIVERABLES_V·↳ FND_LOOKUP_VALUES·↳ WMS_LICENSE_PLATE_NUMBERS·↳ WSH_DELIVERY_ASSIGNMENTS·Explore WSH module →
-
Picking line details
-
Picking line details
-
View: WSH_DELIVERABLES_V 12.2.2
APPS.WSH_DELIVERABLES_V·↳ FND_LOOKUP_VALUES·↳ WMS_LICENSE_PLATE_NUMBERS·↳ WSH_DELIVERY_ASSIGNMENTS·Explore WSH module →
-
- Retrofitted
APPS.POFV_RECEIVING_TRANSACTIONS·↳ AP_INVOICES_ALL·↳ BOM_DEPARTMENTS·↳ BOM_RESOURCES·Explore PO module →
-
Receiving transactions
-
Receiving transactions
-
APPS.WSH_TRIP_DELIVERABLES_V·↳ WSH_DELIVERY_LEGS·↳ WSH_DLVY_DELIVERABLES_V·↳ WSH_TRIPS·Explore WSH module →
-
View: WSHFV_DELIVERY_DETAILS 12.1.1
Full BIS Business View for Delivery Details.
APPS.WSHFV_DELIVERY_DETAILS·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_SITE_USES_ALL·↳ HZ_PARTIES·Explore WSH module →
-
View: WSH_DEL_DTL_ASSGN_V 12.2.2
APPS.WSH_DEL_DTL_ASSGN_V·↳ WSH_DEL_ASSGN_INTERFACE·↳ WSH_DEL_DETAILS_INTERFACE·Explore WSH module →
-
APPS.WSH_STOP_DELIVERABLES_V·↳ WSH_DELIVERY_LEGS·↳ WSH_DLVY_DELIVERABLES_V·↳ WSH_NEW_DELIVERIES·Explore WSH module →
-
Material transaction table
-
Delivery Detail interface Table
-
Material transaction table
-
Delivery Details
-
Delivery Details