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
-
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 ,
-
Table: OE_SETS
12.1.1
owner:ONT, object_type:TABLE, fnd_design_data:ONT.OE_SETS, object_name:OE_SETS, status:VALID, product: ONT - Order Management , description: OE_SETS stores information on line sets. , implementation_dba_data: ONT.OE_SETS ,
-
Table: OE_SETS
12.2.2
owner:ONT, object_type:TABLE, fnd_design_data:ONT.OE_SETS, object_name:OE_SETS, status:VALID, product: ONT - Order Management , description: OE_SETS stores information on line sets. , implementation_dba_data: ONT.OE_SETS ,
-
Table: OE_ORDER_HEADERS_ALL
12.1.1
owner:ONT, object_type:TABLE, fnd_design_data:ONT.OE_ORDER_HEADERS_ALL, object_name:OE_ORDER_HEADERS_ALL, status:VALID, product: ONT - Order Management , description: OE_ORDER_HEADERS_ALL stores header information for orders in Order Management. , implementation_dba_data: ONT.OE_ORDER_HEADERS_ALL ,
-
Table: OE_ORDER_HEADERS_ALL
12.2.2
owner:ONT, object_type:TABLE, fnd_design_data:ONT.OE_ORDER_HEADERS_ALL, object_name:OE_ORDER_HEADERS_ALL, status:VALID, product: ONT - Order Management , description: OE_ORDER_HEADERS_ALL stores header information for orders in Order Management. , implementation_dba_data: ONT.OE_ORDER_HEADERS_ALL ,
-
Table: OE_DROP_SHIP_SOURCES
12.1.1
owner:ONT, object_type:TABLE, fnd_design_data:ONT.OE_DROP_SHIP_SOURCES, object_name:OE_DROP_SHIP_SOURCES, status:VALID, product: ONT - Order Management , description: This table stores relationship between order lines in oe_order_lines_all table and associated oracle purchasing requisitions in PO_REQUISITIONS_ALL and Oracle purchasing purchase orders in PO_LINES_ALL. , implementation_dba_data: ONT.OE_DROP_SHIP_SOURCES ,
-
Table: OE_DROP_SHIP_SOURCES
12.2.2
owner:ONT, object_type:TABLE, fnd_design_data:ONT.OE_DROP_SHIP_SOURCES, object_name:OE_DROP_SHIP_SOURCES, status:VALID, product: ONT - Order Management , description: This table stores relationship between order lines in oe_order_lines_all table and associated oracle purchasing requisitions in PO_REQUISITIONS_ALL and Oracle purchasing purchase orders in PO_LINES_ALL. , implementation_dba_data: ONT.OE_DROP_SHIP_SOURCES ,
-
View: OE_SALES_CONTINGENCY_RM_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:ONT.OE_SALES_CONTINGENCY_RM_V, object_name:OE_SALES_CONTINGENCY_RM_V, status:VALID, product: ONT - Order Management , implementation_dba_data: APPS.OE_SALES_CONTINGENCY_RM_V ,
-
View: OE_RETROBILLED_INFO_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:ONT.OE_RETROBILLED_INFO_V, object_name:OE_RETROBILLED_INFO_V, status:VALID, product: ONT - Order Management , description: View is to show retrobilled activities , implementation_dba_data: APPS.OE_RETROBILLED_INFO_V ,
-
View: OE_RETROBILLED_INFO_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:ONT.OE_RETROBILLED_INFO_V, object_name:OE_RETROBILLED_INFO_V, status:VALID, product: ONT - Order Management , description: View is to show retrobilled activities , implementation_dba_data: APPS.OE_RETROBILLED_INFO_V ,
-
View: OE_ACCRUALS_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:ONT.OE_ACCRUALS_V, object_name:OE_ACCRUALS_V, status:VALID, product: ONT - Order Management , description: This view shows accrued price adjustments in Order Management System. , implementation_dba_data: APPS.OE_ACCRUALS_V ,
-
View: OE_ACCRUALS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:ONT.OE_ACCRUALS_V, object_name:OE_ACCRUALS_V, status:VALID, product: ONT - Order Management , description: This view shows accrued price adjustments in Order Management System. , implementation_dba_data: APPS.OE_ACCRUALS_V ,
-
Table: OE_ORDER_LINES_ALL_EXT_TL
12.2.2
owner:ONT, object_type:TABLE, fnd_design_data:ONT.OE_ORDER_LINES_ALL_EXT_TL, object_name:OE_ORDER_LINES_ALL_EXT_TL, status:VALID, product: ONT - Order Management , description: TL table to store user defined attributes of oe_order_lines_all , implementation_dba_data: ONT.OE_ORDER_LINES_ALL_EXT_TL ,
-
Table: OE_ORDER_LINES_ALL_EXT_B
12.2.2
owner:ONT, object_type:TABLE, fnd_design_data:ONT.OE_ORDER_LINES_ALL_EXT_B, object_name:OE_ORDER_LINES_ALL_EXT_B, status:VALID, product: ONT - Order Management , description: Base table to store user defined attributes of oe_order_lines_all , implementation_dba_data: ONT.OE_ORDER_LINES_ALL_EXT_B ,
-
View: OE_DROP_SHIP_LINKS_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:ONT.OE_DROP_SHIP_LINKS_V, object_name:OE_DROP_SHIP_LINKS_V, status:VALID, product: ONT - Order Management , description: This view is used for Dropship Tab in the additional line information of the Sales Orders form. , implementation_dba_data: APPS.OE_DROP_SHIP_LINKS_V ,
-
View: OE_DROP_SHIP_LINKS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:ONT.OE_DROP_SHIP_LINKS_V, object_name:OE_DROP_SHIP_LINKS_V, status:VALID, product: ONT - Order Management , description: This view is used for Dropship Tab in the additional line information of the Sales Orders form. , implementation_dba_data: APPS.OE_DROP_SHIP_LINKS_V ,
-
Table: OE_LINES_EBS_LOG
12.2.2
owner:ONT, object_type:TABLE, fnd_design_data:ONT.OE_LINES_EBS_LOG, object_name:OE_LINES_EBS_LOG, status:VALID, product: ONT - Order Management , description: Log table for the Euro conversion of OE_ORDER_LINES_ALL. This table is used only by the Euro Customer Conversion concurrent program. , implementation_dba_data: ONT.OE_LINES_EBS_LOG ,
-
Table: OE_SALES_CREDITS
12.1.1
owner:ONT, object_type:TABLE, fnd_design_data:ONT.OE_SALES_CREDITS, object_name:OE_SALES_CREDITS, status:VALID, product: ONT - Order Management , description: This table stores information about sales credits. , implementation_dba_data: ONT.OE_SALES_CREDITS ,
-
Table: OE_LINE_SETS
12.1.1
owner:ONT, object_type:TABLE, fnd_design_data:ONT.OE_LINE_SETS, object_name:OE_LINE_SETS, status:VALID, product: ONT - Order Management , description: This table stores information about Sets. , implementation_dba_data: ONT.OE_LINE_SETS ,
-
Table: OE_LINES_EBS_LOG
12.1.1
owner:ONT, object_type:TABLE, fnd_design_data:ONT.OE_LINES_EBS_LOG, object_name:OE_LINES_EBS_LOG, status:VALID, product: ONT - Order Management , description: Log table for the Euro conversion of OE_ORDER_LINES_ALL. This table is used only by the Euro Customer Conversion concurrent program. , implementation_dba_data: ONT.OE_LINES_EBS_LOG ,
-
Table: OE_HEADERS_EBS_LOG
12.2.2
owner:ONT, object_type:TABLE, fnd_design_data:ONT.OE_HEADERS_EBS_LOG, object_name:OE_HEADERS_EBS_LOG, status:VALID, product: ONT - Order Management , description: Log table for the Euro conversion of OE_ORDER_LINES_ALL. This table is used only by the Euro Customer Conversion concurrent program. , implementation_dba_data: ONT.OE_HEADERS_EBS_LOG ,
-
Table: OE_HEADERS_EBS_LOG
12.1.1
owner:ONT, object_type:TABLE, fnd_design_data:ONT.OE_HEADERS_EBS_LOG, object_name:OE_HEADERS_EBS_LOG, status:VALID, product: ONT - Order Management , description: Log table for the Euro conversion of OE_ORDER_LINES_ALL. This table is used only by the Euro Customer Conversion concurrent program. , implementation_dba_data: ONT.OE_HEADERS_EBS_LOG ,
-
Table: OE_LINE_SETS
12.2.2
owner:ONT, object_type:TABLE, fnd_design_data:ONT.OE_LINE_SETS, object_name:OE_LINE_SETS, status:VALID, product: ONT - Order Management , description: This table stores information about Sets. , implementation_dba_data: ONT.OE_LINE_SETS ,
-
View: OE_PRN_CHG_PERIODICITY_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:ONT.OE_PRN_CHG_PERIODICITY_V, object_name:OE_PRN_CHG_PERIODICITY_V, status:VALID, product: ONT - Order Management , description: The view is for obtaining recurring charges while printing a Sales Order , implementation_dba_data: APPS.OE_PRN_CHG_PERIODICITY_V ,
-
Table: OE_SALES_CREDITS
12.2.2
owner:ONT, object_type:TABLE, fnd_design_data:ONT.OE_SALES_CREDITS, object_name:OE_SALES_CREDITS, status:VALID, product: ONT - Order Management , description: This table stores information about sales credits. , implementation_dba_data: ONT.OE_SALES_CREDITS ,
-
Table: OE_LOT_SERIAL_NUMBERS
12.1.1
owner:ONT, object_type:TABLE, fnd_design_data:ONT.OE_LOT_SERIAL_NUMBERS, object_name:OE_LOT_SERIAL_NUMBERS, status:VALID, product: ONT - Order Management , description: This table stores customer reported lot serial numbers for lot and / or serial number controlled return lines. , implementation_dba_data: ONT.OE_LOT_SERIAL_NUMBERS ,
-
Table: OE_LOT_SERIAL_NUMBERS
12.2.2
owner:ONT, object_type:TABLE, fnd_design_data:ONT.OE_LOT_SERIAL_NUMBERS, object_name:OE_LOT_SERIAL_NUMBERS, status:VALID, product: ONT - Order Management , description: This table stores customer reported lot serial numbers for lot and / or serial number controlled return lines. , implementation_dba_data: ONT.OE_LOT_SERIAL_NUMBERS ,
-
Table: OE_ORDER_PRICE_ATTRIBS
12.1.1
owner:ONT, object_type:TABLE, fnd_design_data:ONT.OE_ORDER_PRICE_ATTRIBS, object_name:OE_ORDER_PRICE_ATTRIBS, status:VALID, product: ONT - Order Management , description: This table stores pricing attributes and asked for promotions, deals, and coupon number entered by the user. , implementation_dba_data: ONT.OE_ORDER_PRICE_ATTRIBS ,
-
View: OE_PRN_CHG_PERIODICITY_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:ONT.OE_PRN_CHG_PERIODICITY_V, object_name:OE_PRN_CHG_PERIODICITY_V, status:VALID, product: ONT - Order Management , description: The view is for obtaining recurring charges while printing a Sales Order , implementation_dba_data: APPS.OE_PRN_CHG_PERIODICITY_V ,
-
Table: OE_ORDER_PRICE_ATTRIBS
12.2.2
owner:ONT, object_type:TABLE, fnd_design_data:ONT.OE_ORDER_PRICE_ATTRIBS, object_name:OE_ORDER_PRICE_ATTRIBS, status:VALID, product: ONT - Order Management , description: This table stores pricing attributes and asked for promotions, deals, and coupon number entered by the user. , implementation_dba_data: ONT.OE_ORDER_PRICE_ATTRIBS ,
-
Table: OE_ORDER_LINES_HISTORY
12.1.1
owner:ONT, object_type:TABLE, fnd_design_data:ONT.OE_ORDER_LINES_HISTORY, object_name:OE_ORDER_LINES_HISTORY, status:VALID, product: ONT - Order Management , description: Stores history of attribute change for Order Lines. , implementation_dba_data: ONT.OE_ORDER_LINES_HISTORY ,
-
Table: OE_PRICE_ADJ_ASSOCS
12.1.1
owner:ONT, object_type:TABLE, fnd_design_data:ONT.OE_PRICE_ADJ_ASSOCS, object_name:OE_PRICE_ADJ_ASSOCS, status:VALID, product: ONT - Order Management , description: This table stores the association between order lines and price adjustments and also between price adjustments , implementation_dba_data: ONT.OE_PRICE_ADJ_ASSOCS ,
-
Table: OE_PRICE_ADJ_ASSOCS
12.2.2
owner:ONT, object_type:TABLE, fnd_design_data:ONT.OE_PRICE_ADJ_ASSOCS, object_name:OE_PRICE_ADJ_ASSOCS, status:VALID, product: ONT - Order Management , description: This table stores the association between order lines and price adjustments and also between price adjustments , implementation_dba_data: ONT.OE_PRICE_ADJ_ASSOCS ,
-
Table: OE_ORDER_LINES_HISTORY
12.2.2
owner:ONT, object_type:TABLE, fnd_design_data:ONT.OE_ORDER_LINES_HISTORY, object_name:OE_ORDER_LINES_HISTORY, status:VALID, product: ONT - Order Management , description: Stores history of attribute change for Order Lines. , implementation_dba_data: ONT.OE_ORDER_LINES_HISTORY ,
-
Table: OE_ORDER_HOLDS_ALL
12.1.1
owner:ONT, object_type:TABLE, fnd_design_data:ONT.OE_ORDER_HOLDS_ALL, object_name:OE_ORDER_HOLDS_ALL, status:VALID, product: ONT - Order Management , description: This table stores information of all the orders and lines that are on hold and the link to hold sources and hold releases. , implementation_dba_data: ONT.OE_ORDER_HOLDS_ALL ,
-
Table: OE_ORDER_HOLDS_ALL
12.2.2
owner:ONT, object_type:TABLE, fnd_design_data:ONT.OE_ORDER_HOLDS_ALL, object_name:OE_ORDER_HOLDS_ALL, status:VALID, product: ONT - Order Management , description: This table stores information of all the orders and lines that are on hold and the link to hold sources and hold releases. , implementation_dba_data: ONT.OE_ORDER_HOLDS_ALL ,
-
View: OE_AK_ORDER_LINES_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:ONT.OE_AK_ORDER_LINES_V, object_name:OE_AK_ORDER_LINES_V, status:VALID, product: ONT - Order Management , implementation_dba_data: APPS.OE_AK_ORDER_LINES_V ,
-
View: OE_AK_ORDER_LINES_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:ONT.OE_AK_ORDER_LINES_V, object_name:OE_AK_ORDER_LINES_V, status:VALID, product: ONT - Order Management , implementation_dba_data: APPS.OE_AK_ORDER_LINES_V ,
-
Table: OE_ORDER_SOURCES
12.2.2
owner:ONT, object_type:TABLE, fnd_design_data:ONT.OE_ORDER_SOURCES, object_name:OE_ORDER_SOURCES, status:VALID, product: ONT - Order Management , description: Feeder System Names that create orders in Order Management tables. , implementation_dba_data: ONT.OE_ORDER_SOURCES ,
-
Table: OE_ORDER_SOURCES
12.1.1
owner:ONT, object_type:TABLE, fnd_design_data:ONT.OE_ORDER_SOURCES, object_name:OE_ORDER_SOURCES, status:VALID, product: ONT - Order Management , description: Feeder System Names that create orders in Order Management tables. , implementation_dba_data: ONT.OE_ORDER_SOURCES ,
-
Table: OE_LINE_ACKS
12.1.1
owner:ONT, object_type:TABLE, fnd_design_data:ONT.OE_LINE_ACKS, object_name:OE_LINE_ACKS, status:VALID, product: ONT - Order Management , description: This table stores information about the acknowledgements for Order Lines. , implementation_dba_data: ONT.OE_LINE_ACKS ,
-
Table: OE_LINE_ACKS
12.2.2
owner:ONT, object_type:TABLE, fnd_design_data:ONT.OE_LINE_ACKS, object_name:OE_LINE_ACKS, status:VALID, product: ONT - Order Management , description: This table stores information about the acknowledgements for Order Lines. , implementation_dba_data: ONT.OE_LINE_ACKS ,
-
View: OE_LINE_SAL_CRDT_HIST_V
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:ONT.OE_LINE_SAL_CRDT_HIST_V, object_name:OE_LINE_SAL_CRDT_HIST_V, status:VALID, product: ONT - Order Management , implementation_dba_data: APPS.OE_LINE_SAL_CRDT_HIST_V ,
-
View: OE_LINE_SAL_CRDT_HIST_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:ONT.OE_LINE_SAL_CRDT_HIST_V, object_name:OE_LINE_SAL_CRDT_HIST_V, status:VALID, product: ONT - Order Management , implementation_dba_data: APPS.OE_LINE_SAL_CRDT_HIST_V ,
-
Table: OE_PRICE_ADJUSTMENTS
12.2.2
owner:ONT, object_type:TABLE, fnd_design_data:ONT.OE_PRICE_ADJUSTMENTS, object_name:OE_PRICE_ADJUSTMENTS, status:VALID, product: ONT - Order Management , description: This table is used to store price adjustments that have been applied to an order or a line. It is also used to store the freight and special charges, Tax on order line, and Shipping Costs captured at ship confirmation. For Tax records the , implementation_dba_data: ONT.OE_PRICE_ADJUSTMENTS ,
-
Table: OE_PRICE_ADJUSTMENTS
12.1.1
owner:ONT, object_type:TABLE, fnd_design_data:ONT.OE_PRICE_ADJUSTMENTS, object_name:OE_PRICE_ADJUSTMENTS, status:VALID, product: ONT - Order Management , description: This table is used to store price adjustments that have been applied to an order or a line. It is also used to store the freight and special charges, Tax on order line, and Shipping Costs captured at ship confirmation. For Tax records the , implementation_dba_data: ONT.OE_PRICE_ADJUSTMENTS ,
-
View: OE_WIP_OPEN_DEMANDS_V
12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:ONT.OE_WIP_OPEN_DEMANDS_V, object_name:OE_WIP_OPEN_DEMANDS_V, status:VALID, product: ONT - Order Management , implementation_dba_data: APPS.OE_WIP_OPEN_DEMANDS_V ,
-
View: ISC_EDW_BOOKINGS_F_FCV
12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:ISC.ISC_EDW_BOOKINGS_F_FCV ONT.ISC_EDW_BOOKINGS_F_FCV, object_name:ISC_EDW_BOOKINGS_F_FCV, status:VALID, product: ONT - Order Management , implementation_dba_data: APPS.ISC_EDW_BOOKINGS_F_FCV ,
-
Table: OE_TRANSACTION_TYPES_ALL
12.1.1
owner:ONT, object_type:TABLE, fnd_design_data:ONT.OE_TRANSACTION_TYPES_ALL, object_name:OE_TRANSACTION_TYPES_ALL, status:VALID, product: ONT - Order Management , description: This table stores information about the order and line transaction types , implementation_dba_data: ONT.OE_TRANSACTION_TYPES_ALL ,