Search Results source_transaction_flag

Overview

CSI_WIP_ASSEMBLIES_V is an Oracle E-Business Suite view owned by the APPS schema and classified under the CSI (Install Base) product. It presents Work in Process (WIP) assembly transactions in a unified form suitable for install base reporting and integration. In EBS 12.1.1 and 12.2.2, the view consolidates two distinct sources of assembly data: transaction lines captured through the Install Base transaction interface, and item instance records held directly in the install base. The UNION of these sources allows the view to expose WIP assemblies that have been received into inventory, along with their associated serial, lot, and inventory organization attributes.

The view is principally used where a report or interface must identify the WIP job that produced a given installed item or assembly. Notably, the column INV_ORGANIZATION_ID — the term the user searched for — is the inventory organization context that ties an assembly instance to a specific inventory organization, enabling reporting across organizations.

Underlying Base Objects

The ETRM metadata documents the following referenced base objects for APPS.CSI_WIP_ASSEMBLIES_V:

• CSI_ITEM_INSTANCES (SYNONYM)
• CSI_T_TRANSACTION_LINES (SYNONYM)
• CSI_T_TXN_LINE_DETAILS (SYNONYM)

The view text joins CSI_T_TRANSACTION_LINES (alias CTT) to CSI_T_TXN_LINE_DETAILS (alias CTL) on TRANSACTION_LINE_ID where CTT.SOURCE_TRANSACTION_TABLE = 'WIP_ENTITIES' and CTL.SOURCE_TRANSACTION_FLAG = 'Y'. This first branch supplies transaction-derived assemblies. The second branch selects directly from CSI_ITEM_INSTANCES (alias CII), providing instance-based rows where LAST_VLD_ORGANIZATION_ID is mapped to INV_ORGANIZATION_ID and where SOURCE_TRANSACTION_FLAG is set to 'Y'. The two sets are combined with UNION, producing a single consistent projection of the assembly columns.

Key Columns

• INV_ORGANIZATION_ID: inventory organization identifier for the assembly. Derived from CTL.INV_ORGANIZATION_ID in the transaction branch and from LAST_VLD_ORGANIZATION_ID in the instance branch. This is the primary search target for organization-scoped queries.
• INSTANCE_ID: unique identifier of the install base instance.
• INVENTORY_ITEM_ID: the inventory item of the assembly.
• QUANTITY / UNIT_OF_MEASURE: quantity and UOM of the assembly.
• SERIAL_NUMBER / LOT_NUMBER: serial and lot control attributes of the assembly.
• INSTANCE_STATUS_ID: status of the instance.
• LOCATION_TYPE_CODE / LOCATION_ID: location of the instance.
• LAST_WIP_JOB_ID: from CTT.SOURCE_TRANSACTION_ID; identifies the WIP job that produced the assembly.
• MFG_SERIAL_NUMBER_FLAG, EXTERNAL_REFERENCE, SOURCE_TRANSACTION_FLAG, PROCESSING_STATUS: transaction control and reference attributes.
• TRANSACTION_LINE_ID / TXN_LINE_DETAIL_ID: keys to the transaction interface; NULL in the instance branch.

Common Use Cases and Queries

Typical usage includes reconciling WIP completions to install base instances, reporting assemblies by inventory organization, and retrieving the originating WIP job for a serialized item. A representative query filters on the searched column:

• List all WIP assemblies for a given inventory organization.
• Retrieve the WIP job and serial number for a specific instance.
• Report assemblies not yet processed through the transaction interface (PROCESSING_STATUS IS NULL).

Sample SQL:

SELECT instance_id,
       inv_organization_id,
       inventory_item_id,
       serial_number,
       lot_number,
       quantity,
       last_wip_job_id
FROM   apps.csi_wip_assemblies_v
WHERE  inv_organization_id = :org_id
ORDER  BY instance_id;

Because the view draws from both transaction lines and item instances, joins against CSI_ITEM_INSTANCES or INV_ORGANIZATION_DEFINITIONS on INV_ORGANIZATION_ID further support organization-aware reporting.