Search Results oe_order_lines_all




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

Table Name: OE_ORDER_LINES_ALL

Purpose:
This table stores individual line details for sales orders in Oracle Order Management (OM) module.

Key Columns:
1. LINE_ID (Primary Key)
- Unique identifier for each order line
- Generated using sequence

2. HEADER_ID
- References the associated order header in OE_ORDER_HEADERS_ALL
- Links the line to its parent order

3. INVENTORY_ITEM_ID
- Identifies the specific product/item being ordered
- Links to MTL_SYSTEM_ITEMS table

4. ORDERED_QUANTITY
- Quantity of items requested by customer

5. ORDER_QUANTITY_UOM
- Unit of measurement for ordered quantity

6. UNIT_SELLING_PRICE
- Price per unit for the line item

7. LINE_TYPE_ID
- Defines the type of order line (standard, service, etc.)

8. ORDERED_DATE
- Date when the line was originally ordered

9. SCHEDULE_SHIP_DATE
- Planned shipment date for the line

10. SCHEDULE_STATUS_CODE
- Current scheduling status of the line

11. OPEN_FLAG
- Indicates if the line is still open/active

12. BOOKED_FLAG
- Shows if the line has been booked

13. CANCELLED_FLAG
- Indicates if the line has been cancelled

Important Attributes:
- Tracks detailed information about each sales order line
- Supports complex ordering scenarios
- Integrates with inventory, pricing, and shipping processes

Typical Use Cases:
- Order processing
- Pricing calculations
- Inventory management
- Shipping and fulfillment tracking