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.
-
Table: OE_ORDER_LINES_ALL
12.1.1
owner:ONT, object_type:TABLE, fnd_design_data:ONT.OE_ORDER_LINES_ALL, object_name:OE_ORDER_LINES_ALL, status:VALID, product: ONT - Order Management , description: OE_ORDER_LINES_ALL stores information for all order lines in Oracle Order Management. , implementation_dba_data: ONT.OE_ORDER_LINES_ALL ,
-
Table: OE_ORDER_LINES_ALL
12.2.2
owner:ONT, object_type:TABLE, fnd_design_data:ONT.OE_ORDER_LINES_ALL, object_name:OE_ORDER_LINES_ALL, status:VALID, product: ONT - Order Management , description: OE_ORDER_LINES_ALL stores information for all order lines in Oracle Order Management. , implementation_dba_data: ONT.OE_ORDER_LINES_ALL ,
-
APPS.OKL_AM_OM_REMARKET_WF dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.CTO_WIP_WORKFLOW_API_PK dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.CTO_ATP_INTERFACE_PK dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.OE_VERSION_HISTORY_UTIL dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.OE_PROCESS_REQUISITION_PVT dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.OE_CONFIG_TSO_PVT dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.OE_ORDER_ADJ_PVT dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.OE_SCH_CONC_REQUESTS dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.ONT_OEXOEORD_XMLP_PKG dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.ISC_EDW_BOOK_SUM1_F_C dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.CSP_PARTS_ORDER dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.MRP_RELEASE_SO dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.CTO_WORKFLOW_API_PK dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.CSTPPINV dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.OE_DEFAULT_LINE_PAYMENT dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.CSTPACDP dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.OTA_UTILITY dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.CTO_AUTO_PROCURE_PK dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.GML_OPM_ROI_GRP dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.OE_PROFILE dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.OKS_OMINT_PUB dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.ONT_OEXAUDHR_XMLP_PKG dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.OZF_OFFR_ELIG_PROD_DENORM_PVT dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.GMI_GMILTGEN_XMLP_PKG dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.OE_VALIDATE_HEADER dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.WMS_WMSSCHS1_XMLP_PKG dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.GMD_QC_LABELS_UTIL dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.OE_PARTY_TOTALS dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.OE_ORDER_MISC_PUB dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.WMS_CROSS_DOCK_PVT dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.WMS_DIRECT_SHIP_PVT dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.GMF_GMFLCHST_XMLP_PKG dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.WMS_PICK_DROP_PVT dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.CSI_ITEM_INSTANCE_PUB dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.JAI_RCV_EXCISE_PROCESSING_PKG dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.OTA_EVT_SHD dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.RLM_RD_SV dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.OE_DEFAULT_LINE_SCREDIT dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.CTO_CONFIG_ROUTING_PK dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.OE_RMA_WF dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.JAI_OM_UTILS_PKG dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.OE_SERVICE_CREDIT_GRP dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.RCV_OE_RMA_RECEIPTS_SV dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.GME_BATCH_WKFL_PKG dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.EDW_UTIL dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.OE_VALIDATE_LINE_PAYMENT dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.JAI_OM_WDD_TRIGGER_PKG dependencies on OE_ORDER_LINES_ALL
12.1.1
-
APPS.PO_OM_INTEGRATION_GRP dependencies on OE_ORDER_LINES_ALL
12.1.1