Search Results rcv_shipment_lines




Here's a detailed description of the RCV_SHIPMENT_LINES table in Oracle E-Business Suite (EBS):

Table Name: RCV_SHIPMENT_LINES

Purpose:
The RCV_SHIPMENT_LINES table stores detailed information about individual receipt lines during the receiving process in Oracle Purchasing and Inventory modules.

Key Columns:
1. SHIPMENT_LINE_ID (Primary Key)
- Unique identifier for each receipt line
- Typically a sequence-generated number

2. SHIPMENT_HEADER_ID
- Links to the corresponding RCV_SHIPMENT_HEADERS record
- Represents the overall shipment/receipt transaction

3. PO_LINE_ID
- References the specific Purchase Order line being received
- Connects to PO_LINES table

4. ITEM_ID
- Inventory item being received
- Links to MTL_SYSTEM_ITEMS table

5. QUANTITY
- Quantity of items received in this line

6. UNIT_OF_MEASURE
- UOM for the received quantity

7. EXPECTED_RECEIPT_DATE
- Date the receipt was originally expected

8. RECEIPT_DATE
- Actual date of receipt

9. SUBINVENTORY
- Destination subinventory for the received items

10. LOCATOR_ID
- Specific storage location within the subinventory

Additional Important Attributes:
- Tracks receiving status
- Captures inspection and quality control information
- Supports various receiving scenarios (purchase orders, returns, etc.)

Typical Use Cases:
- Receiving inventory from suppliers
- Tracking purchase order fulfillment
- Managing inventory receipts
- Supporting inventory and purchasing transactions

Key Relationships:
- Links to PO_LINES
- Connected with RCV_SHIPMENT_HEADERS
- Interfaces with Inventory and Purchasing modules

Recommended Indices:
- SHIPMENT_LINE_ID (Primary Key)
- SHIPMENT_HEADER_ID
- PO_LINE_ID
- ITEM_ID