Search Results oe_order_lines_all




The OE_ORDER_LINES_ALL table is a fundamental entity within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, serving as the primary repository for order line details in the Order Management (OM) module. It stores transactional data related to sales orders, returns, and other order-related activities, enabling organizations to manage customer orders efficiently. This table is part of the Oracle Order Management schema and is tightly integrated with other key tables such as OE_ORDER_HEADERS_ALL, OE_TRANSACTION_TYPES_TL, and HZ_CUST_ACCOUNTS to provide a comprehensive order processing framework. ### **Key Attributes of OE_ORDER_LINES_ALL** The table contains numerous columns that define the characteristics of an order line, including: - LINE_ID: A unique identifier for each order line. - HEADER_ID: References the parent order in OE_ORDER_HEADERS_ALL. - INVENTORY_ITEM_ID: Links to the item in MTL_SYSTEM_ITEMS_B. - ORDERED_QUANTITY: Specifies the quantity of the item ordered. - UNIT_SELLING_PRICE: The selling price per unit. - LINE_TYPE_ID: Indicates whether the line is for goods, services, or a return. - SHIP_FROM_ORG_ID: Identifies the shipping warehouse. - SHIP_TO_ORG_ID: References the customer's ship-to location. - FLOW_STATUS_CODE: Tracks the order line's workflow status (e.g., ENTERED, BOOKED, SHIPPED). ### **Functional Role in Order Management** The OE_ORDER_LINES_ALL table plays a critical role in: 1. Order Entry & Processing: Captures line-level details such as pricing, discounts, and shipping instructions. 2. Inventory Fulfillment: Links to inventory tables (MTL_SYSTEM_ITEMS_B) to validate stock availability. 3. Pricing & Taxation: Stores negotiated prices, promotions, and tax calculations. 4. Shipping & Invoicing: Integrates with Oracle Shipping Execution (WSH_DELIVERY_DETAILS) and Receivables (RA_CUSTOMER_TRX_ALL). ### **Integration with Other Modules** - Inventory (INV): Validates item availability via MTL_SYSTEM_ITEMS_B. - Advanced Pricing (QP): Applies pricing rules stored in QP_LIST_HEADERS. - Shipping Execution (WSH): Generates delivery schedules in WSH_DELIVERY_DETAILS. - Receivables (AR): Facilitates invoicing through RA_CUSTOMER_TRX_ALL. ### **Multi-Org Structure & Security** The _ALL suffix indicates that the table supports multi-org access control, allowing data segregation by operating units. Views like OE_ORDER_LINES enforce data security via VPD (Virtual Private Database) policies. ### **Customization & Extensions** Organizations often extend this table using descriptive flexfields (DFFs) or custom columns to capture additional business-specific attributes. ### **Conclusion** The OE_ORDER_LINES_ALL table is a cornerstone of Oracle Order Management, enabling end-to-end order processing. Its integration with inventory, pricing, shipping, and financial modules ensures seamless order fulfillment, making it indispensable in Oracle EBS 12.1.1 and 12.2.2 implementations.