Search Results source_task_id

Overview

WIP_TXN_COMP_INTERFACE_V is an Oracle Work in Process (WIP) view owned by the APPS schema. It exposes component transaction data destined for the Work in Process interface, projecting columns drawn primarily from MTL_TRANSACTIONS_INTERFACE. The view presents a denormalized, reporting-friendly picture of pending or staged WIP component transactions, blending interface attributes with item-level descriptions resolved from the inventory item master. Its designation as an interface view reflects its role as a read layer over the transaction staging table, commonly used to inspect, validate, and troubleshoot component issues and returns before they are processed into the WIP system. The view status is VALID, and it is available in both EBS 12.1.1 and 12.2.2.

Underlying Base Objects

The view is defined over three documented base objects, all referenced through APPS synonyms:

• MTL_TRANSACTIONS_INTERFACE (MTI) — the primary source, supplying transaction, quantity, date, organization, and source-related columns.
• MTL_SYSTEM_ITEMS (MSI) — joined on INVENTORY_ITEM_ID and ORGANIZATION_ID to retrieve item attributes such as LOT_CONTROL_CODE.
• MTL_SYSTEM_ITEMS_KFV (MSIV) — the key flexfield view, joined to resolve the concatenated item segment string exposed as COMPONENT_ITEM.

The join keys are ORG and ITEM across the interface and item master tables. The metadata lists the objects generically, but the view text confirms the exact predicates: MSI.INVENTORY_ITEM_ID = MTI.INVENTORY_ITEM_ID, MSI.ORGANIZATION_ID = MTI.ORGANIZATION_ID, and the equivalent join to the KFV view.

Key Columns

The view exposes a broad set of columns, several of which are especially relevant to component transaction processing:

• TRANSACTION_REFERENCE — a user-defined reference carried on the interface row, frequently used to correlate staged transactions with external sources.
• TRANSACTION_INTERFACE_ID and TRANSACTION_HEADER_ID — primary and grouping identifiers for the interface record.
• ORGANIZATION_ID, INVENTORY_ITEM_ID, COMPONENT_ITEM — the organization, numeric item key, and concatenated flexfield item segment.
• TRANSACTION_QUANTITY and PRIMARY_QUANTITY — the quantity to be transacted and its primary-unit equivalent.
• TRANSACTION_DATE, OPERATION_SEQ_NUM, REVISION, SUBINVENTORY_CODE, LOCATOR_ID, TRANSACTION_UOM — routing and inventory context for the component movement.
• LOT_CONTROL (from NVL(MSI.LOT_CONTROL_CODE,1)) — indicates whether lot control applies.
• PROCESS_FLAG, VALIDATION_REQUIRED — control columns governing whether the row has been processed or still requires validation.
• SOURCE_CODE, SOURCE_LINE_ID, SOURCE_HEADER_ID and PROJECT_ID, TASK_ID — traceability to originating source systems and projects.

Common Use Cases and Queries

Typical uses include auditing pending component transactions, verifying quantities and references before processing, and reconciling interface rows against their sources. Searching by TRANSACTION_REFERENCE is common for tracing staged records.

• Inspect unprocessed rows: SELECT TRANSACTION_INTERFACE_ID, COMPONENT_ITEM, TRANSACTION_QUANTITY, PROCESS_FLAG FROM WIP_TXN_COMP_INTERFACE_V WHERE PROCESS_FLAG = 1.
• Find by reference: SELECT TRANSACTION_REFERENCE, INVENTORY_ITEM_ID, TRANSACTION_QUANTITY FROM WIP_TXN_COMP_INTERFACE_V WHERE TRANSACTION_REFERENCE = :ref.
• Validate by organization and item: SELECT ORGANIZATION_ID, COMPONENT_ITEM, LOT_CONTROL FROM WIP_TXN_COMP_INTERFACE_V WHERE ORGANIZATION_ID = :org_id.