Results for “mfg_serial_number_flag”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
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.
-
View: CSI_WIP_ASSEMBLIES_V 12.2.2
APPS.CSI_WIP_ASSEMBLIES_V·↳ CSI_ITEM_INSTANCES·↳ CSI_T_TRANSACTION_LINES·↳ CSI_T_TXN_LINE_DETAILS·Explore CSI module →
-
View based on Serial Number change history
APPS.AHL_SERIAL_NUMBER_CHANGE_V·↳ AHL_OSP_ORDERS_B·↳ AHL_OSP_ORDER_LINES·↳ AHL_WORKORDERS·Explore AHL module →
-
View: CSI_BIS_TXN_DTLS_V 12.2.2
View created for the Oracle IT - GSI
APPS.CSI_BIS_TXN_DTLS_V·↳ CSI_SYSTEMS_VL·↳ CSI_TXN_SUB_TYPES·↳ CSI_T_TRANSACTION_LINES·Explore CSI module →
-
Dummy table that mirrors a subset of csi_item_instances. Oracle Internal use only - reserved for future use
-
Dummy table that mirrors a subset of csi_item_instances. Oracle Internal use only - reserved for future use
-
View based on Serial Number change history
APPS.AHL_SERIAL_NUMBER_CHANGE_V·↳ AHL_OSP_ORDERS_B·↳ AHL_OSP_ORDER_LINES·↳ AHL_WORKORDERS·Explore AHL module →
-
View: CSI_WIP_ASSEMBLIES_V 12.1.1
APPS.CSI_WIP_ASSEMBLIES_V·↳ CSI_ITEM_INSTANCES·↳ CSI_T_TRANSACTION_LINES·↳ CSI_T_TXN_LINE_DETAILS·Explore CSI module →
-
View: CSI_WIP_COMPONENTS_V 12.1.1
APPS.CSI_WIP_COMPONENTS_V·↳ CSI_ITEM_INSTANCES·↳ CSI_T_II_RELATIONSHIPS·↳ CSI_T_TRANSACTION_LINES·Explore CSI module →
-
View: CSI_WIP_COMPONENTS_V 12.2.2
APPS.CSI_WIP_COMPONENTS_V·↳ CSI_ITEM_INSTANCES·↳ CSI_T_II_RELATIONSHIPS·↳ CSI_T_TRANSACTION_LINES·Explore CSI module →
-
View: CSD_CUSTOMER_SEARCH_V 12.1.1
APPS.CSD_CUSTOMER_SEARCH_V·↳ AR_LOOKUPS·↳ CSI_ITEM_INSTANCES·↳ CS_STD·Explore CSD module →
-
View: CSD_CUSTOMER_SEARCH_V 12.2.2
APPS.CSD_CUSTOMER_SEARCH_V·↳ AR_LOOKUPS·↳ CSI_ITEM_INSTANCES·↳ CS_STD·Explore CSD module →
-
View: CSI_UNIT_INSTANCES_V 12.1.1
Instances that are units and are not a components of other instances.
APPS.CSI_UNIT_INSTANCES_V·↳ CSI_II_RELATIONSHIPS·↳ CSI_ITEM_INSTANCES·Explore CSI module →
-
View: CSI_BIS_TXN_DTLS_V 12.1.1
View created for the Oracle IT - GSI
APPS.CSI_BIS_TXN_DTLS_V·↳ CSI_SYSTEMS_VL·↳ CSI_TXN_SUB_TYPES·↳ CSI_T_TRANSACTION_LINES·Explore CSI module →
-
View: CSI_UNIT_INSTANCES_V 12.2.2
Instances that are units and are not a components of other instances.
APPS.CSI_UNIT_INSTANCES_V·↳ CSI_II_RELATIONSHIPS·↳ CSI_ITEM_INSTANCES·Explore CSI module →
-
View: CSI_INSTANCE_SEARCH_V 12.2.2
Instance details view for Instance search.
APPS.CSI_INSTANCE_SEARCH_V·↳ CSI_INSTANCE_STATUSES·↳ CSI_ITEM_INSTANCES·↳ CSI_LOOKUPS·Explore CSI module →
-
This view stores the query to retrieve Install Base item instance details.
APPS.AHL_UNIT_INSTALLED_DETAILS_V·↳ AHL_UTIL_UC_PKG·↳ CSI_INST_EXTEND_ATTRIB_V·↳ CSI_INST_PARTY_DETAILS_V·Explore AHL module →
-
View: OKX_ITEM_INSTS_LINES_V 12.2.2
View on Installed base item instance line of Oracle Lease management lease contract. This line points to an item instance (instance_id ) in IB
APPS.OKX_ITEM_INSTS_LINES_V·↳ OKC_K_ITEMS·↳ OKC_K_LINES_B·↳ OKC_K_LINES_TL·Explore OKX module →
-
View: OKX_INSTALL_ITEMS_V 12.2.2
Source View for IB instance line in Oracle Contracts for Lease
APPS.OKX_INSTALL_ITEMS_V·↳ CSI_ITEM_INSTANCES·Explore OKX module →
-
View: OKX_INSTALL_ITEMS_V 12.1.1
Source View for IB instance line in Oracle Contracts for Lease
APPS.OKX_INSTALL_ITEMS_V·↳ CSI_ITEM_INSTANCES·Explore OKX module →
-
View: OKX_ITEM_INSTS_LINES_V 12.1.1
View on Installed base item instance line of Oracle Lease management lease contract. This line points to an item instance (instance_id ) in IB
APPS.OKX_ITEM_INSTS_LINES_V·↳ OKC_K_ITEMS·↳ OKC_K_LINES_B·↳ OKC_K_LINES_TL·Explore OKX module →
-
View: CSI_INSTANCE_DETAILS_V 12.2.2
Instance Details.
APPS.CSI_INSTANCE_DETAILS_V·↳ CSI_INSTANCE_STATUSES·↳ CSI_ITEM_INSTANCES·↳ CSI_LOOKUPS·Explore CSI module →
-
View: CSI_INST_TXN_DETAILS_V 12.1.1
Details about the transaction performed on an Instance.
APPS.CSI_INST_TXN_DETAILS_V·↳ CSI_ITEM_INSTANCES·↳ CSI_ITEM_INSTANCES_H·↳ CSI_TRANSACTIONS·Explore CSI module →
-
View: CSI_INSTANCE_PARTY_V 12.2.2
Instance Party Associations view.
APPS.CSI_INSTANCE_PARTY_V·↳ CSI_INSTALL_PARAMETERS·↳ CSI_IP_ACCOUNTS·↳ CSI_ITEM_INSTANCES·Explore CSI module →
-
View: CSI_INSTANCE_PARTY_V 12.1.1
Instance Party Associations view.
APPS.CSI_INSTANCE_PARTY_V·↳ CSI_INSTALL_PARAMETERS·↳ CSI_IP_ACCOUNTS·↳ CSI_ITEM_INSTANCES·Explore CSI module →
-
View: CSI_INSTANCE_DETAILS_V 12.1.1
Instance Details.
APPS.CSI_INSTANCE_DETAILS_V·↳ CSI_INSTANCE_STATUSES·↳ CSI_ITEM_INSTANCES·↳ CSI_LOOKUPS·Explore CSI module →
-
Business to Business Views for Install Base
APPS.AMS_INSTANCE_PARTY_B2B_V·↳ CSI_II_RELATIONSHIPS·↳ CSI_INSTANCE_DETAILS_V·↳ CSI_I_PARTIES·Explore AMS module →
-
Business to Consumer Views for Install Base
APPS.AMS_INSTANCE_PARTY_B2C_V·↳ CSI_II_RELATIONSHIPS·↳ CSI_INSTANCE_DETAILS_V·↳ CSI_I_PARTIES·Explore AMS module →
-
View: CSI_INSTANCE_SEARCH_V 12.1.1
Instance details view for Instance search.
APPS.CSI_INSTANCE_SEARCH_V·↳ CSI_INSTANCE_STATUSES·↳ CSI_ITEM_INSTANCES·↳ CSI_LOOKUPS·Explore CSI module →
-
Transaction Details : Transaction Line Details.
-
This view stores the query to retrieve Install Base item instance details.
APPS.AHL_UNIT_INSTALLED_DETAILS_V·↳ AHL_UTIL_UC_PKG·↳ CSI_INST_EXTEND_ATTRIB_V·↳ CSI_INST_PARTY_DETAILS_V·Explore AHL module →
-
View to give the children of a Known Instance.
APPS.CSI_INST_CHILD_DETAILS_V·↳ CSI_II_RELATIONSHIPS·↳ CSI_ITEM_INSTANCES·Explore CSI module →
-
Business to Business Views for Install Base
APPS.AMS_INSTANCE_PARTY_B2B_V·↳ CSI_II_RELATIONSHIPS·↳ CSI_INSTANCE_DETAILS_V·↳ CSI_I_PARTIES·Explore AMS module →
-
View to give the parent of a Known Instance.
APPS.CSI_INST_PARENT_DETAILS_V·↳ CSI_II_RELATIONSHIPS·↳ CSI_ITEM_INSTANCES·Explore CSI module →
-
View to give the children of a Known Instance.
APPS.CSI_INST_CHILD_DETAILS_V·↳ CSI_II_RELATIONSHIPS·↳ CSI_ITEM_INSTANCES·Explore CSI module →
-
This view provides information of all Checked Out Assets which is used by Oracle Service Management/Depot Repair product.
APPS.EAM_CHECKED_OUT_ASSETS_V·↳ CSI_ITEM_INSTANCES·↳ EAM_ASSET_OPERATION_TXN·↳ MTL_PARAMETERS·Explore EAM module →
-
View: CSI_INST_TXN_DETAILS_V 12.2.2
Details about the transaction performed on an Instance.
APPS.CSI_INST_TXN_DETAILS_V·↳ CSI_ITEM_INSTANCES·↳ CSI_ITEM_INSTANCES_H·↳ CSI_TRANSACTIONS·Explore CSI module →
-
Transaction Details : Transaction Line Details.
-
View to give the parent of a Known Instance.
APPS.CSI_INST_PARENT_DETAILS_V·↳ CSI_II_RELATIONSHIPS·↳ CSI_ITEM_INSTANCES·Explore CSI module →
-
Business to Consumer Views for Install Base
APPS.AMS_INSTANCE_PARTY_B2C_V·↳ CSI_II_RELATIONSHIPS·↳ CSI_INSTANCE_DETAILS_V·↳ CSI_I_PARTIES·Explore AMS module →
-
Item Instance details.
-
Item Instance details.
-
Open Interface Instance Interface
-
Open Interface Instance Interface