Search Results csd_product_transactions

Overview

The CSD_PRODUCT_TRANSACTIONS table is a core transactional entity within the Oracle E-Business Suite (EBS) Depot Repair (CSD) module. It functions as the primary child table to CSD_REPAIRS, systematically recording all inbound and outbound product movements associated with a specific repair order. Its role is to provide a granular audit trail of the physical product flow throughout the repair lifecycle, from the initial receipt of the defective item to the final shipment of the repaired or replaced unit. This detailed transaction history is essential for inventory management, logistics tracking, and operational reporting within the repair depot.

Key Information Stored

While the full column list is not detailed in the provided metadata, the structure centers on linking product movements to the parent repair order and related estimates. The primary key, PRODUCT_TRANSACTION_ID, uniquely identifies each transaction record. The table's critical foreign key columns define its relationships: REPAIR_LINE_ID links the transaction to its parent repair line in CSD_REPAIRS, and ESTIMATE_DETAIL_ID can link it to a specific line from the initial estimate in CS_ESTIMATE_DETAILS. Typical data stored would include transaction types (e.g., 'INBOUND', 'OUTBOUND'), transaction dates, serial numbers, shipping and receiving references, and identifiers for the specific inventory item and subinventory locations involved in the movement.

Common Use Cases and Queries

This table is central to queries that track the status and history of a repair order's physical components. Common use cases include generating a complete transaction log for a repair order to verify receipt and shipment, reconciling inventory movements, and auditing repair cycle times. A fundamental reporting query would join to the parent repair table to list all product movements for a given order.

• Transaction History Report: SELECT cpt.* FROM csd_product_transactions cpt, csd_repairs cr WHERE cpt.repair_line_id = cr.repair_line_id AND cr.repair_number = '<Repair_Number>' ORDER BY cpt.transaction_date;
• Open Inbound Items: Identifying items received but not yet shipped by querying for 'INBOUND' transactions without corresponding 'OUTBOUND' records for the same repair line.
• Shipment Verification: Confirming the final outbound shipment details, including carrier and tracking information, for a completed repair.

Related Objects

The CSD_PRODUCT_TRANSACTIONS table is integral to the Depot Repair data model, with defined relationships to key master and transactional entities.

• CSD_REPAIRS (Parent Table): The primary parent entity. Joined via CSD_PRODUCT_TRANSACTIONS.REPAIR_LINE_ID = CSD_REPAIRS.REPAIR_LINE_ID. Every product transaction must be associated with a valid repair order line.
• CS_ESTIMATE_DETAILS (Reference Table): Provides a link to the original estimate line item. Joined via CSD_PRODUCT_TRANSACTIONS.ESTIMATE_DETAIL_ID = CS_ESTIMATE_DETAILS.ESTIMATE_DETAIL_ID. This relationship allows tracing the actual transaction back to the estimated part or service.